Hello,
First, welcome to the Dynamics community. All questions are more than welcome, we are all here to learn and share our knowledge.
It is possible to implement your scenario using JavaScript code as the field type used is OptionSet. We could have implemented your scenario with a simple configuration if the Field type were a LookUp.
I implement a generic method using JavaScript Code that you can use for every two dependents OptionSets.
if(typeof(MEA)=="undefined"){MEA={}};
if(typeof(MEA.OptionSet)=="undefined"){MEA.OptionSet={}};
if(typeof(MEA.OptionSet.Utilities)=="undefined"){MEA.OptionSet.Utilities={}};
MEA.OptionSet.Utilities = {
//Cascading Utility
optionSetBValues : null,
Cascade: function (executionContext, optionAName, optionBName, dependecies) {
var formContext = executionContext.getFormContext();
var selectedAValue = formContext.getAttribute(optionAName).getValue();
var optionSetBControl = formContext.getControl(optionBName);
if (optionSetBValues == null)
optionSetBValues = optionSetBControl.getOptions();
if (selectedAValue != null) {
optionSetBControl.clearOptions();
var dependeciesB = dependecies.find(d => d[0] == selectedAValue).slice(1);
var filtredOptionB = optionSetBValues.filter(v => dependeciesB.includes(v.value));
filtredOptionB.forEach(d => {
optionSetBControl.addOption(d);
})
}
else {
optionSetBControl.clearOptions();
}
}
}
Config:
OnLoad:
onChange :
Now, Let's take the following scenario:
OptionA
- schemaname: mea_optionacode.
- options:
- label: A1, value: 1
- label: A2, value: 2
OptionB:
- schemaname: meaoptionbcode.
- options:
- label: B1, value 1
- label: B2, value 2
- label: B3, value 3
- label: B4, value 4
- label: B5, value 5
- label: B6, value 6
If A1 is selected. Only B1, B2, B4 can be selected.
If A2 is selected. Only B3, B5, B6 can be selected.
The handler properties will be:
Comma separated list of parameters:
"mea_optionacode","mea_optionbcode",[[1,1,2,4,[2,3,5,6
"mea_optionacode": optionA schemaName.
"mea_optionbcode": optionB schemaName.
[[1,1,2,4,[2,3,5,6: Array containing the dependecies:
- [1, 1, 2, 4: value 1 selected, only values 1, 2, 4 can be selected.
- [2, 3, 5, 6: value 2 selected, only values 3, 5, 6 can be selected.
