Can formRanger be used to limit number of users who select a particular cell in multiple choice grid?
111 views
Skip to first unread message
Anil Kaul
Jul 20, 2021, 11:40:08 AM7/20/21
to NV Form Ranger Add-on
Hi
I am trying to create a signup sheet where I list my class timings in columns and ask students to sign up for classes on different days. I want to impose restrictions on class sizes (10 students in each class). I created this signup sheet using the multiple choice grid.
I can prevent a student from signing up for multiple sessions on the same date. But what I want to do is see if I can only have atmost 10 people sign for any given time slot for a particular date. I was wondering if FormRanger will allow me to do that?
Any thoughts on how I could make that happen?
The form I created:
thx
-Anil.
Joseph Schmidt
Jul 21, 2021, 10:29:51 AM7/21/21
to nv-form-ra...@googlegroups.com
I believe the only way you can do that is to restructure the form. If the student must only sign up for one class then you would want it to be one question with all possible days and time combinations. If the student must attend daily but can choose the time, then I think you will need a question for each day.
July 1st 3
July 1st 4
July 1st 5
July 2nd 3
July 2nd 4
July 2nd 5
--
You received this message because you are subscribed to the Google Groups "NV Form Ranger Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-ranger-a...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/beecaa24-0f9b-4bcc-a98e-bc63a25d2733n%40googlegroups.com.
Carmen Adderley
Jul 29, 2021, 1:08:07 PM7/29/21
to NV Form Ranger Add-on
Hello Joe,
I hope you can help me with a small issue I am having. I sent up a volunteers registration form, the names on the responses are my 'range' for another volunteers service hours form.
the service hours form range has the "Name" question set us as checkboxes, however, I am finding that while the users scroll the list, they are check marking several names besides their own. This causes the response to have several names on the Name Column and I do not know who to really allocate the serviced time (I do have a pivot table by name summing all serviced hours entered. I would like to limit answer to that question to 1 and I can't find the way to do so.
Thank you in advance for your help.
Regards
Carmen Adderley
Joseph Schmidt
Jul 30, 2021, 8:48:01 AM7/30/21
to nv-form-ra...@googlegroups.com
Why are you using checkbox instead of multiple choice or drop down list. Checkbox should only be used when you expect multiple answers.
If you still have a problem share the form with glua.joe at gmail.com.
The Safe Animal Shelter is a charitable 501(c)(3) tax-exempt organization under the Internal Revenue Code. A COPY OF THE OFFICIAL REGISTRATION AND FINANCIAL INFORMATION MAY BE OBTAINED FROM THE DIVISION OF CONSUMER SERVICES BY CALLING TOLL-FREE (800-435-7352) WITHIN THE STATE. REGISTRATION DOES NOT IMPLY ENDORSEMENT, APPROVAL OR RECOMMENDATION BY THE STATE. Our Florida registration number is 20-070012291-85c. Every contribution is tax deductible to the fullest extent of the law. 100% of the contribution goes directly to the care of the animals at Safe Animal Shelter. No outside solicitor is paid for any part of this contribution. We are a Florida registered corporation.
--
You received this message because you are subscribed to the Google Groups "NV Form Ranger Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-ranger-a...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/b5dccacd-ecde-4c64-b6a0-8f46fe36e9f4n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages