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

  • Profile Image
    TeckStyle 
    Asked 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...

  • Profile Image
    TeckStyle 
    Answered 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
    Shadae
    Answered 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
    TeckStyle 
    Answered 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
    Shadae
    Answered 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
    TeckStyle 
    Answered 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
    Jeanette
    Answered 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
    TeckStyle 
    Answered 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
    Charlie
    Answered 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
    TeckStyle 
    Answered 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
    Charlie
    Answered 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