thanks @SanfordWhiteman - yep, I'm going to use split() - your Velocity advice is always appreciated. ... View more

THANK YOU!!! I knew I was missing something simple ... View more

Hi @SanfordWhiteman  I'm having a similar issue with Datetime flow step logic that I was hoping you could help with. I want to send records to a different campaign based on a datetime field, here is my logic:     Here is the value in that field for the lead I am testing with, outputted into an email And just to confirm the field is a Datetime field: So I would expect this record to skip Choice 1, and be picked up in Choice 2. But it gets picked up in choice 1, any idea what I'm doing wrong here? Your TZ knowledge is always appreciated! ... View more

I owe you so many beers for your help on this! The only thing was I was getting an error if the domain for the lead didn't appear in the JSON which I wasn't getting when just doing a standard foreach , so I referenced another one of you answers​ and wrapped it in an if statement to output some default content if the list is empty, is this the best way to handle this? #if( $domainProjects.isEmpty() ) Default content #else #foreach( $idx in [0..$math.min(7,$math.sub($domainProjects.size(),1))] ) #set( $project = $domainProjects[$foreach.index] ) You're a ${project.category.participantType} for Project ${foreach.count}: #if( $foreach.index.equals(0) ) #set( $project_category_URL_0 = $domainProjects[0].category.URL.substring(8) )<a href="https://${project_category_URL_0}">## #elseif( $foreach.index.equals(1) ) #set( $project_category_URL_1 = $domainProjects[1].category.URL.substring(8) )<a href="https://${project_category_URL_1}">## #elseif( $foreach.index.equals(2) ) #set( $project_category_URL_2 = $domainProjects[2].category.URL.substring(8) )<a href="https://${project_category_URL_2}">## #elseif( $foreach.index.equals(3) ) #set( $project_category_URL_3 = $domainProjects[3].category.URL.substring(8) )<a href="https://${project_category_URL_3}">## #elseif( $foreach.index.equals(4) ) #set( $project_category_URL_4 = $domainProjects[4].category.URL.substring(8) )<a href="https://${project_category_URL_4}">## #elseif( $foreach.index.equals(5) ) #set( $project_category_URL_5 = $domainProjects[5].category.URL.substring(8) )<a href="https://${project_category_URL_5}">## #elseif( $foreach.index.equals(6) ) #set( $project_category_URL_6 = $domainProjects[6].category.URL.substring(8) )<a href="https://${project_category_URL_6}">## #elseif( $foreach.index.equals(7) ) #set( $project_category_URL_7 = $domainProjects[7].category.URL.substring(8) )<a href="https://${project_category_URL_7}">## #end ${project.category.name}## </a> <br> <br> #end #end Thanks again for all of your help. ... View more

' Then at the end create N standalone String $references to hold the URLs.' Slightly confused how to join this all up in my example. But will try and tackle this tomorrow, so 'basically' I need to: Filter the list i.e. #set( $domainProjects = [] ) #foreach( $project in $allProjects ) #if( $project.domain.equalsIgnoreCase($lead.Email_Domain__c) ) #set( $void = $domainProjects.add($project) ) #end #end Then create the url reference from the filtered list (with something similar to your code): #foreach( $key in $lead.downloadcenter.split(";") ) #set( $downloadLink = $allDownloadLinks[$key] ) #evaluate( "${esc.h}set( ${esc.d}downloadLink_${foreach.count} = ${esc.d}downloadLink )" ) #end Then have an if statement for N url placeholders, where if the link exists in the filtered list it displays, otherwise it doesn't. (And I thought tomorrow would just be a day of colouring in this email!) # # ... View more

Thanks, Sanford - I really do appreciate all of your resources on this. But, as a novice with VTL, when you have to use a giant If statement to use a forEach, I'm thinking I may as well just use a giant If statement without the forEach. It feels like Marketo have dropped the ball on this one. Surely multiple (tracked) links from COs would be a common use case for VTL? ... View more

Ouch. That's kind of a big bug, at least for what I had planned. Is this something Marketo plan to fix? ... View more

Thanks for the tip, Mark! I am planning to output links so this is very helpful. ... View more

Thank you, Sanford! What threw me for a bit in your script was the $project variable in the forEach statement: #foreach( $project in $allProjects ) As I don't have any elements called $project in the JSON. So I can try and understand VTL a little bit more $project is declaring a variable for each record in the array?! ... View more

Hi Broderick - could you explain how you handle multiple webinars running at the same time with one webhook, given that someone registering for more than 1 webinars would just have their join_url overwritten with the last value? So any reminder emails etc might not necessarily contain the correct webinar url. But maybe I'm missing something. ... View more