Skip to main content

Notifications

Dynamics 365 general forum
Answered

Editable Grid (Limited amount of users)

Posted on by 55

Dear Dynamics Community,

I hope everybody is holding up good in these times.

I am experieincing a difficulty as I would like to enable the editable grid on one of our entities.

However, not all users should have access to the editable grid.

For example: Invoicing

1. Our Invoice Manager should have access to a editbale grid

2. Our general user should have this as a read only view (however, when opening the record they can modify)

Therefore my question is: Is it possible to enable editable grid for only a user based on its security role.

Or can we only enable the editable grid for a view and not for the other.

Thank you in advance for taking the time.

Kind regards,

  • Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: Editable Grid (Limited amount of users)

    You are welcome :)

  • --Dynamics365-- Profile Picture
    --Dynamics365-- 55 on at
    RE: Editable Grid (Limited amount of users)

    Hi Wahaj,

    Thank you so much for the given support.

    All is working as expected.

    Many thanks

  • Verified answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: Editable Grid (Limited amount of users)

    Hi,

    When you add a subgrid on the form, you can add editable control (to make it editable):

    pastedimage1613511286884v1.png

    As shown in the above image, Click on the controls tab (subgrid), click on Add Control and choose Editable Grid, finally enable it on the Web.

    If you do not add this control the subgrid will act like a normal grid.

    You can read about it here:

    https://powerobjects.com/news-updates/dynamics-365-new-feature-editable-grids/

  • --Dynamics365-- Profile Picture
    --Dynamics365-- 55 on at
    RE: Editable Grid (Limited amount of users)

    Hi  Rashid,

    Thank you so much for your rapid reply. I appreciate it.

    My preference would go to the the second option with two grids.

    However, how would I create a view that is is read only and how do I create a view that is editable.

    As I thought it was entity related.

    Kind regards,

  • Verified answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: Editable Grid (Limited amount of users)

    Hi,

    Thank you for your query.

    There is not out-of-the-box feature that controls editable grid based on a role.

    You can do this using following approaches:

    • Create separate forms form  Manager and General Users. Add editable grid on the Manager form and normal on the General form., Assign appropriate security roles on the form. Only problem here is that you have to manage two separate forms.
    •  Use JavaScript (onLoad) to lock the grid controls based on current user's security roles:

    https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/236280/how-to-make-dynamics-365-editable-grid-read-only-on-a-field-change/690742

    Or you can also add two grids (one normal other editable in different sections, and hide/show these sections based on user role).

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans