Disable "grid edit" button from child reports on forms?

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
  • (Edited)
Hey all! I have a form with several child tables on it. I want to hide the option for users to click "grid edit" or "full report" from the form. Basically, I ONLY want them to be able to edit that report if I set it to be grid-editable on the form. Any ideas?
Photo of Elena Larrabee

Elena Larrabee

  • 856 Points 500 badge 2x thumb

Posted 2 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
One solution is to create a dummy form with no fields on it.  Then, in forms usage assign that form to be used for Grid edit for that report.  So the user will be able to grid edit, but it will be an unsatisfying experience as they will have no columns on the grid.  You might reinforce that with a note on the form.
Photo of Elena Larrabee

Elena Larrabee

  • 856 Points 500 badge 2x thumb
Well, except wouldn't that then also affect that report if I set it to be grid-editable on that form? I do want users to be able to grid edit reports when they're editing the form, but I just don't want them to be able to leave that form to go to the full child report. 

Is there a setting I'm missing somewhere that would hide those options? 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
Hmmm, I don't know a solution to that nuance.
Photo of Dan

Dan

  • 1,180 Points 1k badge 2x thumb
You can hide all of those options ("Full Report", "Grid Edit", etc.) using IOL--just place the following in a formula rich text field on the form, replacing "DBIDHERE" w/ the DBID of the child table (the one whose records are being displayed in the report link):
"<img qbu='module' src='/i/clear2x2.gif' onload=javascript:$(\"table[qbdbid='DBIDHERE'].ToolbarTable\").closest(\".Toolbar\").hide();>"
Photo of Elena Larrabee

Elena Larrabee

  • 856 Points 500 badge 2x thumb
Do you know if there's a way to leave the more > print option?
Photo of Dan

Dan

  • 1,180 Points 1k badge 2x thumb
Most likely it can be done, but I don't have the code for that, and it's not code I can come up with myself. Sorry!
Photo of Elena Larrabee

Elena Larrabee

  • 856 Points 500 badge 2x thumb
That's all right, thank you anyway!