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

    Wish To Create Golf Tee Booking Form

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

    Page URL:
    nowebpageyet

  • Profile Image
    JotForm Support

    Answered by NeilVicente 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

    Answered by guest_23203842537046 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

    Answered by kierang7 on November 17, 2012 at 04:53 AM

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

  • Profile Image
    JotForm Support

    Answered by abajan 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

    Answered by kierang7 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
    JotForm Support

    Answered by abajan 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.