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

    I need to autopopulate a jotform using a certail field as a unique code from spreadsheets?

    Asked by vaibhavTambade on June 30, 2017 at 03:38 AM

    I know I can do this by uploading an Excell file but, I want the data to be read from a Google spreadsheet which will be continuously updated by a jotform. The Exell file that I will be uploading will be static and, won't update automatically.

  • Profile Image
    JotForm Support

    Answered by Nik_C on June 30, 2017 at 05:29 AM

    Unfortunately, we don't have a built-in way to pull data from Spreadsheet and show it in the form. The closest way I could think now is to have Prepopulate URL created in Spreadsheet that when you click it opens the Form and prepopulates it.

    But that will require clicking of the link so the prepopulated form will open from Spreadsheet.

    But basically it would look like this:

    The prepopulate column I created manually, and this is the formula: =HYPERLINK("https://form.jotformpro.com/71801383290958?name="&B2&"&name[last]="&C2)

    If you think that could work please let us know.

    Thank you!