How to Update cells in different Tables at the same time?

[Guillermo_Mata]

Hi,

I´m trying to update cells in different tables, When I update the order Status column in my App I need to update the Status column of each Item. An order can have different Items, the items can have different components, and the Items can be from different categories, each category Item has it´s own table.

For example, if the order status change to “Approved”, I need that the Status of each Item and its components change to “Approved”. Depending on the Items, The update has to be done in 3 to 6 tables, How can I do it?

[School_Bus]

Do you want to be able to manually change it for each table, or is one table a master?
If it’s a master I generally connect tables by sharing a uniqueid so I can just use a lookup function.

If that doesn’t work, I think you can make the editable variable just a reference back to your primary table and then make it transfer to each as if it were the primary.

[School_Bus]

Here is the directions for using references

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

[Steve]

If the various status columns of the components aren’t or shouldn’t be editable by the user and the value doesn’t need to be stored in your spreadsheet, you could use a virtual column to propagate the top-level status. The descendant status values would be updated automatically whenever the app syncs, but this update could make a sync take longer.

This is the simplest approach, and a good way to go for relatively new app creators, but there are other, more sophisticated approaches, too. Would the above work for you?