- rupertgAsked 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.
- bumgoreAnswered 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.