Checking field usage
To help you maintain and improve your apps, you can check field usage information.
To check field usage:
Select the table that contains the field.
Select SETTINGS, then choose Fields.
Hover over the field name, then select Where is this field used? in the dialog box that appears. The Usage page displays a list of the places where the field is used in your app.
Alternatively, if you are editing a field's properties, select the Usage tab.
Types of field usage information
The table on the form usage tab displays the following types of field usage information if relevant.
Forms and reports usage
- Form-based access permissions.
- A form rule, with information on which form rule.
- Exact forms or an advanced dashboard.
- A report link.
- Report formulas.
- Row color-coding for reports.
- Initial filters for reports.
- Default report settings. All reports that use the default report settings are italicized with a note that they use the default fields. This way, if you need to delete or change a field, you can easily see if the field is part of the default settings and only change the report settings once.
Derived fields usage
- Lookup fields.
- Summary fields.
- Formula fields.
- A snapshot or shared values field.
- Used in an email reminder or notification.
- Used in a webhook.
- Part of a table-to-table relationship.
- Used in a custom data rule.
- The number of records that have a value in this field with a link to a table report of those records.
- Estimated space (memory or data) consumed. Due to variations in how Quick Base and data are used, we provide an estimated size for each field to provide a sense of relative field usage. This value may also change as an application is used.
For address fields, also known as composite fields, field usage info reflects both the primary field and all of its sub-fields. For example, if users enter Street 1, City, State/Region, and Postal Code separately, the record will be counted in the total number of Address field records. Also the memory used by all these sub-fields will be counted in the memory usage total for the Address field. The exception is when the Country field has the default value “United States,” then the Country value is not counted.
To help you better manage and track your apps, you can trace the source of your derived fields, such as formula, lookup, and summary fields, using dependency diagrams.
To view the interactive diagram, select the Dependency diagram tab. Select the circle next to a field name to view the fields it includes. When applicable, the table the field is used in is also displayed.
You can drag the diagram or zoom in and out using browser controls.
© 1999-2019 QuickBase, Inc. All rights reserved. Legal Notices.