What is JotForm?
JotForm is a free online 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.


  • Profile Image

    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:

    Auto quote form
    Mobilequote form
    Adh auto quote form
  • Profile Image
    JotForm Support

    Answered by ashwin_d 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!

  • Profile Image

    Answered by sludwig1129 on September 22, 2014 at 10:31 AM
    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


    ...
  • Profile Image
    JotForm Support

    Answered by david 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.

  • Profile Image

    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:

    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
    ...
  • Profile Image
    JotForm Support

    Answered by david 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.

  • Profile Image

    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.

    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


    ...