Airtable Field Schema Documentation: Field Dependencies Counts & Field Percent (%) Filled

Learn how to systematically audit Airtable fields by recording their dependency counts and fill percentages into a tracking spreadsheet.

June 12, 2026 By Mike Crofton-Atkins

This guide demonstrates how to audit an Airtable base by documenting the dependency count and usage percentage for every field. Completing this task provides a comprehensive overview of your data schema to assist with cleanup and optimisation.

This process is intended for database administrators or operations team members conducting a schema audit or base cleanup project.

You will be recording field data from Airtable into a Google Sheet. Ensure you are looking at the Main ABOB Community grid view (Do not change view) MASS copy in Airtable and the Main ABOB Community grid view Field Data Schema sheet in Google Worksheet named Mass (Airtable Services Partner) Plan.

1. Check Field Dependencies

For each field listed in your spreadsheet, locate the corresponding column in Airtable.

Step #1: Click the dropdown arrow in the column header and select Show dependencies. — Click the dropdown arrow in the column header and select **Show dependencies**.

Be very careful to click Show dependencies and not Edit field.

Note the number of dependencies listed at the top of the panel.

Step #2: Click the X to close the dependencies panel. — Click the X to close the dependencies panel.

2. Check Percent Filled

Next, you need to find out how much data populates this field across all records.

Step #3: Scroll to the summary bar at the bottom of the Airtable grid, click the summary dropdown for your column, and select Percent Filled. — Scroll to the summary bar at the bottom of the Airtable grid, click the summary dropdown for your column, and select **Percent Filled**.

Note the percentage that appears. If you are evaluating a checkbox field, treat "Checked" as the equivalent of "Filled."

3. Record Data in the Spreadsheet

Return to your tracking spreadsheet to log the two metrics you just gathered.

Step #4: Click into the Field Dependencies Count column and enter the number of dependencies. — Click into the **Field Dependencies Count** column and enter the number of dependencies.

Step #5: Click into the Percent (%) Filled or Checked column and enter the percentage. — Click into the **Percent (%) Filled or Checked** column and enter the percentage.

Repeat this exact process row by row, column by column, until every field in the spreadsheet has been documented.

Q: Which Airtable view should I use to gather this data?

A: You must strictly use the Main ABOB Community grid view (Do not change view) MASS copy view. Do not change views while recording the data.

Q: How do I handle checkbox fields when looking for a fill percentage?

A: For checkbox fields, the metric is referred to as "Checked" (or "Ticked"). Treat the checked percentage as the filled percentage.

Term	Definition
Field Dependencies	Other elements in an Airtable base (like formulas, automations, or views) that rely on a specific field to function properly.
Percent Filled	An Airtable summary metric indicating the proportion of records that contain data in a given field.
Grid View	A standard, spreadsheet-like layout in Airtable where records are displayed as rows and fields as columns.

Term

Definition

Field Dependencies

Other elements in an Airtable base (like formulas, automations, or views) that rely on a specific field to function properly.

Percent Filled

An Airtable summary metric indicating the proportion of records that contain data in a given field.

Grid View

A standard, spreadsheet-like layout in Airtable where records are displayed as rows and fields as columns.