How to pre-fill form with data previously submitted?

  • frederth
    Asked on August 1, 2016 at 4:57 PM

    Will this work?  I have a form for scholarship application with multiple scholarships to choose from (it is a Google Form currently)?  I want students to be able to enter all their personal, academic, and financial info just once, then be able to select a scholarship from a drop down list, write a paragraph specific to that scholarship, then submit and redo the process for as many scholarships as they choose.

    Tom Frederick

    tomfrederick42@gmail.com

  • Kevin Support Team Lead
    Replied on August 1, 2016 at 9:36 PM

    Yes, this seems currently possible, what you will do is getting the data and generating a link, provide the link to user on the Thank You page or via email, then when your submitter opens the form the pre-filled data will be there, this should be the process to do it, if your submitter also changes some info it will be updated on the link that will be provided. 

    Here is a guide that will help you with that: Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters

    Here is also an app that will help you: http://prepopulate.jotform.io/ 

    However, you may provide us the link to your form and we will help you to generate the link with the pre-filled info. 

     

  • Tom
    Replied on August 1, 2016 at 10:56 PM

    Thanks for the speedy response!  Here is a link my form.

  • beril JotForm UI Developer
    Replied on August 2, 2016 at 3:31 AM

    Thank you for providing the URL of your website, you're able to prepopulate your data with our prepopulate application easily.

    How to pre fill form with data previously submitted?  Image 1 Screenshot 20

     

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.

  • Tom
    Replied on August 2, 2016 at 12:34 PM

    Hmm...Not sure I follow.  I do not want to repopulate.  Instead, I want students doing multiple applications to have all their personal information repopulated after the first application.  For example.  When I apply for "Scholarship X" and press submit, I want to be able to have a link/button that says "Thank you for submitting your application...Would you like to apply for another scholarship?"  If they select "YES" then I want the form to open again and be repopulated with their personal, financial, and academic info so they don't have to type it all in again.  Can you help?

  • Kevin Support Team Lead
    Replied on August 2, 2016 at 1:40 PM

    The app provided by Beril is the correct, that will help you to get the link with the fields from the form on it. 

    It will provide you the link with fixed data that will look like this: http://form.jotformpro.com/form/62145032187955?name[first]=JotForm&name[last]=JotForm&email=support%40jotform.com 

    Now, you already have the link with the pre-populated data, but it is fixed, here you need to replace the fixed data with data from the fields in your form. 

    You will need to get the field's name to capture its value and pass it to the URL, this guide will help you to get the field's name: How-to-find-field-IDs-and-names

    Do note that fields with more than one field in it, like the Full Name field, Address field, Date field, that are not only one text box, example: 

    How to pre fill form with data previously submitted?  Image 1 Screenshot 40

    For this fields you you will need to split the result, for example, the name for that field would be "name" here if you only pass the value as "{name}" it will not work as the "Name Field" contains more than one field, you will need to split it like this "{name:first}" and "{name:last}"

    For the address field it should be like this: 

    {address:addr_line1}

    {address:addr_line2}

    {address:city}

    {address:state}

    {address:postal}

    {address:country}

    Replacing address with the field name that you will find following the guide given above. 

    Now, once you have the fields names, you can pass the values in the URL, so the link without the fixed values and values submitted will be like this: http://form.jotformpro.com/form/62145032187955?name[first]={name:first}&name[last]={name:last}&email={email}

    I have highlighted the variables that will pass the values from the form, paste this on the Thank You page: 

    How to pre fill form with data previously submitted?  Image 2 Screenshot 51

    So when the form is submitted it will show a Thank You page like this one: 

    How to pre fill form with data previously submitted?  Image 3 Screenshot 62

    With the data pre-filled being the data just submitted. 

    Here is the link to my sample form, feel free to give it a try: http://form.jotformpro.com/form/62145032187955 

    If you want to clone it, this guide will help you: How-to-clone-an-existing-form-from-a-URL

    Hope this helps.