I have a table called appsheet_i_task_in_charge which have a [status] and [date_done]
Im trying to run a data action (set a values in some columns of this row) in [date_done] with a condition if [status]="Completed". Unfortunately, whenever I add a data in my table it automatically run a data in the [date_done] eventhough it didnt meet the condition.
Solved! Go to Solution.
If you want the automation to trigger only when the [status] value changes, you need to Access column values before and after an update - AppSheet Help. Otherwise, any update to a row that already has a status of "COMPLETED" will trigger the automation.
If you want the automation to trigger only when the [status] value changes, you need to Access column values before and after an update - AppSheet Help. Otherwise, any update to a row that already has a status of "COMPLETED" will trigger the automation.
@chiukim wrote:
whenever I add a data in my table it automatically run a data in the [date_done] eventhough it didnt meet the condition.
Are you sure it's the Bot that is doing it?
User | Count |
---|---|
25 | |
24 | |
24 | |
20 | |
16 |