Can your forms populate an access database table on an iCloud?

  • Mark E Jarrett
    Asked on March 18, 2018 at 10:26 AM

    Hello.. Can your forms populate a. Access database table on an icloud? If so how do i set it up to do just that. 

  • Jan
    Replied on March 18, 2018 at 10:53 AM

    You can prepopulate the forms via the URL. Here's how: Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters.

    However, we do not have a tool wherein you can prepopulate the form using a data from an external database.

    You can use the Spreadsheet to Form widget. This widget allows you to upload your spreadsheet to your form and use the values you have in the spreadsheet to pre-populate your form. Here's a guide: How-to-Use-the-Spreadsheet-to-Form-Widget.

    We also have an Import Tool app if you want to import submissions to your form. Here's a guide: Import-App-Easily-Import-Your-Excel-or-CSV-Data-into-JotForm.

    Hope that helps. Thank you.

  • Mark E Jarrett
    Replied on March 19, 2018 at 8:43 AM
    Nan. I dont want an excel sheet to populate the form... I want the form to
    populate the Microsoft Access Data Table.
    Mark Jarrett
    This electronic email and document and attachments are private property of
    the sender and are confidential and is protected information subject to the
    Electronic Communications Privacy act of 1986 as amended 18-USC. 2510-2521
    and are confidential and privileged communications intended solely for the
    recipient, use, benefit and information of the intended recipient or
    recipients above.
    ...
  • Jan
    Replied on March 19, 2018 at 10:50 AM

    Unfortunately, we do not a feature where you can populate the form fields from an external database like MS Access Data Table.

    Thank you for your understanding.

  • Mark E Jarrett
    Replied on March 19, 2018 at 11:43 AM
    Not the form fields from a database. The other way. Read my post again. The
    form fields populating the database. This is the swxomd time you have it
    reverse.
    Mark Jarrett
    This electronic email and document and attachments are private property of
    the sender and are confidential and is protected information subject to the
    Electronic Communications Privacy act of 1986 as amended 18-USC. 2510-2521
    and are confidential and privileged communications intended solely for the
    recipient, use, benefit and information of the intended recipient or
    recipients above.
    ...
  • Jan
    Replied on March 19, 2018 at 1:16 PM

    Sorry for the confusion.

    You can create an Excel report and then import it into MSAccess. Here's a guide: How-to-Create-an-Excel-Report.

    You can enable the HTTP Post Data on your form and then write a custom PHP script that will connect the form to your MS Access database. Please check this article: http://www.sitepoint.com/using-an-access-database-with-php/.

    You may also use Webhooks to send HTTP POST notifications to a URL. Here's a guide: How-to-Setup-a-Webhook-with-JotForm.

    Related guides and links:
    How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP
    Send-POST-Data-From-JotForm-Using-PHP-in-Custom-Thank-You-Page
    How-to-Download-Form-Submissions-as-Excel-CSV-PDF
    JotForm's Database Apps

    If you have any questions, let us know. Thank you.