Specify which Reports QuickBase Offers a User

This topic refers to functionality that is not available to accounts on the QuickBase Essential plan. If the functionality described here does not match what you're seeing in QuickBase, your account is probably on this plan.

Imagine that you design some special reports specifically for your sales team and you want to make sure that these report selections appear just for them. Likewise, you may not want to show your Research department those sales reports. You can solve this conundrum by telling QuickBase which reports appear as options for each role.

Note: If you embed a report on your app Home page, all roles see the report regardless of any other settings you make.

Specifying reports does NOT affect data access permissions

When you assign a report to a role, the report appears for users in that role. The goal is to provide users with shortcuts to reports that are helpful to them and others in their role. Assigning a report to one role does NOT mean that users in other roles can't access the data in that report. Sure, users in other roles may not see the report you create, but they can still craft it themselves or find the values in the report by searching for the values they want. This feature does NOT hide or protect sensitive data. If you need to secure data, set up access permissions instead.

QuickBase gives you a few places from which to set your preferences. You can:

Assign a report to roles

You can assign a report to a role when you save the report or assign multiple roles to multiple reports at the same time, using the Roles and Reports Matrix page.

To assign a report to roles when you save the report:

Create a new report. In the Basics section of the report, click the May be viewed by dropdown and select one of:

To assign multiple reports to multiple roles:
  1. Choose Home from the Table bar, click SETTINGS, click Roles, then click the Set role access to Reports link.

    Note: Users who do not have Full Administration access to the app (usually app admins and app managers) cannot access this page.

    QuickBase displays a list of all your application's reports. On the right, are columns—one for each Role.

  2. To specify which report should appear to a particular role, locate the report in the list. Within each role's column, specify whether or not the role should see the report in the reports panel.

    To have the report appear to the role, activate the check in that role's column.

    To hide the name of the report from a role, deactivate the check in the role's column.

    Your changes are saved as you work.

Tip: If you have a lot of roles, columns may stretch far to the right of the screen, making it hard to keep track of which reports you're activating for roles on the far right. When you need to scroll right, the Table and Report columns remain visible on the left.

Specify which reports should be available to a role

To specify which reports should be available to a role, while you're customizing it
  1. Choose Home from the Table bar, click SETTINGS, then click Roles.

    Note: Users who do not have Full Administration access to the app (usually app admins and app managers) cannot access this page.

  2. Click one of the roles.

    Click the User Interface tab.

  3. Click the Set report access link.

  4. Select the checkboxes next to each report you want the role to see in the reports panel.

  5. Click Save.

Note: Again, adding or removing a report from a role does NOT limit or grant permissions to all information within these reports. For example, say a manager has a "salary" report that includes confidential information. If a user without the proper permissions clicks this report, he'll see only those fields that his permissions allow. If you want to limit or grant access to certain fields and tables, you must do so using the appropriate controls within the Role screen's Permissions tab. (Read about configuring role permissions.)

Hide a report from all roles

There is a way to hide a report from all roles, until you choose to show it using the Set report access link or the Set role access to reports link (both methods described above).

To hide a report from all roles:

Create a new report. Before saving the report, in the Basics section of the Report Builder, select Temporarily hide this report. When you save the report, it will appear in the list of reports available from the table Settings page, but it will not appear in the reports panel for any role until you choose to show it using one of the methods described above.

Note that this setting is only visible when creating a report. If you copy a report that has been hidden in this way, the copy will also be hidden. But if you customize the hidden report and save it under another name, the new report will not be hidden.

Related Topics:


Return to top   

© 1999-2015   Intuit Inc.  All rights reserved.  Legal Notices.