- ipbr21054Asked on July 29, 2016 at 11:46 AM
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 ?
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.
- JotForm SupportdavidAnswered 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:
This would require setting up a condition for each part you have to include the URL with your submission data.
- ipbr21054Answered on July 30, 2016 at 08:24 AM
Ive setup the IF statement but where do i put the Url in the DO statement ?
Here is the DO statement Url
But how do i apply it.
- JotForm SupportliyamAnswered on July 30, 2016 at 09:38 AM
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.
- ipbr21054Answered on July 30, 2016 at 11:02 AM
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,
- JotForm SupportliyamAnswered 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.
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:
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:
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.
- ipbr21054Answered on July 30, 2016 at 01: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.
- ipbr21054Answered on July 30, 2016 at 01:41 PM
Ive applied the field correctly now and its been hidden on the form.
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.
I then look for the part number in question HONDA009 and now i see the item.
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 ?
- JotForm SupportNik_CAnswered on July 30, 2016 at 04: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.