Wednesday, November 5, 2014

How to Rename ID Column in SharePoint

Requirement: Rename ID field in a SharePoint list! We had a list with ID column added to the view to provide unique auto number feature. User wants to rename ID field to "Change Request Number" as it sounds more appropriate.
sharepoint rename id column
Solution: Hidden columns such as "ID", "Workflow Status" are not providing Edit features directly from SharePoint web UI and they don't even appear on SharePoint list settings page.

So, use this simple trick to rename any hidden column such as ID:

  • Go to List settings page 
  • Pick any column such as "Title". You'll get Edit Column page. 
  • In the URL, Change the Field parameter from "Title" to "ID" and Hit Enter. E.g.
    http://demo.crescent.com/_layouts/15/FldEdit.aspx?List=%7BB9BED485%2D889D%2D49D9%2DBDC1%2DD78EB4E06EB9%7D&Field=Title
    To
    http://demo.crescent.com/_layouts/15/FldEdit.aspx?List=%7BB9BED485%2D889D%2D49D9%2DBDC1%2DD78EB4E06EB9%7D&Field=IDsharepoint rename id field
  • Now you can rename the field as you wish!
Here is my renamed ID column:

You can also rename a field programmatically with PowerShell or C# Object model code. Here is my another article: How to Rename SharePoint Column Programmatically



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

4 comments :

  1. Excelente! Gracias!!!

    ReplyDelete
  2. Exactly what I needed! Thanks!

    ReplyDelete
  3. good, there is one more way to do this one...

    Create new coloumn based on calculated coloumn

    In Formula field you need to type the below forluma to get the right Unique ID with new form name
    TEXT = Any name u want to give it to the ID column with string. eg - ABC1, ABC2, ABC3....

    ="TEXT"&[ID]

    This works perfectly, only challenge here is first time it will work second time onwards it will not work untill we open edit this coloumn and save it..

    it will updat for all the fileds... its easy solution any way..

    Md Rafi

    ReplyDelete

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...