How can I use the database information that I create with JotForm to populate my Wix site?

  • Profile Image
    eventowl
    Asked on December 12, 2013 at 01:34 AM

    Hello, I am unhappy with the stagnant graphics and the mobile unfriendliness of a Drupal site that I had created for me. I am happy with the design set up of Wix, and after some research, have found that your form and data collection services may be the missing piece I need to move this across to a new service. 

    However, I am unsure how to populate the information that I would enter into Jotform, to a Wix site. 

    Essentially I would like the details entered and submitted into JotForm, i.e. addresses, and pictures to become the search results that can be filtered, on a Wix site. 

    Do you have any advice about how I can make this happen? 

    The site I'd like to improve (which has a basic example of how I'd like the site to navigate, search results etc), is www.eventowl.com.au  (This does not have the form embedded at the moment, but is a good example). 

    Let me know? 

    Thanks, Natasha 

  • Profile Image
    EltonCris
    Answered on December 12, 2013 at 06:28 AM

    Hi Natasha,

    If you mean populate the form results to the search URL query on your Wix site then that's possible.

    Example:

    On the provided Wix example, this is the search URL query when you make sample search on that page.

    http://www.eventowl.com.au/listing-search?type_1=service&field_event_type_tid=6&field_capacity_tid=141&field_region_tid=267&sort_bef_combine=field_price_new_value+ASC

    You can replace the bolded part with a field tags from your form so when you hit submit on your form, these tags will be populated with the form data.

    Example:

    http://www.eventowl.com.au/listing-search?type_1={service}&field_event_type_tid={eventtype}&field_capacity_tid={numberofGuest}&field_region_tid={region}&sort_bef_combine={sort}

    This link must be placed on your form thank you message.

    To get your form field tags, check this guide:

    However, if you mean save the form data to your Wix database after form submissions then that's not possible in the form builder, but there's a workaround which requires custom PHP script, here's a guide: Form to MySQL

    Let us know if you have further questions. Thanks!

  • Profile Image
    Natasha
    Answered on December 12, 2013 at 09:28 PM

    Thank you for this! I meant the latter and will need to get my head around creating the custom PHP script but this looks like the answer I need.

    Cheers 

    Natasha 

  • Profile Image
    EltonCris
    Answered on December 13, 2013 at 03:57 AM

    Glad to be of assistance, Natasha.

    Should you have any other questions or concerns, do let us know by creating a new thread.

    Cheers!