Updating Parent based on all Child column

[Just_a_noobie]

Hello, Appsheet newbie here.

I am trying to automate a bot to change order status from "Open" to "Complete", once all the order details within that order are all either "Complete" or "Cancelled." I'm not sure if this is the best approach either.

I've spent two days trying to find a way to do this, but I only managed to find information on changing Parent when one Child value changes.

For better context:

Order 1

1. Item 1 - Complete
2. Item 2 - Complete
3. Item 3 - Cancelled

(Order 1 status will now change to "Complete")

[dbaum · Accepted solution]

Welcome!

I think the following conversation covers what you're trying to accomplish:  Solved: Event from Virtual Column not firing - Google Cloud Community  

[Steve]

If the child rows are proper child rows by the AppSheet definition (the child row has a Ref-type column that contains the key column value of the parent), you shouldn't need a bot to accomplish what you want--so long as you're willing to capture the result in a virtual column (which is not saved to your data source).