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

  • mark_us Profile Picture
    97 on at
    RE: Editable Grid locked fields should be editable on forms

    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

  • Verified answer
    LuHao Profile Picture
    40,884 on at
    RE: Editable Grid locked fields should be editable on forms

    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/

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,157 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,930 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans