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 ?
Repo_Metrix (Repo Metrix) #1
Aleksi_Alkio (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”)