This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello team , I would like your help, in the following table there are the orders and the sales, I would like to create an action where every time I add a product to the sales, the quantity of the specific product should be reduced by -1 in the orders2
There is surely a way to create an action to accomplish what you describe--I think I've seen a sample somewhere.
Alternatively, you could add additional columns to the Order table that use app formulas to calculate for each row values like quantity sold, and quantity remaining.
You could evaluate reference actions. The sample app mentioned below adds quantity to the child table. But reference actions need not have the tables referenced to each other as long as the actions know what rows it needs to act on.
In your case the table s sales and orders seem to be related by Barcode. So you could list the rows in the Orders table that need to change when the Sales table quantity increases.
LinkedIn
Twitter
