Badges
Accepted Solutions
Likes Received
Posts
Discussions
Ideas
Blog Posts
Hmm I spoke slightly too soon. When I input the date "04/17/2017", I keep getting as the output January 17, 2017 instead of April 17, 2017. Why?My code below. The only changes I've made are around the index I'm substituting in, and the "user in" formatting. ## get the size of the list#set ($listleng...
PS - I had the exact same date formatting problem Sanford Whiteman - so this question and post is very timely! I wasn't inputting timezones. Your code is very clean as usual - thanks so much. I won't be making that mistake again...
Hi LauraReading this, I can totally empathise. I might be a little further along the line than you, so I'd be happy to give you some help (including some docs I've created myself) which might help to explain some of the above. Send me a PM with your email if you're interested.I must say that pretty ...
Still not working....this is bizarre. But I found a workaround.I tried: #if( $Tour_Evaluation__cList.get(0).Testimonial__c.isEmpty() )True#elseFalse#endThis outputs False in Email Preview. To double check the data I tried size(), which outputs 1 for the particular lead I'm looking at. For some reaso...
Thanks Sanford. Makes sense to me that it needs to be inside the brackets!Weird thing is...this doesn't seem to have fixed it. I'm still getting "False" for my query where the field clearly seems to be null. Next, I tried it with two leads: one with the testimonial field filled in, one without. The ...
I'm trying to use an #if statement in Velocity to check whether a field is empty. As per Sanford's excellent article here, Marketo imports everything into Velocity as strings, so he suggests using $var.isEmpty() instead of switching between different methods based on data type.But when I use this st...
Hey teamI'm trying something similar, but when I use the code given to Jim it's not working for me. Here's my code:#set ($listlength = ${abandonedCart_cList.size()}) #set( $lastIndex = $math.sub($listlength,1) )#set($str = $convert.parseDate(${abandonedCart_cList.get($lastIndex).serviceStartDate}, "...
Just to round this off, the above error around arrays is because I was using "Send Sample Email" instead of using a single flow action to test the scripting. Oops!
Thanks so much Sanford. Outputting the entire array is a great way to test! I should have thought of that After some more testing, it seems that this error is purely related to the fact I was testing using "Send Sample Email" instead of Single Flow Actions. Lesson learnt! Phew. Very glad to see some...
I'm having trouble accessing anything other than the first element in a Marketo Custom Object through email scripting. I've tested using a few leads, and here's the behaviour I'm seeing. All leads had at least three entries in the relevant Marketo Custom Object:* ${MarketoCustomObject_cList.get(0).f...