How to Create an automation that update my inventory quantity after i created/save an invoice

AppSheet AppSheet Q&A
, , ,
1

Dear all,

1st table = product with quantity ( barcode as a key), consider as my inventory
2nd table = invoice form where user can choose item and quantity

now i need help on automation like this scenario below:
When a user created or save a invoice with at least 5 items and each item with different quantity.
How can i update my inventory which is invoice - inventory quantity ?

2

Please read these guides, and follow the links inside:

1 Like