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

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

  • Profile Image
    fxr
    Answered 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
    gwkijowski
    Answered 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
    jonathan
    Answered 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
    bfsjotform
    Answered 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
    BDAVID
    Answered on April 13, 2015 at 02:50 PM

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