topic Re: If Match function with AND or OR? in App Development

If Match function with AND or OR?

drminaker — Fri, 12 Aug 2016 18:53:40 GMT

Hi,

Can someone please tell me if it's possible to use AND or OR with a the Match function?

I'm trying to create a custom dimension where I want to pull records from staff who are [Active] and in [Toronto] and name this as 'Available/Toronto'.

The match statements work fine on their own, but I need to combine them using AND. I've tried using several different ways to do this and can't get it to work. Any help, much appreciated.

if(match([Status],'Active'), 'Available/Toronto'

if(match([Location],'Toronto), 'Available/Toronto'

Thanks!

Re: If Match function with AND or OR?

sunny_talwar — Fri, 12 Aug 2016 18:58:26 GMT

May be like this:

If(Match([Status],'Active') and Match([Location],'Toronto'), 'Available/Toronto', FalseCondition)

Re: If Match function with AND or OR?

drminaker — Fri, 12 Aug 2016 19:05:33 GMT

Perfect, thank you so much!

I must have had a comma or parentheses in the wrong place or something. I searched all over trying to find an example of something this basic and wasn't able to. I'll be sure to bookmark this for another time!