CLEAR ALL filters button

[PSES_Inc]

Hi, I am wondering if it is possible to create a button to clear all filters from table?

Thanks!
Nick

[Ander]

@PSES_Inc

I’m sure a button could be used. I use check boxes. Here’s an example:

Filter with two controls with fallback to show all

@zachw Play with this and see if it gives you any ideas:

[Tomas_Sebes]

Hi
Someone found a solution?
Becouse i have also this problem. I have few filters and want them to reset with button.

My filter works little bit wierd becouse when i choose a value from select list, after clikcing it again i see only the selected value and value “Blank”. Is it possible with button select that “Blank” value ?

Thx
Tomas

[anon86103599]

Hi @PSES_Inc,

I have a doc in which I use a table to provide the filter values. This makes it possible and quite simple to implement a button that resets the values (using the ModifyRows action of the button). See the “↻” button here -

[Thomas_Robbs1]

+1 for a suggested solution that uses a simple Button control to reset all of the Interactive Filters so that the table they are filtering is no longer filtered.

It seems straightforward… use a button control that when clicked updates a set of filter controls (referenced by their names) to some value that represents “Blank”.

For me, the missing link is just clarity on how to update multiple filter controls and what value to set them to to represent a “reset”.

Thanks in advance!

[Brendan_Woithe]

Hey there! This is all well and good - except when you need a team to be working on a doc!

[Ian_Nicholson]

The ability to set control values through a formula was recently implemented:

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”…

[Connor_McCormick]

You can probably now have a button called Reset with a formula like:

List(button1, button2, button3).FormulaMap(CurrentValue.SetControlValue(''))