Hi everybody,
I have a table/timeline with various dependencies. So when a dependent row changes the start date, all subsequent rows get updated.
This is great.
What I need now is to be able to differentiate When (on this row) the start date was manually changed by a user from when the start date (on this row) was automatically changed by the Timeline (as a consequence of a change on another row)
GOAL: I need to hook some behaviors to the “If changed by a human/user”
Thank you
Add a checkbox column called “Updated by Automation” that is only updated by the automation.
When the automation is triggered, check for that value.
Thank you very much @Troy_Larson , the issue is that the automations that I’m talking about are not actual automations but " Coda’s Native depedencies" (I probably should have worded the title better), so there is no way for me to add a checkbox column that gets updated whenever a dependency changes the date of a task/row
Ahhh . . . so, maybe check the last update times on the dependent tasks, albeit that’s a sketchy way to do it . . .
Say task 2 depends on task 1 . . . if I update task 1, then task 2 automation could have a conditional to check for automated change:
Like I said, it’s a bit sketchy, but you get the idea.
Thank you very much, I ended up creating a separate date column for the User Input and have it trigger an automation that syncs this to the original date field of the timeline. In the context of the logic that I’m trying to build this seems to work, allowing me to trigger different scenarios according to “who” changed the date. Thank you so much for taking the time. Cheers!
Really clever approach! Nice job!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.