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

    What's the best way to allow users to enter multiple records in form using their information?

    Asked by gwkijowski on October 27, 2012 at 01:07 PM

    Greetings!

    This form will be used to track requests in a facility room reservation system. Users can lease the space for any period from one hour a day to all day for one occasion. Or, up to any time period per day (2:00pm - 4:00pm) every day of the week/month/year at the same time of the day.

    Typical scenarios:

    User teachs a class every Monday evening from 7:30pm to 9:00 for eight consecutive weeks  (see screen shot).

    A year-long training program meets twice-a-month on Wednesday evenings from 6:00pm to 8:00pm and once-a-quarter on Saturday/Sunday.

     

    Instead of creating seperate pages (as per the current form) where the user selects the frequency of use such as:

    Page 1 - An event or use less than one day.

    Page 2 - A series of events taking place once/day for up to 3 days.

    Page 3 - A series of events taking place once/day for up to 30 days

    It would be great to have the user just enter, in one place, a one-time event/use or as many as necessary events/uses for a year-long training.

    Whatever method is used the date field needs to be a "date picker" and start/end time needs to come from list box that can be populated with times from 6:00am to 9:30pm in 15 minutes increments.

    Any help on this would be greatly appreciated!

    Page URL:
    http://form.jotform.us/form/23004568203141

    Screenshot
    date field
  • Profile Image
    JotForm Support

    Answered by fxr on October 27, 2012 at 02:58 PM

    Your description of what you are trying to is well detailed. Thanks, we do appreciate that. 

    Unfortuntely, I am still a little unsure of what it is exactly that you are trying to achieve.

    I have a feeling we may be able use JotForms conditional logic to attain functionality at least close to your hopes/expectations. It would be great if you could provide just a little more detail of how you hope the form would work. 

    "It would be great to have the user just enter, in one place, a one-time event/use or as many as necessary events/uses for a year-long training."

    This sentence seems perhaps the most important in describing what you are hoping to do, can you just elaborate on it a little for us? maybe provide an example scenario along with the description. 

  • Profile Image

    Answered by gwkijowski on October 27, 2012 at 03:41 PM

    Thank you for the quick response!

    Imagine a user wants to request a room for a two hour meeting. The form would provide ONE line so the user would enter their data in the form like:

         date          start time      end time

    10/272012       3:00pm        5:00pm    

     

    The second request is for a class which would be held from 7:00pm to 9:00pm every Wednesday for 4 weeks. So, the form would allow the user to keep entering records - in this case onto FOUR lines - to create the needed records for this request:

          date        start time      end time

    10/102012       7:00pm        9:00pm

    10/17/2012      7:00pm        9:00pm

    10/24/2012      7:00pm        9:00pm

    10/31/2012      7:00pm        9:00pm

     

    Because we don't know how many sessions may be required I don't believe using the matrix would be suitable unless the matrix contained 40-50 rows for every request. This is the maximum number of sessions we would expect to have for any request/series.

    Bascially, is there a way to have Jotform keep showing/adding lines as necessary to capture the appropriate number of records, whether it is 1, 4, 15 or 35 dates/times, to complete the request?

    I think in database language each "event" (the ONE) would be linked to another database which may contain one or multiple entries for the same "event" (the MANY). Hopefully, this makes better sense?

    Again, many thanks!

  • Profile Image
    JotForm Support

    Answered by jonathan on October 27, 2012 at 11:00 PM

    Hi, 

    This is quite difficult to pull-off using the form builder alone and possibly without manipulating the form's source code. But there is a possible and acceptable workaround (in theory) that we may come up. 

    Please alow as some time to test the concept. I or my colleague fxr, will update you once we have some idea to offer.

    Thanks.

  • Profile Image

    Answered by bfsjotform on April 13, 2015 at 12:59 PM

    I am looking for something similar. I need to have one user enter multiple repeating events without having to fill-out the form for each event. Each of these dates would show up in the spreadsheet as a separate event.

     

    Example: Gym Rental  

    date        start time      end time

    10/102012       7:00pm        9:00pm

    10/17/2012      7:00pm        9:00pm

    10/24/2012      7:00pm        9:00pm

    10/31/2012      7:00pm        9:00pm

     

    Thanks,

    Andy

  • Profile Image
    JotForm Support

    Answered by BDAVID on April 13, 2015 at 02:50 PM

    @bfsjotform, your question will be addressed here: http://www.jotform.com/answers/551606