My app is overlapping rows if two entries are made within a short period of time

[Excelsoxls]

This started happening recently. Some users have reported that some entries were missing from the table, so I did some tests and I verified that if two users sync data at the same time the last to sync overlaps the previous entry instead of creating a new row.

Some info that might be useful:

- My table is stored in an Excel sheet on OneDrive;

- My table is literally that (it's formatted as a table);

- The table currently has 74k rows (there's the whole last year data and this years's).

Any input as to why this may be happening is really appreciated.

[ChristhianMoren]

The same thing happens to me, but with a single user, meaning that user created records in offline mode, and when they go online and sync in Excel, some records are overwritten.

I took the time to view the records appearing in Excel in real time (I also work with OneDrive), and then I noticed that record "X" appeared, and after a couple of seconds, it was replaced by "Y."

I've been using this application since 2023, and I've been having this problem for a couple of weeks.

[Excelsoxls]

Yeah I'm pretty much in that exact scenario. Been using that app for the last 2 years and it has always worked fine but all of a sudden this started to happen and I'm losing quite a lot of data because of it.

[BlueTech]

I had this issue happen when I used a number column as the key column. The initial value was MAX(Table[Key])+1

This made the new row added by the second user autofill for the key column, the same initial value as the other user's row and over-rid the already added row. I then changed the column type to text and used UNIQUEID() as the initial value and it solved this issue. 

[Excelsoxls]

I already have a column named ID with its initial value set as UNIQUEID() and it is my key column, it's been like that since I created that app 2 years ago but only now this problem started.

[ChristhianMoren]

The same thing is happening to me. I have an ID column with an initial value concatenated with other fields. It's not duplicated under any circumstances, and if it is, it won't save because that field already exists. I've been working this way since 2023, and this problem arose a couple of weeks ago.

I think it's an AppSheet issue; maybe they made an update and it affected the sync.

[ChristhianMoren]

Have you tried contacting AppSheet support?
I did, but they haven't given me any answers or solutions.

[Excelsoxls]

Not yet, but I'm going to.

[T4nk3rChu]

i also notice this behaviour.
At first i thought it was because of the ID (small chance that the id is duplicate when users add 2 new row at the same time)
But when i made the ID more unique with timestamp + Packed UUID + UserID, the problem still happens from time to time and i don't know why