Use SFDC custom object values in the email as token - Velocity Script Issues | Community
Skip to main content
Monica_Koran
Monica_Koran
New Participant
April 5, 2019
Solved

Use SFDC custom object values in the email as token - Velocity Script Issues

  • April 5, 2019
  • 1 reply
  • 2177 views

I understand that you need to use velocity scripts to pull in custom object data into emails as tokens, but I think I am missing something.

I have a copy of the token here and then I show what it looks like in the acutal email on the lead record and it reads the script, not the value. Thoughts?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

and it reads the script, not the value

That's not actually what's happening.

When Velocity can't find an object property, it prints the offending code, rather than throwing a fatal error (in Java, which Velocity uses under the hood, such errors would be fatal, but Velocity is more casual so the program can continue).

You can change this behavior using the silence operator:

$!SomeVariable

will print either the value of $SomeVariable or nothing (if $SomeVariable doesn't exist), rather than printing the code itself.

Now, that explains the direct reason why you see the code. It doesn't explain why the reference can't be found in your case. To inspect the contents of the list, do this:

#if( !$Institution_Event_Registration__cList.isEmpty() )
#foreach( $reg in $Institution_Event_Registration__cList )
[${foreach.index}]<br>
${reg}
#end
#end

And when posting code (which is far better than a screenshot) please highlight it using the syntax highlighter, as I have above, so it's readable.

Also, it seems like you're using the default syntax injected by the Script Editor, which will eventually cause problems. Please read these important posts:

https://blog.teknkl.com/strive-to-avoid-velocity-formal-references/

https://blog.teknkl.com/script-editor-array-get-index/

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
April 5, 2019

and it reads the script, not the value

That's not actually what's happening.

When Velocity can't find an object property, it prints the offending code, rather than throwing a fatal error (in Java, which Velocity uses under the hood, such errors would be fatal, but Velocity is more casual so the program can continue).

You can change this behavior using the silence operator:

$!SomeVariable

will print either the value of $SomeVariable or nothing (if $SomeVariable doesn't exist), rather than printing the code itself.

Now, that explains the direct reason why you see the code. It doesn't explain why the reference can't be found in your case. To inspect the contents of the list, do this:

#if( !$Institution_Event_Registration__cList.isEmpty() )
#foreach( $reg in $Institution_Event_Registration__cList )
[${foreach.index}]<br>
${reg}
#end
#end

And when posting code (which is far better than a screenshot) please highlight it using the syntax highlighter, as I have above, so it's readable.

Also, it seems like you're using the default syntax injected by the Script Editor, which will eventually cause problems. Please read these important posts:

https://blog.teknkl.com/strive-to-avoid-velocity-formal-references/

https://blog.teknkl.com/script-editor-array-get-index/

Terms & ConditionsAccessibility statement

Loading footer...