Online application form which will populate spreadsheet

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


    Jim Campbell


    Never Forgotten Honor Flight, Inc.


    We are independent, but follow the policy guidelines of the Honor Flight Network (national).

  • Profile Image
    Answered on October 28, 2013 at 09:33 PM

    Hello Jim,

    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:

    You can then use this google spreadsheet to import data to your MS Access database.

    Another alternative:

    Please check our app:

    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.

    Thank you!