I would really appreciate some help with my blocks. I have just started with an app and it is based a production. I have created my database within thunkable and it has 4 columns being Ingredient name, quantity needed per manufactured product, master case quantity, and master case needed. The master case needed is an empty column. The apps function is to calculate how many master case is needed based on the manufacturing quantity. I have tested the function for row 1 by creating a variable for user input for “manufacturing quantity” and it works and calculates correctly however my problem is that now I have to duplicate the blocks for row 1 and change the row id to 2 so it can can make the calculations for the other ingredients. is there a way where thunkable can calculate all the row values for the master case needed column without having to a set of blocks for each row of ingredients.
Sorry for the confusing explanation, Any help would be greatly appreciated.
I have added an example of the block below.