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

    Populate with data from an external google sheet

    Asked by niconi on June 29, 2016 at 11:40 AM

    I would like to populate certain fields automatically.

    For example :

    I have in a google sheet the info : paul jones, 3 children, married

     

    if mail is paul.jones@france.fr in the form, i would like that the fields number of children and marital status populate automatically.

     

    Is it possible ? 

    Page URL:
    https://form.jotformeu.com/niconi/liste-des-pices

    sheet External status 3 and
  • Profile Image
    JotForm Support

    Answered by Nik_C on June 29, 2016 at 12:50 PM

    Unfortunately, you cannot populate the form from a Google Spreadsheet. It is not possible to integrate Jotform and Google Sheets that way.

    Let us know if you need more information.