- parrotheadAsked on August 24, 2015 at 10:59 AM
I have a registration for membership form I use http://form.jotform.us/form/43093886766168?
I would like to query that form to import data to a new renewal form that I would create. Something that may search on a name and then display the data from the other form.
From what I have read on the forum you do not support this directly, but could I use something like the app Import Data to retrieve the information and then filter it by name?
- CharlieAnswered on August 24, 2015 at 01:23 PM
Unfortunately, as you have mentioned, we do not have that feature or app to directly fetch in your submissions and prepopulate it on another form. However, that is possible by the following methods:
First method, if you are familiar with API, then you can easily use API to fetch your submissions and prefill another form. Here's a documentation about it: http://api.jotform.com/
Second method, you can directly use a PHP script to send the submission data to your MySQL database. From there, you can easily query or fetch the submission data from your own database and prepopulate your form. But this means you'll need to have a web page and a database.
I hope that helps.