What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to Fetch submission data from one form and load it to another form?

    Asked by TeckStyle  on March 18, 2015 at 02:01 AM

    I need to show results from a sizing form to a booking/purchase form.

    Form 1- user enters preferred sizes/styles

    Form 2- Main product ordering form.

     

    Form 2 that has product selection, colour, design etc and the option to "load my sizes" (tickbox?), that will essentially load the data from form 1 and show results on form 2... is this possible with "reports", load url string depending on unique user/submission ID or any other method that might be a suitable workaround from the more conventional members stored data that I understand is not currently available in jotform...?

    i understand there might be some html, jquery and or php script to achieve this and am open to suggestions...

    unique another form submission data call
  • Profile Image

    Answered by TeckStyle  on March 18, 2015 at 02:07 AM

    or maybe an option to load "edit form submission" from form 1 and show in an iframe depending on users textbox input (ID/email) on form 2?

  • Profile Image

    Answered by Shadae on March 18, 2015 at 10:52 AM

    Hi TeckStyle,

    You can prepopulate a form with the information from another form by passing information through URL parameters: http://www.jotform.com/help/71-Prepopulating-the-fields-to-your-JotForm-via-URL-parameters 

    You can then use Custom URL "Thank You" page to redirect your users to the second form:

    http://www.jotform.com/help/211-Setting-Up-the-Thank-You-Page 

    Here is an example of how your URL would look:http://form.jotformpro.com/form/50646250060950?firstname={firstname}&lastname={lastname}

    The form ID for your first form

    The form ID for your second form without the {}

    The URL for your second form

    I hope this helps, please inform us if you need further assistance.

    Thank you.

  • Profile Image

    Answered by TeckStyle  on March 18, 2015 at 12:24 PM

    Thanks Shadae, but thats not what I asked....

    I need to pre-populate certain fields BUT onclick/selection of a radio/tick/button and then user enters email/submission ID to pre-populate their sizes.

  • Profile Image

    Answered by Shadae on March 18, 2015 at 02:03 PM

    Hi TeckStyle,

    To confirm, you would like when a user enters their email address, other fields would be prepopulated.

    That can only be achieved if you created conditions, that when a specific email is entered, other fields will be populated.

    You can however create a session using our Save and Continue work around. You can also add the parameters to have the field populated: http://www.jotform.com/help/97-How-to-Save-Forms-to-Continue-Later 

    Please inform us if this is a suitable option.

    Thank you.

  • Profile Image

    Answered by TeckStyle  on March 18, 2015 at 03:59 PM

    If a user enters their email address (or submission ID from form 1) the form will pre-populate with the submission data from form 1.

    EXAMPLE:

    Jimmy can enter his submission ID (or email) in form 2 to retrieve his unique sizes from form 1.

    Kelly can enter her submission ID (or email) in form 2 to retrieve her unique sizes from form 1.

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on March 18, 2015 at 06:55 PM

    Your scenario involves a call to a Database. That is not possible to be accomplish with Jotform. My recommendation would be to download the full source code of the form and apply some PHP/MySQL programming to meet this requirement.

    http://www.jotform.com/help/237-PHP-Forms-Explained

    http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

     

     

  • Profile Image

    Answered by TeckStyle  on March 18, 2015 at 07:38 PM

    Please read the post and see "any other method that might be a suitable workaround from the more conventional members stored data that I understand is not currently available in jotform...?"

     

  • Profile Image
    JotForm Support

    Answered by Charlie on March 18, 2015 at 11:45 PM

    Hi,

    Unfortunately, my colleagues have already suggested possible workarounds, and based from what I understand, the best suitable one for your process flow is using a PHP script and a database in your end.

    Here's how I will do it.

    1. Form 1 (to get the unique sizes) and Form 2 for purchase order.

    2. Form 1 will have a "Thank You" page redirect to a PHP script (I'll name it save_data.php) that will initially stores data to your database. Here's how to send a submission to your MySQL database using PHP: http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

    3. I will have a separate web page where user can enter their submission ID or email address (which should already be in your database after submitting Form 1), that web page can send a POST Data to Form 2 to be pre-populated and continue purchasing the product with the existing data fetched from your database. Here's the guide that was also mentioned earlier: http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters.

     

    Another method that you could use involves more the form's full source code. Here's what I have in mind.

    1. Get Form 2's full source code, and embed it to your web page.

    2. Now using API, you can fetch existing data submission from Form 1 and prepopulate it to Form 2: http://api.jotform.com/docs/

    3. You'll need to create your own functions inside the form's full source code for the conditions or prepopulation together with the API.

     

    I would recommend the second method as it is much more easier to do.

    I hope that helps.

    Thank you.

  • Profile Image

    Answered by TeckStyle  on March 19, 2015 at 12:28 AM

    Ah Charlie thank you!.. I will dive into the second option using API as I don't have a database for this... thank you for your time and possible solutions :)

  • Profile Image
    JotForm Support

    Answered by Charlie on March 19, 2015 at 02:19 AM

    I'm glad it helped. Do let us know if you need additional information on this.

    If you have other concerns or questions, please do not hesitate to open up a new thread here in the forum.

    Kind regards