NEIL PARKHURST

Javascript – Control OptionSet values

December 1, 2015

Here is an example of a function to limit the values of an optionset, in this example I have a field called priority and want to be able to control when some options are selectable.

First off all, I define the options and text values that are possible in the optionset, theses are global variables.

var low = {value : 100000000, text : "Low"};
var medium = {value : 100000001, text : "Medium"};
var high = {value : 100000002, text : "High"};
var reallyHigh = {value : 100000003, text : "REALLY REALLY HIGH"};

Then this function, removes all of the current values and adds back just the ones I want to be selectable. This function is then calls from anywhere needed.

As either popOptSet(true); – to show all values.

Or popOptSet(false); – to show a restricted set.

function popOptSet(all) {
  var pickList = Xrm.Page.getControl("new_priority");
  var options = Xrm.Page.getAttribute("new_priority").getOptions();

  // *** Clear current items
  for (var i = 0; i < options.length; i++) {
    pickList.removeOption(options[i].value);
  }

  // *** Now add back just what is needed
  if (all == true) {
    pickList.addOption(reallyHigh);
  }

  pickList.addOption(low);
  pickList.addOption(medium);
  pickList.addOption(high);
}

Hopefully you can amend this concept for you own purposes.

Happy coding! J

5 responses to “Javascript – Control OptionSet values”

Giorgio

October 14, 2016 at 1:13 pm

Hi,
it seems that your code contains a bug.

Please pay attention to the difference between Xrm.Page.getControl(“new_priority”) and Xrm.Page.getAttribute(“new_priority”)

“getControl” doesn’t implement getOptions method.

Your code should be something like this:
for (var i = 0; i < Xrm.Page.getAttribute("new_priority").getOptions().length; i++)
{
Xrm.Page.getControl("new_priority").removeOption(Xrm.Page.getAttribute("new_priority").getOptions()[i].value);
}

Giorgio – Spagetticode.eu

LikeLike

Reply
1. Neil Parkhurst
  
  October 14, 2016 at 2:01 pm
  
  Thanks for you comment. I have adjusted the code.
  
  LikeLike
  
  Reply
andrewcampey

March 1, 2018 at 9:38 pm

This is VERY useful!

Thanks Neil!

LikeLiked by 2 people

Reply
Raji

March 9, 2018 at 3:32 pm

Can you please tell me why to go for lookup fields instead of optionset? I hear from people that Lookupfields are the best solution for future updates.

LikeLike

Reply
1. Neil Parkhurst
  
  March 9, 2018 at 4:45 pm
  
  Great question. If you list of values is short and unlikely to change optionsets are a good choice. As quick to enter for users. But if you have long lists or expect the options to often change then a lookup provides more flexibility. Another advantage of optionsets can be found if you need the multi-select feature. Both approaches are supported and fine in terms of upgrades. It is just that with lookups you can add values (or even users can add values) without needing to deploy a new version of your solution.
  
  LikeLiked by 1 person
  
  Reply