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
Hello,
I'm not sure if there is a way to actually do what your asking but there is one idea that came to mind if you would like to give it a try.
I created a test list that has a Choice column that has some numbers or text. (I used numbers 1-3 for my choices.) Once that was set I made the column required and also set it to enforce unique values. This requires users to use the column and then only allows each choice to be used once in the list. Therefore if I have 3 choices there will only end up being 3 items in my list at any given time. (unless i delete them)
In a way I'm using the enforce unique values column setting to limit the data that is used in the list overall. Feel free to play around with this concept.