How to limit the number of entries/records to a maximum in a List

Question

how to limit record of a list programmatically or configuration.

When the user insert record in the list if this list has exceeded the maximum numbers of record allowed, the form of insert have to show a message with a text as:

"Numbers of records has exceeded the permitted limit"

Answer 1

On 2013 CSR and the OnPreRender function is one, and maybe even the best way of skinning this cat.
You will have to read the whole list and then not display the Form but a message.

But you can do without CSR and make SharePoint do half the work for you.

A quick and easy ductape patch from the olden days is to hide the NewForm contents.

• On the NewForm.aspx page add a ListView WebPart, make it list all your items
  change the WebPart Layouts Properties Zone-Index to 1 to make it display below the NewForm

• Add another WebPart, use a Content Editor WebPart with the contents:

  <SCRIPT>

  SP.SOD.executeFunc('sp.js', null, function(){//execute after pageload
      var items = document.getElementsByClassName('ms-itmhover');//all displayed listitems
      if (items.length > 10) {//maximum number of items
          var form = document.getElementsByClassName('ms-formtable')[0];//new form
          while (form.tagName !== 'DIV') {//go up to the enclosing DIV
              form = form.parentNode;
          }
          form.innerHTML = '<h1>Numbers of records has exceeded the permitted limit: '+items.length+'</h1>';
      } else {//optional: hide the View with all the items
          var itemlist=items[0];//first item
          while (itemlist.tagName !== 'DIV') {//go up to enclosing DIV
              itemlist = itemlist.parentNode;
          }
          itemlist.style.display='none';
      }
  });
  

  </SCRIPT>

Tip: place the javascript in a separate file and link the Content Editor Web Part to it.. makes it easier to edit... you still have to include the < script> tag!!

Another alternative is:

Limit only one entry per day per user in sharepoint list

iJS

Answer 2

You can crate Before Event Handler to achive this. You can add business logic for checking the number of allowed records in the method itemAdding

Answer 3

You can do this with JavaScript as well. You can add business logic and return false if number of records is exceeded in your Presaveaction.