Set date filters on your Coda tables with 1 click

[@TheOriginalCatfood]

Notes 0:41 - 1:02 It's useful to have a list of backend formulas for calculating values like time/date instead of having them calculated p/ user formula. Imagine having a dozen user formulas that use the same value. It's slower doc load but faster doc running, instead of the reverse. 0:41 - 1:02 Data must be decentralized. 1:57 You can immediately make a column a calculation by selecting the column name and pressing "=" 3:34 Frontend backend frontend backend. 6:55 Using Center alignment makes things look nicer

[@bdv6083]

Excellent video an tips. Does anyone know how we can add the formulas for last year and this year?

[@mr.octopus-plag]

Man, I’m diving in your videos, so much I’m learning! Thanks a lot for sharing this.

[@cozeebees]

2 for 2 for great videos! I love the flexibility coda gives for setting up systems like this. I’m coming from Notion and this video helps me lean into Coda more and update my task / calendar system I have now.

[@HippieP629]

Really slick and one of those things that's so useful bc it'll get clicked a trillion x. Thanks a lot!

[@thecodaguy]

Right? And 3 clicks saved times 1 trillion is 3 trillion! So definitely worth it

[@HippieP629]

@@thecodaguy Question... is it possible to show timeline Hours? I see day, week, month, etc but not hours. Possible?

[@thecodaguy]

@@HippieP629 Hours within a timeline view of an actual table?

[@pioneergarden]

great video Scott!!!

[@sherlock27]

Very very useful & practical!

[@thierryvm]

Excellent video again :), I look forward to the next ones. Could you make one on pls format :), I have a little trouble understanding how it works ^^ Sincerely, Thierryvm

[@thecodaguy]

format function? Check out my tutorial on that until then! coda.io/@simpladocs/format

[@thierryvm]

@@thecodaguy Hello, Thanks for your help Scott :), I still have so much to learn and understand ^^ Sincerely, Thierry

[@erinbungedigital]

How would I extract each date to its own unique row in a table? Or is there a better way to bypass making a list of the dates I need and doing it in a table anyway? Thanks!

[@erinbungedigital]

Hey Scott! Adding this functionality to a doc of mine right now, but I'd also like to have a button that shows all dates again. Any tips on how to make that work?

[@erinbungedigital]

I actually just figured it out! Here it is for anyone else wanting to use this too. Basically I took today's date and added a million days and subtracted a million days, haha! It's not as elegant as I'd like, but it's functional. SetControlValue([YourControl], List(Today() - 1000000, Today() + 1000000))

[@thecodaguy]

Haha I wouldnt recommend adding and subtracting a million days. There are two options 1. Manually place the filter back to "Everything" then use a canvas based formula to draw out its actual listed dates. You can use those to two dates in a button 2. Reference the min() and max() dates within your table as the two dates to pass to the control value. That will functionally be everything!

[@erinbungedigital]

@@thecodaguy Rats! Thought I had something - haha! I'll try your suggestion out and see what I figure out! Thanks!