7 Replies Latest reply on Oct 19, 2016 8:37 PM by Sanford Whiteman

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

      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!