Wish To Create Golf Tee Booking Form

  • Profile Image
    guest_23203842537046
    Asked 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

    Dropdown List

    09.00

    09.07

    09.14

    09.21

  • Profile Image
    NeilVicente
    Answered on November 16, 2012 at 09:56 AM

    Hi,

    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.

    For example:

    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!

  • Profile Image
    guest_23203842537046
    Answered 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

    08:15          
    08:22          
    08:30          
    08:37          
    08:45          
    08:52          
    09:00          
    09:07          
    09:15          
    09:22          
    09:30          
    09:37          
    09:45          
    09:52          
    10:00

    until 17:00

  • Profile Image
    kierang7
    Answered on November 17, 2012 at 04:53 AM

    Has anyone in support got time to have a look at this please

  • Profile Image
    abajan
    Answered on November 17, 2012 at 05:29 AM

    @kierang7

    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.

  • Profile Image
    kierang7
    Answered 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

  • Profile Image
    abajan
    Answered 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

    09:00
    09:07
    09:15
    09:22
    09:30
    09:37
    09:45
    09:52

    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.