Advanced form using Google Docs

  • Profile Image
    Asked on May 07, 2013 at 02:50 AM

    Hi Jotform Team,


    I will be creating an excel in Google Docs.

    This excel will have dates as heading eg below :


    1st January Monday 2013         2nd January Tuesday 2013            3rdJanuaryWednesday2013     etc


    Coming back to jotform.


    My jotform will have a dropdown option for clients to pick a date

    These dates will be identical to Google Docs(Excel) Heading 

    Eg: Clients will get to pick to these from dropdown option - 

    Please pick a date

    1st January Monday 2013

    2nd January Tuesday 2013



    Now if a client makes a booking on 1st January Monday 2013 using Jotform.

    Can the entry(i.e details of the clients) be placed under the heading 1st January Monday 2013 in google Docs. in one row. If there is another booking on 1st January Monday 2013 , it will then be placed in the next row


    This way, at the end of the day, all i have to today is check Google Docs for the number of bookings on a particiular date.


    At the moment, we are extracting excel report of submissions, then copying and pasting everytime a booking is coming. This is very tiresome.


    Please advise.

  • Profile Image
    Answered on May 07, 2013 at 03:13 AM


    There is no option in Jotform that will let you arrange the entries like that but once the data are in Google spreadsheet you can sort them out so that all entries will be arranged in the order of the date they are booked.

    For example if you have a dropdown menu for booking and have the dates as options, once the data are submitted to google spreadsheet a column will be created called "booking" and all booking dates will be in there, displayed in the rows. All you have to do is sort the entire table base on the booking column. You can do this by following instrucions found on the link below.

    Once they are sorted all data with the same booking date should be grouped in succeeding rows and will be easy to check. 

    Hope you find this helpful.