Having issues posting submission data to my DB using Webhooks.

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:

Auto quote form

Mobilequote form

Adh auto quote form

Hello sludwig1129,

I did check your JotForm and found that you have added the following URL in the webhook integration:  https://www1.mscc2.com/VAMdB/Ludwig.php 

I am not sure but is this a webhook URL? Please share the code you have written in this PHP page and we will take a look. You can upload the code here: pastebin.com 

It seems you already have a URL which reads the form data and saves it in your DB:  https://www1.mscc2.com/VAMdB/webform.php You can directly post your form to this page and that should also work for your requirement. The following guide should help you :  http://www.jotform.com/help/213-Send-POST-Data-From-JotForm-Using-PHP-in-Custom-Thank-You-Page 

Hope this helps.

Do get back to us if you have any questions.

Thank you!

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

Thanks,

Steve


Stephen T. Ludwig - President / CEO
Select Insurance Group
1605 Bryan Road.
OFallon, MO 63368
636-410-6219 xt 101 | Office
636-266-0207 | Office Direct
636-552-0043 | Fax
1-855-GET-SELECT | Toll Free
www.selectinsuranceteam.com | Web

Twitter Facebook LinkedIn RSS Feed


...

Hi,

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.

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:

Thank you
Michael Steinhardt
VAM dB / MSCC Corp.
http://www.vamdb.com
(888) VAM-dB42
(888) 826-3242
sales@vamdb.com


thanks,
steve





Stephen T. Ludwig - President / CEO
Select Insurance Group
1605 Bryan Road
OFallon, MO 63368

636-410-6219 xt: 101 | Office
636-266-0207 | Direct
636-552-0043 | Fax
1-855-GET-SELECT | Toll Free
www.selectsr22insurance.com | Web

Stephen T. Ludwig (Principal) NPN License # 7028911
Select Insurance Group NPN License # 10381264
...

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.

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

Stephen T. Ludwig - President / CEO
Select Insurance Group
1605 Bryan Road.
OFallon, MO 63368
636-410-6219 xt 101 | Office
636-266-0207 | Office Direct
636-552-0043 | Fax
1-855-GET-SELECT | Toll Free
www.selectinsuranceteam.com | Web

Twitter Facebook LinkedIn RSS Feed


...