Show/hide multiple fields based on subgrid data

(0) Share

Report

Posted on by sandeepc

5,514

Hi,

I need to show/hide 3 fields based on subgrid data.

If subgrid contains any record then fields should be hidden .

Or if subgrid don't contain data show fields

How can I achieve this

Any links or example would be great full

Tia

I have the same question (0)

All responses (3)

Answers (0)

André Arnaud de Cal... 301,051 Super User 2025 Season 2 on at

Like (0)

Report

Hi Sandeep,

You can write x++ coding to achieve this on the Active() method of the data source that contains the fields which are conditionally shown. You can then check if there are related records in the table of the sub grid.

What should happen if there was initially no record in the sub grid, but a user would add data on the form? Should it then also trigger logic to hide these fields?

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report

Hi Partner,

You can use create one Javascript(web Resource) in CRM to achiev eyour goal.

1)Get SubGird Record Count

https://www.powercommunity.com/how-to-get-subgird-record-count-with-webresource-in-dynamics-crm/

2)Hide or show fields:

https://www.cloudfronts.com/blog/dynamics-crm/hide-and-show-a-field-in-dynamics-365-crm-using-javascript/

Test:

--Hide Fax(fax) and Relationship Type(customertypecode) fields based on 'Contacts' sub-grid.

1)Js Code:

function hideBasedOnsubgridcount(executionContext) {

setTimeout(function () {

var formContext = executionContext.getFormContext();

if (formContext !== null && formContext != "undefined") {

var accountgridname = "Contacts";

var count = formContext.getControl(accountgridname).getGrid().getTotalRecordCount();

if (count == 0) {

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

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

}

else {

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

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

}

}

}, 15000);

2)Add web resource to on Load event:

3)Publish.

4)Result:

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report

Hi Partner，

Was my answer helpful?
If it was helpful, can you verify it?
If you have any questions, please feel free to contact me.

Regards,

Leah

Was this reply helpful? Yes No