When i added new survey, first columns is changed with last saved survey and it lost

When i added new survey(just yes/no question) and send them on excel sheet, first column is changed with last saved survey and it lost.
Hence. i am losing datas.
Is it related that alert?

0 3 131
3 REPLIES 3

Yes , it is.

I know you canโ€™t use row keys for editable tables, only for read only ones.

Two users , when saving, will kinda have the same row number, and they will โ€œoverwriteโ€.

Best to create another column, as a key column, and use uniqueid() as initial value formula, and hide it for the users.

I actually tried your advise before but it did not work.
I tried one more and it worked exactly.

Thanks

Steve
Platinum 4
Platinum 4

Generally speaking, warning and error messages are there for a reason. You should read and respond to them. In this case, it exactly described your problem.

3X_b_9_b9690b36e57e166be1fdf5fbd8757c3d15533fb7.png

Top Labels in this Space