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

    Prepopulate data from Google Sheets

    Asked by cludlowb on December 14, 2016 at 01:59 PM

    Hi, i would like to create a form where if the client its registered in my google sheet with a client code the registration section autocompletes so he doesn't need to fill all data every time. it's that possible?

  • Profile Image
    JotForm Support

    Answered by John_Benson on December 14, 2016 at 03:39 PM

    This is not possible to achieve in the Form Builder. The available process here is exporting the data from the submissions to your database. Here's a guide: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    Please check this app Field Prepopulator, it might be useful for what you're trying to achieve. This will pre-populate the fields with data when your user opened the form.

    You might also want to check Webhooks. Here are the guides:

    Hope that helps. Let us know if you need further assistance. Thank you.