-
Mark E JarrettAsked 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.
-
JanReplied 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 JarrettReplied on March 19, 2018 at 8:43 AMNan. 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.
... -
JanReplied 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 JarrettReplied on March 19, 2018 at 11:43 AMNot 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.
... -
JanReplied 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 AppsIf you have any questions, let us know. Thank you.