I want to be able to input using controls to each row of data.
I was able to do this by assigning a number to each row and setting parameters for each number
example
id|fruits|price|item|total
1|apple|control(id1 param)|3|calc field(3xid1 param)
2|orrange|control(id2 param)|5|calc field(5xid2 param)
However,currently it is about 10lines,but in the future it will increase to more than 100 lines.
Creating more than 100 parameters is difficult.
Is there a function to create parameters in bulk or a way to a accept input by specifying the row number in a certain column?
What I meant by input was a text field.
I apologize for any mistakes in words or examples.
In the example below, I would like to be able to freely enter or change each value in the price column.
And I would like to multiply the input value of price by the quantity and output it to the total column.
example
id|item|price|quantity|total
1|apple|text field value(id1 param)|3|calc field(quantityĂ—id1 param)
2|orrange|text field value(id2 param)|5|calc field(quantityĂ—id2 param)
If there are only a few rows of data, I can create a parameter for each, but I would like to know if there is an efficient way to do this when there are many rows.