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 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... ☺
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!)
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.
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!!!
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.
Great Video! Question though, is it possible to style the number in case it's below 0 (red) and above (green). I have a formula property that shows me the current balance of an account. I want the balance to be red when below 0 and green when above. I've managed to do it with an if() statement, but then I had the same 'bug' like you had in your video. The Balance has at least 11 digits after the comma and I don't know why it does that. This is my formula: if(prop(Current Balance) < 0, prop(Current Balance).style("b", "red"), prop(Current Balance).style("b","green")) I don't have the issue when I add no style to it, but as soon as I apply the style, it changes from number to text and the Balance is not displayed correctly. Is it even possible to apply a style to a number property?
You can’t apply a style to a number - it will always be transformed to a string You can still do it but then it’s a bit of a pain if you want to have 100 separators still visible 🤔
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 !
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
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
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 💪🏻
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 :-)
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
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: ua-cam.com/video/qUEBGg-7L3k/v-deo.html
@@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
@@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: ua-cam.com/video/qUEBGg-7L3k/v-deo.html
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?
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 💪🏻
@@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
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?
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 💪🏻
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)?
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 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 💪🏻
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?
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 💪🏻
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 ?
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
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
@@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
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!
So glad to hear that! What‘s the first use case you‘re gonna revamp with that? ☺️
@@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... ☺
@@GescheSanten Ouh that sounds so cool! What an awesome implementation 😍😍
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!)
Oh man that really means a lot! Thank you so much 😇 just made my day with that comment!
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.
Indeed! Thanks for listing them ☺️
automations are paid right (except the Slack notification)?
This is one the most helpful Notion videos I have seen! Thanks a lot Matthias.
Oh that means a lot to me ☺️ always trying to provide as much value as possible 😇
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 "
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!!!
Ahhh so glad I could be of help! ☺️
Ah finally! 🙏 I used your counting method with the map function to adapt my invoice template! Thank you
Oh amazing! That’s a great use case 😇
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.
I guess relating items you could also do with automations.
Indeed, that’s a possibility too ☺️ just not available to everyone 😅
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 😎
Great Video! Question though, is it possible to style the number in case it's below 0 (red) and above (green).
I have a formula property that shows me the current balance of an account. I want the balance to be red when below 0 and green when above. I've managed to do it with an if() statement, but then I had the same 'bug' like you had in your video. The Balance has at least 11 digits after the comma and I don't know why it does that. This is my formula:
if(prop(Current Balance) < 0,
prop(Current Balance).style("b", "red"),
prop(Current Balance).style("b","green"))
I don't have the issue when I add no style to it, but as soon as I apply the style, it changes from number to text and the Balance is not displayed correctly.
Is it even possible to apply a style to a number property?
You can’t apply a style to a number - it will always be transformed to a string
You can still do it but then it’s a bit of a pain if you want to have 100 separators still visible 🤔
Thanks for the quick reply!:)
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 !
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
@@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
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
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 💪🏻
ah i miss that point, thank you so much!@@mfreihaendig
Thanks Mathias, great resource! What happens on the second year when you have items on the same week, but different year?
You’d need to adjust the formula accordingly to also check for the year 😇
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 :-)
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
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: ua-cam.com/video/qUEBGg-7L3k/v-deo.html
@@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
@@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:
ua-cam.com/video/qUEBGg-7L3k/v-deo.html
@@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 ?
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?
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 💪🏻
@@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
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?
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 💪🏻
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)?
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
@@mfreihaendig Sorry for my stupid question, but how on earth can I have relations to several databases in one column???
@@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 💪🏻
@@mfreihaendig Thanks, that makes sense. But it does not grow with the number of databases. 😞
@@BigBen6666 Nope, for that I'd recommend doing it via APIs and automations 💪🏻
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?
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 💪🏻
Vidéo incroyable ! Ça va m'être très utile. Merci infiniment
De rien ☺️ Super content d'entendre cela
Indeed value providing video
Thank you! ☺️
Thank you for the great video today.
Glad you like it! It’s a spin on my first video ever which needed a rework after the last Notion update ☺️
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 ?
Already Mentioned in the Last Part 😇
Great Video Thank you so much ❤❤❤❤
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
Excellent!
Happy to hear you like it! ☺️
Awesome video 💯
Appreciate it! ☺️ glad you like it!
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.
Oh yeah you got me there - this Notion but trips me up every time 😅 good catch!
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
@@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
ty
Glad you liked it!
You lost me in the first 30 seconds for being an apple fanboy
Haha with all my heart! 😎
Android vs apple what is that supposed to mean lol. Apple sucks
Haha quite the opposite 😎 Team Apple all the way 🚀