Use XSLT to hide columns in SharePoint list forms

In this post i will explain how XSLT can be used to hide the list columns in forms for users with insufficient previleges.

After you open your site and the list in SharePoint designer, create custom forms for New, Edit and Display forms.

Open each of the forms and select the column which should be shown based on user permissions.


Expand the Conditional Formatting option on the ribbon and select Show Content.
In the next screen click on Advanced.
In the pop up that appears after that, search for the function called IfHasRights
This function will determine whether the current user has the rights specified and will do the formatting accordingly, based on the result.


The permission mask specified is determined as the sum of the permission masks for the permissions required. Below mentioned are the permission masks for the permissions.

ViewListItems - 1
AddListItems - 2
EditListItems - 4
DeleteListItems - 8
ApproveItems - 16
OpenItems - 32
ViewVersions - 64
DeleteVersions - 128
CancelCheckout - 256
PersonalViews - 512
ManageLists - 2048
ViewFormPages - 4096
Open - 65536
ViewPages - 131072
AddAndCustomizePages - 262144
ApplyThemeAndBorder - 524288
ApplyStyleSheets - 1048576
ViewUsageData - 2097152
CreateSSCSite - 4194314
ManageSubwebs - 8388608
CreateGroups - 16777216
ManagePermissions - 33554432
BrowseDirectories - 67108864
BrowseUserInfo - 134217728
AddDelPrivateWebParts - 268435456
UpdatePersonalWebParts - 536870912
ManageWeb - 1073741824
UseRemoteAPIs - 137438953472
ManageAlerts - 274877906944
CreateAlerts - 549755813888
EditMyUserInfo - 1099511627776
EnumeratePermissions - 4611686018427387904

Give appropriate mask as shown in the screenshot above and save the form.
The next time the users open the form, they will see the column only if they have enough permissions.
Ofcourse you have to do the same to the label(Deparment) beside the text box you selected previously


This is how the form will appear for users who do not have enough previleges.

Comments

  1. AvinashApril 3, 2013 at 1:35 PM

    Hi Naveed,

    Your blog is like encyclopedia of SharePoint. Great piece of work.
    I have a doubt, users of what kind of permissions will not see the Department column ?

    Thanks,

    Avinah Reddy

    ReplyDelete
  2. Naveed MohammadApril 4, 2013 at 10:15 AM

    Thanks for that comment :).
    In the example shown(screenshot) the permission mask used is 2048 which is for Manage Lists. So the users who have these permissions will be able to view it. It will be hidden for all the other users who do not have this permission.

    ReplyDelete
  3. Dr.AbuBenAdamJuly 26, 2013 at 11:42 AM

    You can use SPServices and jQuery to Hide SharePoint List Columns based on User Permissions:

    http://www.sharepointdiary.com/2013/07/hide-sharepoint-list-columns-based-on-user-permissions.html#ixzz2aB7h7a4o

    ReplyDelete

Post a Comment

Popular posts from this blog

Create web part pages with custom layouts in SharePoint 2010

Image
SharePoint provides web part pages with eight layouts by default. Unfortunately the process of creating web part pages with custom layouts is a little complex. In this post i will show you how you can create web part pages with custom layouts. I have created a component which will deploy an application page which can be used to achieve this. Go to http://archive.msdn.microsoft.com/customspcf  and download the wsp file with the name CustomSPCF.wsp Deploy the solution. This will deploy an application page at /_layouts/customspcf/customspcf.aspx It will add four web part page layouts at 14\Template\1033\Sts\Doctemp\Smartpgs\CustomSPCF\ and four images corresponding to the layout at 14\Template\Images\CustomSPCF\ The below image shows how the application page will look like You can customize the application page and replace the deployed custom layouts or add new layouts. Follow the below steps to replace the exisitng layouts. 1. Go to the applciation page at 14\Templates\L
Read more

Create a Custom Timer Job in SharePoint 2010

Image
I had to create a custom timer job in SharePoint 2010 recently, but could not find a blog which explained the complete procedure to do this. So I decided to write one. In this post I will give a step by step process to create a Custom timer job in SharePoint 2010 using Visual Studio 2010. Timer jobs are created by extending the SPJobDefinition class and deployed as features. So we will create a class which extends the SPJobDefinition class. Then we will create a feature and we will handle the featureActivated() event of that feature. In that we will instantiate the class created. Let us see how to do all this. Create an empty SharePoint project in VS 2010. Give the Site Collection URL where you want this feature will be activated. Create a class in the project.   Add these namespaces using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; class MyTimerJob : SPJobDefinition { public MyTimerJob() : base () { } public MyTimerJob( SPWebApplic
Read more

SharePoint list forms display HTML instead of rendering

Image
I have recently come across a problem where a custom list form i created using SharePoint designer was displaying the HTML directly instead of rendering it. As shown above the HTML for the Assigned To column value is not being rendered. To overcome this you just have to add a simple property to you XSLT. Select the HTML that is displayed and go to the code view. You will see the statement as <xsl:value-of select="@Assigned TO"></xsl:value-of> To this you have to add a parameter called display-output-escaping <xsl:value-of select="@Assigned TO" display-output-escaping="yes"></xsl:value-of> As you can see, this time the HTML is rendered properly.
Read more