When the form is saved I want to change a record from other table

Hello, I have 2 tables
“statistics” with these columns:
product
last purchase
last quantity

“order_detail” with these columns:
order
product
date
quantity

I want that for each record on the table order_detail make an update for the product on the statistics table updating the date and quantity.

How can I do this?

thank you for your help

Use a “reference action”, it is the Action type “execute an Action on a set of rows”, which will trigger an Action on the “other” Table’s record to update it. Have it run via Form Save Behavior or via a Bot.

https://community.appsheet.com/search?q=how%20to%20update%20other%20table%20%23ask

1 Like