@Grace_Brebner3 , hey - at least if my ideas are being challenged it is by one of the best 🙂 One of the reasons I quite like the wait step is it suggests you'll be sending the email at the same time of day as they engaged with you the first time. That being said, I also agree that it has it own sets of challenges and issues 🙂 ... View more

@Sophia_Sellars , @Grace_Brebner3 's example is spot on.  As an extension of that, this link https://docs.marketo.com/display/public/DOCS/Smart+List+Filter+Operators+Glossary will take you to a generic description of the date operators and how to use to achieve your outcome (and others that may be similar).   Cheers Jo ... View more

I hunted down through the iframes and still couldn't see what I was looking for. I'm happy to screen share with you if you have time. ... View more

@SanfordWhiteman , its a template URL so I'm not sure I can expose it to you? ... View more

Harish, thanks for clarifying.  I think though the best way to help is with worked example (as what @SanfordWhiteman often does). In my case, I'm not that clever - but when I do get an outcome with the help of others (usually Sanford) then I try to post back the full worked example as a guide to others. just saying 'do this' when someone doesn't know the hows or whys really won't give them as much guidance as you'd hope 🙂 Cheers Jo ... View more

@Harish_Gupta6 wrote: You need to write a JS script and add onblur events on all fields and then create a function to check if all fields have been filled or not. Call this function on each field onblur event and validate the field. If all fields have the data then change the color of your button. Let me know if you need help with Script. I will write it for you.   Thanks @Harish_Gupta6 - this is probably treading over the line as far as community guidelines go.  You aren't allowed to solicit work IIRC.  You are allowed to demonstrate expertise by offering up ideas that may make people come to you for work.     ... View more

Then most proper we shall be. ... View more

@SanfordWhiteman , gotcha.  I presume the easiest way to do this is to wrap all the code after this #set( $currentSeminarList = $lead.metlifecompetitiondatas2 ) with this #if( $currentSeminarList != "" ) All the doing code #end It seems to behave, but is that the best practice approach?   ... View more

Hmm... so my code now looks like this (and seems to be working) #set( $allSeminarDetails = { "ABC" : { "blurb":"Postman Pat", "date":"24 Aug", "time":"10:30", "attendees":0, "village":"somewhere" }, "CBA" : { "blurb":"Bob the builder", "date":"14 Aug", "time":"10:30", "attendees":0, "village":"somewhere else" } } ) #set( $currentSeminarList = $lead.metlifecompetitiondatas2 ) #set( $currentSeminarCodes = $currentSeminarList.split("[|]") ) ## this list will hold matched seminars #set( $currentSeminarDetails = [] ) ## find matching seminar in master list #foreach( $code in $currentSeminarCodes ) #set( $currentRegistration = $code.split(";") ) #set( $villageCode = $currentRegistration[0] ) #set( $aSeminar = $allSeminarDetails[$villageCode]) #set( $aSeminar.attendees = $currentRegistration[1] ) #set( $void = $currentSeminarDetails.add( $aSeminar ) ) #end ## iterate over matches only #foreach( $seminar in $currentSeminarDetails ) <table style="table-layout:fixed; width:100%; background:#eeeeee"> <tr> <td style="width:30%;">Date</td><td style="">${seminar.date}</td> </tr> <tr> <td>Time</td><td style="">${seminar.time}</td> </tr> <tr> <td>Village</td><td style="">${seminar.village}</td> </tr> <tr> <td>Details</td><td style="">${seminar.blurb}</td> </tr> <tr> <td>Attendees</td><td style="">${seminar.attendees}</td> </tr> </table> <br> #end But I get the following error when I try to either approve the email or send a sample. Validation Error approving  LG - 202007 - RRS - CORE.01 - Registration Acknowledgement  —  <div>An error occurred when procesing the email Rendered_Email_Velocity_Error_Area_?! </div> <p>Error invoking method 'get(java.lang.Integer)' in [Ljava.lang.String; near</p> <div><pre >?</pre></div>   I have made sure I don't have the velocity in my text version of the email.  What should I look for next? Cheers Jo ... View more

@SanfordWhiteman wrote: You don't need to pre-set attendees in the details Map, though it's nicely informative if you do. You aren't using this variable:  #set( $attendees = $currentRegistration[1] )​ Splitting on just ; is fine, you don't need to put it in a character class [;] as it's not reserved I like being informative, especially in a language I'm not super familiar with.  It helps me understand my work later.  That being said, I take your point about it not being needed. True enough.  That line can go Gotcha.  Makes perfect sense. Now time to do a gloriously formatted table for output, and I'm most of the way there! 🙂   Thanks so much for all your help @SanfordWhiteman .   Cheers Jo ... View more

