Skip to main content

Notifications

Announcements

No record found.

Service | Customer Service, Contact Center, Fie...
Suggested answer

Remove Optionset from a column in Editable subgrid

Posted on by 10

Hello , 
I have requirement to remove options from optionset on click of a record through JS . 
Example I have a column "Status" whose values are A , B  ,C , D .
On select of a record I would like to show only A & B in the editable grid.

  • Ray Profile Picture
    Ray 1,505 on at
    RE: Remove Optionset from a column in Editable subgrid

    Accoding to my research, this is not a doable requirement.

    There are fewer methods/events you can access in grid control, compare with formContext control. You can see detail with GridAttribute.

    Also here is my test result:

    "executionContext" is the gridContext. "new_source" is an optionset field but it does not have the removeOption() method.

    function onRowSelected(executionContext){
        debugger;
        executionContext.getFormContext().data.entity.attributes.forEach(attribute => {
            if(attribute.getName() == 'new_source'){
                attribute.controls.get(0).removeOption(100000001);
            }
        });
    }

    WeChat-Screenshot_5F00_20220808135358.png

    Also you can read more about Grid.

  • Ray Profile Picture
    Ray 1,505 on at
    RE: Remove Optionset from a column in Editable subgrid

    The gridContext is different with the formContext. If you are trying to access some control/attribute in grid, you should use gridContext rather than formContext.

  • Medidhi Profile Picture
    Medidhi 10 on at
    RE: Remove Optionset from a column in Editable subgrid

    Thanks for your reply .I have tried  this  , its not working in case of Editable Subgrid .

    pastedimage1657280579352v1.png

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Remove Optionset from a column in Editable subgrid

    Hi,

    Please try Remove option code to remove option from your field

    docs.microsoft.com/.../removeoption

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans