Forum Discussion
Avoid editing columns on edit mode on sharepoint list
Hi francescjp ,
for a dirty fix:
You could create a calculated column that just displays the team name.
Then hide the original team name in the edit-dialog with the conditional formula.
=if([$ID], 'true', 'false')
And finally remove the team name field from the view and add calculated column. That way you won't be able to edit the field in grid view.
But i think that you are mixing two processes into one here.
I personally would do this:
- Create two lists: One for requesting a team and one for requesting team membership.
- Then I would create a lookup in the membership list to the teams list.
- Change permissions on the lists so that users can only add new items and display items, but not edit items.
- Have your users create a new entry in the membership list every time they want to change somthing. Perhaps even make them enter a comment as a required field.
That makes it much easier to see which user requested which user's membership. And you see when that happened.
Best Regards,
Sven
- francescjpJan 08, 2023Brass Contributor
Hello Sven:
I like dirty way. The Team column is a lookup one. I am not able to use it in a calculated column?
You know if it's possible to use a lookup column in calculated column?
Thank you very much.
Francesc
- SvenSieverdingJan 09, 2023Bronze Contributor
francescjp
Mhmm..... You cannot use a lookup column in a calculated column, so this is no longer an option.
We needed the calculated column so that your users cannot easily edit the value in grid view.
So now you need to disable grid view capabilities.
You can do so by selecting- Gear
- -> List/Library Settings
- ->Advanced Settings
- ->Allow items in this document library to be edited using Quick Edit and the Details Pane?
-> No
Best Regards,
Sven- francescjpJan 09, 2023Brass Contributor
HelloSvenSieverding :
I have found the perfect solution for this case. Using Power Automate I can modify the permission of each item when it's created. I assign only view permissions. This article shows how to do it.
Thank you very much for your help.