Sharepoint modern list set column as readonly in quick edit view

Question

Sharepoint modern list set column as readonly in quick edit view

Anonymous

Hello,

Can anyone tell me how to set some columns as read-only in the modern list Quick edit view ? I have tried to create calculated columns, but it doesn't support lookup and user fields.

Any help would be appreciated.

Thanks
Sheron

Accepted answer

1 additional answer

Your answer

Answer 1

Anonymous

Hi All, I have found a solution for this using calculated fields and JSON formatting. You can create a calculated field for the Lookup or People column you want to make as read-only, with formula reference to any single line of text field. And then apply JSON formatting to the calculated field to display the column value of the Lookup or People column. The JSON formatting will apply in the quick edit view. I have a lookup column "DU" which I want to be readonly, so I have created a calculated column hidden_DU with formula reference to the Title field. And applied the below JSON formatting to the hidden_DU field. JSON formatting: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "flex-wrap": "wrap", "display": "flex" }, "txtContent": "[$DU.lookupValue]" } ![94938-calculatedlookupfield.png][1] Hope it helps !! Thanks. [1]: /api/attachments/94938-calculatedlookupfield.png?platform=QnA

Jerry Xu-MSFT 7,961 Reputation points

2021-05-11T01:12:07.737+00:00

Hi, anonymous user ,

Thanks for your sharing and glad to hear you get a workaround for this. Please mark your reply as answer so other community members will be able to find your solution when they are in similar situation.
Carlos Delgado 1 Reputation point

2021-07-24T17:34:51.763+00:00

That solution does not work for Multiline text fields, any work around?

Answer 2

Jerry Xu-MSFT 7,961

Hi, anonymous user ,

In SharePoint Online, we do not have an out-of-box solution to make a certain list column to be read-only. The calculated column solution is a workaround. If that does not fit your requirements, PowerApps could be an option for you. With it you can do more customization on you list forms.

Anonymous

2021-05-06T05:09:59.007+00:00

Hi @Jerry Xu-MSFT ,

We are using spfx solution for the new and edit forms. But we need the quick edit for bulk update of list items. Could we make the columns read-only by spfx extensions? If I create a field customizer, will it reflect in the quick edit view?

Thanks for your support.

Regards,
Sheron
Jerry Xu-MSFT 7,961 Reputation points

2021-05-06T06:54:02.75+00:00

Hi,

Per my test, field customizer will not get reflect in quick edit view. Per my knowledge, set a field as read-only will also hide the column from editing view. Here is an example which seems to be helpful for you
Anonymous

2021-05-08T13:18:51.257+00:00

Hi @Jerry Xu-MSFT ,

I can not set the field as read only. As the fields need to be editable in some views and set to read only in a specific view based on the user role. I have found a workaround using JSON formatting.

Thanks for your support.

Regards,
Sheron
George Manos 1 Reputation point

2022-11-25T15:37:11.513+00:00

Hi,

Could you share the JSON format solution with us?

Thank you,
George

Share via

Sharepoint modern list set column as readonly in quick edit view

1 additional answer

Your answer