Check MC Option Set for value, setVisible if value is selected

(0) Share

Report

Posted on by Community Member

Hi,

I'm trying to achieve the following:

I've got a field on the account form called "scp_relationshiptype_mc", which is a multi-select option set with several values.

Depending on which value is selected, another field will be shown.

Eg.: If someone picks options "A", "B", and "C" in the MC option set field, three otherwise hidden fields "scp_A", scp_B" and "scp_C" will become visible. If they pick "A" and "B", only "scp_A" en "scp_B" ought to be shown.

It is disappointing that I can use MC option sets, but I can't do anything with them in a business rule or a workflow, so I've resorted to using JavaScript. I'm not a developer, so pardon any rookie mistakes.

I've gotten this far:

function onLoad() {
ShowHideRT();
}

function ShowHideRT() {

if ("scp_relationshiptype_mc" !== null)
{
//EV
if (Xrm.Page.getAttribute("scp_relationshiptype_mc").getValue().includes(798200000))
{
Xrm.Page.getControl("scp_rt_specifyev").setVisible(true);
Xrm.Page.getControl("scp_relationshiptypecomment").setVisible(true);
}
//TechPartner
else if (Xrm.Page.getAttribute("scp_relationshiptype_mc").getValue().includes(798200001))
{
Xrm.Page.getControl("scp_rt_specifytechpartner").setVisible(true);
Xrm.Page.getControl("scp_relationshiptypecomment").setVisible(true);
}
//GridOp
else if (Xrm.Page.getAttribute("scp_relationshiptype_mc").getValue().includes(798200002))
{
Xrm.Page.getControl("scp_rt_specifygridoperator").setVisible(true);
Xrm.Page.getControl("scp_relationshiptypecomment").setVisible(true);
}
//ServComp
else if (Xrm.Page.getAttribute("scp_relationshiptype_mc").getValue().includes(798200003))
{
Xrm.Page.getControl("scp_rt_specifyservicecompany").setVisible(true);
Xrm.Page.getControl("scp_relationshiptypecomment").setVisible(true);
}
//BuildConstr
else if (Xrm.Page.getAttribute("scp_relationshiptype_mc").getValue().includes(798200004))
{
Xrm.Page.getControl("scp_rt_specifybuildingconstruction").setVisible(true);
Xrm.Page.getControl("scp_relationshiptypecomment").setVisible(true);
}
//NonTrad
else if (Xrm.Page.getAttribute("scp_relationshiptype_mc").getValue().includes(798200005))
{
Xrm.Page.getControl("scp_specifynontraditional").setVisible(true);
Xrm.Page.getControl("scp_relationshiptypecomment").setVisible(true);
}
//Other...

}
}

This JS is called in the onLoad of the Account page and the onChange of the "scp_relationshiptype_mc" field.

When I try to open the account page, I get the error:

TypeError: Cannot read property 'includes' of null at ShowHideR

I had hoped that .include method would help me retrieve the necessary values to check on.

Help is much appreciated!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Dmitri 34 on at

Like (1)

Report

It says you cannot call 'includes' method, if a value of the field is null. So, first of all, check if the Xrm.Page.getAttribute("scp_relationshiptype_mc").getValue() is not null.

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (1)

Report

Hi , i would suggest you to compare your code with MSDN blog : msdn.microsoft.com/.../gg594433(v=crm.7).aspx

Was this reply helpful? Yes No
Verified answer

tw0sh3ds 5,600 on at

Like (2)

Report
So first of all, you should not use Xrm.Page anymore, you should use formContext:

[View:https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/clientapi/reference/executioncontext/getformcontext:750:50]

So just pass execution context to your onload function and your ShowHideR function and get form context and you can simply replace all Xrm.Page with formContext.

Now - the error clearily states that you multiselect does not have any value selected. You should do something like

var multiValueArray = formContext.getAttribute("scp_relationshiptype_mc").getValue(); if(multiValueArray == null){ //no value is selected return; } if(multiValueArray.includes(xxxx)){ } etc.

Just be aware that "includes" version is available only in modern browsers and not all of them.

Was this reply helpful? Yes No
Suggested answer

Guido Preite 54,086 Moderator on at

Like (2)

Report

keep in mind that "includes" (when used on arrays that is the value returned by the multiselect optionsets) is not officially supported on Internet Explorer or Edge, you should use "indexOf" instead.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is what I needed, thank you!

I've assembled most of the code through different other approaches I found in the community.

Just one quick question, when I use .includes, I have to refer to the optionset value and not the optionset text, right?

Thanks again!

@all the others, also a big thank you for helping out. Much appreciated!

Was this reply helpful? Yes No
tw0sh3ds 5,600 on at

Like (0)

Report

yes, you should refer to option set value

Was this reply helpful? Yes No