How to allow a role that has limited views export a report?

  • 42
  • 1
  • Question
  • Updated 2 weeks ago
  • Answered
I have created multiple roles in my Application that restrict field views, editing capabilities and reports. I have one report that is visible to a finance role, however the users are unable to export the report to excel. Is there a setting I'm missing that prevents a role from exporting a report they can view?
Photo of Jennifer Gentry

Jennifer Gentry

  • 110 Points 100 badge 2x thumb

Posted 2 weeks ago

  • 42
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
I’m away from my computer now, but look for the setting, hide multi record operations and instead allow multi record operations.
Photo of Jennifer Gentry

Jennifer Gentry

  • 110 Points 100 badge 2x thumb
Thanks - Did a look around different areas and can't find it. Should I be looking at the app settings or the report settings generally or in the specific report?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
It’s in the settings for the Role.
Photo of Jennifer Gentry

Jennifer Gentry

  • 110 Points 100 badge 2x thumb
it seems that it's already on "allow"

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
It’s acually that import/ export setting.

Did you test as Role to test this. Or test as user?

If test as user, is the user in multiple Roles?
Photo of Jennifer Gentry

Jennifer Gentry

  • 110 Points 100 badge 2x thumb
I tested as the role and the user has confirmed that he can't export. He's only in that one role and if I change him to admin he has no issue, but can't leave him with that access as a permanent solution. Here is what the permissions look like
(Edited)
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,214 Points 5k badge 2x thumb
HI Jennifer,

Another place where export permissions can be set is in the application properties. To find it you would first go into application settings and then into the application properties page. Under that page there is a header for Advanced Settings and specifically for Security Options. One of the options is to - Allow users who are not administrators to export data-, if that is not checked then it could be blocking any non-Admin from exporting data. 


Photo of Jennifer Gentry

Jennifer Gentry

  • 110 Points 100 badge 2x thumb
YAY! This worked! Thank you!!!!