Forum Discussion

ElenaLarrabee1's avatar
ElenaLarrabee1
Qrew Captain
6 years ago

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

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?

7 Replies

  • 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.
  • 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? 
  • 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();>"
  • 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!