- paulAsked on May 31, 2015 at 07:12 PM
I need to get data entered in a website form into my FileMaker database. There may be about 150 forms submitted per day. How can this be accoplished?
This is a re-post of a comment on How to send Submissions to Your MySQL Database Using PHP
- JotForm Supportashwin_dAnswered on June 01, 2015 at 07:49 AM
Unfortunately we do not have any built in feature to send your form's submission data to your FileMaker DB.
One possible solution is to post your form's submission data to your own PHP page and then write your own code to insert data to FileMaker by taking advantage of its API.
Here are the steps you should follow:
#1. Create your form and set the preferences to send POST data. Please check the screenshot below:
#2. Set the "Custom URL" of your form's thank you option to redirect to your own page after the form is submitted. Please check the screenshot below:
The following guide should help you on how to post your form's submission data using your own custom thank you PHP page: https://www.jotform.com/help/213-Send-POST-Data-From-JotForm-Using-PHP-in-Custom-Thank-You-Page
You may also like to check the FileMaker API here: http://help.filemaker.com/app/answers/detail/a_id/6385/related/1/session/L2F2LzEvdGltZS8xNDMxMTE0MjAyL3NpZC9SQ0VUaVJsbQ%3D%3D
Hope this helps.
Do get back to us if you have any questions.
- JordanAnswered on April 10, 2017 at 10:39 AM
I have managed to figure a way to do this without having to use custom web publishing / HTTP Post. Simple get from URL and some exporting and importing. If you interested let me know and I can send you an example database on how I did it.
- PEvaluationsAnswered on June 15, 2017 at 05:47 PM
I'm interested in how you accomplished the integration with Insert From URL?
- JotForm SupportEltonCrisAnswered on June 15, 2017 at 08:30 PM
While I am not quite sure of Jordan's way of accomplishing it but if that requires exporting form data into database format e.g. SQL, you can use these apps to export them.
Perhaps using Webhook might also interest you. Guide: http://www.jotform.com/help/245-Creating-your-first-Webhook-with-JotForm
Please let us know how we can be of further help so we can move your question to a separate thread.