i have created the following column, which represents an auto generated item number site column:-
#Assumes that you are creating the site column in the top-level site of a site collection #Script can also be used to create a site column in the Content Type Hub #Get site and web object $site = Get-SPSite -Identity "http://sharepointdev:26611/sites/wiki123" $web = $site.RootWeb #Assign fieldXML variable with XML string for site column $fieldXML = '<Field Type="Text" Name="TestDate12" Description="This is a test date column2." DisplayName="Item Num2ber" StaticName="TestDate12" Group="Custom Columns" Hidden="FALSE" Required="FALSE" Sealed="FALSE" ShowInDisplayForm="TRUE" ShowInEditForm="FALSE" ShowInListSettings="TRUE" ShowInNewForm="FALSE"> </Field>' #Output XML to console write-host $fieldXML #Create site column from XML string $web.Fields.AddFieldAsXml($fieldXML) #Dispose of Web and Site objects $web.Dispose() $site.Dispose()
now since it is an auto generated number so i hide it from the Create & Edit forms, so users can not modify its value, while it is visible in the display form. but now users are able to modify its values from the quick edit grid. so is there a property similar to ShowInEditForm that disable a column from the quick edit grid ?