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.
Online application form which will populate spreadsheetAsked by jameskcampbelljr 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 0n-line form of our Applications, 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/
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.