Hi Appsheet! I am having this problem of cas...

(Philark Cacillo) #1

Hi Appsheet!

I am having this problem of cases where 2 or more users may simultaneously edit the same row of data at the same time. Is there a way that the app can call the SYNC functionality before users can edit a row? (So I could filter out if USER1 has edited first and thus other users cannot edit the same row)

I would appreciate any suggestion. Thank you

(Reza Raoofi) #2

No, that’s not possible; sync is only initiated from device either after 30 minutes from the last sync, or after each row update, or manually from device.

Since AppSheet allows for offline work, therefore it caches data offline and you should not consider it multiuser update on the same row. You may want to read this page too:

https://help.appsheet.com/users/concurrent-usage-with-multiple-users

(Philark Cacillo) #3

Thanks @Levent_KULACOGLU @RezaRaoofi

(Aleksi Alkio) #4

@Philark_Cacillo This doesn’t help you “totally”, but you could check when the last sync was made in the device. If it’s less than one minute, you could be able to update the record. Overwriting can still happen of course if two users are using the record exactly at the same time, but it can help if you can’t structure your app in a better way.

(Levent KULAÇOĞLU) #5

@Philark_Cacillo I’m afraid that’s not possible. Simultaneous users can edit the same row and the the last user’s changes will prevail when the app is synced.