i have a spreadsheet connected with thunkable.
This Spreadsheet has header on first row and formula(cell E2) on second row.
Formula, on cell E2, is obtained combining data from cells on second row, and these data arrive from thunkable app. After i have to get the output value inside cell E2 and send it to thunkable.
If i use update it works perfectly. But my question/problem is: if two people, almost simultaneously, try to use it maybe it could be give a synchronazing problem.
I thought to copy formula(E2) on all the column and use a create row in order to give, to different users, different output but extending formula it creates 0,0 output before data arrives and command crete row occupies an empty line without formula.
How can i solve this problem?
Thank to all in advance