An input data was replaced by another newly input data

[kirkwongkk]

Hi all,

I am working on an app and found out input record may sometimes be replaced by another new record.

Say two persons are using the app and creating records. When the first person creates the first record and before he saved, the seond person creates a new record, the first record will be covered by the seond record.

Checked google sheet history, it showed that the first record was there but replaced by the second record.

Any idea how to avoid this problem? Many thanks.

[TeeSee1 · Accepted solution]

How is the key value of your table determined?

If UNIQUEID(), for instance, is used, then two records should be created even if Save is pressed (well,, almost) at the same time.

You need to make sure that the key value is not duplicated when creating a row.

https://support.google.com/appsheet/answer/10106672?hl=en

[kirkwongkk]

Hi, I was using the rownumber as KEY. now try to use UNIQUEID(). hope it will be fine. Thanks for your advice.