About Michael_McGowa1

Michael_McGowa1 · ‎08-30-2022

I changed the code so I am comparing 0 instead of "" and seems to be working in the actual sends and test sends. The only issue is that if I look in the preview the token outputs $0 and if I view the email as a webpage it also shows $0. I can remove the view as webpage if needed but is there any way that it can be consistent? That the correct output be shown in the preview, sent email and viewed as a webpage? Otherwise, I'll call it resolved. Thank you for your help

Michael_McGowa1 · ‎08-30-2022

Added that code to the script. Here is the output from that. <div class="mc-ip-hide"><div style="color:#000000; font-size:12px; text-align:left; font-family:Helvetica, Arial, sans-serif;"><strong>CAUTION: External email. Please use caution when clicking links or opening attachments</strong><br></div><hr></div> <div id="body" class="mktoText" style="font-family: Helvetica, Arial, Sans-Serif; padding:10px;"> $0 <span style="color: #000000; font-family: Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">{mktoEmailable=1, mktotakenNiche=0, mktotakenJuno=0, mktoeligibleniche=1, mktocoreg=, mktotakenBold=0, mktotakenChristianConnector=0, mktoeligiblebold=1, mktoeligiblechristianc=0, mktoeligiblejuno=0, mktoeligiblenitro=1, mktocoreg2scp=0, mktotakenNitro=0} class java.lang.String mktoEmailable 1 class java.lang.String mktotakenNiche 0 class java.lang.String mktotakenJuno 0 class java.lang.String mktoeligibleniche 1 class java.lang.String mktocoreg class java.lang.String mktotakenBold 0 class java.lang.String mktotakenChristianConnector 0 class java.lang.String mktoeligiblebold 1 class java.lang.String mktoeligiblechristianc 0 class java.lang.String mktoeligiblejuno 0 class java.lang.String mktoeligiblenitro 1 class java.lang.String mktocoreg2scp 0 class java.lang.String mktotakenNitro 0 </span> </div>

Michael_McGowa1 · ‎08-30-2022

Below is the new output with the new token with $lead in the script. You needed me to make a new script token with just $lead in the script. That was the disconnect. I hope this is what you are after. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head> <body><div class="mc-ip-hide"><div style="color:#000000; font-size:12px; text-align:left; font-family:Helvetica, Arial, sans-serif;"><strong>CAUTION: External email. Please use caution when clicking links or opening attachments</strong><br></div><hr></div> <div id="body" class="mktoText" style="font-family: Helvetica, Arial, Sans-Serif; padding:10px;"> $0 <span style="color: #000000; font-family: Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">{mktoEmailable=1, mktotakenNiche=0, mktotakenJuno=0, mktoeligibleniche=1, mktocoreg=, mktotakenBold=0, mktotakenChristianConnector=0, mktoeligiblebold=1, mktoeligiblechristianc=0, mktoeligiblejuno=0, mktoeligiblenitro=1, mktocoreg2scp=0, mktotakenNitro=0}</span> </div>  </body> </html>

Michael_McGowa1 · ‎08-30-2022

It's one token. Just the dollar amount is the token because it is used in the subject line as well as the body of the email.

Michael_McGowa1 · ‎08-30-2022

Here is the output of the email after I sent it. This is being viewed in Outlook but also comes out this way in other ISPs like Gmail. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head> <body><div class="mc-ip-hide"><div style="color:#000000; font-size:12px; text-align:left; font-family:Helvetica, Arial, sans-serif;"><strong>CAUTION: External email. Please use caution when clicking links or opening attachments</strong><br></div><hr></div> <div id="body" class="mktoText" style="font-family: Helvetica, Arial, Sans-Serif; padding:10px;"> You qualify for these easy scholarships worth 0 this month: </div>  </body> </html> I also noticed that when I view the email as a webpage, the token renders as it should. Here is the output from the View as Webpage. <div class="mktoText" id="text"> Hey Michael, <br> You qualify for these easy scholarships worth 29,000 this month: </div> Hope this is what you are after. Let me know if you need anything else.

Michael_McGowa1 · ‎08-29-2022

I am not sure what you mean. Do you need to see the code of the email where this appears? Here is that. You qualify for these easy scholarships worth: {{my.dollarAmt}} Here is the output that I am seeing: Here is what I see in the preview: Let me know if you need anything else.

Michael_McGowa1 · ‎08-29-2022

