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.
In the screenshot above, I’ve set-up the “Reset all filters” button to push two buttons:
- One button sets the value for the priority filter (control) to all of the priority options; and
- One button sets the value for the status filter (control) to all of the status options
Now I don’t have to toggle two different drop-down menus in my doc to choose “Done,” “In Progress,” and “Not Started” in one select list, and then “High,” “Medium,” and “Low” in the other. Ahhhh, the bliss of a single mouse click.
Some other ways you might use the set control value action:
- Set (or reset) a date range for a date column-based control
- Select default values for a select list control
- Pre-fill text in a textbox control
If this inspires you to build other functions, we’d love to hear more. Let us know how you’re using the set control values action in the comments, and tell your mouse-clicking finger(s), “thanks for your patienceーyour moment has arrived!”