Change Inventory Amount Based on Sold Amount (Different Tables)

[App_Gestion]

Hi everyone! New to Appsheet, it’s been great so far!

I can´t seem to figure out how to do the following:

I have an inventory table and an orders table. The inventory table has a stock amount for a given item (column name: Cantidad), when I sell a certain amount of an item that amount gets stored in my Orders table, (column name is the same: Cantidad). What I need to do is: When that order is saved in my orders table, subtract the amount sold from the stock column in the inventory table.

I guess It’s an action that I want to have performed in a workflow, I’ve been trying for a while now, looked at some videos and searched the community, but I can´t seem to figure it out.

Any one that can help?

Thanks!

[Suvrutt_Gurjar]

Hi @App_Gestion ,

Welcome to the AppSheet community.

I believe you may wish to take a look at the following sample app for ideas.

In that app, the quantity in the order details table after adding a line item to the order is deducted from that product’s total quanity in the products table.

https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders?appGuidString=245...

Edit:Made minor spelling corrections.

[App_Gestion]

Hi @Suvrutt_Gurjar, thanks for the quick reply!

I’ll take a look!