- guest_23203842537046Asked on November 16, 2012 at 09:26 AM
How would I screate a table like this please?
I need a dropdown box showing all tee times between 09.00 and 17.00 . Each tee time would be 7 minutes after the previuos teetime. Here is the booking form I need:
Heading: Preferred Teetime
Select your preferred tee time
- JotForm SupportNeilVicenteAnswered on November 16, 2012 at 09:56 AM
JotForm does not have a built-in function that can generate such a list, but we can probably generate them manually (via scripting) if it's just a simple dropdown that you're looking to create.
Before we proceed, can you please confirm if that's exactly how the time slots should appear, i.e., 09.07 as opposed to 09:07? Furthermore, should the 7 minute difference carry over the next hour, i.e., 10.03 follows 09.56?
We'll await your prompt response. Thanks!
- guest_23203842537046Answered on November 16, 2012 at 10:05 AM
Thank you for your response.
This is the format for one particular club and some intervals are 7 minutes and others are 8 to enable 30 and 60 minute rounding.
If you can start it off so that I can input then times myself as I'm sure you are busy. Anyway I would like to be able to edit the times as other clubs will have different requirements. Thank you
- kierang7Answered on November 17, 2012 at 04:53 AM
Has anyone in support got time to have a look at this please
- JotForm SupportabajanAnswered on November 17, 2012 at 05:29 AM
If I understand what is required, it would really just be a matter of manually entering all of the time slots into the dropdown menu. Although it's true that a script to generate the times would simplify and expedite the task, we haven't been able to find or create any. However, I'll see how quickly I can provide the list for you to copy into the form's dropdown.
- kierang7Answered on November 17, 2012 at 05:34 AM
Thanks but have already created the list in excel and the form looks ok.
I used this formula in A2 =a1+Time(0,7,0) where a1 had 08:00
Thanks for your help
- JotForm SupportabajanAnswered on November 17, 2012 at 06:00 AM
Okay, no problem. It occurred to me also that an Excel formula would probably be the answer but as soon as I noticed the pattern (xx:00, xx:15, xx:22, xx:30, xx:37, xx:45, xx:52 ), I realized that rather than trying to figure out a formula it would probably be faster to just copy
into a text file, paste it back into the said file seven times and change the hours. I was actually about to post the list when I saw your reply.
Anyway, I'm glad you got it worked out.