Field Management - Tokens | Community
Skip to main content
Kyle_Lampis
New Participant
September 28, 2018
Solved

Field Management - Tokens

  • September 28, 2018
  • 1 reply
  • 1941 views

I am trying to use a lead token to populate dates into an email. I created the new token based on the data I want reflected from the excel sheet, however when I preview the Email Send via person view, the data does not populate. Other tokens are working just fine in the same email - it's only the one with dates that won't work. I tried changing the 'type' multiple times from date to text to integer - none have worked. I'm wondering if this is an issue with the way I built the token, or if it's an Excel import issue.

Example:

Data in Excel Column I want populated (yyyy):                           Token I created: {{lead.Flex Field-STM Since Date:default=edit me}}
Flex Field-STM Since Date         
2018
2017
2018
1985
2013

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

Just a 4-character year isn't a Date. It's an alphanumeric String (don't be tempted to make it an Integer). So try the import again with the datatype as String.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
September 28, 2018

Just a 4-character year isn't a Date. It's an alphanumeric String (don't be tempted to make it an Integer). So try the import again with the datatype as String.