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!