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.
Prepopulate data from Google SheetsAsked 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?
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.
Hope that helps. Let us know if you need further assistance. Thank you.