What is JotForm?
JotForm is a freeonline form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.

Why do you not want to answer this thread?(Your answer will be sent to Jeanette and Aytekin)

Having issues posting submission data to my DB using Webhooks.

Asked by
sludwig1129
on September 21, 2014 at 04:59 PM

Now the next thing… I am trying to have the forms I have in Jotform to post to my database. I have tried to do the webhooks thing and it doesn’t seem to work. Maybe you might be able to do something in the background that I don’t know about? This is the instructions that my database provider gives:

Post from Website

With VAM dB you can post forms directly from your web site into your database to capture new leads. All you need to do is make a few changes to your form.

1. Change the url that the form post to: https://www1.mscc2.com/VAMdB/webform.php - this is a secure web page for your data to be submitted to.

2. Add a hidden field for the page you want visitors directed to after completing the form, for example

Add a hidden field to identify your account:

3. Have the field names match the options below for the basic fields first_name last_name company home_phone work_phone cell_phone home_fax work_fax email best_time_to_contact address city state (2 character abbreviations) zip birth_month (2 digit number) birth_day (2 digit number) birth_year (4 digit number) gender (options: M, F, Male, Female) height weight tobacco_use (options: Yes, No) tobacco_type occupation employer income (numbers only) reference_number comments medical_ailments_impairments medications_taken hazardous_activities family_history driving_record travel_details other_health_comments policy_type (options: Life, LTC, Health, Medicare) For policy type of: Life insurance_company death_benefit (numbers only) term (must match an existing option in VAM dB) rate_class (must match an existing option in VAM dB) product annual_premium (numbers only) modal_premium (numbers only) mode policy_owner policy_owner_relationship primary_beneficiary primary_beneficiary_relationship secondary_beneficiary secondary_beneficiary_relationship For policy type of: LTC insurance_company daily_benefit (numbers only) benefit_period (must match an existing option in VAM dB) product annual_premium (numbers only) modal_premium (numbers only) mode For policy type of: Health insurance_company plan_name modal_premium (numbers only) mode For policy type of: Medicare insurance_company plan (examples: A, F, F High Deductible, Supplement, Advantage etc) plan_name modal_premium (numbers only)In order to to have the policy information create a new record on the policy screen in VAM dB, you must include a hidden field in your form with the type of policy. For example for life insurance you would add the following: Three other hidden fields can be passed the form: referrer_id, lead_type_id, agent_id The values for these fields must be the ID number associated with a record in your VAM dB account. Administrators can get the ID numbers for these from the Settings page. On the edit page for each of these options the ID number will be displayed at the top of the page.

4. Add a hidden field to create a note of all other fields captured in the form. This can also include the fields to create a note of all data entered. This field format can also be emailed alerting you of a new lead in your account. To set the email address(es) for the web form to send to click the Account link in VAM dB and the Database Settings tab. You must have administrator permissions to enter the email address. This can also be used to capture fields in your form that do not have a matching field in VAM dB. For example:

First Name: [first_name] Last Name: [last_name] Phone: [home_phone] Email: [email] Do you currently have health insurance? [Have_Health_Ins] Current Company: [Current_Company]

Full Example of the form with the above fields as it would be on your website:

First Name: [first_name] Last Name: [last_name] Phone: [home_phone] Email: [email] Do you currently have health insurance? [Have_Health_Ins] Current Company: [Current_Company]

First Name:

Last Name:

Home Phone:

Email:

Do you currently have health insurance??

Current Company:

Below are links to other sample forms that you can copy and paste for immediate use on your website. 1. Simple contact form. View 2. Short form for life insurance quote request View 4. Long form form for life insurance quote request View

I need to make sure the following forms are posting to my database but these 3 forms, specifically:

I have no idea how to do this. Attached is the code what I think you might be looking for. I have this code located at http://www.florida-fr-44-insurance.com/cheap-florida-fr44-sr22-rates/

I’ve tried a few times to put some php code in the webhooks area. I am not going to lie and say that I have any idea what I am doing here. For someone who knows what they are doing and how the website works in and out, it is probably fairly simple. I can connect you with my Database guy if you need to know specifics of what needs to go where if you can’t get what you need from the attachment I provided in this email

Unfortunately the webpage your referenced does not let us know the code you are using for your webhooks or the code being used to POST the data to your DB. As my colleague stated, if you could provide us with the PHP code you are using to POST the data, we can probably help you figure out why it is not POSTing. If we can see the actual script used, we should be able to help you adjust it to make it work. We may have more specific questions about your DB setup after we see the script though, so you may want to have your IT person send a message too.

Answered by
sludwig1129
on September 24, 2014 at 09:21 AM

The guy’s name is Michael. He has been very helpful and can assist in getting you exactly what you need. His info is below:

If you could have your database admin post the information here that would be optimal. Since this is the best place and this thread already has the basis for the conversation I believe that would be the best start. Once we have the script used to POST the information the DB we should be able to see where the issue is occurring.

Answered by
sludwig1129
on September 24, 2014 at 11:01 AM

Michael, can you provide a response for this one? Just hit reply to all.