Dear Appsheet community,
I have a question about concurrent use of data within the app.
In my spreadsheet, I have a sheet to which I import rows from another system. I then use Appsheet to add new information to those rows, for which there are 10 extra columns. I have about 20 users, so the chance for concurrent use of data is pretty high, and I always have a risk of data loss when two users work on the same row.
I’ve read the articles about concurrent usage and I know that Appsheet is always overwriting the entire row, even if only 1 value was changed. Now I understand that this is the way the platform works, and that app creators just have to find our ways around it.
However, I’m very curious to know why exactly is the platform designed this way and why it isn’t possible to only overwrite data that changed. Perhaps, it is something that Appsheet is planning to change in the future, or, it is the only way of working with gSheets.
I would be very thankful if someone could explain this to me!