I have a requirement where I need to show or hide the phone number (standard field) if the contact is VIP or not (customm field) in standards layout. Only a specific profile will have access to see the phone number of those VIP contacts. However, everyone will see any contact regardless if is VIP or not. How can I achieve this?
I can create 2 separate layouts if the contact is VIP or not but they will still be able to run a report and see that phone number. I need to restrict the access to the field in both layout and data level.
Any advice/approach in how to achieve this is much appreaciate it.