How to hide field in View

Asif Bhat shared this question 17 months ago
Answered

Hi Team,

We have created a calculated field on "Notes" field which is of type "NTEXT".

In the calculated field (Notes-NEW) I converted the "Notes" Field from ntext to Varchar using the concvert function.

Now I want to hide the "Notes" field in the View so that no one will use this field and use the calculated field.

Is there a way to do it ?

Kind Regards,

Asif Bhat

Comments (5)

photo
1

Hi Asif,

Yes there is a way to hide the calculated field or any other field that you want to hide. When in the view, you would need to select the Restricted Access Level under the format of the field you are interested in. This will then show the Notes Field under the View Security ICON, which you then add which users can see this. When they go into the report building, the Notes field will no longer appear. Please see below images for a quick understanding of this.

Please refer to the View security here for more information.

The following shows I have created a Calculated Field called New Campaign from Campaign and then applied the security to the Campaign Field for only The Sys Admin. The New Campaign will be the only option viewable of the 2 for users other than the Sys Admin, but the Sys Admin will see both.

Please let me know if this is what you are looking to do.

Regards,

Paul

388d65acefc494cf64143d3c478b1399

0f78326241eec8556748e517fd3169aa

photo
1

Hi Asif,

Just following up on this ticket and wondering if this been resolved?

photo
1

Hi Asif,

I have not heard anything back from in regards to this so just seeing how it is going. If you could get back to me and let me know if you need further help or whether this has been resolved, that would be great.

Regards,

Paul

photo
1

Hi Asif,

It has been a couple of weeks since my first reply on this question. Are you okay for me to close off this ticket now. If you need, you can always re-open.

Regards,

Paul

photo
1

Hi Asif,

As I have not heard back from you for some time with this ticket. I will close it off for now. Feel free to re-open this if you need further information.

Regards,

Paul