Button to create rows for the next month

Happy Monday all,

I have a table where I’m pulling in information from Google cal and need rows for each day of the month. Is there a way to have a button add rows for the next month?

Thanks.

1 Like

Yes @Karina_Mikhli you can use the AddRows() formula to add rows to a table. You haven’t provided enough details for me to help you further, but Coda can do this!

1 Like

Thank you.

It’s a table where every row is a new date (it pulls information from other places). So I needed to add a row for 6/8, 6/9, etc. My ask is if there is a way to auto-populate rows with the future dates? This is easy in Excel but I know Coda works differently, so am wondering if it’s possible here at all.

Please let me know if any of this is unclear.

Hey Karina,

If I’m understanding correctly, a set up using Sequence() & FormulaMap() should suffice. I used named formulas to make the button formula easier to read. I’m using Sequence() to list every day of the month between the start and end dates, then I’m using FormulaMap() to add a row to the table for every day of the month. It’s meant to be run on the first of the month by automation though since it uses the Today() formula, but I’d imagine you can use Controls or manually set the start/end values if you’d like to populate the dates ahead of time.

Hope this helps!

2 Likes

Thank you! I’ll try to implement this soon and let you know if I have any questions.

Here’s another example using Date pickers instead of formula-generated constants. This will allow you to adjust the start & end dates of rows to be printed to the table.

3 Likes

Thanks again for all your help.

1 Like