Clear Field doesn't work

[Anonymous]

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

[sunny_talwar · Accepted solution]

Change select in field search string for years to this

=Max({1}years)

[swuehl]

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]

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]

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]

Aah, a mystery solved

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