I have a table report and I'm need to hide one column based on the sales rep. How can I accomplish this?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of benecia1111

benecia1111

  • 80 Points 75 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,516 Points 4k badge 2x thumb
You can't hide a column in a report based on a variable such as a User; but you could build a formula field that would hide/show data in a column based on a User and then use that column in your report, so the column would still be there, but the content would hide/show based on the User.
You can also set the field level access in that Role to not include that field. Then the field will not exist on reports or forms for users in that Role.