I'm only half way through the video and already my mind is spinning, what amazing things I can do with this. Can't wait to implement this and clean up my old (roll-up heavy) system a bit. Thank you for this great video!
@mfreihaendig
10 ай бұрын
So glad to hear that! What‘s the first use case you‘re gonna revamp with that? ☺️
@GescheSanten
10 ай бұрын
@@mfreihaendig So I'm definitely going to redo the way I rollup my tracked working hours and my key results, but that something for the Christmas holidays :) I just used this video for my Pigment and Watercolour Databases. Where different Pigments in one database relate to different watercolours in another. Those colours have a lot of Boolean properties, asking if they are in the 12/24/48 box of different manufacturers. I'm now working on a way to display those information to help my customers make decisions. ("Which colours does Gesche recommend? Which box/colour-set do I have? Which are missing from the recommended list? Which are the alternatives, if I use another manufacturer?") I AM neglecting my to-do-list today to do this instead... ☺
@mfreihaendig
10 ай бұрын
@@GescheSanten Ouh that sounds so cool! What an awesome implementation 😍😍
@orhanburakerdinc38
Жыл бұрын
This is one the most helpful Notion videos I have seen! Thanks a lot Matthias.
@mfreihaendig
Жыл бұрын
Oh that means a lot to me ☺️ always trying to provide as much value as possible 😇
@chriswells2954
Жыл бұрын
I love your channel and what you do. Thank you! (Also a shout out for upping your production game over time, especially with sound. Just want you to know that your regular viewers notice and appreciate it!)
@mfreihaendig
Жыл бұрын
Oh man that really means a lot! Thank you so much 😇 just made my day with that comment!
@SennaCrow
Жыл бұрын
Technically there are four ways now to ensure new entries always get the "stats" relation. 1) Button - creates new entries that automatically have the correct entry relation. 2) Filtered view - auto-adds the same relation entry when new entries are added 3) template - create a template that already has the relation entry chosen. 4) automation - set up an automation with the lightning bolt symbol so new entries automatically get the correct relation entry added to them.
@mfreihaendig
Жыл бұрын
Indeed! Thanks for listing them ☺️
@TechnoTube001
Ай бұрын
automations are paid right (except the Slack notification)?
@hellonadski
Жыл бұрын
my god i've been trying to figure this out, but with the updated formula i can't work out anything. luckily i decide to click on your video and my problem is solved😭 thank you so much for this knowledge!!!
@mfreihaendig
Жыл бұрын
Ahhh so glad I could be of help! ☺️
@benonhisway
10 ай бұрын
Ah finally! 🙏 I used your counting method with the map function to adapt my invoice template! Thank you
@mfreihaendig
10 ай бұрын
Oh amazing! That’s a great use case 😇
@saloniv1111
7 ай бұрын
How can I create stats for something which involves Date property and filter it by " relative to today " like let's say "This week " or " this month "
@christianmagill3829
Жыл бұрын
I love the idea of combining on a Gallery card. I've been creating "Warnings" properties for my databases to perform validation and it would be great to collect them globally in one place.
@christianmagill3829
Жыл бұрын
I guess relating items you could also do with automations.
@mfreihaendig
Жыл бұрын
Indeed, that’s a possibility too ☺️ just not available to everyone 😅
@mfreihaendig
Жыл бұрын
Oh that’s a great idea! A separate status database that shows information across your workspace 😍 might just add that to the list of content ideas 😎
@gpwahyunanda
7 ай бұрын
Hello Matt, nice video as always. Do you mind to share how to make sure our process of adding the new sales to the stats, so it become automatically rollup without selecting the new sales. Thanks
@mfreihaendig
7 ай бұрын
Glad you like it! I show the process in the video - you want to set up a database template that already has a connection to the stats db and make it the default template so it automatically is applied moving forward 💪🏻
@gpwahyunanda
7 ай бұрын
ah i miss that point, thank you so much!@@mfreihaendig
@massimilianobolondi9397
8 ай бұрын
Thanks Mathias, great resource! What happens on the second year when you have items on the same week, but different year?
@mfreihaendig
8 ай бұрын
You’d need to adjust the formula accordingly to also check for the year 😇
@massimilianobolondi9397
8 ай бұрын
Yes, formatDate("W/YYYY") works regardless of the year, I've learnt it the hard way when working with clients who had data spanning across multiple years :-)
@StrijdTegenHaaruitval
9 ай бұрын
Hi Matthias, thank you so much for your explanation. I have an issue however implementing this, when I link my 2 databases and relate them, using the prop.length formula for total amount of entries, is returning 18 entries, even though I only have 16. Any idea of what is happening there?
@mfreihaendig
9 ай бұрын
There‘s been a Notion bug around forever where formulas count templates - so you probably have two templates set up with the relation, right? ☺️ Until they finally fix it, just deduct the number of templates from prop.length inside the formula 💪🏻
@StrijdTegenHaaruitval
9 ай бұрын
@@mfreihaendig I do indeed! So it counts the templates as entries in the database I see! Subtracting 2 would fix that right? Edit: ah didn’t read to the end haha thank you so much
@MaxFilms_no
Жыл бұрын
This was very usefull, thanks! I am wondering - would it be possible to write a formula in such a way that would e.g. only display Total Sales Volume for a current week?
@mfreihaendig
Жыл бұрын
Of course! For that, you can create a helper property in your sales database and use the if() operator to fill the sales volume if it was this week and leave it empty if not 💪🏻
@patriciamauduit9590
Жыл бұрын
Vidéo incroyable ! Ça va m'être très utile. Merci infiniment
@mfreihaendig
Жыл бұрын
De rien ☺️ Super content d'entendre cela
@Itsmyrap
9 ай бұрын
Is there anyway to avoid templates being added to the count? I added the relation to my “new entry” template and noticed the count is off by one. Thanks !
@mfreihaendig
9 ай бұрын
Unfortunately no, that’s been a forever bug in Notion. You need to count your templates and then subtract the number from the analytics in your formulas
@Itsmyrap
9 ай бұрын
@@mfreihaendig Ah ok !! Thanks for the response. I was wrecking my brain trying to figure out why the number was off. 😂 Appreciate the helpful video
@8bulcul
Жыл бұрын
Thank you for the great video today.
@mfreihaendig
Жыл бұрын
Glad you like it! It’s a spin on my first video ever which needed a rework after the last Notion update ☺️
@KavinPrasathCreationsUnique
Жыл бұрын
Awesome video 💯
@mfreihaendig
Жыл бұрын
Appreciate it! ☺️ glad you like it!
@DoYouKnowVikas
Жыл бұрын
Indeed value providing video
@mfreihaendig
Жыл бұрын
Thank you! ☺️
@BigBen6666
Жыл бұрын
Many thanks for the video. This is very helpful. But I got one more question. How can one do this statistics if one has several databases and wants to show the values in different tiles of one statistics database (one tile per database)?
@mfreihaendig
Жыл бұрын
Sure thing! If it’s the same type of values, you could simply create several rows and connect them with different entries of databases to get different calculations 💪🏻 For completely different calculations, I’d probably go with two different analytics databases next to each other. Otherwise, you’d need another layer of helper properties and if statements to switch between the calculations
@BigBen6666
Жыл бұрын
@@mfreihaendig Sorry for my stupid question, but how on earth can I have relations to several databases in one column???
@mfreihaendig
Жыл бұрын
@@BigBen6666 Not in one column ;) If you have three databases with the same type of information (lets say sales for three different sub-companies), you would have one analytics database with calculations and then three separate relations. You'd need to layer in one extra step of a helper property with if statements to take the corresponding values. IF ( relation a filled, then proceed with the values for a, if relation b filled, then proceed with the values for b) and so on So basically, you need to create a separate calculation infrastructure per database that you want to connect 💪🏻
@BigBen6666
Жыл бұрын
@@mfreihaendig Thanks, that makes sense. But it does not grow with the number of databases. 😞
@mfreihaendig
Жыл бұрын
@@BigBen6666 Nope, for that I'd recommend doing it via APIs and automations 💪🏻
@solilos
Жыл бұрын
Excellent!
@mfreihaendig
Жыл бұрын
Happy to hear you like it! ☺️
@hedaboss488
Жыл бұрын
Hey bro, you know how I asked about a notion formula. I wanted a checkbox and I want the formula to show the date of when I checked the box, and shows "no date" when the checkbox is empty. Do you know how to get it to store the current date in a formula or something whenever I check the box?
@mfreihaendig
Жыл бұрын
That’s unfortunately not possible with formulas alone - you could achieve the result with database automations by filling the date properly with now when you check it and then using a separate formula with if statements to either display no date or the date 💪🏻
@tkani5
11 ай бұрын
What if I have complete list of client names and their phone numbers in one database #1 and I have database #2 where I don’t want to see all clients but want to see a certain client or clients if I put his or their phone numbers. Like I fill number and second line fills with clients details. How to build such formulas
@mfreihaendig
11 ай бұрын
That’s a fairly straightforward use of find() You can use this for example: prop("Test Clients").find(current.prop("Number")==prop("Number")) Check out my video on formulas 2.0 for more details: kzitem.info/news/bejne/0ot7qHudZml9ZqA
@tkani5
10 ай бұрын
@@mfreihaendig thank you very much for answer but the problem what I see is that it doesn’t find that prop when I type find bcz this prop is in other database … what I want is to fill information in database 2 which is in database 1
@mfreihaendig
10 ай бұрын
@@tkani5 I assumed you had a relation active between the two databases - that’s the requirement for this to work. Notion isn’t a spreadsheet so you can’t do a vlookup type for operation without first connection databases (and entries) with relations. So in your second database, you’d need to relate all entries to all clients. Then, you can use the above formula if the main value is the one you look up or you put a map() operation inbetween - check this video for more details: kzitem.info/news/bejne/0ot7qHudZml9ZqA
@tkani5
10 ай бұрын
@@mfreihaendig no I can’t work it out , are you available for consultation and showing ? How much it’s gonna be and how to contact you ?
@brunoclement-ziza652
Жыл бұрын
Awesome video, awesome channel. But are you sure you've got 56 sales and not 55 ? The "template" that you created counts for 1 I think.
@mfreihaendig
Жыл бұрын
Oh yeah you got me there - this Notion but trips me up every time 😅 good catch!
@brunoclement-ziza652
Жыл бұрын
I don't know how to deal with it. Put a special character into the template's name and count all the items with this special character, and then substract from de count ?@@mfreihaendig
@prepos9376
Жыл бұрын
@@mfreihaendig and how do I not count the template? I realized that even in the rollups that count the % checked, the template is also considered if connected
@ruuuff
9 ай бұрын
ty
@mfreihaendig
9 ай бұрын
Glad you liked it!
@MohamedEldegla
Жыл бұрын
why don't we just add all the ckeckboxes formulas in the insights database formulas directly and save us all of these extra properties in the sales database ?
@MohamedEldegla
Жыл бұрын
Already Mentioned in the Last Part 😇
@MohamedEldegla
Жыл бұрын
Great Video Thank you so much ❤❤❤❤
@mfreihaendig
Жыл бұрын
Thanks, really appreciate it! ☺️ Comes down what you prefer, if it’s simpler calculations the later method is surely easier and cleaner, just sometimes harder to troubleshoot
@frosecold
Жыл бұрын
You lost me in the first 30 seconds for being an apple fanboy
@mfreihaendig
Жыл бұрын
Haha with all my heart! 😎
@MaxRuso
Жыл бұрын
Android vs apple what is that supposed to mean lol. Apple sucks
@mfreihaendig
Жыл бұрын
Haha quite the opposite 😎 Team Apple all the way 🚀
Пікірлер: 72