Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to create a button that will select values matching the search criteria:
[Step=1 AND (Status=A OR Status=B)]
And the second button:
[Step=2 AND (Status=A OR Status=B)]
I try to create a button with multiple actions, each of which will select values matching the search criteria.
But I don't see how to provide 2 possible values for one field.
Neither | not ; work as OR
Do you know what kind of scripting is used there?
change your action to
Select values in a field
then put the values to be filtered.
='valueA;valueB'
- Matheus
@mariam_vd
see it this way
='valueA;valueB'
When I type it like that, the button doesn't assign any filers (nothing happens when I press it)
I tried:
='valueA;valueB'
='=valueA;valueB'
='valueA,valueB'
='=valueA,valueB'
='valueA';'valueB'
=''valueA';'valueB''
and other possible variations.
it only works like that:
='value1'
Or like that:
='value2'
And I also tried to add another action, so that the first action apply value 1
and the second action apply value 2
But as there are no operators between the action, each next overwrites the previous one
change your action to
Select values in a field
then put the values to be filtered.
='valueA;valueB'
- Matheus
Thanks, @MatheusC
It worked.
And I was able to add another action (same but for another field), which also worked together with the first one (confined with AND, as I needed)