Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I was wondering if it is possible to create a Field where the user can choose out of two options using these statements
IF(WildMatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*'),'Billable')
IF(WildMatch(MsgCategories,'*NONBILLABLE*'),'NonBillable')
In Script level try this,
Load
IF(Wildmatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*'),'Billable',
if(WildMatch(MsgCategories,'*NONBILLABLE*'),'NonBillable')) as Flag
Your flag field consist of two field value Billable & NonBillable ...
Hope it is match with your requirment.
Hi
try some thing like this
IF(WildMatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*') and MsgCategories-=' NONBILLABLE' ,
'Billable)
I need IF(WildMatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*'),'Billable') To show up as Billable and IF(WildMatch(MsgCategories,'*NONBILLABLE*'),'NonBillable') AS NonBillable
IF(WildMatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*') and
MsgCategories-=' NONBILLABLE' ,'Billable)
it will gives Billable only
I need IF(WildMatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*'),'Billable') To show up as Billable and IF(WildMatch(MsgCategories,'*NONBILLABLE*'),'NonBillable') To show up as NonBillable
In Script level try this,
Load
IF(Wildmatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*'),'Billable',
if(WildMatch(MsgCategories,'*NONBILLABLE*'),'NonBillable')) as Flag
Your flag field consist of two field value Billable & NonBillable ...
Hope it is match with your requirment.
Thank You so much, It seems like it is working perfectly, however there are messages that can be both billable and non billable, it will not pick that up correct? it will show up as billable only It seems.