Hello i normally never ever comment on videos but i just found your channel today and your template and bought it straight away! And im so happy i did this is amazing and you are amazing ive never found a template so organized and clean and has everything im looking for! you will go far in life and thank you so so much!
Wow, thank you so much! 😊 I'm thrilled to hear that you love the template and found it helpful. Your support means a lot to me! If you ever have any questions with the template, feel free to reach out. Thanks again, and happy planning!
Hi i have a question. Am i able to do the watching summary formula with multiple tables and not only "movies and tv series"? if you want a reference here's the formula; lets( total, prop("Movies") and prop("Tv series") and prop("Anime") and prop("Barbie movies") and prop("Ghibli movies") and prop("Kdrama").filter(current).length(), watched, prop("Movies") and prop("Tv series") and prop("Anime") and prop("Barbie movies") and prop("Ghibli movies") and prop("Kdrama").filter(current.prop("Status") == "watched").length(), watching, prop("Movies") and prop("Tv series") and prop("Anime") and prop("Barbie movies") and prop("Ghibli movies") and prop("Kdrama").filter(current.prop("Status") == "watching").length(), planning, prop("Movies") and prop("Tv series") and prop("Anime") and prop("Barbie movies") and prop("Ghibli movies") and prop("Kdrama").filter(current.prop("Status") == "planning").length(), addedThisMonth, prop("Movies") and prop("Tv series") and prop("Anime") and prop("Barbie movies") and prop("Ghibli movies") and prop("Kdrama").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length(), "↳ Total movies: " + total + " " + "↳ Watched: " + watched + " " + "↳ Watching: " + watching + " " + "↳ Planning: " + planning + " " + "↳ Added this month: " + addedThisMonth + " " ) I would appreciate it SO MUCH if you'd help. I've been doing this since 5pm and it's 2am now😅
Hi there, you can definitely link summary to multiple tables, and create a summary. I noticed in your formula, you used "and" to combine multiple tables, instead you should use "+" and add length() function to each property, I created a sample watchlist database with summary formula, you can check it out here: somethingorganizedtutorials.notion.site/Watchlist-Formula-Test-ab7375ed317a4597b3ae5df5850be1e2?pvs=4 I hope it helps
@@somethingorganized Hello again, thank you so much for the fast answer. The watchlist database you have linked won't let me see the summary folder to see the code so I tried to do what you said with the length myself but it only checks in the movies table. When i set the status, or add a title to any of the other tables (tv series, anime, kdrama, barbie movies and ghibli movies) it won't show up on the summary list. So it only works on the "movie" table but not on the rest of the tables Here is my formula: lets( total, prop("Movies").filter(current).length() + prop("Tv series").filter(current).length() + prop("Anime").filter(current).length() + prop("Kdrama").filter(current).length() + prop("Barbie movies").filter(current).length() + prop("Ghibli movies").filter(current).length(), watched, prop("Movies").filter(current.prop("Status") == "Watched").length() + prop("Tv series").filter(current.prop("Status") == "Watched").length() + prop("Anime").filter(current.prop("Status") == "Watched").length() + prop("Kdrama").filter(current.prop("Status") == "Watched").length() + prop("Barbie movies").filter(current.prop("Status") == "Watched").length() + prop("Ghibli movies").filter(current.prop("Status") == "Watched").length(), watching, prop("Movies").filter(current.prop("Status") == "Watching").length() + prop("Tv series").filter(current.prop("Status") == "Watching").length() + prop("Anime").filter(current.prop("Status") == "Watching").length() + prop("Kdrama").filter(current.prop("Status") == "Watching").length() + prop("Barbie movies").filter(current.prop("Status") == "Watching").length() + prop("Ghibli movies").filter(current.prop("Status") == "Watching").length(), planning, prop("Movies").filter(current.prop("Status") == "Planning").length() + prop("Tv series").filter(current.prop("Status") == "Planning").length() + prop("Anime").filter(current.prop("Status") == "Planning").length() + prop("Kdrama").filter(current.prop("Status") == "Planning").length() + prop("Barbie movies").filter(current.prop("Status") == "Planning").length() + prop("Ghibli movies").filter(current.prop("Status") == "Planning").length(), addedThisMonth, prop("Movies").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length() + prop("Tv series").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length() + prop("Anime").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length() + prop("Kdrama").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length() + prop("Barbie movies").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length() + prop("Ghibli movies").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length(), "↳ Total movies: " + total + " " + "↳ Watched: " + watched + " " + "↳ Watching: " + watching + " " + "↳ Planning: " + planning + " " + "↳ Added This Month: " + addedThisMonth + " " ) I hope i'm not asking for too much... i'm really grateful for your help🥲
@@blirss hi, I’m sorry you couldn’t see the formula in the link I shared. Here is the formula sample, you can add mode databases/tables. Make sure in all of your tables have the same properties as Status, Date and created time. I also added the formula in code block in the template I shared you, in case you want to check it again. But this is the formula lets( total, prop("K-Drama").filter(current).length() + prop("Anime").filter(current).length(), watched, prop("K-Drama").filter(current.prop("Status") == "Watched").length() + prop("Anime").filter(current.prop("Status") == "Watched").length(), watching, prop("K-Drama").filter(current.prop("Status") == "Watching").length() + prop("Anime").filter(current.prop("Status") == "Watching").length(), planning, prop("K-Drama").filter(current.prop("Status") == "Not started").length() + prop("Anime").filter(current.prop("Status") == "Not started").length(), addedThisMonth, prop("K-Drama") .filter(current.prop("Created Time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")) .length() + prop("Anime") .filter(current.prop("Created Time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")) .length(), "↳ Total entries: " + total + " " + "↳ Watched: " + watched + " " + "↳ Watching: " + watching + " " + "↳ Planning: " + planning + " " + "↳ Added this month: " + addedThisMonth + " " )
@@somethingorganized Hello once again! It worked! Thank you sincerely for your help, now i can track my movies instead of writing them all down in my notes. Thank you for your time and have a great day
@@ijeomajames9055 hi, you can access the template here, hope it helps somethingorganizedtutorials.notion.site/Watchlist-c6c692060b5b4327bc10b0335ea3f890?pvs=4
And I thought my watchlist was already perfect... Thank you for this! You deserve much more views. 🙌
Thank you so much! 😊 I'm glad you found it helpful. Your support means a lot to me!
Hello i normally never ever comment on videos but i just found your channel today and your template and bought it straight away! And im so happy i did this is amazing and you are amazing ive never found a template so organized and clean and has everything im looking for! you will go far in life and thank you so so much!
Wow, thank you so much! 😊 I'm thrilled to hear that you love the template and found it helpful. Your support means a lot to me! If you ever have any questions with the template, feel free to reach out. Thanks again, and happy planning!
omo 😮 this is so interesting!
Yeah tracking movies & TV series in Notion is so fun 🍿
Hi i have a question. Am i able to do the watching summary formula with multiple tables and not only "movies and tv series"? if you want a reference here's the formula;
lets(
total,
prop("Movies") and prop("Tv series") and prop("Anime") and prop("Barbie movies") and prop("Ghibli movies") and prop("Kdrama").filter(current).length(),
watched, prop("Movies") and prop("Tv series") and prop("Anime") and prop("Barbie movies") and prop("Ghibli movies") and prop("Kdrama").filter(current.prop("Status") == "watched").length(),
watching, prop("Movies") and prop("Tv series") and prop("Anime") and prop("Barbie movies") and prop("Ghibli movies") and prop("Kdrama").filter(current.prop("Status") == "watching").length(),
planning, prop("Movies") and prop("Tv series") and prop("Anime") and prop("Barbie movies") and prop("Ghibli movies") and prop("Kdrama").filter(current.prop("Status") == "planning").length(),
addedThisMonth, prop("Movies") and prop("Tv series") and prop("Anime") and prop("Barbie movies") and prop("Ghibli movies") and prop("Kdrama").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length(),
"↳ Total movies: " + total + "
" +
"↳ Watched: " + watched + "
" +
"↳ Watching: " + watching + "
" +
"↳ Planning: " + planning + "
" +
"↳ Added this month: " + addedThisMonth + "
"
)
I would appreciate it SO MUCH if you'd help. I've been doing this since 5pm and it's 2am now😅
Hi there, you can definitely link summary to multiple tables, and create a summary. I noticed in your formula, you used "and" to combine multiple tables, instead you should use "+" and add length() function to each property,
I created a sample watchlist database with summary formula, you can check it out here:
somethingorganizedtutorials.notion.site/Watchlist-Formula-Test-ab7375ed317a4597b3ae5df5850be1e2?pvs=4
I hope it helps
@@somethingorganized Hello again, thank you so much for the fast answer. The watchlist database you have linked won't let me see the summary folder to see the code so I tried to do what you said with the length myself but it only checks in the movies table. When i set the status, or add a title to any of the other tables (tv series, anime, kdrama, barbie movies and ghibli movies) it won't show up on the summary list. So it only works on the "movie" table but not on the rest of the tables
Here is my formula:
lets(
total, prop("Movies").filter(current).length() +
prop("Tv series").filter(current).length() +
prop("Anime").filter(current).length() +
prop("Kdrama").filter(current).length() +
prop("Barbie movies").filter(current).length() +
prop("Ghibli movies").filter(current).length(),
watched, prop("Movies").filter(current.prop("Status") == "Watched").length() +
prop("Tv series").filter(current.prop("Status") == "Watched").length() +
prop("Anime").filter(current.prop("Status") == "Watched").length() +
prop("Kdrama").filter(current.prop("Status") == "Watched").length() +
prop("Barbie movies").filter(current.prop("Status") == "Watched").length() +
prop("Ghibli movies").filter(current.prop("Status") == "Watched").length(),
watching, prop("Movies").filter(current.prop("Status") == "Watching").length() +
prop("Tv series").filter(current.prop("Status") == "Watching").length() +
prop("Anime").filter(current.prop("Status") == "Watching").length() +
prop("Kdrama").filter(current.prop("Status") == "Watching").length() +
prop("Barbie movies").filter(current.prop("Status") == "Watching").length() +
prop("Ghibli movies").filter(current.prop("Status") == "Watching").length(),
planning, prop("Movies").filter(current.prop("Status") == "Planning").length() +
prop("Tv series").filter(current.prop("Status") == "Planning").length() +
prop("Anime").filter(current.prop("Status") == "Planning").length() +
prop("Kdrama").filter(current.prop("Status") == "Planning").length() +
prop("Barbie movies").filter(current.prop("Status") == "Planning").length() +
prop("Ghibli movies").filter(current.prop("Status") == "Planning").length(),
addedThisMonth, prop("Movies").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length() +
prop("Tv series").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length() +
prop("Anime").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length() +
prop("Kdrama").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length() +
prop("Barbie movies").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length() +
prop("Ghibli movies").filter(current.prop("Created time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM")).length(),
"↳ Total movies: " + total + "
" +
"↳ Watched: " + watched + "
" +
"↳ Watching: " + watching + "
" +
"↳ Planning: " + planning + "
" +
"↳ Added This Month: " + addedThisMonth + "
"
)
I hope i'm not asking for too much... i'm really grateful for your help🥲
@@blirss hi, I’m sorry you couldn’t see the formula in the link I shared.
Here is the formula sample, you can add mode databases/tables. Make sure in all of your tables have the same properties as Status, Date and created time. I also added the formula in code block in the template I shared you, in case you want to check it again. But this is the formula
lets(
total,
prop("K-Drama").filter(current).length() +
prop("Anime").filter(current).length(),
watched,
prop("K-Drama").filter(current.prop("Status") == "Watched").length() +
prop("Anime").filter(current.prop("Status") == "Watched").length(),
watching,
prop("K-Drama").filter(current.prop("Status") == "Watching").length() +
prop("Anime").filter(current.prop("Status") == "Watching").length(),
planning,
prop("K-Drama").filter(current.prop("Status") == "Not started").length() +
prop("Anime").filter(current.prop("Status") == "Not started").length(),
addedThisMonth,
prop("K-Drama")
.filter(current.prop("Created Time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM"))
.length() +
prop("Anime")
.filter(current.prop("Created Time").formatDate("YYYY-MM") == now().formatDate("YYYY-MM"))
.length(),
"↳ Total entries: " + total + "
" +
"↳ Watched: " + watched + "
" +
"↳ Watching: " + watching + "
" +
"↳ Planning: " + planning + "
" +
"↳ Added this month: " + addedThisMonth + "
"
)
@@somethingorganized Hello once again! It worked! Thank you sincerely for your help, now i can track my movies instead of writing them all down in my notes. Thank you for your time and have a great day
@@blirss I’m glad it worked! Have a great day.
Could paste the formular here
Thank you
@@ijeomajames9055 hi, you can access the template here, hope it helps somethingorganizedtutorials.notion.site/Watchlist-c6c692060b5b4327bc10b0335ea3f890?pvs=4