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 |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |