JotForm Data to MS Access

  • Profile Image
    snit99
    Asked 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

  • Profile Image
    Chriistian
    Answered 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
    snit99
    Answered 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
    david
    Answered 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.