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

    JotForm Data to MS Access

    Asked by snit99 on August 06, 2015 at 06:08 PM

    I have read the posts in regard to this issue.  Is there a way to have the data go automatically to MS Access?

     

    http://form.jotform.us/form/52151242264142

    JotForm ms access in a
  • Profile Image
    JotForm Support

    Answered by Chriistian on August 07, 2015 at 01:48 AM

    Hi,

     

    This is possible using the Send Post Data feature or using Webhooks integration. You will need a basic understanding on PHP for this to work. For more information regarding Send Post Data feature and Webhooks, you can check the following articles:

    1. Send Instant Submission Notifications with Webhooks

    2. How to Post Submission Data to Thank You Page

    3. Send POST Data From JotForm Using PHP in Custom Thank You Page

    4. How to send Submissions to Your MySQL Database Using PHP

    5. Webhook Samples

     

    The process would be just like in #4 link but instead of inserting it to MySQL Database you will insert it to MS Access database.

     

    Hope this helps. Do let us know if you need further assistance.

     

    Regards.

  • Profile Image

    Answered by snit99 on March 04, 2016 at 12:41 PM

    We use Access.  I know we can copy and past from the spreadsheet to Access.  But I would like the data from our JotForm to go to a spreadsheet (excel or google drive) and have the output look like the link below.  When a member fills in the form and picks an activity, the spreadsheet will show "True".  And when a member does not pick the activity, the spreadsheet will show "False".

    Also, can the spreadsheet show the form of payment...check, PayPal, Cash?

    https://www.dropbox.com/home?preview=Sample+MIWC+Membership8-4-15-3.xlsx

  • Profile Image
    JotForm Support

    Answered by david on March 04, 2016 at 03:18 PM

    You can automatically send your submission data to a Google Docs spreadsheet:

    http://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

    However, it is not possible to send the data automatically to an Excel spreadsheet.  The output format cannot be edited and any information that needs to be included would need to be included as options in the form.  If you need to know the form of payment, you would need to have the option in your form to select the form of payment.