![]() The same thing can apply if you want to hide a field obviously you can restrict the view for users and just make sure the list settings do not allow users to modify or create new views (and make sure you or the list administrator DOES have a view that shows you everything). But at long as they are locked down to a view or views that hides the original field and only shows the read-only version, you should be good to go! You will need to make sure to update the SharePoint list permissions so that users cannot create or modify views. Make this view the default, and when other people access this view, they ONLY will see the read only column.Ħ. Next, create a view that ONLY shows the "Employee Name - Read Only" column. Now when you see the list, you will see two employee name columns one can be edited, and the other is "read only" (and is just referencing the other employee name column).ĥ. ![]() When setting up the column, tell it to use a formula. For the "read only" column, create a duplicate column called "Employee Name - Read Only".ģ. ![]() To show the hidden columns, highlight the area where the. This makes it easier for you to see that columns are hiding. You’ll notice that the columns are missing. As you can see, the columns collapse and at the top panel. Right-click over the selected items and select Hide. Assume that "Employee Name" is a column that you want to lock down.Ģ. In your Excel spreadsheet, highlight the columns you want to hide. ![]() Let's say you have a list that can be edited by multiple people, but there is a master value on each item that should be locked down. I have a fairly simple workaround to apply "read only" to columns that requires no coding. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |