- jameskcampbelljrAsked on October 28, 2013 at 05:43 PM
I am one of 130+ Honor Flight Hubs taking our Honored Veterans on a free trip to Washington DC to see their memorials.
The most laborous and time consuming task is taking the handwritten applications from the Veterans, Volunteers and Guardians & keying them into a spreadsheet for a gazillion requirements in running our Not For Profit, volunteer organization.
i am looking of an online application form, that would be filled out by the veterans, guardians & volunteers, on-line, that would then automatically populate our flight workbook spreadsheet, which then populates an Access Data Base for all our reports & many printed outputs required. This would save our volunteers literally 100s of man/women hours for each flilght (4 flights a year).
Never Forgotten Honor Flight, Inc.
We are independent, but follow the policy guidelines of the Honor Flight Network (national). http://www.honorflight.org/Page URL:
- JotForm Supportashwin_dAnswered on October 28, 2013 at 09:33 PM
I am not sure how the submission records will be pushed to MS Access database but my suggestion would be that you build your form with all the fields you require. Once your form is complete, you can integrate your form with google spreadsheet. This will ensure that a copy of submission record is saved in your google spreadsheet. Here is a guide which should help you: http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet
You can then use this google spreadsheet to import data to your MS Access database.
Please check our app: http://sqlserver.jotform.io/
You can use this app to download the SQL file of your submissions and then run this SQL query in your MS access database editor.
Do get back to us if you have any questions.