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
Thank you all very much for suggestions. You were most helpfull!
Warwick Ward, I tried you approach and it does the trick!
One master list with all sessions and places available.
One registrations list, with a lookup field to the masterlist, entry form shows only sessions that have places available.
When a registration is entered succesfuly a workflow kicks off and adjusts the number of available places in the masterlist.
Works just like it was meant to.
Thanks again!!
I use what I call the "clip board" technique. For each session I set the number of seats available using a seat number column. Then make a view with the edit button next to each available seat and remove the toolbar so no one "can" add additional seats. I've done it for years, never had a problem.