-
sludwig1129Asked on September 21, 2014 at 4: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:
Mobilequote form
Adh auto quote form
-
Ashwin JotForm SupportReplied on September 21, 2014 at 11:00 PM
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!
-
sludwig1129Replied on September 22, 2014 at 10:31 AMI 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
... -
David JotForm SupportReplied on September 22, 2014 at 12:18 PM
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.
-
sludwig1129Replied on September 24, 2014 at 9:21 AMThe 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
... -
David JotForm SupportReplied on September 24, 2014 at 10:54 AM
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.
-
sludwig1129Replied on September 24, 2014 at 11:01 AMMichael, 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
...