Hi community,
I’m trying to trigger an automation in Coda when a checkbox changes state based on a formula. For example, I have a checkbox that automatically checks itself if the sum of two columns is greater than 8.
The problem is that row change automations do not detect formula-driven checkboxes, only manual changes in the cell. I’ve seen suggestions to use a “cache” column that copies the checkbox state so the automation can trigger, but I don’t really understand how that cache column works or how to set it up.
I would like to know if there is a more direct or recommended way to trigger an automation based on a formula-driven checkbox, or if someone can explain how to use the cache column correctly.
1 Like
Hello @Carlos_Moreno ,
What is the cause of the row change (the columns with the numbers). If that is based on manual input (or a form input), you can trigger the automation based on a row change and have the automation check if the sum of the values is greater than 8. If yes, continue the automation, if not, the automation does not execute.
Obviously you have to build a mechanism to prevent the automation on executing if the sum changes from, for example 9 to 10, but you could do that by storing the values in a helper column. Unless you want it to trigger on any change resulting in a value greater than 8.
In the automation you can set the row-change-fields so the automation won’t trigger on the change of a non relevant column.
If you can’t figure it out, please share a dummy doc resembling your project and we can help you in your doc.
1 Like