I have a stock adjustment data to be approved like in attached pict.
In case of approval. Approver will click the check box on the right side. Is it possible to create new multi rows from these checked data?
I have tried to update such rows but problems occur when I have a new stock counting for those record again. Hence, I need to add new rows instead.
this task is complicated and you need advanced knowledge in glide to accomplish it.
There are multiple threads in this forum to do it…
Always the best solution, no matter what anyone else says… is google scripts…
It may not be ideal since you have a lot of information to show in a Grid style view, but if you can fit it in a Table style view, then you could add actions to each row that could be modified to add a row whenever that action is selected.