Set Grid Edit for specific report only

  • 1
  • 2
  • Question
  • Updated 1 year ago
  • Answered
I have a large table with many records. The roles are not allowed to grid edit on this table, however, I need them to have access to grid edit ONE report from the many that are on this table. Is there a way to set this up? I have gone through trying to Override Role settings through report, and it does nothing. I have tried to change the permission through the form, no cigar. Before I try to find a back-end solution, is there any way to override role permissions for one specific report?
Photo of Ursula Ll

Ursula Ll

  • 1,446 Points 1k badge 2x thumb

Posted 1 year ago

  • 1
  • 2
Photo of dwhawe

dwhawe, Champion

  • 662 Points 500 badge 2x thumb
When you are in the table settings, go to Forms.

You should see an option below the list of forms called "Override role settings by report".  That will allow you to choose <standard behavior> on a specific report.
(Edited)
Photo of Ursula Ll

Ursula Ll

  • 1,446 Points 1k badge 2x thumb
Hi dwhawe, that was not working, but I found a workaround. I created a formula button, that sends the user directly to the report in grid edit mode, which superceded any role settings. I would still like to know why the option you state above didn't work for me, but I didn't have time to mess around haha!
(Edited)