When new new entry added in table b run action in table a

[sunil_prajapati]

HELLO EVERYONE

is it possible,

I have two tables of an inventory table A & table B, table b has inventory modification reference by table A

so whenever I will add an entry in the table for any product modification I will add a new entry with a unique number of the table as a reference and then I need to do a change in column status of table A from in stock to use.

[Steve]

help.appsheet.com

Workflow

Send Email, SMS or Notifications on Add, Update, or Delete.

[sunil_prajapati]

hey steve thx a lot, but can you help me to put the formula in reference row. please let me know in few details.

[OptimiX_XcrY]

Do you want to do inventory/stock corections ?
If yes, I ended up doing it via Gsheet formulas…the stock table A has a column* that sums that row product from table B-inventary/corections . The current stock of a product in table A has formula to calculate based on other tables (sales,etc), “minus” that column*

[sunil_prajapati]

actually, the status of “table a” should change by action when I take any product in “table b” for sales. all product is a reference from “table a” to “table b” and only “in stock” product will be sawed in “table b”. so once I sale a product in “table b” that particular product will be the trigger in “not in stock” or “sold” in “table a” column of “status” automatically.

[OptimiX_XcrY]

Have a column in table a (sheet or virtual) that sums all the quantities of that product from table b.
If in table a , initial stock minus this column <=0 , then your condition is met. Have a slice of table a used in table b if you want to only have in stock options