Thanks again Notion should use your videos on its page, They are simple and understandable for beginners
@daniellangewisch4 жыл бұрын
Thanks, Ali. Glad you enjoyed it! Let me know if there are any other specific parts of Notion you’d like me covering.
@Alidid4 жыл бұрын
Daniel Langewisch if it's possible make more videos about Databases, Formulas, Relations, Rollup in different categories like content hub, knowledge hub, daily routines ... i think it will be useful for beginners because of your teaching skills Apologize for my poor English 😅
@daniellangewisch4 жыл бұрын
Will do! Thanks for the feedback!
@tanyadavis32853 жыл бұрын
Could you provide a link to the tracking template you use? I would like to see how the relationships between the weeks and months work. Thanks!
@sunnysworld28793 жыл бұрын
Thanks a lot, although it did take me a while to actually understand the difference between 'relation' and 'rollups' but now I am blown away :D
@daniellangewisch3 жыл бұрын
Thanks! I’m glad this helped! 😃
@JA_YT4 жыл бұрын
Hi, how do you create the go to bed, the stand up and the overall sleeptime column? THis would be very helpful for me:)
@daniellangewisch4 жыл бұрын
So first, I have two "Date" columns that are labeled ToBed and WakeUp. In these fields, I select the date that I am referring to and the time that I either went to bed or woke up. However, those columns aren't very useful for viewing the information because it is formatted like "Aug 01, 2020 10:30pm", where I really just want the time. So, I created a separate column for each and used this formula: slice(format(prop("ToBed")), 12, 21) . Obviously, you replace "ToBed" with "WakeUp" for the second column. This is essentially extracting only the time from the other column so that it only shows the time in this new column. Hope that helps! Let me know if you have any other questions about how to do it!
@JA_YT3 жыл бұрын
Daniel Langewisch Ok, and who do you subtract the standup time from the going to bed time?
@daniellangewisch3 жыл бұрын
So then, I create a new column for "Sleep Hours" and use this formula: round(dateBetween(prop("WakeUp"), prop("ToBed"), "minutes") / 60 * 100) / 100 . This calculates the time between the time you went to bed and time you woke up, converts it into minutes, and then converts it into hours with a decimal.
@DboyHamburg3 жыл бұрын
Thanks for your video. Your example assumes that only one piece per item is purchased. What is the solution if "Jimmy G" needs 2 pairs of shoes?
@daniellangewisch3 жыл бұрын
Hey! Thanks for the reply. There are several ways you could solve this. One possible solution would be to create an individual column for each merchandise and then enter the number for how many items the person bought.
@DboyHamburg3 жыл бұрын
@@daniellangewisch THX and have a nice christmas time
@scrollsandtaps3 жыл бұрын
Small suggestion: Choose to put text of your KZbin video thumbnail towards the left side
@daniellangewisch3 жыл бұрын
Thanks for the feedback! That is something I have realized and am going to try to avoid in the future. Appreciate it 😃