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

  • gouldca
    Asked on January 6, 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?

  • raul
    Replied on January 6, 2015 at 1: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.