Add about 8-9 rows automatically.

[Srikanth_S]

Hello everyone,

I have 4 tables

Product - :  Product Name, Created By

Formula - : Product Name, Ingredient,  Qty per Kg

Production : - Product Name, Qty in Kg

Production Log: Product Name, Ingredient, Qty in Production 

1) Lets assume a Product X has 5 ingredients in the Formula. Number of ingredients can vary.

2) When user creates a production record, I need a BOT automation workaround to create Production Log records as many as there in the formula.  The Qty in the Production Log shall be updated as a multiplicated value of [Qty in Kg] of Production x [Qty Per Kg] of Formula. 

 Could someone help me to have this workaround.

Regards,

Srikanth.

[Aurelien · Accepted solution]

Hi @Srikanth_S 

Here is how to do this without need of a bot:

Looping with Actions (Sample App BUILD Video) - Google Cloud Community

You will need to adapt to your case for adjusting quantity, but this is it 🙂