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

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Acknowledged
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  and not necessary.

In roles, I have selected:
- Hide UI for creating or customizing reports
- Hide personal settings link
- In user interface, Hide UI for: all 6 options selected.

Thanks.
Photo of Gary Boyd

Gary Boyd

  • 800 Points 500 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,814 Points 5k badge 2x thumb
Hi Gary,

Unfortunately in your instance there is not a specific UI component to toggle this option off and on for users. It is built in to allow for further Sorting and Grouping. However, it should only be populating that dropdown that appears with fields that the specific user has field access to. Any field where they are set to permissions of none should not appear in that list. This does mean they might see fields they have access to but aren't on the typical forms and reports they can use but they will not see the name of fields they have been given permissions of none for. I hope this information is helpful Gary. 
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
Using your favorite script injection technique you can remove that option with one line of code:
$("#A1").remove();
Likewise you can remove other options in that menu by specifying the appropriate id:



But don't stop there - you can likewise add your own options to that menu.
Photo of Gary Boyd

Gary Boyd

  • 800 Points 500 badge 2x thumb
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?
Photo of Gary Boyd

Gary Boyd

  • 800 Points 500 badge 2x thumb
Hi Dan - trying to use chrome to find elements and it is really worthwhile.
This did not work & I could not find A1 in the source code.
$("#A1").remove();


$("#ViewOtherOps").remove();
This partially works - pressing 'More' button does nothing, however the 'More' button still shows above the report.

$("#vsmore").remove();
More button clicks and shows no options
(Edited)