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

    Advanced form using Google Docs

    Asked by rupertg 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

    3rdJanuaryWednesday2013 

     

    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.

    Submissions JotForm excel heading
  • Profile Image

    Answered by bumgore on May 07, 2013 at 03:13 AM

    Hello,

    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.

    http://www.wikihow.com/Sort-by-Multiple-Columns-in-Google-Spreadsheets

    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.