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?