I hope, anyone can help me with a question.
Let me describe the problem.
I have a very large table, calles “Master Service Calendar”. It contains the yearly personal calendar of 124 employees, so the table has over 40.000 rows. There are different reasons to use such a big table, and we found (together with the Coda team) no other reasonable solution.
Anyway, the solution works great. But on the years end, these calendars needs to be prepared for the next year. If I would copy that page (which contains the “Master Service Calendar” table) and exchange the calendar values and replace that page, then I would later need to update every formula, which references the old “Master Service Calendar” table.
So my question is: Is there an opportunity or formula to change the calendar date values for the next year via an action?