How to show or hide based on multiselect option set values

(1) Share

Report

Posted on by Kruthi2704

How to show or hide based on multiselect option set values

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

Wahaj Rashid 11,321 on at

Like (2)

Report
Hi,

Thank you for your query.

To show/hide fields based on Multi-select optionset, you need to register a JavaScript function.

For example, you can register a JS function on change of Multi-select optionset field.

Here is a sample function to show/hide telephone1 field based on selected value:

function onMultiSelectChange(executionContext) { const formContext = executionContext.getFormContext(); const moField = formContext.getAttribute("new_multioptionsetfieldname"); //Returns Array of Selected OptionSet Values, example [1001,1002,1005 ] const selectedOptions = moField.getSelectedOption(); // Now you can implement your logic here, for example: if(selectedOptions.filter(i => i.value === 1001).length > 0) { // Hide mobile phone field formContext.getControl("telephone1").setVisible(false); } else { // Show mobile phone field formContext.getControl("telephone1").setVisible(true); } }

Please note, when you register this function, you need to pass Execution Context as first parameter.

Here are few links for your understanding:

Get and Set Multiselect Option set field values through Javascript | Microsoft Dynamics CRM / 365 (wordpress.com)

Hiding and Showing a Field in Dynamics 365 using JavaScript - Carl de Souza

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Kruthi2704,

You can use businee rule to show or hide fields based on another multiselect optionset fields value, which is a no-code way.

Go Settings > Customizations > Customize the system> Entities >Expand one entity you need > Business Rules.

Save and Activite it, then publish all customizations.

2.Test:

When 'Relation type' field value is 'competitor', the parent account field will be hidden, otherwise, it will be shown in the form.

You can refer following link to know more about business rules:

Create business rules and recommendations | Microsoft Docs

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
Suggested answer

meelamri 13,216 User Group Leader on at

Like (1)

Report

Hello Leah Ju,

I don't think a Business Rule can implement this scenario. Since Business Rules does not support multi-select option sets. Please refer to the documentation:

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-business-rules-recommendations-apply-logic-form

this need can only be implemented with JavaScript code as suggested by Wahaj Rashid.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Kruthi2704,

As Mehdi said, Business Rules does not support multi-select option sets.

I'm so sorry that I didn't notice this, you can only use js code to achieve it in the scenario.

But if you want to show/hide fields in other scenario that fields is not multiselect option set values, Business Rules is a good way to achieve it.

Not just show/hide fields, it has following other actions:

Consider using it the next time if you have one of these needs.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
Suggested answer

Kruthi2704 25 on at

Like (0)

Report

Thanks wahaj

Was this reply helpful? Yes No
MattBarker 25 on at

Like (0)

Report

Wahaj Rashid, This is brilliant thank you. Would you please be able to provide an example where you make multiple fields visible based on a multi-select optionset? Is it simply a case of listing multiple if statements? A revised example would be amazing.

Was this reply helpful? Yes No
MattBarker 25 on at

Like (1)

Report

Sorry. i worked it out. i also added a handler for NULL.

function onMultiSelectChange(executionContext) {

const formContext = executionContext.getFormContext();

const moField = formContext.getAttribute("mso_field");

//Returns Array of Selected OptionSet Values, example [1001,1002,1005 ]

const selectedOptions = moField.getSelectedOption();

// Now you can implement your logic here, for example:

if(selectedOptions != null){

if(selectedOptions.filter(i => i.value === 100000000).length > 0) {

// Hide mobile phone field

formContext.getControl("field1").setVisible(true);

} else {

// Show mobile phone field

formContext.getControl("field1").setVisible(false);

}

if(selectedOptions.filter(i => i.value === 100000001).length > 0) {

// Hide mobile phone field

formContext.getControl("field2").setVisible(true);

} else {

// Show mobile phone field

formContext.getControl("field2").setVisible(false);

}

}

if(selectedOptions == null){

formContext.getControl("field1").setVisible(false);

formContext.getControl("field2").setVisible(false);

}

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi I have four multi select option ["favorite player", "favorite food", "First School", "Middle Name"] .

I want to have equal number of text boxes (Answer 1 for first option selected ,Answer 2 for second option selected, Answer 3 for third answer and so on)

If user selects only two option then two respective answer text boxes will show. How to achieve this?

Was this reply helpful? Yes No
RugerSR762 375 on at

Like (0)

Report
Thank you for posting this. It is a good starting point. However, I have encountered two issues with my use case:

1.) When there is no value in the multiselect option set (new_type), the script will throw an error

2.) I do not think my array is properly configured as the requirement is when a certain type (i.e. "residential" is the ONLY value selected, show/req contact only while hiding customer... meanwhile if anything except residential is selected show both customer and contact only requiring customer:

function displayContact(executionContext) { const formContext = executionContext.getFormContext(); const oppType = formContext.getAttribute("new_type"); //Returns Array of Selected OptionSet Values const selectedOptions = oppType.getSelectedOption(); if (selectedOptions.filter(i => i.value === 925170001).length > 0) { // Display both Customer and Contact lookup fields and set required formContext.getControl("new_customerid").setVisible(true); formContext.getAttribute("new_customerid").setRequiredLevel("required"); formContext.getControl("parentcontactid").setVisible(true); formContext.getAttribute("parentcontactid").setRequiredLevel("required"); } else { // Hide Customer field and remove requirement level formContext.getControl("new_customerid").setVisible(false); formContext.getAttribute("new_customerid").setRequiredLevel("none"); formContext.getControl("parentcontactid").setVisible(true); formContext.getAttribute("parentcontactid").setRequiredLevel("required"); } }

Was this reply helpful? Yes No