Hide/Remove Text in the Column in CRM View "Items Available To Work on" for Queue Item entity

0
votes

When a user opens the view "Items Available To Work on" for QueueItem entity, a related entity's column is showing some data in the view. I want to remove or hide that data when another column in the view has some specific data in it.

Here is the actual example which I need to achieve.

When the field "Case Type" has text "Revenue Collection" then hide text "Dummy Taxpayer" from the field "Taxpayer". Both fields are showing from related entity Case in this QueueItem view.

Queue Item

I have checked the following possibilities but these are not working.

1- RetrieveMultiple message cannot be used with the QueueItem entity.

2- Tried with entity "SavedQuery" on RetrieveMultiple, but that is giving FetchXML of the view. We cannot change the result of the FetchXML dynamically here also.

3- In the properties of the column "Taxpayer" in the view, we do not have the option to run a JavaScript as my CRM version is 2016. This feature is available in Dynamics 365.

So, there is no supported way to achieve this as per my understanding. Any help/suggestion is appreciated on this issue

2
dynamics-crmdynamics-crm-onlinedynamics-crm-2016
The link in the question named "Queue Item" is the screenshot of the issue which needs to be resolved. – user2050288
Is your View Editable? Also is it ok for you iff your view is Editable, depending on condition your field is Disabled (not hidden) As far as I know you cannot hide/show column in view based on some condition – AnkUser
Yes, the view is Editable in the sense that we can add/remove columns in the view. The view "Items available to work on" in the default view in which I have added fields from related case entity. I do not need to hide/show columns but I just want to hide text/data showing in that specific column if the column "Case Type" has specific text – user2050288
no you cannot do that, Either you can disable/enable it or you can use field security profile so that this field will be shown only to specific users who have Field security role. – AnkUser
Ok, if we need to enable disable a column in the view based on condition in CRM 2016, how it can be done? – user2050288

2 Answers

0
votes

In Grid,

You cannot Hide/show column dynamically depending on your condition. Rather you can enable/disable field so that users cannot edit field based on Condition.

Please find Link Article as Example.

0
votes

This is more of a data captured problem rather than data hide/show problem.

When the case type is "Revenue Collection", the value of the "Tax payer" should be null. Then this problem is solved in grid/view or form and everywhere.