Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a button which selects all values in country field ,i am setting action select in field Country '(INDIA|US|UK*)',it selects correctly, but when i apply background color calculation on activation with if(Region='(INDIA|US|UK*)',LightRed(),black()),it does not work?? any idea
sorry, I didnot try it
what i tried now works in my test
=if (GetFieldSelections(Region)='INDIA, US, UK',Lighred();..)
I guess there is a space between , and next character
and it might depend on the order how you select the regions (if you do by Action it should work)
you Need to concat the regions and test to the result
if (concat(Region,'|')='INDIA|US|UK',LightRed(),...
when you select the regions with '(INDIA|US|UK*) each Region will be selected, bit not within 1 string
thanx linder but still text color not changing
sorry, I didnot try it
what i tried now works in my test
=if (GetFieldSelections(Region)='INDIA, US, UK',Lighred();..)
I guess there is a space between , and next character
and it might depend on the order how you select the regions (if you do by Action it should work)
Color change also working for you?
it works thanx a lot for the solution