Forum Discussion
How do I make the ID column un-editable (again) in a Microsoft List?
There is an default ID column which comes with a List. As I understand, it auto-increments as the user adds a new row to the List.
I decided to make this column visible to show in the List. I did this so that this ID can be used as the primary key value that can be used when a user wants to modify or look up an item in the List.
But I found that when the user clicks to add a new item, the ID field appears for the user to add an ID. This is not good. Not only was I able to add an id that is way out of sequence, but I was able to create a record with an id that had already been assigned.
In an attempt to fix the problem, I set the ID to HIDDEN mode. But then, fir some reason, when I clicked to add a new item, the ID appeared for the user to enter an ID for that field.
wm-thompson I think you have renamed the "Title" column to "ID" previously (changing display name of the Title column from "modern" list view). See the Abc type against "ID" column in the list form - by default ID is an "Number" type column and it should not have that Abc icon which is generally used for text columns (like "Title").
I have added more details and explanation about this issue at: How do I make the ID column un-editable (again) in a Microsoft List?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
