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.
Solved! Go to 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 🙂
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 🙂
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |