Trigger query when table checkbox.value is changed

App Building
,
1

How can I trigger a query when a checkbox in a table is checked or unchecked?

2

There are When Checked and When Unchecked events you can select over in the Inspect tab.

3

Thanks for your reply! I can’t find those events in the Inspect tab for a checkbox within a table.

4

My bad, I didn’t notice you said in a table which you very clearly did! Feature request time I guess.

1 Like
5

Bumping this!

6

Hey everyone! This isn't currently possible, since custom columns are largely frontend. I do have a workaround, though!

You can add more logic as needed, but my setup is as follows:

  1. A "dummy" Query JSON with SQL query to watch the table.recordUpdates property and trigger when the table.recordUpdates property changes. This property is the only property that changes with a check/uncheck of a custom column checkbox. This query will just have {{table1.recordUpdates}} in the body.
  2. On Success and more importantly, On Failure (since this dummy query will actually count as failing, since it's not returning any data), trigger your target query.

As a note: watching recordUpdates will trigger this dummy query (and target query) with any change at all to recordUpdates (whether that's unchecking or editing another column). You can disable the dummy query from running on certain conditions (in the Advanced tab) if needed.

7

image
image1830×914 71 KB