-
EXELAAsked on October 13, 2020 at 3:42 PM
I have two forms. One is a clone of the other so the field names are identical.
I am building a URL to pass fields in the notification email.
Works fine, but...
As the field values contain spaces the URL stops at the space and doesn't pass the second part of the URL.
I have tried passing the data into Zapier and building the URL there. I have used their URL encoder to change spaces for %20 and = for %3D. The transform works in Zapier but the subsequent form doesn't get the data from the query string.
This is what I am seeing https://www.loom.com/share/32c5f01dd654487eb894694abf35d6b6
I have read https://www.jotform.com/help/71-prepopulating-fields-to-your-jotform-via-url-parameters
Using https://prepopulate.jotform.io is a poor option as it is manual and fields would all need to be text as it doesn't work with dates.
Any suggestions please.
David
-
Jovanne JotForm SupportReplied on October 13, 2020 at 7:29 PM
Hi David, thank you for contacting JotForm support.
Are you perhaps referring to this form 202854468709365 being prepopulated from the form 202843117049048?
You can manually pass the field data via URL parameters. Just follow this format:
https://www.jotform.com/form/202854468709365?second_form_field_name={first_form_field_name}
Example:https://www.jotform.com/form/202854468709365?destination={destination}&hotelName={hotelName}
Guide: prepopulating-fields-to-your-jotform-via-url-parameters
If you want to have the prepopulated link in the notification email, you can insert a hyperlink and set up the prepopulated link as the source URL.
Example: https://www.jotform.com/form/202854468709365?destination={destination}&hotelName={hotelName}
I hope this will help. Let us know if you have further questions.
-
EXELAReplied on October 16, 2020 at 6:15 AM
Joavanne.
This doesn't work.
The value in the field {hotelName} is Big Hotel.
So the URL with parameters is https://www.jotform.com/form/202854468709365?hotelName={hotelName}.
But the problem is the space between "Big" and "Hotel".
So the query string reads https://www.jotform.com/form/202854468709365?hoteName=Big Hotel
As you know this would actually read https://www.jotform.com/form/202854468709365?hotelName=Big
If I added further param's in the querystring that would not get sent.
As you will see from the many comments on prepopulating-fields-to-your-jotform-via-url-parameters this guide is just wrong. Or at least not useable.
I have tried to solve for this using URL encoders but the receiving form does not pick up the data in the query string.
Can you have someone in advance support look at this please.
David
-
Vick_W Jotform SupportReplied on October 16, 2020 at 8:02 AM
Hi David,
Yes, you are correct. If the pre-populated URL is added as URL only then it will not work as it will break the URL due to the spaces.
However, we are suggesting to create a Hyperlink Text. This will automatically replace the spaces with % when you click on it and it will not break the URL.
Please try this cloned form. I've added a hyperlink in its Email notification and Autoresponder email as well.
https://form.jotform.com/202893107292961
Here is how you can clone it.
https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL
I've also added an email field in the cloned form so you can receive an Autoresponder email with the link as well.
Please try it and let us know if you need further assistance.
Thanks.
-
EXELAReplied on October 20, 2020 at 4:46 AM
Hi Vick
https://www.loom.com/share/ab543e9400084bdc9d8361fed3cf1f8a
Thanks for your answer
It hasn't explained to me anything that I need to do to get this to work for me.
I know how to clone a form but don't see how that helps me pass URL param in tan encoded query string.
Can you explain more detail, please?
David
-
Vick_W Jotform SupportReplied on October 20, 2020 at 5:05 AM
Hi David,
Please accept my apologies as I didn't explain it in detail.
After filling out the 3 fields you click on the Next button, then on the next page please click on Submit.
This will submit the form and send you an email.
That email will have a hypertext link.
When you click on it the same form will open again with the prepopulated parameters and the data will automatically get filled.
I'll create a video and send it to you shortly.
Thanks.
-
EXELAReplied on October 20, 2020 at 5:25 AM
Hi Vick,
I can see that on submit the URL
https://www.jotform.com/form/202854468709365?hotelName=Cairo Hotel has been passed into the TY page.
So this has managed to pass the encoded %20. How? I can't see any of you magic behind the scenes.
This is my scenario
Form 1 filled by prospect for basic info
Form 2 is "internal form" prepopulated and completed by agent. On submission this form sends an SMS containing a URL shortener to the prospect.
On clicking the shortened url the prospect sees a Form 3, that is a quote. This has the prepopulated fields (hidden) printed into a paragraph field. They accept the quote and therefore see Page 2 etc.
There are about 20 fields to pass in the url. Some are text containing spaces and some are date fields.
Thanks for your help.David
-
Vick_W Jotform SupportReplied on October 20, 2020 at 7:03 AM
Hi David,
Here is the short video. After form submission, you'll receive the hypertext link in the email. When you click on it the URL will automatically open a form with prepopulated data. Replacing the spaces with %20. There is no magic in it. This is how the browser treats a URL when there are spaces in it.
Please check the short video below.
https://drive.google.com/file/d/1lLB-7UINrN0DjRmArUfcX3nVvVZk4Z24/view
Based on your explanation, the data from the first will be populated in the second form. You can use the URL parameters to populate all fields. You just have to add the URL as hypertext in the email. As I did in the cloned form.
Let us know if you have any questions or concerns.
Thanks.
-
EXELAReplied on October 20, 2020 at 7:57 AM
Thanks Vick
What I need to see is the setting you have in the notifications of this form. You are showing me the "front-end" but I need help with seeing the back-end of this.
If you look at my original forms you can see that I tried this approach but couldn't get it to work. I need to see what you have done in the settings/notifications
https://www.loom.com/share/b7ebdf1c7a2c43fabf62d231e7032055
Thanks
-
Vick_W Jotform SupportReplied on October 20, 2020 at 8:25 AM
Sure, David. Here it is.
Here is how you can create a hyperlink text.
1.
2.
Here is the cloned form again.
https://form.jotform.com/202893107292961By cloning it in your account you'll be able to see the backend settings as well.
Let us know if you have any questions or concerns.
Thanks.
-
EXELAReplied on October 21, 2020 at 10:07 AM
Okay got it Vick
HOWEVER it does not pas the dates!!
How do I get those over?
-
EXELAReplied on October 21, 2020 at 10:25 AM
-
Jovanne JotForm SupportReplied on October 21, 2020 at 12:04 PM
Hi,
HOWEVER it does not pas the dates!!
How do I get those over?
Kindly use this prepopulated link:
As for prepopulating address fields, please allow me some time to conduct some tests. I will get back to you as soon as I have more information.
Thank you.
-
Jovanne JotForm SupportReplied on October 21, 2020 at 12:34 PM
Hi again,
Your next question will be answered on this thread https://www.jotform.com/answers/2647083 to avoid cofusion.
Thank you. -
EXELAReplied on October 21, 2020 at 1:19 PM
Joanne
You haven't answered the question about dates!
The link you have given me is exactly the same as the one I gave you?
-
Jovanne JotForm SupportReplied on October 21, 2020 at 5:37 PM
Hi,
It's different, as you can see:
You need to capture the exact field name of both fields.
Guide: prepopulating-fields-to-your-jotform-via-url-parameters
I hope this will help. Let us know if you have further questions.
-
EXELAReplied on October 24, 2020 at 6:54 AM
The date field doesn't pass
https://www.loom.com/share/da155af93885494da317bac6611076d3
I can see the data is in the URL encoded correctly but the target field doesn't pull it in.
-
Vanessa_TReplied on October 24, 2020 at 7:42 AM
Based on your screencast, you are having a Date Picker field with Time enabled. Unfortunately, I am unable to find ways to prepopulate both date and time within one Date Picker field.
However, as a workaround, you can use a Date Picker field for the date then add a Time field for the time. Then to prepopulate both, kindly have this format:
FORM_URL?date[month]={date:month}&date[day]={date:day}&date[year]={date:year}&time[timeInput]={time:timeInput}&time[ampm]={time:ampm}
Where date is the Unique name of the Date Picker field and time is the Unique Name of the Time field.
-
EXELAReplied on October 25, 2020 at 12:03 PM
Thanks Vanessa
I have this working right up until the last 8 fields.
https://www.loom.com/share/81faa7552a464caab665a2fa91d0d0a0
I don't think there is a field name problem but I will check.
Is there a limited to the amount of data that can be passed in the URL?
-
Vanessa_TReplied on October 25, 2020 at 1:30 PM
JotForm doesn't actually set a URL character limit, however, as per checking, some browsers do have a limit of 2,048 characters.
Nonetheless, I checked the most recent notification email that you have and can see that the fields you have referred on your last video are properly populated using the URL below:
Can you please confirm if you're still having issues?
-
EXELAReplied on October 25, 2020 at 1:46 PM
It all tested correctly !
Thanks for your help