JScript to Show/Hide Sub Grid based on Option Set

(0) Share

Report

Posted on by William Bradley

175

I have some code written that when the field 'Corporate Tracker Type' = Yes, show the associated Grid, else Hide. Here is the code I am using:

function ShowHideTTTGrid(context) {

var formContext = context.getFormContext();

var CorporateTrackerType = formContext.getAttribute("lennar_corporatetrackertype").getValue();

var docTab = formContext.ui.tabs.get("{67f21f51-420e-4b0b-ab79-a45d7595ad48}");

if (CorporateTrackerType != true) {

docTab.sections.get('{65e87d15-fb83-4a40-b449-7cf6fdad0706}').setVisible(true);

} else {

docTab.sections.get('{65e87d15-fb83-4a40-b449-7cf6fdad0706}').setVisible(false);

}

Does this code look correct? I am getting the following error:

In the Form Properties, I have the function Control Form Event OnLoad and Control Corporate Tracker Type Event OnChange.

Thanks for any suggestions!

All responses (26)

Answers (2)

William Bradley 175 on at

Like (0)

Report

RE: JScript to Show/Hide Sub Grid based on Option Set

Yep - stupid me. That did the trick. Working as expected. Thanks again Andrew and rexkenley!
Verified answer

rexkenley 110 on at

Like (2)

Report

RE: JScript to Show/Hide Sub Grid based on Option Set

You can further simplify by just stating

docTab.sections.get('{67f21f51-420e-4b0b-ab79-a45d7595ad48}_section_5').setVisible(CorporateTrackerType != 531180000);

From 4 lines to 1 :)
Verified answer

a33ik 84,325 Most Valuable Professional on at

Like (2)

Report

RE: JScript to Show/Hide Sub Grid based on Option Set

Replace line

if (CorporateTrackerType != 531,180,000) {

with the line

if (CorporateTrackerType != 531180000) {

optionset value is number so no spaces, commas, e.t.c. Value with commas is formatted value.
William Bradley 175 on at

Like (0)

Report

RE: JScript to Show/Hide Sub Grid based on Option Set

Hi Andrew, thanks again for the continual help. I found what might be an issue. The field Corporate Tracker Type (lennar_corporatetrackertype) is an option set, not a boolean. So, I updated the code as such so that the Yes value (when selected the Sub Grid needs to show) is the value 531,180,000.

There is no error thrown, however - the Grid (in the Section) does not show at all - it just remains hidden:

Here is the updated code:

function ShowHideGrid(context) {

var formContext = context.getFormContext();

var CorporateTrackerType = formContext.getAttribute("lennar_corporatetrackertype").getValue();

var docTab = formContext.ui.tabs.get("{67f21f51-420e-4b0b-ab79-a45d7595ad48}");

if (CorporateTrackerType != 531,180,000) {

docTab.sections.get('{67f21f51-420e-4b0b-ab79-a45d7595ad48}_section_5').setVisible(true);

} else {

docTab.sections.get('{67f21f51-420e-4b0b-ab79-a45d7595ad48}_section_5').setVisible(false);

}

}

Do you see anything I am missing? The Event handlers (onLoad, OnChange) have remained the same. I do notice that the field Corporate Tracker Type is locked on the form.

Ideas?
rexkenley 110 on at

Like (0)

Report

RE: JScript to Show/Hide Sub Grid based on Option Set

Sorry, I meant the GUID, that is throwing me off.

Add this to your code.

docTab.sections.get().forEach((s) => { console.log(`${s.getName()} ${s.getVisible()}`);});

This will display all the valid names in your tab.
Suggested answer

a33ik 84,325 Most Valuable Professional on at

Like (2)

Report

RE: JScript to Show/Hide Sub Grid based on Option Set

It's a bit hard to give you other advises.

My recommendation - master basics of script troubleshooting. I have a manual for it:

It's short but it should be enough for you to figure out steps.
William Bradley 175 on at

Like (0)

Report

RE: JScript to Show/Hide Sub Grid based on Option Set

Apologies, I never answered your question. When I updated the code to include the _section_5, that is when the error stopped. But the code does not show/hide the section as I expect it to. Here is the current code:

function ShowHideGrid(context) {

var formContext = context.getFormContext();

var CorporateTrackerType = formContext.getAttribute("lennar_corporatetrackertype").getValue();

var docTab = formContext.ui.tabs.get("{67f21f51-420e-4b0b-ab79-a45d7595ad48}");

if (CorporateTrackerType != true) {

docTab.sections.get('{67f21f51-420e-4b0b-ab79-a45d7595ad48}_section_5').setVisible(true);

} else {

docTab.sections.get('{67f21f51-420e-4b0b-ab79-a45d7595ad48}_section_5').setVisible(false);

}

}
a33ik 84,325 Most Valuable Professional on at

Like (1)

Report

RE: JScript to Show/Hide Sub Grid based on Option Set

In your scripts you should use the name of tabs and sections. The issue I see comparing your script and screenshot that for section you have _section at the end of the name and I don't see it in the script. Can you post your current code and exact names of Tab and section?
William Bradley 175 on at

Like (0)

Report

RE: JScript to Show/Hide Sub Grid based on Option Set

Yes, if you look at the code I posted at the top, I am using the Tab Name (not label) and Section name:

Tab:

Section:
rexkenley 110 on at

Like (1)

Report

RE: JScript to Show/Hide Sub Grid based on Option Set

I looked up the documentation and it didn't really say, but aren't you supposed to pass the tab NAME (unless you name your tabs like that).

docs.microsoft.com/.../formcontext-ui-sections

community.dynamics.com/.../how-to-write-javascript-code-client-api-reference-formcontext-ui-sections-getparent-setlabel-setvisible