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: Exporting Data

    That's not exporting "full form fill data" in any way. It's exporting the current values of the fields, regardless of how they were updated.The data from form submissions is starkly different from the data stored on the lead, especially after time has passed. Form fills are a different dimension exp...

    image_type
    Discussions
    943 1 1
  • solved badge Re: Issues with Webinar Token

    A Wait step is really clumsy here; you can’t know how long to wait and always risk sending a blank value. But I suspect the direct issue in your case is the email isn’t in the program.

    image_type
    Discussions
    848 2 1
  • solved badge Re: Exporting Data

    You can only export Filled Out Form data using the API. There’s aren’t column(s) that reflect form fields directly.

    image_type
    Discussions
    973 0 0
  • Re: Velocity script is not pulling data in URL

    We can’t troubleshoot a screenshot. Please provide actual code, and use the syntax highlighter to highlight your code as Java (as its syntax is closest to Velocity). In addition, are you trying to output multiple links from Velocity using the same Velocity variable (that is, same ${reference})? Ther...

    image_type
    Discussions
    925 1 0
  • solved badge Re: Velocity Scripting - Help

    Just noticed one thing if i add a token in the body ${{my.formattedAmount}} like this it gives an error but if i give $ {{my.formattedAmount}} then it works not sure if thats the issue ?Of course. If you use the prefix ${ that conflicts with Marketo’s email variable syntax. Do don’t put the dollar s...

    image_type
    Discussions
    1219 0 0
  • solved badge Re: Velocity Scripting - Help

    Yesterday, I tested some code based on suggestions from ChatGPT, but I am unable to locate those details to share with you at the moment.There’s a 0% chance that ChatGPT will give you usable code for Marketo’s Velocity environment. Don’t use it. Lastly, while I was adding the token, I encountered an...

    image_type
    Discussions
    1220 0 1
  • solved badge Re: Velocity Scripting - Help

    Not providing your (attempted) code, nor even the datatype of this field, makes it harder to provide useful help! If the field is a Float, Currency, or Integer, you want${number.format("${esc.h}${esc.h},${esc.h}${esc.h}${esc.h}",$yourField)}but impossible to say for sure. Please remember to provide ...

    image_type
    Discussions
    1271 0 5
  • solved badge Re: I want to import custom object to test - can someone check my logi...

    Linked Field name is CIFOK, then you obviously can't leave the CIF out of the Person upload as you suggested earlier. That's the field that joins the 2 objects together.

    image_type
    Discussions
    771 0 0
  • solved badge Re: Sanity check on person is created

    If you were using Person Was Created w/an infinite date lookback, then yes, everyone who filled out the form. By definition, everyone who fills out a form was created!

    image_type
    Discussions
    689 1 0
  • solved badge Re: Transparency agreement after progressive profiling qs

    1. Is Jquery a good way to use in form?I try to avoid jQuery whenever possible. Using vanilla JS is more portable and just as efficient (in some cases much faster). 2. Do we have to update the code when I add new fields in form (If I use the method that you shared)?No, you only have to include field...

    image_type
    Discussions
    766 1 0

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,759
Total Tags 701
Likes Received 12360