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

[DjLeiii]

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 ?

[Joseph_Seddik]

Please read these guides, and follow the links inside:

• Actions: The Essentials - AppSheet Help 
• Automate workflows - AppSheet Help.