How can I update a table's field when another...

[Mark_Wilhelm]

How can I update a table’s field when another table’s trigger field is changed?

I have two tables - Components and StoresInventory, the components table consists of a master list of serial numbers of components. i want to scan the serial from the physical component, then add it into the StoresInventory table, then update the component table to have the stores name in the StoreName field.

[Aleksi_Alkio]

The easiest way is with the virtual column.

[Mark_Wilhelm]

hmm… interesting idea! could you please elaborate more…?

[Aleksi_Alkio]

You need to lookup the value with the suitable app formula and because it’s in virtual column, it will recalculated when you sync the data. help.appsheet.com - Virtual Columns Virtual Columns help.appsheet.com