We using a Sharepoint 2010 and I need to make a list where people will be able to apply for event. Event is for max 30 people, and I want to disable "Add new item" if list already have 30 attendees. I have next columns in my list:
- Applied ON
I also set a counters for columns (/List Settings/Views/All Items/Totals => set to Count) and I have an insight to current number of rows on the top of the page, but I want to be fully professional :)
I was try in Validation Settings with:
but, this is not a solution, cause people can change mind and delete them self from event, and ID increasing every time.
Does anybody know how can I use already set "Counter" from the top of the list columns. I would like to use it in Validation Settings as simple formula, similar as above mentioned with ID (maybe better question: Can it be used), or any other solution to complete this, on first view, simple task??
Thanks in advance.