Update value in another table

Hi, im beginning in appsheet but i cant found how to do the next,
i have 3 tables, product table, inventory table and purchase table.
the purchase table and inventory table have reference the product table, what i need to do is
when i add a new purchase with a status “ongoing” i need to update the column “transit” in the inventory table with the quantity in the purchase row, for example
product1, i have 10 in transit in invetory, when i add a new row in purchase with quantity 20 for that same product and the status is “ongoing”, the column in inventory transit need to be update 10 + 20 = 30
Please help me

0 1 302
1 REPLY 1

Top Labels in this Space