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!

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

Your Achievements

0% to

Next /

to gain points, level up, and earn exciting badges like the new !

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