Can JotForm Pull from a Google Docs (Database) File to Auto Populate a Form

  • Profile Image
    Asked 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?

  • Profile Image
    Answered on January 06, 2015 at 01:49 PM

    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.
    Thank you.