Can you connect your form to PostgreSQL

  • postittojason
    Asked on October 20, 2018 at 10:51 AM

    can you connect your form to a database postgreSQL?

  • John_Benson
    Replied on October 20, 2018 at 7:17 PM

    To get data in PostgreSQL, you can use this app: https://apps.jotform.com/app/postgresql_export

    Give it a try and let us know if you have questions.

  • postittojason
    Replied on October 20, 2018 at 11:43 PM
    I am trying to get data from a postgreSQL database populated into the form
    based on a barcode scan match.
    Best
    Jason Weedon, CEO
    *Want my ear for 15 mins click here! *
    Culinary Center
    1200 West Cermak Road
    Chicago Illinois 60608
    Billing
    1074 West Taylor Street, Box 126
    Chicago Illinois 60607

    O 877 219 3663
    M 312 296 5953
    CONFIDENTIALITY NOTICE: This e-mail and any files transmitted with it are
    intended solely for the use of the individual or entity to which they are
    addressed and may contain confidential and privileged information protected
    by law. If you received this e-mail in error, any review, use,
    dissemination, distribution, or copying of the e-mail is strictly
    prohibited. Please notify the sender immediately by return e-mail and
    delete all copies from your system.
    ...
  • Adrian
    Replied on October 21, 2018 at 4:57 AM

    I am trying to get data from a postgreSQL database populated into the form based on a barcode scan match.

    Unfortunately, this is not possible.

    If I understand you correctly, you are trying to populate the form with data from a PostgreSQL database while the user is filling the form.

    As a workaround, I suggest you try and export your data to an Excel (Spreadsheet) or a CSV file.

    Then, using the Spreadsheet to Form widget, the users will be able to enter a unique code based on which the form will be populated (with the data from the spreadsheet).

    Complete Guide: How-to-Use-the-Spreadsheet-to-Form-Widget


  • postittojason
    Replied on October 21, 2018 at 9:43 PM
    I think there is a way by connecting integromat? To connect live with timed
    updates.
    Best
    Jason Weedon, CEO
    *Want my ear for 15 mins click here! *
    Culinary Center
    1200 West Cermak Road
    Chicago Illinois 60608
    Billing
    1074 West Taylor Street, Box 126
    Chicago Illinois 60607

    O 877 219 3663
    M 312 296 5953
    CONFIDENTIALITY NOTICE: This e-mail and any files transmitted with it are
    intended solely for the use of the individual or entity to which they are
    addressed and may contain confidential and privileged information protected
    by law. If you received this e-mail in error, any review, use,
    dissemination, distribution, or copying of the e-mail is strictly
    prohibited. Please notify the sender immediately by return e-mail and
    delete all copies from your system.
    ...
  • ivy
    Replied on October 22, 2018 at 2:48 AM

    Hi!

    You can follow this basic guide by connecting integromat:

    https://www.jotform.com/blog/integromat-integration/

    https://apps.jotform.com/app/integromat 

    Please let us know if you need further assistance.