Can I get a substring of the submission ID in a hyperlink in an autoresponder

  • Profile Image
    mtlscouts_committee
    Asked on December 22, 2012 at 11:17 AM

    Hi;

    I have put a hyperlink in the autoresponder of my form.  The URL of the link points back to my form, and passes a parameter (linkedFrom) that ends up in a hidden field.  What I want to do is to append only a part of (if posible) the submission ID to the URL.  Note that the text of the URL is the same as the URL itself.

    The URL is:  http://www.jotform.ca/form/23215769312250?linkedFrom=sharedAutoRespNotice 

    Thus the email would contain that text as a hyperlink that points to the displayed URL.

    I want the URL & the text to be something something like http://www.jotform.ca/form/23215769312250?linkedFrom=sharedAutoRespNotice_{submissionID}[12,18]  (or whatever the proper substring for the last 6 digits might be)

    Resulting in:  http://www.jotform.ca/form/23215769312250?linkedFrom=sharedAutoRespNotice_234567

    THanks;

     

     

     

  • Profile Image
    fxr
    Answered on December 22, 2012 at 03:39 PM

    Hi, you are going to have to use the full JotForm URL you are creating to populate the form correctly.

    But, in your email you could embed a completely text that what the URL actually is, with something like this:

    <a target="_blank" href=" http://www.jotform.ca/form/23215769312250?linkedFrom=sharedAutoRespNotice_{submissionID}">WHATEVER_I_WANT_THE_LINK_TEXT_TO_SAY</a>

     Obviously changing ' WHATEVER_I_WANT_THE_LINK_TEXT_TO_SAY' to any whatever text you want your form link to show.

    Is that a solution that you think could work for you?

  • Profile Image
    mtlscouts_committee
    Answered on December 22, 2012 at 05:11 PM

    OK, I think I see that I can include the {ID} in the URL if I use the 'Edit HTML source' editor from the autoresponder editor.  Are you sure that {ID} will be replaced by the actual submission ID, even though it is within quotation marks (of the href)?

    <a target="_blank" href=" http://www.jotform.ca/form/23215769312250?linkedFrom=sharedAutoRespNotice_{ID}">WHATEVER_I_WANT..</a>

    Also, how do I get only the last 6 digits of the ID?  I really don't need/want the entire 18 digits.

    Thanks;

     

  • Profile Image
    jonathan
    Answered on December 22, 2012 at 06:12 PM

    Hi,

    You can not cut the ID number... because the email html editor does not allow any type of  scripts for security reasons. That is why you cannot utilize substring or concatenate script function for example.

    BUT here is an idea I think you might want to consider...

    Instead of using the submission ID {ID} in the email field, add instead a Unique ID field in your form, then use that instead. You can start the index property of the unique field to your preferrence. You can even make it start at 6 digits using padding only

    To maximize your customization of the email template, compose everything first using the default template.. Example, add the link using the insert/edit link tool and set it to open on new window.. it will have the same effect as target_blank when you look at the email html source code.

    Hope this help. Please feel free to contact us anytime for any additional inquiry.

    Thanks.

  • Profile Image
    mtlscouts_committee
    Answered on December 22, 2012 at 06:46 PM

    The UniqueID field is a great idea.  Plus I already have it in my form.

    Thank you very much