
Specialist
2019-01-08
09:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Using Match with IF Statement
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.
1,968 Views
1 Solution
Accepted Solutions

MVP
2019-01-08
09:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this may be
If(WildMatch(GetFieldSelections(Product),'*Explorer*', '*Durango*', '*Highlander*', '*Pathfinder*'), RGB(5,66,117))
1,966 Views
3 Replies

MVP
2019-01-08
09:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this may be
If(WildMatch(GetFieldSelections(Product),'*Explorer*', '*Durango*', '*Highlander*', '*Pathfinder*'), RGB(5,66,117))
1,967 Views

Specialist
2019-01-08
09:43 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Extremely well done there my friend.
Do you mind explaining why we had to use the WildMatch vs. Match?
1,959 Views

MVP
2019-01-08
09:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
