Email Script Token Troubles

[Zach_Bollinger]

Hello all,

I am trying to get 3 (A,B,C) different phone numbers to appear in an email based on an email script token and have hit a wall trying to find the issue in my code. When I try to preview a specific person, I get defaulted to the 3rd phone number. The referring fields (A and B)  are text fields and Standard Objects in our Database.

##check if the lead is an A
#if(${lead.XX_A_relationshipmanagertext} =="name 1"#OR"name 2")
            ##if the lead has name or name, use the phone number A 'XXX-XXX-XXXX'
    #set(${lead.XX_A_relationshipmanagertext} = "XXX-XXX-XXXX ")
##check if the lead is an B
#elseif(${lead.XX_B_relationshipmanagertext} ==" name 3 "#OR" name 2  "#OR " name 4 "#OR" name 5")
            ##if the lead has name, or name, or name, or name, use the phone number B 'XXX-XXX-XXXX'
    #set(${lead.XX_B_relationshipmanagertext} = "'XXX-XXX-XXXX ")
#else
            ##otherwise use phone number C  'XXX-XXX-XXXX' 
    #set(${lead.XX_B_relationshipmanagertext} #OR ${lead.XX_A_relationshipmanagertext} == "XXX.XXX.XXXX")
#end
##print the phone number
(${lead.XX_B_relationshipmanagertext} #OR ${lead.XX_A_relationshipmanagertext})

[SanfordWhiteman · Accepted solution]

That code won’t even compile, so it’s a bit beyond a question of logic.

The preferred operator for Boolean OR in Velocity is double-pipe ||. Not recommended but also supported is literal OR. The hash-OR (#OR) you seem to be trying is not supported.

Also a bunch of other attempted assignments that simply won’t work.

You’re better off not using any OR statements but rather a collection-centric approach. Create lists of options and check if the List.contains() the current value.

#set( $relationshipManagerLookup = [
{
 "fieldName" : "XX_A_relationshipmanagertext",
 "text" : ["name 1", "name 2"],
 "phone" : "212-123-4567"
},
{
 "fieldName" : "XX_B_relationshipmanagertext",
 "text" : ["name 3", "name 4", "name 5"],
 "phone" : "313-234-5678"
}
] )
#set( $defaultRelationshipManager = {
 "phone" : "414-345-6789"
} )
##
#foreach( $matchable in $relationshipManagerLookup )
#if( $matchable.text.contains($lead[$matchable.fieldName]) )
#set( $matchedRelMgr = $matchable )
#break
#end
#end
#set( $matchedRelMgr = $display.alt($matchedRelMgr,$defaultRelationshipManager) )
Phone: ${matchedRelMgr.phone}

P.S. I recommend you read my past Velocity posts & comments if you’re going to be supporting VTL tokens in production.... you don’t want to be in an urgent troubleshooting situation without wider experience of the Velocity ecosystem.

[Zach_Bollinger]

Thank you for all of the help, I am reading up on velocity currently. Your code works well!