Driving school client mutli forms need to be organized when submitted

  • Profile Image
    Craig Boudria 
    Asked on October 09, 2015 at 04:30 PM

    Hi I have a client that I will be doing their website.  Its a driving school. So they have student sign up for course online. currently when a student signs up for a class. Just and email is sent and the school has to manually organize each email and place in the correct class.  Was wondering if possible to have whatever class the student choices.  Say November 15-December 20 night class would populate a spread sheet for that particular class.  So all the emails and contact would go directly into the different class spreadsheets.  There are a few more things. but just wanted to start with this.

     

    Thanks for your time

    Craig

  • Profile Image
    EltonCris
    Answered on October 09, 2015 at 08:04 PM

    Hello Craig,

    First, may I know which spreadsheet you are referring where these data are populated? Unfortunately, our spreadsheet or table report can't handle conditions so this can't be done on the form builder. Perhaps a third party integration would be able to achieve that but right now I have no clue which one gives ideal solution, maybe because I haven't completely understand the process at all. I am thinking of using the Google Spreadsheet, then manipulate/organize the data within the Google Spreadsheet on another sheet tab using formula or similar. Or by using Visual Report, you can filter the data grid report display depending on the question and answer. This might as well help when organizing the result.

    Example:

    If you also know programming, you should be able to achieve this by using the Jotform API or by sending the data over Webhook

    Let us know if you have further questions. Thanks!