Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Elite
4 years ago

Re: How to turn off access to a child table Form so all data entry / view is from Grid Edit only

Mark,

I suspect customer care may be thinking that you would restrict the view/edit at the role permissions level, while you are explaining to restrict the view/edit permissions at the report level, which as you mentioned, should work just fine.

------------------------------
Mike Tamoush
------------------------------

5 Replies

  • AnnettaColeman's avatar
    AnnettaColeman
    Qrew Cadet
    4 years ago

    I may be confused on where you want me to control access.   I opened the specific grid edit report and tried all available options under the Reports & Charts panel.  (see attached picture).    NONE of the selections made ANY difference including choosing "No one; hide it".   In all options all roles who have edit access (at role permissions) were able to click through do the underlying table (this is what I want to restrict) and also edit from the embedded grid edit in the Parent form.   Similarly the Viewers (who have only view access at the role level to the table) were completely unaffected by any of the options.   

    Perhaps the problem is that role permissions at the table level are in control?   So cannot restrict in this panel?    I am confused.     Please help.   Thanks!



    ------------------------------
    Annetta Coleman
    ------------------------------

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      np,
      View any typical Parent record.
      Right click near he Report link field for the embedded report to edit FORM Properties.
      locate the blue link to the report being used.
      Click the link to open up the configuration for the report.
      Scroll down to near the bottom and deselect "Allow Viewing records from this report" and "Allow editing records from this report".
      Save the report.

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • AnnettaColeman's avatar
        AnnettaColeman
        Qrew Cadet
        4 years ago
        Mark -
        This worked PERFECTLY!!!!!

        I am raising a special thanks to you this Thanksgiving for your tireless support of QuickBase community.   THANK YOU!!

        ------------------------------
        Annetta Coleman
        ------------------------------