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.


  • Profile Image

    Online application form which will populate spreadsheet

    Asked 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).

     

    Jim Campbell

    Co-Founder

    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:
    neverforgottenhonorflight.org

    Reports www network
  • Profile Image
    JotForm Support

    Answered by ashwin_d 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:  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.

    Another alternative:

    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.

    Thank you!