I updated the code as you suggested but still having the problem. Here is the new code: ##********Finding out if they came through the CoReg #set ($coReg = ${lead.mktocoreg}) #set ($coReg2Scp = ${lead.mktocoreg2scp}) #if($coReg.equals("niche")) #set ($coRegMkt = "yes") #elseif ($coReg.equals("campusreel")) #set ($coRegMkt = "yes") #else #set ($coRegMkt = "no") #end ##********Finding out if they came through the CoReg and converted or Just Member #if(($coReg2Scp.equals("")) && ($coRegMkt.equals("yes"))) #set ($scpMember = "Coreg Not a Member") #elseif (($coReg2Scp.equals("1")) && ($coRegMkt.equals("yes"))) #set ($scpMember = "Coreg but member") #else #set ($scpMember = "Member") #end ##******************Eligible or Taken Bold********** #set ($takenBold = ${lead.mktotakenBold}) #set ($eligibleBold = ${lead.mktoeligiblebold}) #if (($eligibleBold.equals("1")) && ($takenBold.equals(""))) #set ($showBold = 25000) #else #set ($showBold = 0) #end ##******************Eligible or Taken Juno********** ##set ($takenJuno = ${lead.mktotakenJuno}) ##set ($eligibleJuno = ${lead.mktoeligiblejuno}) ##if (($eligibleJuno.equals("1")) && ($takenJuno.equals(""))) ##set ($showJuno = 2500) ##else ##set ($showJuno = 0) ##end ##******************Eligible or Taken Niche********** #set ($takenNiche = ${lead.mktotakenNiche}) #set ($eligibleNiche = ${lead.mktoeligibleniche}) #if (($scpMember.equals("Coreg Not a Member")) && ($coReg.equals("niche"))) #set ($showNiche = 0) #elseif (($eligibleNiche.equals("")) && ($coReg.equals("campusreel")) && ($takenNiche.equals(""))) #set ($showNiche = 2000) #elseif (($eligibleNiche.equals("1")) && ($takenNiche.equals(""))) #set ($showNiche = 2000) #else #set ($showNiche = 0) #end ##******************Eligible or Taken Christian Connector********** #set ($takenCC = ${lead.mktotakenChristianConnector}) #set ($eligibleCC = ${lead.mktoeligiblechristianc}) #if (($eligibleCC.equals("1")) && ($takenCC.equals(""))) #set ($showCC = 2500) #else #set ($showCC = 0) #end ##******************Eligible or Taken Nitro********** #set ($takenNitro = ${lead.mktotakenNitro}) #set ($eligibleNitro = ${lead.mktoeligiblenitro}) #if (($eligibleNitro.equals("1")) && ($takenNitro.equals(""))) #set ($showNitro = 2000) #else #set ($showNitro = 0) #end ##Adding up the dollars available #set ($subtotal = $math.add($showNiche, $showBold, $showNitro, $showCC)) #set ($formattedTotal = $number.format("number", $subtotal)) ${formattedTotal} In the body and subject line of the email, I have the token {{my.dollarAmt}}. The reason why I had two dollar signs in the output is because this is to show a dollar amount (i.e. $25,000). I'm at a loss of what to do and frustrated that when I look at the preview, the code is working as it should. It's when I send the email that it shows 0. What am I missing in the code so the correct number gets into the send email and is in a US currency format?

Michael_McGowa1 · ‎08-29-2022

I sent a real email and this problems persists. Can you tell me what is causing this and how to fix it?

Michael_McGowa1 · ‎08-26-2022

I have a script in an email that is adding the dollar amount of offers a person is eligible for and showing that in the subject line and the body. When I look at the email in the preview it is working as it should. Here is a screenshot. However, when I send a test email, I am seeing the following. What is happening? Here is the script I am using. ##********Finding out if they came through the CoReg #set ($coReg = ${lead.mktocoreg}) #set ($coReg2Scp = ${lead.mktocoreg2scp}) #if($coReg.equals("niche")) #set ($coRegMkt = "yes") #elseif ($coReg.equals("campusreel")) #set ($coRegMkt = "yes") #else #set ($coRegMkt = "no") #end ##********Finding out if they came through the CoReg and converted or Just Member #if(($coReg2Scp.equals("")) && ($coRegMkt.equals("yes"))) #set ($scpMember = "Coreg Not a Member") #elseif (($coReg2Scp.equals("1")) && ($coRegMkt.equals("yes"))) #set ($scpMember = "Coreg but member") #else #set ($scpMember = "Member") #end ##******************Eligible or Taken Bold********** #set ($takenBold = ${lead.mktotakenBold}) #set ($eligibleBold = ${lead.mktoeligiblebold}) #if (($eligibleBold.equals("1")) && ($takenBold.equals(""))) #set ($showBold = 25000) #else #set ($showBold = 0) #end ##******************Eligible or Taken Niche********** #set ($takenNiche = ${lead.mktotakenNiche}) #set ($eligibleNiche = ${lead.mktoeligibleniche}) #if (($scpMember.equals("Coreg Not a Member")) && ($coReg.equals("niche"))) #set ($showNiche = 0) #elseif (($eligibleNiche.equals("")) && ($coReg.equals("campusreel")) && ($takenNiche.equals(""))) #set ($showNiche = 2000) #elseif (($eligibleNiche.equals("1")) && ($takenNiche.equals(""))) #set ($showNiche = 2000) #else #set ($showNiche = 0) #end ##******************Eligible or Taken Christian Connector********** #set ($takenCC = ${lead.mktotakenChristianConnector}) #set ($eligibleCC = ${lead.mktoeligiblechristianc}) #if (($eligibleCC.equals("1")) && ($takenCC.equals(""))) #set ($showCC = 2500) #else #set ($showCC = 0) #end ##******************Eligible or Taken Nitro********** #set ($takenNitro = ${lead.mktotakenNitro}) #set ($eligibleNitro = ${lead.mktoeligiblenitro}) #if (($eligibleNitro.equals("1")) && ($takenNitro.equals(""))) #set ($showNitro = 2000) #else #set ($showNitro = 0) #end ##Adding up the dollars available #set ($subtotal = $math.add($showNiche, $showBold, $showNitro, $showCC)) #set ($formattedTotal = $number.format("number", $subtotal)) $${formattedTotal}

