Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am looking for some help around customizing a list from SharePoint front end as I do not have access to a SharePoint developer.

We have a Nomination Form for Awards (custom list). The Awards forms are supposed to be submitted before 10th of every month. After which, the users should not be able to add new items in this list. I need help from you all on how do I get this done!

One way is to manually change access rights for everyone from Contribute to Read, but this is rather risky option - user groups painfully created for 5000 users may be get accidently deleted.

share|improve this question
1  
Do you create a new list for every month? –  Blue Murphy Aug 17 '12 at 14:37
add comment

1 Answer

up vote 1 down vote accepted

Add a validation for the list:

  1. Go to List -> List Settings -> Validation settings
  2. As formular enter =DAY(Created)<10
  3. As user message enter Entries must be added before the 10th
share|improve this answer
    
Thank you very much Per. this is a great solution and it works. :) –  hemalshah Aug 21 '12 at 18:53
    
Would you be able to tell me how to customize this now to allow dates from 27th till 10th of every month? Something like this would work? '=DAY(Created)>27<10' –  hemalshah Aug 21 '12 at 18:55
    
It should be something like =OR(DAY(Created)>27, DAY(Created)<10) see Calculated Field Formulas –  Per Jakobsen Aug 21 '12 at 18:58
    
Awesome! this one works! :) I tried changing the date to today's date and it allowed me to submit, but after changing it to 22, it does not. Thanks a Ton Per! :) :) –  hemalshah Aug 21 '12 at 19:24
    
Hi @Per, I am facing an issue after I have set up this validation. Items once created, the list is not allowing them to be edited, while giving out the same validation error message we have set up for the date validation. –  hemalshah Sep 4 '12 at 15:47
show 3 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.