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
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |