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.

In the screenshot above, I’ve set-up the “Reset all filters” button to push two buttons:

  1. One button sets the value for the priority filter (control) to all of the priority options; and
  2. 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. :woman_in_lotus_position:

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

51 Likes

This is fantastic, well done, that was indeed missing a lot.

3 Likes

Yes Coda team. You are bloody legends. This is such an awesome tool - simple yet massively powerful.

9 Likes

Awesome new functionality!

To be honest I didn’t know I needed it until I saw it made! It opens so much options in my mind!

Thanks for shipping cool stuff every week!

3 Likes

Hi, this is exciting!
Is it possible (yet) to have different users seeing different views of the same table at the same time? for your example above, let’s say you wanted to see the “High + not started”, but I wanted to see “all” and we were both on the page.

This has been an unfortunate limitation of the table views which causes us to create a lot of different views for different use cases.

Would love to know if/when user-specific views are available (beyond the opportunity to filter lists by those assigned to ‘current user’).

1 Like

Hi Allison!

For now, Controls are still applied on a per-doc level vs. a per-user level, which means collaborators viewing the same table on the same page will see the same set of filters. The alternative would be duplicate instances of the same table on different pages with unique controls. We’ve been hearing this feedback quite a bit lately, though, and are working way throughs to address it down the road–thanks for your feedback and great example.

…and the workaround to set up user-specific filters with a helper table is still here, @Allison_LaValley!

Welcome to the Community!


As for the improvement itself, that’s a great addition! Way to go Coda!

2 Likes

Here comes some more Coda awesomeness :+1: :partying_face: !!!

Thank you :grin: !!!

1 Like

P.S. How do you select All?

Setting to full table with control.SetControlValue(Table) shows “Something +15 more” but not “All”.

1 Like

This Codan loves this new feature, too!!! Thanks to our amazing eng team!

5 Likes

This is a really usefull feature! But I am thinking, Why didn’t you use the RunActions() formula to clean them all? At least, for me, it works and I don’t need to create more buttons to be pushed.

Official documentation for SetControlValue()

SetControlValue (control, value)

Set the value of a control

SetControlValue(StatusTextbox, "Done")

An action which when triggered will set the StatusTextbox to Done.

INPUTS

control

The control to set

value

The value to set for the control

OUTPUT

Outputs an action value which (when run) will set the specified control with value.

1 Like

Hi Paul, thanks for the feedback, i believe “select all” is not yet possible but something we will definitely consider adding in the next iteration.

2 Likes

To “select all” in a column in the GIF example, my formula was [Table Name].[Column Name].totext(), which selected all of the choices in the source column for the lookup (and did not select “Select All” nor “Blanks”)

3 Likes

And just want to add that Paul’s workaround is actually a really powerful tool in its own right. We use a bunch of these (UI tables that have one row per user, and then just show the current user’s row) in our small business database/project management system, and they work incredibly well.

I will also be re-working a bunch of menus with this new feature straight away, as it simplifies a bunch of things that we’ve done to essentially give the same usability, but with tonnes more mucking around (and some not great UX as a result!)

This is awesome.

Thanks

1 Like

This is game changing for so many of my docs where I would still sometimes use a table instead of text input so that I could adjust the value later if I needed to with a button/automation

4 Likes

Hi,

Thanks for this great addition. I got it to work on one doc (reset slider value with a button) but when I tried to have it reset a date interactive filter, I wasn’t sure how to translate “everything” into the default value.

Thanks.

1 Like

image Can’t set up date range by this SetControlValue([Select Set control value action Date],[Set control value action].Date.ToText()). Look at the error messge. Please check that

Dear Coda-Team!

Now we just need simple custom multi select tags to categorise items with ease. Please!!!

Best, Calvin

1 Like

Would there be a way to set the value to blank too with multi-select control ? :blush:

It works with single-select but on multi-select I only get the None (whatever formula I try) :blush: