Skip to main content

How to make a List column read-only

Use the below code:

using (SPSite mySite = new SPSite("siteURL"))
{
    using (SPWeb myWeb = mySite.OpenWeb())
    {
        SPList myList = myWeb.Lists["ListName"];
        SPField myField = myList.Fields["ColName"];
        myField.ReadOnlyField = true;
        myField.Update();
    }
}

With this code, the column becomes read-only. This column does not appear while adding new item or editing existing item, and also in the list of columns in List settings. But, you can add this column to a view, so, user can see the data. Also, programmatically, you can add/update a value to this column (That means, it is set to read-only from SharePoint UI point of view)

One use of this approach is when you want to introduce auto-generated number column.
Labels:

Comments

  1. AnonymousJuly 8, 2022 at 9:39 AM

    Where should we insert this code

    ReplyDelete
  2. SureshJuly 11, 2022 at 8:27 PM

    This is a server side code, so it can be executed from an exe as a one-time activity.

    ReplyDelete
  3. AnonymousJuly 22, 2022 at 1:19 PM

    Where you insert this code, is it in power shell ISE??

    ReplyDelete
  4. SureshJuly 23, 2022 at 1:31 PM

    No. As I mentioned it is from an exe. Create an exe and refer sharepoint.dll. Then you can execute this exe to perform the action. This post is more than a decade old. As far as I remember this option was available only with server side code at that time. You may check if this can be achieved with client side code or power shell code. That will be easier than server side code. Which version of SharePoint you have? Is it on-prem or Online?

    ReplyDelete

Post a Comment

Popular posts from this blog

All about SharePoint List View Styles

Sometimes, there are out of the box features which we tend to ignore and later when we do apply, we are more than happy about the feature which is readily available in SharePoint. One such feature is List View Style. I never thought I would write a post on this. However, whenever I spoke about this with users, people were excited to see the result. That prompted me to write this post. Instead of getting into only theory part, I will basically take use cases where these styles can be applied and also touch up on on some minor limitations with certain style. When you are creating/modifying a List view, you will get an option to select View Style. As shown below, there are 8 options available and Default is always set if you ignore this style. List of View Styles I will take typical Contact List and Announcement List to explian about these styles. Let us go one by one. Default: This view, as name suggest, is the default style in a view. This is one of the widely seen style
1 comment
Read more

How to update Person field with multiple values using REST API

Person or Group field in SharePoint is similar to a Lookup field. When you are updating this field using REST API, you need to append "Id" to the name of the column in the body construct. For example, the body construct looks like this: data: { "__metadata": { "type": "SP.Data. ListName ListItem" }, "Title": "First Item", " PeopleField Id": "4" }; The highlighted portions should be replaced by the actual List Name and Column Name. In the above example, the REST call is updating a List item with Title and People columns. How to get the value for user ID ("4" in the above example) needs a separate explanation and that will be my next post! The above example works fine if Person field is configured to accept only one value. If we change the Person field to accept multiple values, how do we pass more than one value in the REST call? Since we normally separate user names with semicolon in peop
12 comments
Read more

How to get SharePoint List or Library GUID via REST

Sometimes, you would need List or Library GUID to use that in some operation. In such cases, how do you get hold of GUID using REST API? There is a straight-forward end point which you can use: /_api/web/lists/getByTitle('ListTitle')/Id This will return the GUID of a List or Library. There is also another approach. However this approach works only if a List or Library contains at least one item. /_api/web/lists/getByTitle('ListTitle')/items This is a familiar end point which we use to fetch items of a List or Library. To get the GUID from the response, you would do: var listIDTemp = response.data.d.results[0].__metadata.id; var listID = listIDTemp.substring(listIDTemp.lastIndexOf("guid") + 5).split('\'')[0]; As you can see, we are doing string operations to fetch GUID from metadata.id. This contains information only if the response has at least one item.
Post a Comment
Read more