Hi all!
I would like to add a custom “on submit” action that checks if value of a column “Stage” was changed to “Completed”. Right now, I’ve set a condition to check if “Stage” is set as “Completed”, however, this also triggers the action whenever users press submit on a row that already is “Completed”. I only want the action to run when the value changes to “Completed”.
How can I do this?
Thanks,
Henrik
You might be able to add a column in the table, such as a completion date column or simply a boolean column.
Then modify the IF condition in your action to also check if that new column is empty or unchecked. As a final step in the action, fill that new column with a date or true using an additional Set Column action.
I’m not big on doing stuff like this in an On Submit action but it should probably work. You may need to add a Wait action before that last Set Column if you start to have problems.
Thanks, Jeff! That worked.
I ended up adding a columned “Stage changed” as a boolean and in the custom action added an action to change this to true. Also, added a condition to check that “Stage changed” is empty before running the action.
Awesome. My only suggestion is to change the IF condition to check if the boolean is unchecked instead of empty. Booleans can be either empty, true, or false. If you ever need to uncheck that box, your condition may not work as expected because it will be unchecked (false) but won’t be empty.
Great point, I’ve updated it!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
