Manipulating Google Sheet while Appsheet app is used

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?

In short: yes.

But…

You might find some instances where edits made by you, or by others, are lost due to overlapping edits if you are doing things while people using the app are making edits.

As far as “Can I put a filter on the sheet and not affect the users” - yes. The filter is for your local interaction, not actually removing records from the table, so it’s a temporary thing for your interaction only.

1 Like

I’d recommend the usage of Filter Views over just a Filter.

1 Like

Of that I’m aware, but the bulk operations I do are in rows that I know are not being updated, so I’m not worried about overlaps.

Well the filter is aesthetic in terms of row visibility yes, but the sorting is physical. When I turn off the filter, the row order remains altered.

Would physically re-sorting the table rows make any difference?

1 Like

Why, what’s the difference to Appsheet?

1 Like

If you don’t have any sorting taken care of in your views (meaning, you left the sorting blank for any inline view) then yes, changing the sorting in the sheet would affect the sorting in the app.

But if all of your inline views have sorting taken care of then the sheet can change around all it wants - the app takes over the sort because you have specified so.

I could be wrong, but I believe I’ve previously experienced direct filters as having a more direct modification of the data, more akin to sorting, versus filter views leaving the base data completely alone, and just showing a view of it.

3 Likes

My experience as well.

2 Likes

I definitely wouldn’t recommend what you intend to do.

Definitely use filter views, not filters. Filters will affect all users so long as the filters are in place.

1 Like