Button that performs action on a control

[Paul_Kazuwa]

In my doc I would like to create a button that can perform an action on a control.
I have a Check box control on which I would want to toggle the status between true and false after clicking a reset button that will also perform other actions simultaneously. Currently I have to click the reset button to perform all other actions and then manually check or uncheck the check box afterwards

On the button actions there is only a “Push Buttons” action. Does anyone have a hack for what I want to do.

[Pch]

You could add to your table a button that will checked/unchecked your checkboxes for you

Can I use Modifyrows() with an if() statement in the value to be modified? Can't get it to work

Hey Steve! Looks like the ModifyRows action does not evaluate new column values on per-row basis. You need to split your action in two: check the checkbox on the rows where it needs to be checked, and uncheck on those that need to be unchecked. Here’s a formula for the “Set” button in the answer above; no need for hidden buttons. RunActions( ModifyRows([Table 1].Filter(Checkbox.Not() AND Value = Input_Colour), Checkbox, true), ModifyRows([Table 1].Filter(Checkbox AND Value != Input_Colour…

Depending on how your doc is built but the Reset button could perhaps push that button for you too

[Andrew_Stinger]

This recent update might also help!

Launched: Set control value action

Have you ever made the perfect table with the perfect set of interactive filters. . . only to realize it takes a few more steps than you’d like for your collaborators to clear or reset the filters? Or wish you could automate a default value for your controls? We have too! I’m honored today to share the news that we’ve launched a new “Set control value” action that you can use in your buttons and automations. [Set Control Value.gif] In the screenshot above, I’ve set-up the “Reset all filters”…