Phillip_Wild

Phillip_Wild

Contact Me
Online Status
Offline
Date Last Visited
‎10-08-2023 10:39 PM
Level 10
Joined the community 07-10-2014
Rank Icon Level 10
Global Lead, Marketing Technology
Melbourne, Australia
  • solved badge Re: How do I modify the date format for a token using Velocity Script?

    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...

    image_type
    Discussions
    5701 0 1
  • solved badge Re: How do I modify the date format for a token using Velocity Script?

    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...

    image_type
    Discussions
    5701 0 2
  • solved badge Re: How do I modify the date format for a token using Velocity Script?

    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 ...

    image_type
    Discussions
    5701 0 5
  • Re: Email script - isEmpty() not working

    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...

    image_type
    Discussions
    2320 0 0
  • Re: Email script - isEmpty() not working

    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 ...

    image_type
    Discussions
    2320 0 2
  • Email script - isEmpty() not working

    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...

    image_type
    Discussions
    3032 0 4
  • solved badge Re: Date Format Velocity Script

    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}, "...

    image_type
    Discussions
    4397 0 1
  • solved badge Re: with scripting not working

    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!

    image_type
    Discussions
    2954 0 0
  • Re: Velocity scripting - can only access the first element in Marketo ...

    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...

    image_type
    Discussions
    1483 0 0
  • Velocity scripting - can only access the first element in Marketo Cust...

    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...

    image_type
    Discussions
    1713 0 2

Top Badges Earned

Customize up to 8 badges at the top of your trophy case for all other Community members to see!Customize up to 8 badges at the top of your trophy case for all other Community members to see!
  • Affirm 50 Affirm 50 Earned on 12.21.21 Earned by 25 people Select to learn more
  • Applaud 250 Applaud 250 Earned on 11.11.21 Earned by 35 people Select to learn more
  • Give Back 400 Give Back 400 Earned on 11.02.21 Earned by 33 people Select to learn more
  • Boost 250 Boost 250 Earned on 6.29.21 Earned by 59 people Select to learn more
  • Affirm 25 Affirm 25 Earned on 5.27.21 Earned by 51 people Select to learn more
  • Validate 10 Validate 10 Earned on 5.26.21 Earned by 25 people Select to learn more
  • Unlock 2 Unlock 2 Earned on 4.26.21 Earned by 30 people Select to learn more
  • Builder Builder Earned on 2.19.21 Earned by 58 people Select to learn more
Public Statistics
Date Registered ‎10-07-2014 10:55 AM
Date Last Visited ‎10-08-2023 10:39 PM
Total Messages Posted 559
Likes Received 335