Can data in a report column be SHOWN for some records and HIDDEN for other records?
Is there a way to configure things so that on Reports, for most Profiles, for a certain field, let's say "Price", data can be
shown in the column for some records and
hidden in the column for other records? This would be based on another field in the record, say "Internal/External".
So, for most users, for the "Price" column, on Reports:
- for records marked "External", users see the "Price" data
- for records marked "Internal", although the Price data exists, users see blank (the data is hidden).
And, the same to hold true for the Record Summary popup.
Background:
- We have an Enterprise account and are using Roles & Profiles.
- We know that *entire records* can be private to the creator and their team, etc.
- But this is not the solution for the above since we want the users to see all records.
- We know that *entire columns* can be hidden from some users, by using Field Permissions and making a column not visible to users with a certain Profile.
- Yet, is not the solution for the above - we want the column to show on reports... But for the DATA to show for some records, but be blanked hidden for other records.
- We realize that this IS the solution for the FORM (the field will hidden for that profile). Good.
- We know we can limit the columns via Views, and who has access to those Views.
- But again, not the solution, since we want the column to show, and the data to show for some records.
This is important to us. Many thanks for your help!