Skip to main content
Question

Can a user view a report without having the table show on the menu bar?

  • April 21, 2017
  • 0 replies
  • 31 views

I want to create a button on a form that links to a report on another table, but I don't want the other table to show in the users menu bar. Is this possible?
This topic has been closed for replies.

  • Quickbase Alumni
  • April 21, 2017
Yes this is possible, (and this might rock a few peoples perception of QB security)

But the option of "May be viewed by" actually ONLY restricts what appears in the 'reports & charts' menu.  Any user regardless of role can see the report if they have the url, report id, or just change their URL to a different qid.

So yes, just make that report only show in the menu for who you'd like, but the button to have a URL link to that report will work for anybody who has access to the app.

You can make a formula url, and just copy the report URL into the formula box.

  • Author
  • Quickbase Alumni
  • April 21, 2017
So I have done that.  I made only the specific report viewable that I want them to see.  I have the URL for the button specifically to that report.  But, if I have the "Hide Table In Bar" checked on the User Interface tab under Roles, the button doesn't work.  If I don't hide the table in the bar, then the button works.  I don't want to show the table in the Table Bar.


  • Quickbase Alumni
  • April 21, 2017
What does the end of your link look like?

Like this:  "?a=td"
or This: "?a=q&qid=1"

The first is a link to the table home page, the second is a link to the actual report.

**Edit**: The first wont work if you hide the table, but the second should work as long as they have permissions to view records in that table.

  • Author
  • Quickbase Alumni
  • April 21, 2017
Yes.  That worked.  Thanks so much!!