Forum Discussion
How can I limit the number of items that can be entered into a list?
- You may be better off listing all sessions in one list with spots available
user registrations using a forms which go into another list, this form has a lookup to the sessions list with a filter to only show sessions with spots > 0. And a workflow on each registration to take a spot available from a session each time a person registers.
This would need to be an enhancement to out of the box forms using javascript, powerapps or another 3rd party forms product
As the earlier replies suggest, will those items need to be unique, or is it just a sequential list that needs to stop at certain point?
We're having an annual "Summercourse" with various breakout sessions. Our employees can sign up for three breakout sessions of they're choise. Each breakout session has a limited number of seats available.
I've made a list for every breakout session, where people can put they're name up (O365 accountname), and would like to limit the number of entry's possible to the maximum number of seats available for that session.
Two possible approaches:
(1) Create a master list that will take registrations and a workflow that copies item into each breakout session list, or(2) Create separate breakout sessions and have a workflow that starts automatically to check whether you've reached the maximum number of seats.
In both cases, you may have to include a hidden/restricted list that keeps track of the count. It will be more complex if you have to factor allowing 1st, 2nd or 3rd choice. I hope that helps.Can we apply JavaScript onto that list?If so ,this will be more easy Ma'am.
http://lazysharepoint.wordpress.com
I've also wanted to do something like this in order to create a list that users can use to sign up for a class or event with a limited number of seats.
Would be great to be able to set the limit to, let's say 20 items, users trying to add more items should get a message saying this specific list is full. (custom message would be even more lovely)
This is so needed when your not a Sharepoint wizzard and just a teacher in a school! Edvard Wikström
Had a similar need today, and it turns out the solve is relatively simple. Just use the COUNT function in the validation formula against any of the fields available. I happened to have used the system Created (by) field but really, any should work! Enjoy!
- That is exactly what we want to use it for.
