Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi frnds
if([BTS Contact]='Manager' and Portfolio ='US Pharma','Kelly ',
if([BTS Contact]='Manager' and Portfolio ='Corporate','’Tasha ',
if([BTS Contact]=' Manager' and Portfolio ='MDS','Juli ',
if([BTS Contact]='Manager' and Portfolio ='MTS (McK Tech Solutions)','Terri ',
if([BTS Contact]='Solution Manager','solution_manager_name',
if([BTS Contact]='Project Manager','project_manager')))))) as contact
it is working in frontend object level but if i apply back end it is not working
here the condition is :"
if([BTS Contact]='Solution Manager' then bring data solution_manager_name field;
if([BTS Contact]='Project Manager then bring data roject_manager' field;
Thanks,
siddiq
Can you use field name without single quote
if([BTS Contact]='Manager' and Portfolio ='US Pharma','Kelly ',
if([BTS Contact]='Manager' and Portfolio ='Corporate','’Tasha ',
if([BTS Contact]=' Manager' and Portfolio ='MDS','Juli ',
if([BTS Contact]='Manager' and Portfolio ='MTS (McK Tech Solutions)','Terri ',
if([BTS Contact]='Solution Manager',Solution_manager_name,
if([BTS Contact]='Project Manager',project_manager)))))) as contact
Did the solution provided here not work for you? Need clarification on if condition with two fields
Thanks sunny now i got it
Can you use field name without single quote
if([BTS Contact]='Manager' and Portfolio ='US Pharma','Kelly ',
if([BTS Contact]='Manager' and Portfolio ='Corporate','’Tasha ',
if([BTS Contact]=' Manager' and Portfolio ='MDS','Juli ',
if([BTS Contact]='Manager' and Portfolio ='MTS (McK Tech Solutions)','Terri ',
if([BTS Contact]='Solution Manager',Solution_manager_name,
if([BTS Contact]='Project Manager',project_manager)))))) as contact