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

    Can a form be made that updates entries in a database, letting another jotform user access them and also make changes to that database?

    Asked by johnsinsight on March 24, 2016 at 04:24 PM

    Hi,

    Thanks for your attention.

    I'd like a jotform to:

    Capture user input

    Store it somewhere (google drive sheets seems to work on jotform)

    Allow updating of the database/sheet

    Allow a different jotform to view the database information

    Make changes to the same fields of the form

    Make certain forms see /update only certain sheets

     

    Please let me know if this is possible. 

    Thank you;

    -John

     
    JotForm user access and another
  • Profile Image
    JotForm Support

    Answered by Nik_C on March 24, 2016 at 06:10 PM

    Unfortunately, Jotform does not support integration with databases. You could host a PHP script that will update database on every submission. You can take a look at this guide on how to send POST data on form submission. If you can hire developer he could make an app that will pull data  from spreadsheet. Please take a look at the following JQuery plugin.

    Let us know if you need more information.