• Replies 8 replies
  • Subscribers 416 subscribers
  • Views 83 views
  • Users 0 members are here
Related

Using OR in Conditional Mask for Data Element

David Pitak
$organization

Hey all,

 

I've been trying to use this without any success.  Basically I'd like any element to show if peformance code(or description) contains certain strings, and to be blank ('') otherwise.

 

I've tried if(val like 'string1%' or val like 'string2%', 'Output', '')  

 

Is there a syntax that will make this work?

 

Thanks,

David

Parents
  • $organization

    Hey David,

    I've never tried using "like" in an If statement before in Design Element Properties, but here is an example of a type of statement that definitely works for me.

    If(val='123456','HAPPY'+(val),'')

    The output of this will of course be HAPPY123456 or nothing.

    Maybe it's the spaces in yours that make it not work? Try using 'val' instead of 'Output' perhaps?

    Once you get it up and running, it allows you to do some really cool stuff on Ticket Design.

    Best of luck!

    Beau @ Arts Centre Melbourne 

Reply
  • $organization

    Hey David,

    I've never tried using "like" in an If statement before in Design Element Properties, but here is an example of a type of statement that definitely works for me.

    If(val='123456','HAPPY'+(val),'')

    The output of this will of course be HAPPY123456 or nothing.

    Maybe it's the spaces in yours that make it not work? Try using 'val' instead of 'Output' perhaps?

    Once you get it up and running, it allows you to do some really cool stuff on Ticket Design.

    Best of luck!

    Beau @ Arts Centre Melbourne 

Children
No Data