Link Jotform with WP database to auto-fill custom post type?

  • johnboy666
    Asked on March 29, 2016 at 8:17 AM

     

    Hi there,

    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.

    So...

    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:

    https://www.petshelddear.com/obituary/archie-adams/

     

    The back-end looks like this..

    Link Jotform with WP database to auto fill custom post type? Image 1 Screenshot 20

    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,

    John.

  • Charlie
    Replied on March 29, 2016 at 9:29 AM

    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.

  • johnboy666
    Replied on March 29, 2016 at 9:59 AM

    Hi Charlie,

     

    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?

     

    Thanks,

    John.

  • Charlie
    Replied on March 29, 2016 at 10:34 AM

    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.