Solved: Trigger Action to recalculate ALL rows via API - Page 2

JPAlpano · 08-05-2022 10:04 AM

Scenario:
One set of users only interacts with App based on Table 1.
Another set of users only interacts via GSheet imported as Table2.

Action button created:
I have created an action button which simply changes an [Update Counter] of Table 1 column to +1.
This will trigger all app formulas to recalculate.

Question:
How do I trigger the action button to fire on ALL rows using the API?
Most docs I've seem talks about passing in Keys of specific rows to fire the action on.
But I want all rows to recalculate.

I will call the API via Apps Script but I just need to know the format of that API.

dbaum

When you pass the list of keys from the action to the automation's webhook task to invoke the API, I assume you can simply include all rows with an expression like Table[Key Column].

View solution in original post

dbaum

I indeed meant AppSheet in first bullet and Apps Script in second bullet. So, I guess I misunderstood your scenario. I didn't realize you weren't starting in AppSheet.

If I'm understanding now, then my "Thinking about this a little more...." comment is what's applicable in your scenario. Whatever the trigger is within your script, start by invoking the AppSheet API's Find action to return the keys of the rows you need--either via SELECTOR property, or via a filtered slice defined within AppSheet, or just return all the rows. Once you have the keys, you can then invoke the AppSheet API's Edit action to update the Change Counter or whatever other columns for those rows.

View solution in original post