Disappearing fields in the Spreadsheet base

I've created appsheet application with some kind o workflow to our specific business needs and i've found the problem. Randomly in the Spreadsheet base my data have been disappearing, not all row, but some  fields of this row. Is no information in audit history, i can only check this directly in my spreadsheet base, when i'm clicking "show history of changes" , all deleted fields were deleted in one specific time

1 5 119
5 REPLIES 5

I'm not letting people to delete and i have no bots to delete this fields

Steve
Platinum 4
Platinum 4

The behavior you describe can occur when two or more users add a row with the same row key. When that happens, the row added last will replace those added before.

Is there any recommended solution for this type of event? 

Avoid using the same key. Use of UNIQUEID() is the recommended way to generate key column values.

And another question, "row key" with initial value UNIQUEID(), shouldn't solve this problem?

Top Labels in this Space