New Bug Encountered: Changing the value of a column

AppSheet AppSheet Q&A
1

So I often use an action to set a column to “Send Report” and then to “” to trigger a workflow where [Column]=“Send Report”. To do this I’d normally have to create 2 actions to set the column data an another to “execute a sequence of actions” . Doing it this way works fine - the workflow triggers

I’ve tried to use the updated option by having one action set to “Set the values of some columns in this row” and having the same 2 column changes set inside that one action. Doing it this way does not trigger the workflow. Also when I watch the speadsheet cell that should be changed - it never changes. Curriously in the workflow log it shows that it has triggered

Is this a bug or am I using it wrong? Can’t you have the same column changed more than once in the same action?

2

The Set the values of some columns in this row action is one action that modifies several columns in a single row. After all of the column values have been set, then the modified row is saved and then workflow can act on it. By the time workflow sees it, all changes in your action are complete.

Setting multiple column values with this action is equivalent to the user interacting with the row in a form.

2 Likes
3

Thanks for the explanation @Steve

1 Like