Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Clear Field doesn't work

Hi guys,

           I have a little problem, I created a button with there two actions in this order:

  1. clear all field;
  2. select max value of field A.

Now when I press the button never change.

For example, suppose the field has three values:

  • 2015
  • 2016
  • 2017

and now 2015 is selected.

So when I press the button, the new selected value should be 2017, but the selected value remain 2015.

What's the problem?

I attach a very simple example.

Thanks to all

1 Solution

Accepted Solutions
sunny_talwar

Change select in field search string for years to this

=Max({1}years)

View solution in original post

5 Replies
sunny_talwar

Change select in field search string for years to this

=Max({1}years)

swuehl
MVP
MVP

As search string, use

=Max({1}years)

You may or may not want to remove the first action, depending on your complete requirements.

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Not sure why your Clear All action is failing, but I can confirm that I am also experiencing this.

Instead I'd suggest:

- remove the Clear All Action

- change the expression in your 'Select In Field to =max({1} years)

swuehl
MVP
MVP

Well, you might expect that the actions are executed one after the other and that the second action's search string expression is evaluated based on the selection status after the first action finished - but that's unfortunately not true, AFAIK.

I believe, the context of the search string evaluation is determined prior the execution of any action.

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Aah, a mystery solved

I very rarely use triggers for selections so hopefully will avoid this in my day job!