What happens if I need to duplicate some of the tables, but create connected views with other tables?
In particular: I want to automatically fill in a control (or a row of a table) when duplicating the row that will inform the page what date it refers to. After that, all subsequent tables in the page look at that control to see what rows to display.
I would use a lookup table, but changing the value in that source table will change all the views of that table. I need each page to have a different date.
How might I automatically (using a formula) set a date for a page that will only be changed manually?
E.g. I’d like to somehow automatically fill this control with the current date when a page is duplicated:
