Is this possible? I’m trying to pull in a row from another table (e.g. “Weight Repeaters”) using a select list. Then, I want to be able to edit a few of the columns from that row (e.g. “Activity Description”, “Time”, etc) to customize it, but I don’t want the source row to change when I do this.
This will be a very ongoing process as we continually build these agendas/training plans – so ideally I can create a smooth, simple process without having to train my team much on how to use it. More screenshots here if it helps.
So every agendas workout has it’s own custom description and duration?
Wouldn’t it make sense to store that info in the agendas table and reference it from the workouts table? This would only make sense for the duration tho, using a formula to just show the most common duration.
The basic answer is: no, this cannot be done. If you are ‘pulling in’ a row from another table, it still is the other table you are looking at. Any edit will show in the source table. With CFL (Coda Formula Language) you can construct buttons to pull in a copy of the row in the source table - and you can edit the copy. Depending on the use and structure of your doc, that might create a lot of extra data in your document, so you have to consider carefully what you want to accomplish. Perhaps a simple text or canvas field to make some notes would do the job too.
you can do this in coda with an action formula.
action formulas can be triggered by a button.
so you need a button that executes the formulas needed to add a new row, and copy into it the data needed from the other table.
so you need to use the AddRow() formula to add a new row with the data required.
this copies in the initial values, but allows the user to edit them later if required.
since the values are copies, the original data is not changed by the edits.
