Discussions

Expand all | Collapse all

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

  • 1.  Disable ""grid edit"" button from child reports on forms?

    Posted 10-16-2018 20:06
    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?


  • 2.  RE: Disable ""grid edit"" button from child reports on forms?

    Posted 10-16-2018 20:16
    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.


  • 3.  RE: Disable ""grid edit"" button from child reports on forms?

    Posted 10-16-2018 20:20
    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? 


  • 4.  RE: Disable ""grid edit"" button from child reports on forms?

    Posted 10-16-2018 20:29
    Hmmm, I don't know a solution to that nuance.


  • 5.  RE: Disable ""grid edit"" button from child reports on forms?

    Posted 10-16-2018 20:59
    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();>"


  • 6.  RE: Disable ""grid edit"" button from child reports on forms?

    Posted 10-16-2018 21:03
    Do you know if there's a way to leave the more > print option?


  • 7.  RE: Disable ""grid edit"" button from child reports on forms?

    Posted 10-16-2018 21:07
    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!


  • 8.  RE: Disable ""grid edit"" button from child reports on forms?

    Posted 10-17-2018 17:25
    That's all right, thank you anyway!