Include a specific URL in submission data when a selection is made

  • ipbr21054
    Asked on July 29, 2016 at 11:46 AM

    Hello,

    Here is the form in question 60712393428355

     

    When i receive the form in my email there is a field named Part Number.

    As i add items to my database i wont remember what each part number is.

    Is it possible some how to link the entered text in this field to a url that is currently in place so when i click the link a new page opens showing me what that part number is ?

     

    Example,

    Please look at the last submission for this form

    You will see that the field Part Number has been submitted with Honda009 assigned to it.

    I would like to click the Honda009 so this page is then shown http://www.theremotedoctor.co.uk/m-images/emailref/Honda009.html

     

    This would then be applied to each part number in question.

     

    Please advise.

  • David JotForm Support
    Replied on July 29, 2016 at 12:20 PM

    This would be possible depending on how many parts you have.  You could create a condition for each part to fill in a text box with the appropriate URL:

    https://www.jotform.com/help/286-How-to-Populate-Field-with-a-Value-from-Another-Field

    This would require setting up a condition for each part you have to include the URL with your submission data.

  • ipbr21054
    Replied on July 30, 2016 at 8:24 AM

    Ive setup the IF statement but where do i put the Url in the DO statement ?

    Here is the DO statement Url

    http://www.theremotedoctor.co.uk/m-images/emailref/Honda009.html

    But how do i apply it.

  • liyam
    Replied on July 30, 2016 at 9:38 AM

    Hello ipbr21054,

    My apologies but I'm having difficulty understanding the situation. In order for you to be guided properly, can you share with us the workflow of your form on how they search and select the product? This way we can properly address your issue and we'll have  concrete solution to your concern.

    Thanks for your understanding.

  • ipbr21054
    Replied on July 30, 2016 at 11:02 AM

    OK

    Go here http://www.theremotedoctor.co.uk/karfrv.html?scrollto=selection

    From the Item Selection on the right select Frv Key 2004-2008

    A photo of the key "Honda009" is now shown.

    Now select "CLICK TO ORDER"

    You are now able to complete the form & you will notice that the Part Number field is allready completed with "HONDA009"

    When i receive the form in my email i see HONDA009 but i dont know what it is,hence this post.

    I would like to click on HONDA009 on the form and it will show me what it is,

    http://www.theremotedoctor.co.uk/m-images/emailref/Honda009.html

     

     

     

  • liyam
    Replied on July 30, 2016 at 12:03 PM

    Thank you for the details, ipbr21054. I greatly appreciate it :)

    I was assuming at first that we can try getting the URL to pre-fill a hidden field or something rather than using a condition since it could be a lengthy process.

    But I'm starting to assume that each product has its own HTML page, and using the correct file name as the product. Example:

    http://www.theremotedoctor.co.uk/m-images/emailref/Honda009.html = Honda009 part number
    http://www.theremotedoctor.co.uk/m-images/emailref/Honda001.html = Honda001 part number
    http://www.theremotedoctor.co.uk/m-images/emailref/Honda002.html = Honda002 part number
    And so on and so forth...

    I can think of two ways to address this:

    First, add a new field. A regular text box will do and just hide it.

    Include a specific URL in submission data when a selection is made Image 1 Screenshot 30

    Next, you can try either of the two methods:

    1) Add the value via URL parameter. Add a hidden field in your form, such as a regular text box and set it as hidden in the properties. Then just add the URL as your value for the hdden field that you have added in the form such as this:

    http://form.jotformeu.com/form/60712393428355?partNumber=Honda009&linkTo=http://www.theremotedoctor.co.uk/m-images/emailref/Honda009.html 

     

    You can see the form I copied from you in action, but the field is not hidden for you to see: https://form.jotform.com/62113703811949?partNumber=Honda009&linkTo=http://www.theremotedoctor.co.uk/m-images/emailref/Honda009.html 

    ====

    2) Via conditions, but the problem I noticed is that there is a space in between the values and the prefix and suffix that I've set. Example: 
    http://www.theremotedoctor.co.uk/m-images/emailref/[space here]Honda009[space here].html

    In any case this is the condition:

    Include a specific URL in submission data when a selection is made Image 2 Screenshot 41

    Try visiting this form and change your product selections and you will notice what I mean: https://form.jotform.com/62113703811949 

    Hope this helps.

    Please let us know of your thoughts.

    Thanks

  • ipbr21054
    Replied on July 30, 2016 at 1:18 PM

    I have cloned your form ending in 11949 and its form number in my list is now 62115565434352

     

    Now when i receive the form the link to part number is isnt shown at all.

  • ipbr21054
    Replied on July 30, 2016 at 1:41 PM

    Ok

    Ive applied the field correctly now and its been hidden on the form.

    See here http://form.jotformeu.com/form/62115565434352?partNumber=Honda009

    When i receive the form via email i now see the field Link to part number with its link to the right.

    Clicking on this link a new page opens with my database list now shown.

    See here http://www.theremotedoctor.co.uk/m-images/emailref/

    I then look for the part number in question HONDA009 and now i see the item.

    See here http://www.theremotedoctor.co.uk/m-images/emailref/Honda009.html

     

    So i assume that all i need to do now is within my web site change the form currently in use from 60712393428355 to 62115565434352

    Would you agree with me ?

     

  • Nik_C
    Replied on July 30, 2016 at 4:48 PM

    If I understood the workflow correctly and 62115565434352 is linked as you described, then yes, I agree you should replace the 60712393428355  with it since that will assure the workflow you need. 

    If you have further questions please let us know.

    Thank you!