JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Link Jotform with WP database to auto-fill custom post type?Asked by johnboy666 on March 29, 2016 at 08:17 AM
If the following is possible I'm happy to pay for it to be done...
I would like to use data that's submitted on a form to auto fill back-end fields on a custom post type in Wordpress.
1) user/customer completes form.
2) Data from form is used to fill specific fields in a custom post type thereby (in this case) creating an online memorial (would also have to go to pending queue for admin approval).
An example of a memorial can be found here:
The back-end looks like this..
Is this possible OR is there ANY other way of achieving this.
I've had a developer try to accomplish (not using jotform) but the best he could manage was an iframe of the backend which just isn't user-friendly.
Thanks in advance,
I am not quite sure if I understand your concern correctly, would you like to use the data on the JotForm form submitted to be prepopulated on your WP's fields?
You can directly send post data of your form on your PHP script and save it on your database, from there, you can simply call the data and prepopulate it on your WP's page.
Here are some guides that might help:
PHP Forms explains in JotForm: https://www.jotform.com/help/237-PHP-Forms-Explained
Enable Send POST Data from JotForm and send it to a PHP script: https://www.jotform.com/help/213-Send-POST-Data-From-JotForm-Using-PHP-in-Custom-Thank-You-Page
Send submission data to your MySQL database using PHP: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP
Now if you do not want the landing or thank you page to be the PHP script that will fetch the POST data, then you can just simply run the PHP script in the background using WebHook. Here's an intro about it: https://www.jotform.com/help/245-How-to-Setup-Webhook-with-JotForm
I hope that helps. Do let us know if you need more information on this.
Thanks for your quick response.
Yes - I would to use the data on the jotform to populate fields in Wordpress BACK-END.
Basically to create a Wordpress post using the data from the jotform.
Looking at the links you've provided I get the impression it may be possible but it's way beyond my skill-set.
Is there anyone on staff (or who you can recommend) who would be willing to set this up for a fee?
We do not offer a form creation service, and in your case, it might also involved a setup in your Wordpress, which means we will also do some Wordpress modifications and tests. It would be best to hire a developer for this. You can find some freelancer developers in these sites: www.upwork.com and www.freelancer.com.
What we can mostly offer is to assist you in creating your forms and help you setup some things, but given that I believe you have some deadlines, it would be more practical to hire a developer instead.
In case your developer is familiar with APIs, you can also directly fetch the submission data from JotForm and save it in your database using our API, you use this link as a reference: http://api.jotform.com/docs/#form-id-submissions
I hope that helps.