Cascade filter for our forms are working for all the selection from the dropdown except for selecting one entry from the dropdown list. i.e. if you have "A", "B", "C" and "D" in the dropdown list. It works fine for "A", "B" and "D" but when you select "C" the data for the child dropdown will show the results on the previous selection. I have tried it with code and with configuration filter but its still the same. It could be that there is something wrong with the data. any ideas?
Are you using lookup fields or lookup control? How is the filtering set up? Please share the screenshot of the Filter section from the field/control properties.
Please check the browser console for the errors when selecting the 'C' option and share the screenshot.
Part of the disabled code (used before)
// JavaScript source code
fd.spRendered(function () {
fd.field('ProjectNumber').ready().then(function () {
function filterLookup(v) {
// getting the selected Division (0 if nothing is selected).
var categoryId = 0;
if (v) {
categoryId = isNaN(v) ? v.LookupId : v;
}
if (categoryId) {
// setting filtration allow Global Marketing "-PRDE" to appear when Design is selected
if (fd.field('Division').value.LookupValue == 'Design') {
fd.field('ProjectNumber').filter = 'Division/Id eq ' + categoryId + ' or Division/Id eq 38'; //Global Marketing ID = 38
} else {
fd.field('ProjectNumber').filter = 'Division/Id eq ' + categoryId;
}
} else {
// resetting the filtration
fd.field('ProjectNumber').filter = null;
}
fd.field('ProjectNumber').refresh();
}
//filter Projects when form opens
fd.field('Division').ready().then(function (field) {
filterLookup(field.value);
});
//filter Projects when Division changes
fd.field('Division').$on('change', function (value) {
filterLookup(value);
fd.field('ProjectNumber').value = null;
});
in both instance it is working fine for all the selection made except when you select one. I think it could be because of data. But couldn't figure out what.
There are no errors while selection on browsing console.