Forum Discussion
Solved
How can I limit the number of items that can be entered into a list?
I want to limit the number of items that can be entered into a list. Anyone have any suggestions on how to achieve that? Thx in advance for any help.
- 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
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!