@SanfordWhiteman  (and for the general amusement and hopefully edification of others), I've made solid progress.  My code is working as expected, and I'm getting to grips with the string maps stuff quite nicely. The output section at the end is almost 'debug' at the moment, but will go into a nice table shortly.   #set( $allSeminarDetails = { "GNG" : { "blurb":"Come to GNG and learn about Poodles", "date":"5 Aug 2020", "attendees":0 }, "POY" : { "blurb":"It's POYsonal Now", "date":"6 Aug 2020", "attendees":0 }, "GUL" : { "blurb" : "GULivers travels have nothing on life here", "date":"7 Aug 2020", "attendees":0 }, "WTG" : { "blurb" : "Waiting Waiting Waiting", "date":"8 Aug 2020", "attendees":0 }, "POH" : { "blurb" : "POH POH POH your boat", "date":"9 Aug 2020", "attendees":0 } } ) #set( $currentSeminarList = $lead.metlifecompetitiondatas2 ) #set( $currentSeminarCodes = $currentSeminarList.split("[|]") ) ## this list will hold matched seminars #set( $currentSeminarDetails = [] ) ## find matching seminar in master list #foreach( $code in $currentSeminarCodes ) #set( $currentRegistration = $code.split("[;]") ) #set( $villageCode = $currentRegistration[0] ) #set( $attendees = $currentRegistration[1] ) #set( $aSeminar = $allSeminarDetails[$villageCode]) #set( $aSeminar.attendees = $currentRegistration[1] ) #set( $void = $currentSeminarDetails.add( $aSeminar ) ) #end ## iterate over matches only #foreach( $seminar in $currentSeminarDetails ) ${seminar.blurb}&nbsp;&nbsp; ${seminar.date}&nbsp;&nbsp; ${seminar.attendees}<BR><BR> #end   What I'm most curious about is where can I improve what I'm doing.  Are their areas of inelegance or inefficiency in here that I could be doing better?   Cheers Jo ... View more

@SanfordWhiteman  So, in my string, I actually get something like: GNG;4|POY;3   The code gives me the seminar, and the number is the attendees. Ultimately, my allSeminarDetails map will have blurb, date, time, and a URL. My currentSeminarDetails will end up with the right rows from allSeminarDetails PLUS the attendees for that seminar. That way I can emit it all in the HTML of the email. Sorry for not making this all clear at the beginning - I was trying to give a simplified example and build it up from there. ... View more

@SanfordWhiteman , I can switch to string keys quite happily and easily 🙂 .  I'm always happy to find nicer/better ways of doing things especially as it avoids the ghastly nested loop. How far off the mark am I in my desire to add more than just the details from allSeminarDetails (i.e. + the number of attendees) in my previous message. ... View more

So a nested loop in other words :).... Darn it I was hoping for something more elegant!  Thanks for the help @SanfordWhiteman  Next silly question.  in this line here: #set( $void = $currentSeminarDetails.add($detail) ) How can I add one extra element that is NOT in the $allSeminarDetails array.  In this instance, I also know the number of attendees (which can vary by seminar).   So in essence what I want (and will experiment with shortly) is something like #set( $void = $currentSeminarDetails.add($detail,$attendees) ) but I feel like that won't work   ... View more

@SanfordWhiteman yes - this is in a token.   I've tweaked things and made it behave, so now my next challenge. How to take my split string, and find each matching value in an array. I've got to this point:   #set( $seminarDetails = [ {"CODE":"GNG","BLURB":"Come to GNG and learn about Poodles"}, {"CODE":"POY","BLURB":"It's POYsonal Now"}, {"CODE":"GUL","BLURB":"GULivers travels have nothing on life here"}, {"CODE":"WTG","BLURB":"Waiting Waiting Waiting"} ]) #set ($seminarList = ${lead.metlifecompetitiondatas2}) #set ($seminarArray = $seminarList.split("[|]")) #foreach ($seminarCode in $seminarArray) ## how to find the SeminarCode in the SeminarDetails array. #end     Let's assume the passed in field {lead.metlifecompetitiondatas2} contains POY|GUL. My foreach loop will iterate twice (happy day).  What I want to do is get access to the appropriate blurb in the array at the top for output in the email (without doing some silly nested foreach loop on the seminarDetails array). And I am sure I could condense some of this (i.e. splitting the marketo field straight into an array), but I like to keep it nice and stepwise so I can understand each bit before condensing once I have a handle on what is going on. ... View more