So I am attempting to switch my water delivery company over to paperless.
I’ve been using app sheet so the drivers can enter the deliveries so I don’t have to do it myself manually.
We have been using it for well over a year, and we have had some issues in the past with the files corrupting, I figured out eventually that this was because I didn’t have a unique identifier for each row and have since fixed that issue.
I decided this week to try to have one of the drivers go completely paperless, and for the reason the entire first half of his day is missing now.
There are 2 columns the driver fills in; how many bottles of water he delivered and how many empty bottles he returns.
Me and one other person often have the workbook open that contains all of the information for the app as we are updating customers or doing other things with it. The driver will try to sync at the end of the day and he will get a message that he is unable to sync(because we have the file open), so we get him to text us and we close it and all is well.
I recently ticked the option in Behavior> Offline/Sync for Automatic updates as we had some data loss occur previously, and this seemed to be periodically adding the changes to the workbook.
I also have the Delayed Sync and Sync on Start option ticked.
Any direction as to what the problem may be would be greatly appreciated.