Online database question

  • Profile Image
    Asked on January 27, 2021 at 08:02 AM

    I know that JotForm is an online form builder with an online cloud database. Is it possible to query that online database with a unique ID, populate another online form and then display that form? I can already pull down the populated data and email a new link that shows the pre-populated form. would like to skip the emailing part and just automatically have the new form appear.

    And, maybe I should be more specific. We are a small doctor's office and want patients to electronically sign our HIPAA form. We can use a JotForm form to upload the unique patient number, first name, last name and birthday to the JotForm online database.. When the patient arrives, we would like to bring up a JotForm form that asks for the patient number, which we enter. Then the name and birthday appear (pulled from the JotForm online database), to confirm we made a correct entry. If correct, we hand the tablet to the patient to read and sign.

    The idea is that every evening, we upload the next day's scheduled appointments to the online database from our in house software.


  • Profile Image
    Answered on January 27, 2021 at 09:41 AM

    Hi! Simple method to achieve this would be to use our Spreadsheet to Form widget. This widget allows you to upload an Excel database file to a form and at run time, form data can be loaded into the form fields using a unique code which could be a Unique ID, Email, Phone Number etc.

    Here is an example of this widget in action:

    In this Demo Form, enter any value between 'unique1' and 'unique10' in the "Spreadsheet to Form Widget" field and hit "Auto Complete Fields" button. This will load data in the form fields.

    Similarly, you can prepare an Excel file with with the unique patient number, first name, last name and birthday and upload to this widget on your form.

    At runtime, doctors could feed in the patient number to load the personal details of the patients and then you can manually fill out the remaining fields. You can upload a new spreadsheet at anytime on this form as well with updated data.

    Let us know if this doesn't solve your purpose.

    Thank you!