Is there a way to set up a membership database with Jotform?

  • Profile Image
    Britonc
    Asked on June 28, 2020 at 01:32 PM

    I'm working on creating a simple membership database that will also allow me to track daily activities... 

    I plan several primary forms (Member Sign-up / Member Sign-In / Daily Activity Tracking) and am trying to understand if it is possible to search for data from existing tables in the system)...

    Basically for the Member Sign-In Form, is it possible to "look-up" or search the member table to find an existing member and then display some of the fields from that table on the Sign-in Form?

    Alternatively, what is the appropriate way for me to allow an employee to look-up member data at the time members are being signed in?

    Thanks


  • Profile Image
    Welvin
    Answered on June 28, 2020 at 03:42 PM

    I'm sorry, but our forms are not designed to work this way. You can signup people, but saving their data into an external database needs to be manually hard-coded.

    For example, this method through PHP:

    https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    As for the lookup feature, this is possible through our Spreadsheet to Form widget.

    https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Unfortunately, you will need an excel database for the widget to work. This also means you will have to update the excel file every time you have new data. The excel file cannot be dynamically filled with existing data from your other form.

    There is also no sign-in feature in our forms.

    Thanks