I have a google sheets backend to an appsheet...

(Jason Yellery) #1

I have a google sheets backend to an appsheet app. some data is entered in appsheet and some data is entered directly in sheets. on a few occasions the the updates / edits made directly in google sheets were not saved.

Is there any setting or best practices that could prevent this?

Thanks in advance

(Praveen Seshadri (AppSheet)) #2

There are three possible explanations:

a) you have a high traffic app and as you were making edits directly to the sheet, some updates from the app overwrite them — if so, then the solution is to Pause the app (Manage -> Deploy pane) when you are making direct edits

or

b) the direct edits are successful but then some time later, an update from the app overwrites them. This is by design.

The “last writer wins”.

c) you are adding new rows directly but also adding new rows via the app. In this case, check to see that your key column is chosen well (and not the _RowNumber). If there is a conflict between keys, then one could overwrite the other

(Aleksi Alkio) #3

d) you have chosen the option “Delta Sync” as ON.