I have a parent table named ORDER with a colu...

(Repo Metrix) #1

I have a parent table named ORDER with a column named STATUS that is enum. I have a related child table named TASKS that also has a STATUS column that is enum. If I change the status in TASKS via action to “Completed” how can I tell Appsheet to go back to the Order table and change the column STATUS to “Completed” also ?

(Aleksi Alkio) #2

The easiest way is the virtual column. Because it’s child record, you could read it’s status like… IF(IN(“Completed”,SELECT([VirtualColumnList][Status],TRUE)),“Completed”,“Not Completed”)