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 can I prepopulate form field values using values from a spreadsheet?

    Asked by bob@afcamail.com on September 22, 2014 at 05:01 PM

    I want people to form that has some of the field values prepopulated from a prior form submission (the values now reside in a spreadsheet).  For example, a person submits a job application with 3 references.  We want to email each of the 3 references a link to another jobform and have the reference company's name and the job applicant's name prepopulated.

    prepopulate form form field name job application 3 and
  • Profile Image
    JotForm Support

    Answered by david on September 22, 2014 at 05:28 PM

    Hi,

    Though it is not possible to pre-populate  your form based on data from a spreadsheet, it is possible to populate your form with data entered in the URL:

    http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters

    You could then include the modified URL in the email.  You can search for the fields of the 2nd form and find the field names required to be filled.  Next, get the email template variables (values on your email notification editor with { })

    So on your email notification's content, you will need to create a link to your 2nd form something like this:

    http://form.jotform.com/form/123456789?firstname={firstnamevar}&lastname={lastnamevar}

    This way, when the user follows the link, the form is already pre-populated with values coming from the 1st form.

    Let us know if you have any questions about this and we will be happy to help.