I want to use an AppSheet Action to store the search criteria (the one entered in the native AppSheet search field) in a table row. I want to perform SQL server-side batch processing on the subset of records shown to the user based on their search criteria.
If I mark each visible record with a process_this_row=true
, all these changes (dozens) need to sync back to the server first, which takes awhile. Instead, Iโm imagining sending the search criteria to the server as a single new row in a control table, triggering a batch job using the search criteria from the AppSheet search field.
Is there a function in AppSheet to get the search criteria string? Or a function that returns a list of ids for the filtered records? Or is there a way to save changes to server in a sub-second (or near sub-second) batch?
User | Count |
---|---|
15 | |
13 | |
8 | |
7 | |
4 |