web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Editable Grid locked fields should be editable on forms

(0) ShareShare
ReportReport
Posted on by 97

Hi there,

I am currently struggeling in resolving my requirements. Maybe someone can help out:

I have an entity where all fields should be editablle on the form. For that enitity I enabled the editable grid, because grouping is needed for the users. But: the should not be allowed to change any values on the editable grid view.

Therefor I created a business rule on entity scope, that locks the fields. This was successfull and the fields are now locked in the editable grid view, but as well (guess what) on the forms. I tried now to create a second business ule with scope all forms to unlock the fields on the form and activated it after the one with entity scope to have them executed in the right order.

I was expecting the fields on the editable grid still beeing locked because of the business rule with entity scope and those on the forms being unlocked because of the all forms sciope rule unlocking them. Instead all fields are again unlocked and the enitity scope rule is ignored.

Any other ideas despite using client side scripting (which would be the last option) or am I doing sth. wrong?

My personal last idea woud be to create the fields that I want to display in the grid view as a copy as calculated field and use them in the view and not on the form. 

Any one else having ideas or experiences in that direction?

Kind regards

Markus

I have the same question (0)
  • Verified answer
    LuHao Profile Picture
    40,892 on at

    Hi Markus,

    I recommend that you use Javascript to lock the columns in the editable grid without passing business rules. This can prevent the fields in the form from being affected.

    Of course, if we choose Javascript, then we have to add Javascript to all editable grids which contains this field.

    Please refer to this blog, and if you have any questions about this solution, feel free to keep asking.

    https://xrmdynamicscrm.wordpress.com/2020/07/05/dynamics-crm-365-disable-fields-in-editable-grid-view-using-javascript/

  • mark_us Profile Picture
    97 on at

    Hi Hao,

    thanks for verifying, what I already thought. We will go that way using client side scripting to lock the editable grid view columns.

    Best Regards

    Markus

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 33 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans