About me
Certiffications
CHUVASH.eu
CHunky Universe of Vigourous Astonishing SHarepoint :)
Disabling a column in Quick Edit
Posted by on 2014-11-28
In my project I have a column called Request Status. This column is not shown in any forms, meaning users should not edit, because it is controlled through the app. Nevertheless it is editable in the Quick Edit.
Yesterday I wrote about jsgrid in my blog. Now comes more. Today I’ll share a little practical solution how one can disable editing a field in Quick Edit.
The field is edited in jsgrid, but to disable it, we only have set the property called AllowGridEditing to false on our column (not even touching the heavy jsgrid api). We can do in the OnPreRender event in our Client Side Rendering (CSR) registration. Having the context object we have access to the Fields (ContextInfo.ListSchema.Field):
(function () {
var overrideContext = {};
overrideContext.Templates = overrideContext.Templates || {};
overrideContext.Templates.OnPreRender = function(ctx) {
var statusField = ctx.ListSchema.Field.filter(function(f) {
return f.Name === 'Request_x0020_Status';
});
if (statusField) {
statusField[0].AllowGridEditing = false;
}
}
SPClientTemplates.TemplateManager.RegisterTemplateOverrides(overrideContext);
})();
Another way is to implement the display form:
(function () {
var view = function (ctx, field) {
if (ctx.inGridMode) {
field.AllowGridEditing = false;
}
return window.RenderFieldValueDefault(ctx);
};
var overrideContext = {};
overrideContext.Templates = overrideContext.Templates || {};
overrideContext.Templates.Fields = {
'Request_x0020_Status': {
'View': view
}
};
SPClientTemplates.TemplateManager.RegisterTemplateOverrides(overrideContext);
})();
Hi!
Thanks for sharing this script, very usefull.
My question is, how can I set the DefaultValue in the DataGrid with same field where I set AllowGridEtditing to false?
Thanks,
Niki
You can try this:
But in some cases it doesn’t work. Then you need to return the field value:
Hi, Thanks for nice stuff , I want to enable editing for new item for existing item i want to disable editing your code disabled fully.plz help
Hi, you can create different functions for new and edit. In the edit you can disable editing in Quick Edit.
Pingback: Disable a site collection column inside lists's quick edit grid | Question and Answer
how can i set AllowGridEditing to false for multiple columns ?
Hi, you have to “find” all columns that matter and set AllowGridEditing to false.Use HTML5 javascript functions filter and forEach.
Hi, can you please help me to set “AllowGridEditing” to false for multiple columns? I tried repeating the code for “Request Status”, but it doesn’t seem to work.
Please help me with multiple column disabling with jslink in quick edit
Hi
Thanks for the help ful post, I am trying to sort values in multi choice field in quick edit, can you please help, I tried to write function to sort but it doesn’t apply to values in the columns
Is this script inserted in a CEWP above the quick edit web part or is it inserted somewhere else into existing code using SharePoint Designer? Or other method. Thanks for your help.
Pingback: SharePoint 2013 – Disable multiple columns in Quick Edit | Why Didn't I Think of That?
An update for multiple columns, hope this helps others : https://wditot.wordpress.com/2016/02/02/sharepoint-2013-disable-multiple-columns-in-quick-edit/
Great! Thanks for sharing! Now your blog post will be linked. I read your blog. Good stuff. Keep posting!
Hi, thanx for this. But it didn´t quite work for me. This is what I loaded as a text file into the documents library (library has check out required). I assigned rights for that file just for me (the list views were created by others as public views but I have site collection admin rights on that SP site and placed the URL into CEWP in that view and clicked stop Editing. So here is the code I used
var updateViewerFields=[“Actual Completion Date”,”Date of Update”,
“Start Date”];
(function updateView() {
var overrideContext = {};
overrideContext.Templates = overrideContext.Templates || {};
overrideContext.Templates.OnPreRender = function(ctx) {
for(j=0; j<ctx.ListSchema.Field.length; j++)
{
var f = ctx.ListSchema.Field[j];
for(i=0;i<updateViewerFields.length;i++){
if(f.DisplayName == updateViewerFields[i]){
f.AllowGridEditing=false;
}
}
}
}
SPClientTemplates.TemplateManager.RegisterTemplateOverrides(overrideContext);
})();
but the columns are still editable.
Any thoughts please?
Many thanx again
You have to overrride the “View” behaviour of the fields. f.AllowGridEditing outside “View” override will not affect the field.
Why not just use a calculated column? What I did was to create and set a calculated column to equal the value of the column I wanted to disable. Then I added the calculated column to the view of the Quick Edit. Calculated columns are not editable.
Dear Anatoly, do you know how I can disable bulk edit in datasheet/quick edit view?
Chris🤔
Thanks
Hi Anatoly
I am trying to implement a scenario in which I want to restrict the users to select the choice options present with choice field in Quick edit more. For eg.- choice contains month names – Jan, Feb, March, Apr etc.. I want them to have only month options which is next three months.
Any help is appreciated.
Hi Anatoly
I am trying to implement a scenario in which I want to restrict the users to select the choice options present with choice field in Quick edit more. For eg.- choice contains month names – Jan, Feb, March, Apr etc.. I want them to have only month options which is next three months.
Any help is appreciated.