Solved: Batch-update rows quickly in the backend without c... - Page 2

C2

Hi everyone,

I’m looking for the best practice to quickly batch-update a large number of rows in AppSheet without triggering slow client-side updates (one-by-one).

For example, currently I have an action like: Set the value of this row [select] = "Yes". If I select 100 rows, I’ll see 100 separate updates on the client side, which is slow and visually disruptive.

Has anyone implemented a backend solution (e.g., Google Apps Script or webhook) to update multiple rows quickly in the background? If yes, could you share your experience or an example of how you set this up?

Thanks in advance!

Steve

What you want to do is not possible with the built-in bulk selection mechanism. The alternative is implementing your own filtering and selection feature that captures the selection in an EnumList column of a single row. That single row could then trigger a bot to act on the many selections captured by the EnumList.

View solution in original post

Batch-update rows quickly in the backend without client-side lag