Say I want to be able to update a certain groups of rows with a button. Let’s say I have a list of subtasks, and when the main task is “Complete”, I want to change the status of all related subtasks to “Complete” as well.
MainTask-Table fields: MainTask-Name, MainTask-Status
SubTask-Table fields: SubTask-Name, Related-MainTask-Name, SubTask-Status
Normally, if coding something like this, I’d start out in MainTask-Table, find all rows in SubTask_Table with the right Related-MainTask-Name, go to the first row, update the SubTask-Status, then loop through all the other rows in the found set until I’m at the last row.
It looks like Coda has something similar with the FunctionMap function?
So if I have a button in the MainTask-Table that says “Mark SubTasks Complete”, how would I do that?
Is it possible to do this with a loop of buttons? Say, for example, I have a button that says “Mark SubTask Complete” in each row of the SubTask table. Then in the MainTasks table, have a button that automatically executes all the buttons in the related rows? Obviously, if there was a fixed number of buttons to push, I can just add in those buttons one at a time, but I don’t know how many subtasks there are for each main task.