how limit the items in a custom list

Hi,

I want to use a custom list as as a form for reservation. I wan't to limit the number of items in this list. Is it possible?

Thanks.
ProvostAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jessc7Commented:
What do you want the end-user experience to be?
0
typerracerCommented:
You could write a custom event receiver in .NET that checks the number of items in a list whenever a new item request is made and check the number of items in the list against your preset allowed number of items.
0
ProvostAuthor Commented:
Thanks for your time,

But I don't have access to development server.  I only have access to SharePoint Designer as site collection admin.  
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

jessc7Commented:
You could have a workflow that queries the list to see how many items there are, and delete any once the limit is reached.

Not a good user experience though.
0
TEEDACommented:
This is a wonky workaround, but like you, I only have access to SPD so I have to be creative.

I would create a list column that increments with each registration. Then I would create a custom NewForm.aspx (make a copy of the default NewForm.aspx, do not edit it!) and add a text area that tells the user that the class is full.  I would use conditional formatting to hide that text area until the max number of registrants is reached, and set all the other columns in the newForm to display only when the number of registrants is less than the limit.  Then I'd set the custom NewForm as the Supporting File for that list. I've used this trick many times and it's been a lifesaver.
0
ProvostAuthor Commented:
Hello,

I want to my users to make reservation for an activity thru a form like
Name:
Email:
Etc...
This form will be the NewForm.aspx when you create a new item of in a list. I want to have a maximum 20 persons by activity.
I don't have access to development server.  I only have access to SharePoint Designer as site collection admin.  
0
TEEDACommented:
You should be able to do all of the above in SharePoint Designer. If you're not sure how to create a custom NewForm, try this:
http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?List=676af157%2D7d96%2D4e15%2Da987%2D54b8a3e4d948&ID=73

Good luck!
0
TEEDACommented:
I should mention that in the above post, you only need to do Steps 1 and 2, then set the conditional formatting on the Custom List Form fields you insert.   When you're done, set the custom NewForm as the supporting file for the list (in SharePoint Designer).
0
ProvostAuthor Commented:
Thanks Teeda,

I read, then blog you mention above, very interesting. I've never done that, so there will be some learning. But I understand most of it. The only thing I wonder about is how to increment my counter. From then article I understand I can retrieve its value. But where do you put the logic to add + 1?  With some JavaScript?

Tanks
0
TEEDACommented:
I think I would use a workflow that increments a "count" column when new item is created. I imagine there are lots of ways to do it, and if you can write javascript, that sounds like a good solution.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ProvostAuthor Commented:
Thanks, I will try with a workflow.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.