Hide/Disable a selectable value in an Option List

(0) Share

Report

Posted on by Kelly Grant

100

I have an Option List that is populated with Years. As a year expires, I'd like to remove it from being selected from the Option List. I'd like this value to continue to display on historical records, but I seem to be having great difficulty in making this happen.

Removing it the actual Option set seems to remove the reference to the "2014" label, so historical records show up as blank. This is not acceptable.'
Utilizing the Javascript solution of Xrm.Page.getControl('field name').removeOption(value); also seems to come with the drawback that when viewing this a historical via the Form...it also blanks out the field making look like it was never set. Not really acceptable.
I've tried to utilize unsupported javascript to select the particular Options that I want to remove and remove them. I've gotten it to work for IE10, but cannot seem to get it to correctly run in IE9. It doesn't seem to understand which frame to look in.
- function FilterFiscalYear(){ $("select[attrName='sgs_fiscalyear'] option[title='2014']").each( function() { $(this).remove(); });}

I'm entirely baffled as to why it's so difficult to remove an option from an Option set, but leave the historical data displaying that value that's no longer selectable.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Deepesh161 6,317 on at

Like (0)

Report

Make a html webresource which internally fetches option set , sets it but only show the ones you want in your select control.

Was this reply helpful? Yes No
Kelly Grant 100 on at

Like (0)

Report

Thanks for your quick reply. Can you provide any examples of how to do this? I'm not quite following what you've recommended.

Are you recommending that I use Jscript to clear the Option Set. Query the Options I want. And then use Xrm.Page.getControl('field name').addOption(value,index) to populate the Option Set with my desired list?

Was this reply helpful? Yes No
Verified answer

Deepesh161 6,317 on at

Like (1)

Report

No, I am suggesting to fetch option set values in html webresourcr(keep it hidden on form).

You will also know current year in script.

Build a dynamic select control in html (show all years except current one)

Reference to form a dynamic select control: http://stackoverflow.com/questions/7340644/dynamically-add-input-type-select-with-options-in-javascript

When somebody changes selection in your resource on the background set your option set.

Hope it is more clear now.

Was this reply helpful? Yes No
Saddamk206 777 on at

Like (1)

Report

Hi,

Also can try this:-

for (var i = 0; i < Xrm.Page.getAttribute("FieldName").getOptions().length; i++)
{

Xrm.Page.getControl("FieldName").removeOption(Xrm.Page.getAttribute("FieldName").getOptions()[i].value);
}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I ended up making a custom entity and then replaced the Picklist with a Lookup to the custom entity. This would let me disable records so they were no longer selectable, but retained their value for historical reporting.

Was this reply helpful? Yes No