Michael_McGowa1 · ‎07-25-2022

Got it. Thanks Sanford.

Michael_McGowa1 · ‎07-25-2022

I took away the spaces but now the entire subject line is moving as if there is a tab space before the subject line Also I am the encoding is still showing up in the body of the email Any suggestions? Here is the updated code. ##********Finding out if they came through the CoReg #set ($coReg = ${lead.mktocoreg}) #set ($coReg2Scp = ${lead.mktocoreg2scp}) #if($coReg.equals("niche")) #set ($coRegMkt = "yes") #elseif ($coReg.equals("campusreel")) #set ($coRegMkt = "yes") #else #set ($coRegMkt = "no") #end ##********Finding out if they came through the CoReg and converted or Just Member #if(($coReg2Scp.equals("")) && ($coRegMkt.equals("yes"))) #set ($scpMember = "Coreg Not a Member") #elseif (($coReg2Scp.equals("1")) && ($coRegMkt.equals("yes"))) #set ($scpMember = "Coreg but member") #else #set ($scpMember = "Member") #end ##******************Eligible or Taken Bold********** #set ($takenBold = ${lead.mktotakenBold}) #set ($eligibleBold = ${lead.mktoeligiblebold}) #if (($eligibleBold.equals("1")) && ($takenBold.equals(""))) #set ($showBold = 25000) #else #set ($showBold = 0) #end ##******************Eligible or Taken Juno********** #set ($takenJuno = ${lead.mktotakenJuno}) #set ($eligibleJuno = ${lead.mktoeligiblejuno}) #if (($eligibleJuno.equals("1")) && ($takenJuno.equals(""))) #set ($showJuno = 2500) #else #set ($showJuno = 0) #end ##******************Eligible or Taken Niche********** #set ($takenNiche = ${lead.mktotakenNiche}) #set ($eligibleNiche = ${lead.mktoeligibleniche}) #if (($scpMember.equals("Coreg Not a Member")) && ($coReg.equals("niche"))) #set ($showNiche = 0) #elseif (($eligibleNiche.equals("")) && ($coReg.equals("campusreel")) && ($takenNiche.equals(""))) #set ($showNiche = 2000) #elseif (($eligibleNiche.equals("1")) && ($takenNiche.equals(""))) #set ($showNiche = 2000) #else #set ($showNiche = 0) #end ##******************Eligible or Taken Christian Connector********** #set ($takenCC = ${lead.mktotakenChristianConnector}) #set ($eligibleCC = ${lead.mktoeligiblechristianc}) #if (($eligibleCC.equals("1")) && ($takenCC.equals(""))) #set ($showCC = 2500) #else #set ($showCC = 0) #end ##******************Eligible or Taken Nitro********** #set ($takenNitro = ${lead.mktotakenNitro}) #set ($eligibleNitro = ${lead.mktoeligiblenitro}) #if (($eligibleNitro.equals("1")) && ($takenNitro.equals(""))) #set ($showNitro = 2000) #else #set ($showNitro = 0) #end ##Adding up the dollars available #set ($subtotal = $math.add($showNiche, $showBold, $showNitro, $showCC, $showJuno, 13000)) #set ($formattedTotal = $number.format("number", $subtotal)) =?UTF-8?Q?${esc.d}?=${formattedTotal}

Michael_McGowa1 · ‎07-25-2022

Hi Sanford, Below is the full script token. With the subject line I am seeing: And in the body of the email I am seeing ##********Finding out if they came through the CoReg #set ($coReg = ${lead.mktocoreg}) #set ($coReg2Scp = ${lead.mktocoreg2scp}) #if($coReg.equals("niche")) #set ($coRegMkt = "yes") #elseif ($coReg.equals("campusreel")) #set ($coRegMkt = "yes") #else #set ($coRegMkt = "no") #end ##********Finding out if they came through the CoReg and converted or Just Member #if(($coReg2Scp.equals("")) && ($coRegMkt.equals("yes"))) #set ($scpMember = "Coreg Not a Member") #elseif (($coReg2Scp.equals("1")) && ($coRegMkt.equals("yes"))) #set ($scpMember = "Coreg but member") #else #set ($scpMember = "Member") #end ##******************Eligible or Taken Bold********** #set ($takenBold = ${lead.mktotakenBold}) #set ($eligibleBold = ${lead.mktoeligiblebold}) #if (($eligibleBold.equals("1")) && ($takenBold.equals(""))) #set ($showBold = 25000) #else #set ($showBold = 0) #end ##******************Eligible or Taken Juno********** #set ($takenJuno = ${lead.mktotakenJuno}) #set ($eligibleJuno = ${lead.mktoeligiblejuno}) #if (($eligibleJuno.equals("1")) && ($takenJuno.equals(""))) #set ($showJuno = 2500) #else #set ($showJuno = 0) #end ##******************Eligible or Taken Niche********** #set ($takenNiche = ${lead.mktotakenNiche}) #set ($eligibleNiche = ${lead.mktoeligibleniche}) #if (($scpMember.equals("Coreg Not a Member")) && ($coReg.equals("niche"))) #set ($showNiche = 0) #elseif (($eligibleNiche.equals("")) && ($coReg.equals("campusreel")) && ($takenNiche.equals(""))) #set ($showNiche = 2000) #elseif (($eligibleNiche.equals("1")) && ($takenNiche.equals(""))) #set ($showNiche = 2000) #else #set ($showNiche = 0) #end ##******************Eligible or Taken Christian Connector********** #set ($takenCC = ${lead.mktotakenChristianConnector}) #set ($eligibleCC = ${lead.mktoeligiblechristianc}) #if (($eligibleCC.equals("1")) && ($takenCC.equals(""))) #set ($showCC = 2500) #else #set ($showCC = 0) #end ##******************Eligible or Taken Nitro********** #set ($takenNitro = ${lead.mktotakenNitro}) #set ($eligibleNitro = ${lead.mktoeligiblenitro}) #if (($eligibleNitro.equals("1")) && ($takenNitro.equals(""))) #set ($showNitro = 2000) #else #set ($showNitro = 0) #end ##Adding up the dollars available #set ($subtotal = $math.add($showNiche, $showBold, $showNitro, $showCC, $showJuno, 13000)) #set ($formattedTotal = $number.format("number", $subtotal)) =?UTF-8?Q?${esc.d}?=${formattedTotal}

Michael_McGowa1 · ‎07-22-2022

I tried this but I am still seeing the issue. Here is a screenshot of the subject line I will also say that the month is also a token so when you look at it in the subject line it is {{my.month}} No-Essay Scholarships Worth {{my.dollarAmt}}

Michael_McGowa1 · ‎07-22-2022

If you are using a script token in the subject line, and also in the body, and the script is formatting the number to currency, is there a way to code this so that this spacing in the subject line does not happen? This is what I have in script for the total #set($total = $number.currency(${subtotal})) #set($stringLength = $total.length() - 3) #set($totalb = $total.substring(0,$stringLength)) ${totalb} I have also tried just using number formatting instead of the currency formatting i.e. #set ($formattedTotal = $number.format("number", $subtotal)) ${esc.d}${formattedTotal} Yet, I still get the space in the subject line.

Michael_McGowa1 · ‎03-11-2021

I need to create an automated email that goes out once a week. It sounds straight forward but I am stumped on the best way to execute this. This email would go out to all members informing them of new activities created the previous week. The email would contain information on the activities and links to our website going directly to the activity. The activities are created by another team member and the information is stored in our backend. I envision the program to work like this: The other team member inputs the new activity information in our backend. On the day before deployment, an API trigger populates a table with the new offers and their information. On the day of deployment, a smart campaign checks to see if there is new information in the table and if yes, sends the email inserting the offer information from the aforementioned table into the email, and if no, no email is deployed from this program for that week. What is the best way of executing this? I cannot have a Custom Object table because the offers are not linked to a person. I do not want an API call for every person that would receive the email because that could potentially cause us to hit our limit on API calls in a day. Thoughts? Any help would be appreciated.

Michael_McGowa1 · ‎02-10-2021

Hi Beth, I here is a screenshot of the flow for the trigger campaign. I am using a two step method of looking at the anniversary of the mkto_rfbdemail then in a separate step adding to the list. Let me know if you need anymore information

Michael_McGowa1 · ‎02-10-2021

Hello all, I am trying to set up a birthday email as in this article. https://nation.marketo.com/t5/Marketo-Whisperer-Blogs/Sending-a-Birthday-Message/ba-p/247530. However, it has been requested that the birthday email be sent 7 days prior to the recipient’s birthday. Therefore, I created a field called mkto_rfbdemail in the lead database. This is a date field. Then, created a smart campaign to Change Data Value of mkto_rfbdemail to {{lead.Date of Birth}} - 7 days. This works. The problem is when I set up the trigger and batch campaigns. For the trigger campaign, I have the trigger set to Campaign is Requested is Marketo Flow Action. I set the flow to look at the anniversary of mkto_rfbdemail. For this test, instead of sending the email I have the campaign add the recipients to a list. For the batch, I have it set up to filter on mkto_rfbdemail is not empty, and in the flow step, request the trigger campaign. In both smart campaigns, a person can go through the flow once in 364 days. When this ran this morning, the list contained 4000 recipients or the entire email universe for this property. There should have been no more than 20 recipients. Where did I go wrong?

Michael_McGowa1 · ‎09-24-2020

I want to set up an experiment where 50% of the welcome emails go out immediately (it's a triggered email by an API call), and the rest go out 30 minutes later. Please take a look at the flow steps. Is this correct? My concern is that those who received the welcome email immediately will also receive it 30 minutes later.

Michael_McGowa1 · ‎05-06-2020

Hey Sanford, that didn't work for me. Researching this more, thought I would share what has worked for me is using the HTML entity of the emoji in the preheader i.e. &#128203 for a clipboard.

Michael_McGowa1 · ‎04-24-2020

Would you post your code just so I am sure that I am not missing anything? I tried it again and it still is not working for me.

Michael_McGowa1 · ‎04-23-2020

I did try that and unfortunately, that did not work. I first tried saving each emoji as a separate script but then the preheader would not appear at all. Also trying the entire preheader as one script i.e. Earn Cash Just by Completing Free Surveys Online! Gave me the same result and nothing showed up. Finally, when I go back to the scripts with emojis in them, and try to open them up to edit them, they do not open which is strange.

Michael_McGowa1 · ‎04-23-2020

So that bracket has been fix. Here is what I am putting into the script for the clipboard emoji =?UTF-8?Q?=F0=9F=93=9D?= Here is the code for the moneybags emoji =?UTF-8?Q?=F0=9F=92=B0?= I also on a hunch tried putting the actual emoji into the script (without the utf code). That did not work either.

Michael_McGowa1 · ‎04-22-2020

Unfortunately, that did not work. I also tried saving the raw emoji as a text file, then rich text file in the tokens window and those did not work either. FYI, I am putting this code in my styles tag span.preheader { display: none !important;} Then the following after the body tag. <span class="preheader">{{my.clipboardemoji}} Earn Cash Just by Completing Free Surveys Online {my.moneybagsutf}}</span> Thoughts?

Michael_McGowa1 · ‎04-22-2020

Has anyone had success in putting emojis in the preheader? I have been able to do it in the subject line by following the method here https://blog.teknkl.com/yes-you-can-use-emojis-in-marketo-subject-lines/?marketo-nation but when I follow the same method for the preheader, the code renders and not the emoji. If I try putting the emoji in the preheader text, then the rest of the text disappears. I also tried making the preheader a token but that did not help. Any advice?

Michael_McGowa1 · ‎03-25-2020

Here it is. #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/New_York") ) #set( $defaultLocale = $date.getLocale() ) #set( $calNow = $date.getCalendar() ) #set( $ret = $calNow.setTimeZone($defaultTimeZone) ) #set( $calConst = $field.in($calNow) ) #set( $ISO8601 = "yyyy-MM-dd'T'HH:mm:ss" ) #set( $ISO8601DateTimeWithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $ISO8601DateTimeWithMillisUTC = "yyyy-MM-dd'T'HH:mm:ss.SSSZ" ) ##set( $theCurrentMonth = ##$date.format( "yyyy-MM", ## $calNow, ## $defaultLocale, ## $defaultTimeZone ##)) ##set( $LastWeek = ##$date.format( "yyyy-MM", ## $calNow.subtract($calConst.DATE,7), ## $defaultLocale, ## $defaultTimeZone ##) ) $calNow.add($calConst.MONTH,-1) #set( $myLastMonth = $date.format( "yyyy-MM", $calNow, $defaultLocale, $defaultTimeZone ) ) #set( $dateOptions = { "formats" : { "userin" : "yyyy-MM-dd HH:mm:ss", "userout" : "yyyy-MM" }, "timezones" : { "userin" : "America/New_York", "userout" : "America/New_York" }, "locale" : $date.getLocale() } ) #set( $updatedDate = ${sPAdActivity_cList.get(0).updatedAt} ) #set ( $formattedUpdatedDateIn = $convert.parseDate( $updatedDate, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) #set( $UpdatedDate_formatted = $date.format( $dateOptions.formats.userout, $formattedUpdatedDateIn, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) ## filter sorted list into new list #set( $completedActivityList = [] ) #foreach( $activity in $sorter.sort($sPAdActivity_cList, ["updatedAt:desc"]) ) #if( $activity.activityStatus.equals("Completed") && ($UpdatedDate_formatted == $myLastMonth) ) #set( $void = $completedActivityList.add($activity) ) #end #end #if( !$completedActivityList.isEmpty() ) #set( $alternateRowColors = ["#e6eff8", "#ffffff"] ) #set( $totalPoints = $math.getTotal( $completedActivityList, "points" ) ) ## open <table> <table width="600" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #000"> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>Activity</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#FFF; padding-top:5px; padding-bottom:5px;"><strong>Points Earned</strong></td> </tr> ## iterate filtered list #foreach( $activity in $completedActivityList ) #set( $sPAdActivity_cList.description = $myDescription.replaceAll("^${esc.q}|${esc.q}$","")) #set( $rowColor = $alternateRowColors[$math.mod($foreach.index,2)] ) <tr> <td bgcolor="${rowColor}" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.description.replaceAll("^${esc.q}|${esc.q}$","")}</td> <td bgcolor="${rowColor}" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.points}</td> </tr> #end ## close </table> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; padding-top:5px; padding-bottom:5px; color:#fff;"><strong>Total Points Earned</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>$totalPoints</strong></td> </tr> </table> #end

Michael_McGowa1 · ‎03-24-2020

The dates are working correctly and being formatted the way I would like them. It seems that the last sticking point is the this line #if( $activity.activityStatus.equals("Completed") && ($UpdatedDate_formatted == $myLastMonth) ) Seems straight forward but when I test it, the page comes out blank

Michael_McGowa1 · ‎03-23-2020

That didn't work for me. I took out the braces and replaced them with parentheses as you instructed. I have tried variations but here is where I began. If I could ask you to produce the code that would give me the results for last week (S-S) or Last Month I would appreciate it. Below is the code. #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/New_York") ) #set( $defaultLocale = $date.getLocale() ) #set( $calNow = $date.getCalendar() ) #set( $ret = $calNow.setTimeZone($defaultTimeZone) ) #set( $calConst = $field.in($calNow) ) #set( $ISO8601 = "yyyy-MM-dd'T'HH:mm:ss" ) #set( $ISO8601DateTimeWithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $ISO8601DateTimeWithMillisUTC = "yyyy-MM-dd'T'HH:mm:ss.SSSZ" ) #set( $LastWeek = $date.format( "yyyy-MM", $calNow.subtract($calConst.DATE,7), $defaultLocale, $defaultTimeZone ) ) #set( $LastMonth = $date.format( "yyyy-MM", $calNow.subtract($calConst.MONTH,1), $defaultLocale, $defaultTimeZone ) ) #set( $theCurrentMonth = ${date.format( "yyyy-MM", $calNow, $defaultLocale, $defaultTimeZone )) #set( $dateOptions = ( "formats" : ( "userin" : "yyyy-MM-dd HH:mm:ss", "userout" : "yyyy-MM" ), "timezones" : ( "userin" : "America/New_York", "userout" : "America/New_York" ), "locale" : $date.getLocale() ) ) #set( $updatedDate = ${sPAdActivity_cList.get(0).updatedAt} ) #set ( $formattedUpdatedDateIn = $convert.parseDate( $updatedDate, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) #set( $UpdatedDate_formatted = $date.format( $dateOptions.formats.userout, $$formattedUpdatedDateIn, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) ## filter sorted list into new list #set( $completedActivityList = [] ) #foreach( $activity in $sorter.sort($sPAdActivity_cList, ["updatedAt:desc"]) ) #if( $activity.activityStatus.equals("Completed") && $UpdatedDate_formatted.equals("${LastMonth}") ) #set( $void = $completedActivityList.add($activity) ) #end #end #if( !$completedActivityList.isEmpty() ) #set( $alternateRowColors = ["#e6eff8", "#ffffff"] ) #set( $totalPoints = $math.getTotal( $completedActivityList, "points" ) ) ## open <table> <table width="600" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #000"> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>Activity</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#FFF; padding-top:5px; padding-bottom:5px;"><strong>Points Earned</strong></td> </tr> ## iterate filtered list #foreach( $activity in $completedActivityList ) #set( $sPAdActivity_cList.description = $myDescription.replaceAll("^${esc.q}|${esc.q}$","")) #set( $rowColor = $alternateRowColors[$math.mod($foreach.index,2)] ) <tr> <td bgcolor="${rowColor}" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.description.replaceAll("^${esc.q}|${esc.q}$","")}</td> <td bgcolor="${rowColor}" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.points}</td> </tr> #end ## close </table> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; padding-top:5px; padding-bottom:5px; color:#fff;"><strong>Total Points Earned</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>$totalPoints</strong></td> </tr> </table> #end

Michael_McGowa1 · ‎03-20-2020

That worked, thanks. Now, for the second bit. For the code below, I added the timezones and the necessary elements mentioned in your article. Then I set the parameter for Last Month, Last Week, and then tried to format them along with the "updatedDate" in the sPAdActivity_cList table. Then in the first foreach loop, I am having the completed date matching either Last Week or in this case, last month. However, now it not working again. #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/New_York") ) #set( $defaultLocale = $date.getLocale() ) #set( $calNow = $date.getCalendar() ) #set( $ret = $calNow.setTimeZone($defaultTimeZone) ) #set( $calConst = $field.in($calNow) ) #set( $ISO8601 = "yyyy-MM-dd'T'HH:mm:ss" ) #set( $ISO8601DateTimeWithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $ISO8601DateTimeWithMillisUTC = "yyyy-MM-dd'T'HH:mm:ss.SSSZ" ) #set( $LastWeek = ${date.format( "yyyy-MM", $calNow.subtract($calConst.DATE,7), $defaultLocale, $defaultTimeZone #set( $LastMonth = ${date.format( "yyyy-MM", $calNow.subtract($calConst.MONTH,1), $defaultLocale, $defaultTimeZone #set( $theCurrentMonth = ${date.format( "yyyy-MM", $calNow, $defaultLocale, $defaultTimeZone )}) #set( $dateOptions = { "formats" : { "userin" : "yyyy-MM-dd HH:mm:ss", "userout" : "yyyy-MM" }, "timezones" : { "userin" : "America/New_York", "userout" : "America/New_York" }, "locale" : $date.getLocale() } ) #set( $updatedDate = ${sPAdActivity_cList.get(0).updatedAt} ) #set ( $formattedUpdatedDateIn = $convert.parseDate( $updatedDate, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) #set( $UpdatedDate_formatted = $date.format( $dateOptions.formats.userout, $$formattedUpdatedDateIn, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) ## filter sorted list into new list #set( $completedActivityList = [] ) #foreach( $activity in $sorter.sort($sPAdActivity_cList, ["updatedAt:desc"]) ) #if( $activity.activityStatus.equals("Completed") && $UpdatedDate_formatted.equals("${LastMonth}") ) #set( $void = $completedActivityList.add($activity) ) #end #end #if( !$completedActivityList.isEmpty() ) #set( $alternateRowColors = ["#e6eff8", "#ffffff"] ) #set( $totalPoints = $math.getTotal( $completedActivityList, "points" ) ) ## open <table> <table width="600" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #000"> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>Activity</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#FFF; padding-top:5px; padding-bottom:5px;"><strong>Points Earned</strong></td> </tr> ## iterate filtered list #foreach( $activity in $completedActivityList ) #set( $rowColor = $alternateRowColors[$math.mod($foreach.index,2)] ) <tr> <td bgcolor="${rowColor}" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.description}</td> <td bgcolor="${rowColor}" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.points}</td> </tr> #end ## close </table> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; padding-top:5px; padding-bottom:5px; color:#fff;"><strong>Total Points Earned</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>$totalPoints</strong></td> </tr> </table> #end

Michael_McGowa1 · ‎03-19-2020

Been working on this all day and not making any progress. First, trying to get rid of the quotes, I have tried different versions of the following. It is still putting quotes around the description. ## filter sorted list into new list #set( $completedActivityList = [] ) #foreach( $activity in $sorter.sort($sPAdActivity_cList, ["updatedAt:desc"]) ) #if( $activity.activityStatus.equals("Completed") ) #set( $void = $completedActivityList.add($activity) ) #end #end #if( !$completedActivityList.isEmpty() ) #set( $alternateRowColors = ["#e6eff8", "#ffffff"] ) #set( $totalPoints = $math.getTotal( $completedActivityList, "points" ) ) ## open <table> <table width="600" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #000"> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>Activity</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#FFF; padding-top:5px; padding-bottom:5px;"><strong>Points Earned</strong></td> </tr> ## iterate filtered list #foreach( $activity in $completedActivityList ) #set( $sPAdActivity_cList.description = $myDescription.replaceAll("^${esc.q}|${esc.q}$","") ) #set( $rowColor = $alternateRowColors[$math.mod($foreach.index,2)] ) <tr> <td bgcolor="${rowColor}" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.description}</td> <td bgcolor="${rowColor}" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.points}</td> </tr> #end ## close </table> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; padding-top:5px; padding-bottom:5px; color:#fff;"><strong>Total Points Earned</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>$totalPoints</strong></td> </tr> </table> #end Second, taking the original code and trying to get the completed activities from last month or last week, I looked over the article but it keeps giving me errors. Here is that code: #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/New_York") ) #set( $defaultLocale = $date.getLocale() ) #set( $calNow = $date.getCalendar() ) #set( $ret = $calNow.setTimeZone($defaultTimeZone) ) #set( $calConst = $field.in($calNow) ) #set( $ISO8601 = "yyyy-MM-dd'T'HH:mm:ss" ) #set( $ISO8601DateTimeWithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $ISO8601DateTimeWithMillisUTC = "yyyy-MM-dd'T'HH:mm:ss.SSSZ" ) #set( $LastWeek = ${date.format( "yyyy-MM", $calNow.subtract($calConst.DATE,7), $defaultLocale, $defaultTimeZone #set( $LastMonth = ${date.format( "yyyy-MM", $calNow.subtract($calConst.MONTH,1), $defaultLocale, $defaultTimeZone #set( $theCurrentMonth = ${date.format( "yyyy-MM", $calNow, $defaultLocale, $defaultTimeZone )}) #set( $dateOptions = { "formats" : { "userin" : "yyyy-MM-dd HH:mm:ss", "userout" : "yyyy-MM" }, "timezones" : { "userin" : "America/New_York", "userout" : "America/New_York" }, "locale" : $date.getLocale() } ) #set( $updatedDate = ${sPAdActivity_cList.get(0).updatedAt} ) #set ( $formattedUpdatedDateIn = $convert.parseDate( $updatedDate, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) #set( $UpdatedDate_formatted = $date.format( $dateOptions.formats.userout, $$formattedUpdatedDateIn, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) ## filter sorted list into new list #set( $completedActivityList = [] ) #foreach( $activity in $sorter.sort($sPAdActivity_cList, ["updatedAt:desc"]) ) #if( $activity.activityStatus.equals("Completed") && $UpdatedDate_formatted.equals("${LastMonth}") ) #set( $void = $completedActivityList.add($activity) ) #end #end #if( !$completedActivityList.isEmpty() ) #set( $alternateRowColors = ["#e6eff8", "#ffffff"] ) #set( $totalPoints = $math.getTotal( $completedActivityList, "points" ) ) ## open <table> <table width="600" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #000"> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>Activity</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#FFF; padding-top:5px; padding-bottom:5px;"><strong>Points Earned</strong></td> </tr> ## iterate filtered list #foreach( $activity in $completedActivityList ) #set( $rowColor = $alternateRowColors[$math.mod($foreach.index,2)] ) <tr> <td bgcolor="${rowColor}" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.description}</td> <td bgcolor="${rowColor}" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.points}</td> </tr> #end ## close </table> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; padding-top:5px; padding-bottom:5px; color:#fff;"><strong>Total Points Earned</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>$totalPoints</strong></td> </tr> </table> #end Don't know what I doing wrong. Hitting my ceiling which admittedly is pretty low.

