SanfordWhiteman

SanfordWhiteman

Contact Me
Online Status
Offline
Date Last Visited
yesterday
Level 10 - Community Moderator
I'm a web, database, and network architect based in NYC, with specializations in the financial services, publishing, and SaaS sectors. I build complex Marketo integrations for companies large and small... and can make Marketo forms and emails do things you never thought possible! Check out my blog at https://blog.teknkl.com, which has Marketo-specific technical insights you won't see anywhere else, along with wider topics from my programming and systems work.
Joined the community 23-07-2014
Rank Icon Level 10 - Community Moderator
Chief Technologist
New York City
  • solved badge Re: Velocity Script Not Populating In Email

    I was editing this script in Notes and I couldn't work out how to change between curly vs straight quotes - apparently that tool does it automatically as I watched it change as I typed in " (it looks like it's auto-italicising them). IYes, that’s a common struggle. I have a Windows addon that change...

    image_type
    Discussions
    2640 1 1
  • solved badge Re: velocity script limit - truncation

    1) Marketo segmentations can often replicate some personalization logic with better performance.Marked your post as correct, though I doubt you can substantiate this claim for scenarios where Velocity and Segmentations can both do the job. (That is, when you’re not doing things that can only be done...

    image_type
    Discussions
    788 1 0
  • solved badge Re: How to properly reference Velocity variables in multiple scripts

    Yep, although I’d use a real Boolean as your check as opposed to an empty String. Plus a little cleanup in there to use .equals() and avoid unnecessary output.## --- Set required Velocity variables for timezone and formatting ---#set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/New_Y...

    image_type
    Discussions
    1474 1 0
  • solved badge Re: Velocity Script Not Populating In Email

    Looking much more manageable and nice work with the sets/lists. See that you’re using curly quotes in several places, though, which will not work. Gotta be straight quotes "! Also, a few syntax errors remained. So you can start from here:## Determines discount offering based on audience targeting se...

    image_type
    Discussions
    3382 1 3
  • Re: To get number of messages sent by each Marketo user

    Unfortunately, don’t think there’s a way to do this. Only place where the user who scheduled a campaign — a dubious proxy for “owning” a campaign in many organizations anyway— is logged is in the Asset Audit Trail. And that’s only kept for 6 months.

    image_type
    Discussions
    1227 0 0
  • solved badge Re: Velocity Script Not Populating In Email

    How do I reference the set later on in the script? Would I use a command like this:$lead.Support_Type__c.equals("Gold Success Plan")#if( $interestingPublicSectorSubsegments.contains( $lead.Public_Sector_Subsegment__c ) ) You’re checking if the list of interesting values contains the field value.

    image_type
    Discussions
    2671 1 5
  • solved badge Re: Velocity Script Not Populating In Email

    @michellechopin wrote:Excuse the noob question but what do you mean when you say I'm "not outputting any fields"? I'll go through and connect the fields from the list to make sure everything is pulling in properly but will remove the {} as I go!Meaning you’re not printing any fields as-is. Printing ...

    image_type
    Discussions
    2718 1 0
  • solved badge Re: Velocity Script Not Populating In Email

    With your suggestion in mind, where does the #set section fit in the PubSec area?🙂You can put all such “interesting lists” at the top of the token (which also makes them much easier to edit). They have to be declared before they’re used. Additionally, question in terms of how to read the script - d...

    image_type
    Discussions
    2680 1 7
  • solved badge Re: Velocity Script Not Populating In Email

    Given that I have a LOT of fields to update in here, what option is best? I don't want to remove them all and then have to add them back in (or vice versa) 😛There is no one best option. It depends on where they’re used. In your case you aren’t outputting any fields, so don’t use ${formal.references...

    image_type
    Discussions
    2733 0 2
  • solved badge Re: Velocity Script Not Populating In Email

    I find these giant boolean conditions way over the border into unreadability, even after the rewrite. Don’t do stuff that way. Instead, declare your lists of interesting values at the top:#set( $interestingPublicSectorSubsegments = [ "SLED - Higher Ed - CML", "SLED - Higher Ed - ENT", "SLED - Loc...

    image_type
    Discussions
    2708 1 9

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!
  • Applaud 2000 Applaud 2000 Earned on 2.08.21 Earned by 1 people Select to learn more
  • Validate 500 Validate 500 Earned on 11.04.22 Earned by 2 people Select to learn more
  • Prowess Prowess Earned on 2.10.21 Earned by 7 people Select to learn more
  •  Artisan Artisan Earned on 2.10.21 Earned by 7 people Select to learn more
  • Originator Originator Earned on 2.10.21 Earned by 21 people Select to learn more
  • Publish 100 Publish 100 Earned on 10.05.21 Earned by 3 people Select to learn more
Public Statistics
Name
Location New York City
Personal web page https://blog.teknkl.com
Date Registered ‎07-23-2014 11:52 AM
Date Last Visited yesterday
Total Messages Posted 25,764
Total Tags 706
Likes Received 12363