I have an Appsheet app that is intensively used by about 20 simultaneous users, constantly bombarding the Google Sheet with updates.
While these users are writing their updates, I need to manipulate the data in the Google Sheet to do bulk operations more efficiently, using Google Sheet quick filters and resorting the filtered rows.
The table in question has a proper physical column with unique values set to Key in Appsheet.
My assumption is that I can can manipulate the sheet as described without any issues, because Appsheet writes the updates based on the Key value, not the row number, making the order of rows is irrelevant.
Am I correct or can I run into data integrity issues regardless by manipulating the sheet as described?