How to enable access to summary field for a user but deny access to see all detail records except their own.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Project table is parent to Time Details table.   Table report in Project table has multiple summary fields totaling up various things from Time Details.  We want users to see those various summary totals of everyone's records in that report, but when they go to the detail tables we never want them to see anyone's detail records except their own.  How do I do that?
Photo of Robin CC

Robin CC

  • 200 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Harrison Hersch (MCF)

Harrison Hersch (MCF), Champion

  • 40 Points
If I understand the requirement, this is not possible natively. QuickBase "override permission of subfields" works on fields, but not records. You can technically obscure the child records but someone very savvy could get around that. One option would be to move the summary data to another table and have users access that table.