FAQs

​

Why did my Airtable data source disconnect?

An Airtable data source enters a disconnected state when its authorization can no longer be used to reach the selected table. Two situations cause this. The first is an expired or invalid refresh token. Airtable refresh tokens have a long but finite lifetime, and once one expires the next scheduled sync can no longer authenticate. The second is a permissions change: if the base or table is no longer shared with the authorized connection, or the granted access is revoked, the sync fails with a permissions error. In both cases, reconnecting the data source issues a fresh authorization and restores syncing. See How to connect Airtable to Adriel for the reconnect steps.

​

Why don’t my Airtable date columns filter by date range?

Date, date-time, created-time, and last-modified-time columns are imported as text values rather than as a native date type. On its own, a text column is not treated as the table’s timeline, so the dashboard date range does not filter it. Date-range filtering works only when one of these columns is mapped as the date field during data-source setup. When no date column is mapped, the whole table is treated as a single snapshot: every row is returned regardless of the dashboard date range, and the widget shows one combined total instead of splitting by period. To enable date filtering, reconnect or reconfigure the data source and map a date-type column as the date field. For the full field type mapping and the schedule on which changes take effect, see the Airtable data reference.

​

Why are only some of my linked records or attachments showing up?

This is expected. Several Airtable field types hold more than one value per cell, and the connector imports each one differently.

• Attachments — only the first attachment’s URL is imported for a cell. Additional files in the same cell are not brought across.
• Collaborators — a multiple-collaborator cell imports only the first collaborator’s name.
• Linked records, multiple-select, and lookup values — these keep every value, joined into a single text value separated by a pipe (|). They appear as one combined string rather than as separate rows.
• Button columns — these hold no stored value and are dropped during import, so they never appear as a selectable field.

To report on individual linked records or attachments separately, split them into their own columns or rows in Airtable before the next sync.

​

Can I combine two Airtable tables on one dashboard?

Each selected table becomes its own separate data source, keyed to a single base and table. There is no native join across two Airtable data sources. To bring multiple tables together, either combine them into one table in Airtable first and import that, or place both data sources on the same dashboard and use Blend Data settings to align them on a shared breakdown. Airtable data can also be viewed in a generic table and combined with other data sources when it shares the same breakdowns.

​

Which Airtable columns can be used as metrics or breakdowns?

The available fields come from the imported table’s own columns rather than a fixed catalog, and each column’s role is decided by its Airtable field type. Numeric columns — such as number, currency, percent, duration, count, auto-number, and rating — can serve as metrics or as breakdowns. All other columns serve as breakdowns. Adriel also adds a Row count metric and a Raw data breakdown to every Airtable data source. Columns whose type resolves only at the row level, such as formula, rollup, lookup, and synced-source fields, can behave as either depending on the actual value, so their aggregation may vary. For the complete field type mapping and default aggregations, see the Airtable data reference.

​

Related