Solved: Mixing bulk editing methods with Apsheet API - Page 2

thematgallery · 09-26-2022 03:55 AM

Hello there,

I have an app that relies on bulk editing since it needs to apply changes to specific columns, across multiple rows, simultaneously.

I currently make use of the action button "Data: set the values of some columns in this row" combined with the INPUT() function, that´s set across all of the table´s columns. This way, when I select the rows that I want to edit, it opens up a form that allows me to change specific column values, across all select rows.

Despite this is actually working, it gets super slow when editing +30/40 rows, since it has to run one sync for each column that I change, which makes bulk editing with large datasets quite impractical.

That´s the reason why I started to look forward to make that bulk editing through the API, but I haven´t been succesful, at least for now. I wonder if I could get any help on how to either combine the method firstly described, with an API request, or if I should go for a full restructuring of how changes are made, and working only with the API.

Since I got here because the "low-coding" or "no-coding" was fitting my needs in the first place, now that these challenges come across, I kind of need help to solve more complex stuff...

Thanks for reading it, and all help is appreciated.

WillowMobileSys

Unfortunately, I don't think the INPUT() function can be used in a way to where, it pops-up for input, enter values once and then apply them to several selected rows.

You can build this. Create a Form specifically to capture the values you want to apply, maybe in its own little table. Then use the Editable Table view to allow for selection of the rows by marking them to be updated. Then use a bot for each flagged row to receive the updated values.

If you can automatically choose the rows to be updated, then you can skip the Editable Table part and go right into an action that applies the updates to expression selected rows.

View solution in original post