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.
Can JotForm Pull from a Google Docs (Database) File to Auto Populate a FormAsked by gouldca on January 06, 2015 at 10:54 AM
I have repeating customers, I would like to enter their data, such as Company name, email, address, phone number, contact person; into the JotForm the first time they are a customer. For each subsequent job, I would like a drop down of all previous customers, and once the customer name is selected, the remaining data also be populated. Can JotForm do this?
Unfortunately, this cannot be done within the form builder. To do this, you would need to use the full source code of your form and use a web programming language such as PHP or ASP.NET to search the data in the database and populate the fields accordingly.
Another way that I can think of on how to do this is by using prepopulated fields in your form. This method would not require the use of the full source code of your form. However, you would still need to use a web programming language to search within the database and create the corresponding URL.
Let us know if you need further assistance.