AUTOMATION: RUN A DATA ACTION

[chiukim]

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. 

[dbaum · Accepted 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.

[Marc_Dillon]

---

@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?