Travis_Schwartz

I'm hoping I can use velocity to populate a link instead of using traditional segmentation or creating multiple versions of emails.   I have a link that I need to show, but the link is going to be reliant on the value in a certain field in the lead record.   The value I am using to populate the field is ${lead.creditCardPromoAmount}   What I need it to do is     If $lead.creditCardPromoAmount = 15,000 then display this unique url elseIf $lead.creditCardPromoAmount = 7,500 then display this unique url elseIf $lead.creditCardPromoAmount = 5,000 then display this unique url elseIf $lead.creditCardPromoAmount = 2,500 then display this unique url     Those are the only possible values that members of this program will have.   ... View more

Our instance of Marketo uses an account number as a unique identifier instead of email address because multiple accounts can use the same email address.    The challenge is when we send them certain types of emails (birthday seems to be the biggest one). I can limit each person to only be able to run through the campaign once per year... the problem pops up when a member has multiple accounts. Marketo is treating individuals with three account numbers as three separate individuals (which is how the system is set up), but I don't want them to receive three birthday emails.   I was thinking it may be possible to create a smart list of duplicates to use as a suppression list, but how do I ensure they get at least one copy?    Has anyone else had something like this come up? Is there a solution? ... View more

Hello,   I'm trying to figure out how to format a date on a custom object. I've seen other posts, but am not finding one that is addressing my specific use case... and if it is, I'm not understanding what I need to change to make it work.   Here is what I started with and it is pulling the date, just not in the format I want/need:   #if( !$customList_cList.isEmpty() ) #foreach( $customList in $customList_cList ) #if( $customList.listID.equals("Returned Item") && !$customList.date1.isEmpty() ) #set( $myDate = $customList.date1 ) #break #end #end #end ${myDate}     Looking at the community and seeing posts from @SanfordWhiteman, I know that I need to incorporate time zones and the like... I found a post that looked similar to what I wanted to do and I ended up with this:   #set( $dateOptions = { "formats" : { "userin" : "yyyy-MM-dd", "userout" : "m d, yyyy" }, "timezones" : { "userin" : "America/Los_Angeles", "userout" : "America/Los_Angeles" }, "locale" : $date.getLocale() } ) #set( $transactionDatelike = $customList_cList.get($lastIndex).date1 ) #set( $transactiontDate = $convert.parseDate( $transactionDatelike, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) ## convert the date to a different format #set( $transactionDate_formatted = $date.format( $dateOptions.formats.userout, $transactionDate, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) $transactionDate_formatted     But I know this isn't going to work, because it's not looking for the Custom List with a List ID of "Returned Item", and it's just spitting out the token value at the end when I test it.   Advice on how to fix this so that it displays the date in m d, yyyy format? ... View more

I created a token based off a prior one that I got help creating, but I keep getting an error with it and I've done all I can to adjust it. The solution is beyond my current knowledge base. I would love some help in understanding what I need to fix to make this token work.   We have a custom object that is called "account". What I am trying to do is the following: 1. Does the member have a custom object called "account" 2. If so, and the description field is ARROWHEAD VISA 3. Display the rate field for that account object.   Below is my token code I've tried implementing. I've ensured all relative boxes are checked as well. #if( !$account_cList.isEmpty() ) #foreach( $account in $account_cList ) #if( $account.description.equals("ARROWHEAD VISA")) #set ( $newRate = $account.rate} ) #break #end #end #end ${newRate}  The values I get when I drag each option are:   ${account_cList.get(0).description} ${account_cList.get(0).rate}   Thank you for your assistance. ... View more

I was tasked with creating an anniversary-style email for our members.   What I am wanting to do is take the existing lead record field Mbrship Open Date, which is when the member joined and create a token for how many years have passed since then. F or example, say your Mbrship Open Date field said 3/9/2020 the value of the Token would be 2. That I could use in the design of the email.   It feels like this may have to be a velocity script, but perhaps maybe it can be done using a smart campaign and a new field that is "years since membership opened" and have the flow step populate that value... I just don't know how to do it, if it was possible.   Thanks ... View more

Please let me know if what I'm wanting to do is possible.   I have a custom list that comes over every day and I have the following fields coming over Date1: this gives the date that the person was added to the list List ID: Referring Members Text3: First name in all caps   What I want to do is have a token that converts the first name (Text3) to proper case for those who are on the list with list ID = "Referring Members" with the date in the date field = today.   Alternatively, if we can't do the date, just pull the Text3 information from the Custom List ID "Referring Members"     ... View more

My team setup a referral campaign where they used a unique ID as a referral promo code to signup new members. I'm just curious if there is a way of connecting those records in a streamlined fashion.   I have the two fields that match: unique id, and promo code, but is there a way to match those back to each other in Marketo? I'm not seeing a way of saying if promo code = unique id (without physically putting the unique id into Marketo), add to list or anything.    It feels like this should be doable because the data exists... I'm just not seeing a way of comparing the two values. ... View more

I have an email using velocity script and I am getting different results between the desktop and mobile versions and I don't know how to solve this.   Here are the emails showing the same code:    But when I view it as a member of the list, it gives me the desired result on desktop, but mobile produces the results from the {{My.ACU-Total-Savings}} token. I'm not sure why it would be doing this... even if there was an error, why does it render correctly on desktop and incorrectly on mobile using the same token?   I've double checked and confirmed that the correct field is being checked in the velocity token. Here is the script for each:   {{my.ACU-Monthly-Payment}} #set($total = $number.currency(${lead.altAutoACUMonthlyPayment})) #set($stringLength = $total.length()) #set($totalb = $total.substring(0,$stringLength)) ${totalb}## #if( $display.alt($lead.altAutoACUMonthlyPayment,"$0") ) #set( $lead.altAutoACUMonthlyPayment = '<span style="font-size:14px;"><p>Contact us.</p></span>' )## #end   {{my.Alt-Auto-Monthly-Payment}} #set($total = $number.currency(${lead.altAutoMonthlyPaymentnotACU})) #set($stringLength = $total.length()) #set($totalb = $total.substring(0,$stringLength)) ${totalb}## #if( $display.alt($lead.altAutoMonthlyPaymentnotACU,"$0") ) #set( $lead.altAutoMonthlyPaymentnotACU = '<span style="font-size:14px;"><p>Contact us.</p></span>' )## #end   {{my.ACU-Total-Savings}} #set($total = $number.currency(${lead.altAutoACUFinanceSavings})) #set($stringLength = $total.length() - 3) #set($totalb = $total.substring(0,$stringLength)) ${totalb}## #if( $display.alt($lead.altAutoACUFinanceSavings,"$0") ) #set( $lead.altAutoACUFinanceSavings = '<span style="font-size:14px;"><p>Contact us.</p></span>' )## #end   Any ideas on what is going on here?   ... View more