- snit99Asked 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?
- JotForm SupportChriistianAnswered on August 07, 2015 at 01:48 AM
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:
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.
- snit99Answered 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?
- JotForm SupportdavidAnswered on March 04, 2016 at 03:18 PM
You can automatically send your submission data to a Google Docs spreadsheet:
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.