Is there an AppSheet function to access string in AppSheet's search criteria UX field?

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.

2X_4_4deaa0438ffc6d53cf034e971ed8046f52b55dd0.png

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?

0 9 705
9 REPLIES 9