Select in field button doesn't work?

[richnorris]

If you create a button with a Select in Field function, and you set the values to values that exist, then it works fine. But we have restriction on section access, so for some uers, the values dont exist for them.  The button is selecting 'France' 'Germany' and 'Spain', but some of the users do not have 'Germany'.

The button applies a number of actions, and for the users who don't have 'Germany' available, it just stops. It doesn't move on to the next actions, and it doesn't select 'France' or 'Spain' either. This seems a bit odd? Is there a way around this? A way to say, 'Select the following value if available'?

[jerem1234 · Accepted solution]

Maybe use the concat function like:

='(' & concat(distinct Country, '|') & ')'

or if you only want specific ones try:

='(' & concat({<Country = {'France', 'Germany', 'Spain'}>}distinct Country, '|') & ')'

Hope this helps!

[#3]

Jeremy's answer should work

If the set analysis still returns nothing, just try with a star to run a research:

='(' & concat({<Country = 'France*', 'Germany*', 'Spain*'}>}distinct Country, '|') & ')'

Fabrice

[richnorris]

Thanks SO MUCH guys, this is a brilliant solution, of course set analysis can cope with non-existant values! It's very strange, because if we try with dummy data, (France|Spain|R'lyeh) It actually works fine with no fuss. It's only when we use Germany specifically in a section-access restricted set of values, where that value has been restricted, that we experience the issue.