Michael_McGowa1 · ‎03-18-2020

Starting a new thread for this question. With a lot of help I have a Velocity script that will list all the activities a member has taken and add up the points that they have earned. The code is here: ## filter sorted list into new list #set( $completedActivityList = [] ) #foreach( $activity in $sorter.sort($sPAdActivity_cList, ["updatedAt:desc"]) ) #if( $activity.activityStatus.equals("Completed") ) #set( $void = $completedActivityList.add($activity) ) #end #end #if( !$completedActivityList.isEmpty() ) #set( $alternateRowColors = ["#e6eff8", "#ffffff"] ) #set( $totalPoints = $math.getTotal( $completedActivityList, "points" ) ) ## open <table> <table width="600" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #000"> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>Activity</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#FFF; padding-top:5px; padding-bottom:5px;"><strong>Points Earned</strong></td> </tr> ## iterate filtered list #foreach( $activity in $completedActivityList ) #set( $rowColor = $alternateRowColors[$math.mod($foreach.index,2)] ) <tr> <td bgcolor="${rowColor}" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.description}</td> <td bgcolor="${rowColor}" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#000; padding-top:5px; padding-bottom:5px;">${activity.points}</td> </tr> #end ## close </table> <tr> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; padding-top:5px; padding-bottom:5px; color:#fff;"><strong>Total Points Earned</strong></td> <td bgcolor="#005daa" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:13px; padding-left:5px; padding-right:5px; color:#fff; padding-top:5px; padding-bottom:5px;"><strong>$totalPoints</strong></td> </tr> </table> #end I need make some additions to the code and have tried and failed to do the following. Only lists the activities completed in the past month or the past week. It would be preferable if this could be done programmatically since this would preferably be an automated email. There is an issue off quotation marks around the title of the activity. It’s listed that way in the CRM, I do not know why. I need to find a way to take those quotation marks out. Is there a trim command in Velocity script? If anyone could help, I would appreciate it.

Re: Script showing something different in the prev...

Re: Script showing something different in the prev...

Re: Script showing something different in the prev...

Re: Script showing something different in the prev...

Re: Script showing something different in the prev...

Re: Script showing something different in the prev...

Re: Script showing something different in the prev...

Re: Script showing something different in the prev...

Script showing something different in the preview ...

Re: Using an email script token in the subject lin...

Re: Using an email script token in the subject lin...

Re: Using an email script token in the subject lin...

Re: Using an email script token in the subject lin...

Re: Using an email script token in the subject lin...

Suggestion on how to execute this email program

Re: Problem with a birthday email

Problem with a birthday email

Triggered Random sends based on time

Re: Emojis in Preheader

Re: Emojis in Preheader

Re: Emojis in Preheader

Re: Emojis in Preheader

Re: Emojis in Preheader

Emojis in Preheader

Re: Repost of List based on updated date

Re: Repost of List based on updated date

Re: Repost of List based on updated date

Re: Repost of List based on updated date

Re: Repost of List based on updated date

Repost of List based on updated date