How to limit a SharePoint list to one row, with no-code

How to limit a SharePoint list to one row, with no-code

Have you ever wanted to use the functionality of a SharePoint list, but limit the list to only one row?

Did you go into Item Limit in the view, only to realize that you are limiting the number of items to be viewable, not actually limiting the number of items in the list?

I have, and I have come up with a very simple, OOB, no-code solution: Add a column, that is Required, Enforces Unique Values, and give it a Default Value. That’s it!

However, to make it more robust and transparent, you will need to:

1. Create a site column





2. Create a List Content Type





3. Add the Site Colum to the Content Type





4. Make the column Hidden

Let’s test it out. After adding my content type to a new custom list, I created one record: “Item 23665.” I can see it in the list. Now, I will attempt to add a second list item: “Item 27788”:

After pressing Save nothing happens (the window stays open – you will have to write some code to force it to close). The user must press Cancel to get out of this modal, and the record will not be saved.

I hope you find this helpful.

- Kristin Cameron

SharePoint Designer Cannot Display the Item

SharePoint Designer Cannot Display the Item

In Office 365, after successfully accessing the SharePoint site via the URL in the browser, and after successfully opening the site in SharePoint Designer 2010 or SharePoint 2013, I continuously received the following error when accessing workflows (to view or edit).

There is a very simple solution to this problem:

1. Close SharePoint Designer 2013
2. On the local computer, browse to the following folder:
C:\Users\\AppData\Local\Microsoft\WebsiteCache
3. Delete all the folders that are present.
4. On the local computer, browse to the following folder:
C:\Users\\AppData\Roaming\Microsoft\SharePoint Designer\ProxyAssemblyCache
5. Delete all the folders that are present.
6. Open SharePoint Designer 2013 and make the changes to your site as needed.

The TechNet article can be found here.
- Kristin Cameron