Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I am trying to use the IF and Match statements together to create the below expression:
If(GetFieldSelections(Match( Product,'Explorer','Durango,'Highlander','Pathfinder')),RGB(5,66,117))
so that if the selected items match the requirement, the button will be colored Blue (RGB code above).
I keep getting an error and any help rendered will be appreciated.
Thank you.
Try this may be
If(WildMatch(GetFieldSelections(Product),'*Explorer*', '*Durango*', '*Highlander*', '*Pathfinder*'), RGB(5,66,117))
Try this may be
If(WildMatch(GetFieldSelections(Product),'*Explorer*', '*Durango*', '*Highlander*', '*Pathfinder*'), RGB(5,66,117))
Extremely well done there my friend.
Do you mind explaining why we had to use the WildMatch vs. Match?
Well, I was not sure if you are going to ever select one value in Product or can you select multiple values as well... if you are going to just select 1 value..... then you can use this
If(Match(GetFieldSelections(Product),'Explorer', 'Durango', 'Highlander', 'Pathfinder'), RGB(5,66,117))