Forum Discussion

GaryBoyd's avatar
GaryBoyd
Qrew Assistant Captain
8 years ago

Hide 'Sorting and grouping...' on More drop-list of a report

Hi,  I am unable to suppress the 'Sorting and grouping' selection on the 'More' droplist at the top of all my reports. Clicking on it allows users to view field names which is a security issue, messy...
App builders
Ask about Quickbase functionality
reports and charts
GaryBoyd's avatar
GaryBoyd
Qrew Assistant Captain
8 years ago
Thanks Dan - for this and you obviously provide a lot of help on functionality when you search other posts also. Have not had time to try yet.

Would be good to consider, if you restrict field role permissions to none, do the formulas for users relying on info from those fields fail?
TreySmith1's avatar
TreySmith1
Quickbase Staff
6 years ago
I understand that this post is old, but for those browsing this is correct. Any fields that a user is restricted access to will affect how the user sees other fields, reports, formulas, etc that use this field. A good practice before restricting field access would be to check the fields usage, allowing you to see what things will be affected by limiting the user's access to said field.

To do so, you'll just need to go to the field's settings, then click on the 'usage' tab in the upper left of the screen.