Can I create a custom field that is a substring of another field? | Community
Skip to main content
A
Anonymous
October 19, 2016
Question

Can I create a custom field that is a substring of another field?

  • October 19, 2016
  • 2 replies
  • 3819 views

I'm interested in doing this without scripting, but I can't find a way using formulas.

GOAL: WITHOUT SCRIPTING, I'd like to use a portion of an existing field as a query string in an email link (in our case, OrderID). This OrderID already exists within the text of another field we DO already capture (the OrderURL). In short, I'd like the link to look like this:

www.blah.com/target-page?id-to-send=123456 (or www.blah.com/target-page?id-to-send={{lead.OrderID}})

Where OrderURL (an existing field) = v123456.abcdef.aaabbcc.com

And OrderID (not currently its own field) = 123456

QUESTION: Is there a way to accomplish any of the following?

  1. Create a custom field in Marketo whose value is a portion of another field (a substring function) without scripting

  2. Create the link such that the substring action is performed on the existing field (the OrderURL) within the link itself at the point of render/send (rather than having to create a persistent field)

  3. Accomplish my goal in some other way I haven't considered

Did I mention that I don't want to use scripting to accomplish this? Thanks for any guidance!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SanfordWhiteman
SanfordWhiteman
New Participant
October 19, 2016

Your requirement of "at the point of render/send" mandates that you use an email script. That's what -- and where -- scripts are for.

A
Anonymous
October 19, 2016

That's not a requirement...just one way I could think to solve the problem (for example, another way was listed in option #1).

SanfordWhiteman
SanfordWhiteman
New Participant
October 19, 2016

The answer is still no, if you're averse to all kinds of scripting.

A FlowBoost script could do this in one line, then save the value in another persistent lead field. But I would never choose a FlowBoost script over a Velocity script for this case.

Jim_Thao7
Jim_Thao7
New Participant
October 19, 2016

Short answer, no. 

Marketo currently doesn't do math in any way that I know of: which includes addition, subtraction, multiplication, division of strings, numbers, etc.

    Terms & ConditionsAccessibility statement

    Loading footer...