Knowing if a selection content a certain value

[romain_p]

Hello guys,

I am trying change the color of a Text_Object depending of the selection of a Field.

The field name is [Quarter], and the Text_Object might turn Orange() when the value 'Q3 19' is selected.

It works when I select only 'Q3 19'  in the field, but not if I select several values ('Q3 19' & 'Q4 19' for example).

The script is like that for the moment:

if([Quarter]='Q3 19',RGB(240,171,0),RGB(217,217,217))

Do you have any solution?

Thanks a lot in advance!

[Vegar · Accepted solution]

Try something like this.

=if( SubStringCount('|' & Concat([Quarter], '|') &'|', '|Q3 19|') ,
     RGB(240,171,0),
     RGB(217,217,217)
    )

[romain_p]

It works!

Thanks a lot Vegar!