This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ?
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”)
LinkedIn
Twitter
