- Alex StuartAsked on April 19, 2016 at 02:31 PM
I am trying to create a way to take data from my filemaker database and fill in a form The form is found here.
My goal is to make it simple to have the data available and fill out only data that changes like the date of my workshops.
Is there a way to send data to the parent website/email in the exact same form that this form does?
wshfc.org is the parent
I am not affiliated with this website but am a user of their website and am creating a real estate database.
- KadeJMAnswered on April 19, 2016 at 03:43 PM
Do you mean you want to send your form submission data to the parent website?
Where is exactly on the parent website are you trying to send it to?
Is this going to another form on the parent website or are you referring to something else?
Unless it is for the database you are creating for that site?
Or are you just trying to send the data there anyway?
- Alex StuartAnswered on April 19, 2016 at 04:43 PMI want to pretend I have filled out the form automagically and be able to submit the data JUST AS IF I had clicked on the submit form button.
I am pulling data from filemaker and can create a URL but havent figured out how to auto fill out the form from filemaker.
- JotForm SupportKevin_GAnswered on April 19, 2016 at 06:11 PM
If I can understand what you are trying to achieve, you want to pre-fill some data on your form, this data will come from your database.
If I'm correct, this app will help you to get the URL with the form fields on the URL, then you will be able to fill these fields with the data from your database, take a look on the app here: http://prepopulate.jotform.io/.
You will be able to fill the fields with data from your database and at the same time will allow your users to edit the data and submit the form, but do note that this data will not be sent to your database again, it will be stored on our servers and you will be able to see it on the submissions page.
If you need to save this data again on your database, please take a look on this guide in order to get the steps to do it: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.
Hope this helps.
- Alex StuartAnswered on April 19, 2016 at 10:43 PMOk so I have solved many issues thanks to that. Now I have another problem. How can I get the value of a checked box or radio box to pass into the url? What should go after the = sign I guess is my question.
- JotForm SupportEltonCrisAnswered on April 20, 2016 at 02:19 AM
Use the exact options as the parameter value separated by commas on the URL.
comments - checkbox field name
Bring sack lunch,Lunch/Dinner provided - checkbox field options
URL: http://form.jotform.com/form/11573954323?comments=Bring sack lunch,Lunch/Dinner provided
You can find the full instructions here http://www.jotform.com/help/71-Prepopulating-the-fields-to-your-JotForm-via-URL-parameters.
Hope this helps!
- Alex StuartAnswered on April 20, 2016 at 02:43 AMTons of help. ? Thanks
One last thing when I try to do this using Windows 10 both Edge and Firefox it works the first time by the way I have less than 1000 characters. However the second time I paste the URL it will not update the fields. I actually see it update and then revert back to the previously saved version. When I do this on my iPhone however it works no problem. Seems to be a potential bug.
I am pre-populating many fields. It always works the first time. But unless I clear the field data in the browser it will not update subsequently.
It also works if I only do one field. the second time it still populates it with the new data
I'm hoping this is a known problem and there is a known solution. LOL thank you once again
- JotForm SupportEltonCrisAnswered on April 20, 2016 at 03:50 AM
You seem to have enabled autofill feature in your form too, which is not compatible with prepopulating through URL. Disabling the autofill feature in your form should fix it.