Launched: Set control value action

News from Coda
21

Find myself the right formula for daterangepickerSetControlValue([Select Set control value action Date],List([Set control value action].Date.sort().First(),[Set control value action].Date.sort().last()))

1 Like
22

I think None evaluates to Blank

23

Ah :grin: ! That was a bit confusing :innocent: !

For me None meant there was nothing selected in the multi-select :sweat_smile:, not that it was effectively set on blank !

Well, TIL :blush: .

Thanks for clarifying this @cnr :grin: !

2 Likes
24

Thank you for your feedback! We do not support “everything” as a string right now. if you look at the formula return value for “everything” it just returns some hardcode default value. We can use that, alternatively we can create a default everything control and provide that as the date range value in the formula. Sadly, the display does not show “everything”. The underlying values are the same and is a temporary workaround if you set filters depending on its value.

2 Likes
25

Thank you for your feedback! You can set a blank value with any number spaces wrapped in quotes like " "

1 Like
26

You found it ! Yeah the date range control takes the begin and end date so in your case it takes some data messaging to pass the right input.

1 Like
27

I wish Coda people would stop using these stupid gifs which are useless and distracting. Just film short videos instead with a bit of explanation like normal people. You aren’t helping anyone with these lame silent gifs.

28

But it doesn’t work if I need to use some values and None: type 1, type 2, Blank - "type 1, type 2, "

2 Likes
29

discourse doesn’t allow uploading videos and tutorials normally follow

30

Is “discourse” the software? If so, that is truly sad. These gifs demos have been nothing but frustration for me anyway. They usually just add confusion and anxiety to whatever useless idea they don’t explain. Better nothing than these gifs.

31

Thank you Sergei_G. Would this formula walkaround work for you?

SetControlValue([your select], list(“A”, “B”, “”))

1 Like
32

it doesn’t work

image
image651×901 32.6 KB

33

Hope the next step will be the SetFilterValue - just a button with copied filters values for the view. It’s much easier to do and without additional step to make controls. But result - the same.

1 Like
34

I came here to write exactly the same comment that you were replying to. If your doc is used by other people canvas controls are almost useless on pages that are used a lot (for example for Tasks tables with filters and controls).

There is a way to make controls custom for every user with a helper table that stores filter values for each user, but it’s a very convoluted way to do this.

Count me in as another person who asks for Controls to have an option to be per-user. Peace!

3 Likes
35

For those of us who are less skilled (meaning me!), could you show what the formula would look like for daterangepicker buttons with control values for Today, Yesterday and Last 7 Days?

Thank you!!!

36

This should help!

Here’s the one for the last 180 days:

SetControlValue(MyControl, 
  List(
    Today() - 180,
    Today()
  )
)
3 Likes
37

Hi @Gregg_Stebben,

I agree that the documentation could be improved, pls. find some samples where I tried to clarify the logic:

3 Likes
38

@Connor_McCormick , very well done!

39

All credit goes to @Jean_Pierre_Traets for the improvements they made to the doc

2 Likes
40

This awesome, thank you!