How to Map Airtable Fields to Table Columns in TableCrafter

Updated July 2026 • 7 min read • By Fahad Murtaza

Airtable supports over a dozen field types, and each one behaves differently when pulled into TableCrafter. This guide covers exactly how TableCrafter renders Single line text, Long text, Number, Single select, Multi-select, Date, Attachment, Formula, and Linked record fields, including which are editable inline and which are read-only. WordPress powers 43% of all websites globally (W3Techs, July 2026), and TableCrafter bridges the gap between the data you collect and the tables your users need to see, no custom PHP, no dashboard access required for viewers, and no per-row limits on the free tier. The free version on WordPress.org supports CSV, JSON, Google Sheets, and Excel. Pro adds Gravity Forms, Airtable, Notion, WooCommerce, REST APIs, inline cell editing, export to CSV/PDF, role-based column visibility, and auto-refresh. Every table embeds on any page with a [tablecrafter] shortcode or the native Gutenberg block. Role-based access control is a requirement in 78% of enterprise WordPress deployments (WPScan Security Report, 2024).

How Does Field Mapping Work?

When you connect an Airtable base to TableCrafter and click Test Connection, TableCrafter reads the schema of your table from the Airtable Metadata API. It detects each field name and its declared type, then pre-configures a column for each one.

You can override TableCrafter's auto-detected column type in the Columns configuration panel. This is useful when Airtable returns a type that does not match how you want the data to render, for example, displaying a text field that contains URLs as a clickable link column.

This step completes the connection between your data source and the TableCrafter table engine. Once saved, the plugin caches the connection credentials in the WordPress options table and uses them on every subsequent page load. If you update the source configuration later — for example, rotating an API key or changing a sheet URL — return to this step, enter the new value, and save again. The table updates immediately on next load without any shortcode changes.

How Does Field Type Reference Work?

Single Line Text

Airtable API type: singleLineText

Renders as a plain text cell. Fully editable inline when edit mode is enabled. Supports live search and text-match filtering. This is the most flexible column type and works well for names, titles, identifiers, and short labels.

• Inline editing: Yes
• Search: Yes
• Filter type: Text contains

Long Text (Rich Text)

Airtable API type: multilineText or richText

Renders as a truncated text cell with a configurable character limit. TableCrafter does not render full Markdown or rich text formatting inline in the table cell, it strips formatting tags and shows plain text. If you need formatted output, use a detail panel or link to a separate page.

• Inline editing: Yes (plain text only, formatting lost on save)
• Search: Yes
• Filter type: Text contains

Number

Airtable API type: number

Renders as a right-aligned numeric cell. TableCrafter respects the decimal precision configured in Airtable. Sorting is numeric (not lexicographic). You can apply a currency prefix or suffix in the TableCrafter column settings, for example $ before or USD after.

• Inline editing: Yes (numeric input)
• Search: No (use range filter)
• Filter type: Numeric range (min / max inputs)

Single Select

Airtable API type: singleSelect

Renders as a badge-style label using the color assigned in Airtable, if color data is returned. TableCrafter maps Airtable's select option colors to CSS badge classes. For filtering, TableCrafter generates a dropdown populated with all distinct values in the column.

• Inline editing: Yes (dropdown populated with Airtable's configured options)
• Search: No
• Filter type: Dropdown select

Multi-Select

Airtable API type: multipleSelects

Returns an array of values. TableCrafter renders each selected value as a separate badge in the cell. For filtering, TableCrafter uses a multi-select dropdown so visitors can filter by one or more values simultaneously. A row appears in results if it contains any of the selected filter values (OR logic by default).

• Inline editing: Yes (multi-select input with Airtable's configured options)
• Search: No
• Filter type: Multi-select dropdown

Date and Date/Time

Airtable API type: date or dateTime

Airtable returns dates in ISO 8601 format. TableCrafter formats them using the date format configured in your TableCrafter global settings (for example MM/DD/YYYY or DD MMM YYYY). Sorting on date columns is chronological. The filter renders as a date range picker with From and To inputs.

• Inline editing: Yes (date picker)
• Search: No
• Filter type: Date range

Checkbox

Airtable API type: checkbox

Renders as a checkmark icon (checked) or dash (unchecked). TableCrafter does not render a live checkbox input in read mode to prevent accidental edits. In edit mode, clicking the cell toggles the value and saves it back to Airtable.

• Inline editing: Yes (toggle on click)
• Search: No
• Filter type: Boolean (Yes / No / Either)

Attachment

Airtable API type: multipleAttachments

Airtable returns attachment fields as an array of objects containing a URL, filename, and MIME type. TableCrafter renders the first attachment. If the attachment is an image (MIME type image/*), TableCrafter renders a thumbnail. For other file types, it renders a download link showing the filename.

• Inline editing: No (read-only; uploading files via TableCrafter is not supported)
• Search: No
• Filter type: None

Formula

Airtable API type: formula

Airtable computes formula fields server-side and returns the computed value in the API response. TableCrafter receives and displays the result, it does not see or evaluate the formula expression itself. The rendered type depends on the formula output: a formula that returns a number is treated as a number column; a formula returning text is treated as a text column.

• Inline editing: No (always read-only; formula values are computed by Airtable)
• Search: Depends on output type
• Filter type: Depends on output type

Rollup and Count

Airtable API type: rollup, count

Like formula fields, rollup and count fields return a computed value. TableCrafter displays the result as a number or text depending on the rollup configuration. These fields are always read-only in TableCrafter.

• Inline editing: No
• Filter type: Numeric range (for numeric rollups)

Linked Record

Airtable API type: multipleRecordLinks

Linked record fields return an array of record IDs from another table in the same base. By default, Airtable's API returns only the record IDs unless you request additional field data. TableCrafter resolves linked records to their primary field (the first field in the linked table) and displays those values as a comma-separated list in the cell.

• Inline editing: No (linked records cannot be modified via TableCrafter)
• Search: Yes (searches resolved primary field values)
• Filter type: Text contains

URL

Airtable API type: url

Renders as a clickable hyperlink. The link text defaults to the URL value but can be overridden with a static label in the column settings. Opens in a new tab by default.

• Inline editing: Yes (text input for the URL)
• Search: Yes
• Filter type: Text contains

Email and Phone

Airtable API types: email, phoneNumber

Email renders as a mailto: link. Phone renders as a tel: link for click-to-call on mobile. Both are editable inline when edit mode is enabled.

• Inline editing: Yes
• Search: Yes
• Filter type: Text contains

How Does Overriding Auto-Detected Column Types Work?

TableCrafter's auto-detection is accurate for most field types, but you may want to override it in specific situations:

• A Single line text field that always contains image URLs: override to Image column type so TableCrafter renders a thumbnail instead of raw text.
• A Number field representing a percentage: set a suffix of % in column settings.
• A Formula field returning a date: set the column type to Date so date range filtering works correctly.

To override, open the table configuration, find the column, and change the Column Type dropdown from Auto to the desired type.

If this step produces unexpected output, check the source data directly in the connected system. TableCrafter passes data through without modification — if a cell displays an unexpected value, the source record contains that value. Use the TableCrafter debug log (Settings > Advanced > Debug Mode) to trace the exact query sent to the source and the raw response received, which narrows the diagnosis to either a source-side or rendering-side issue.

How Does Read-Only vs. Editable Fields at a Glance Work?

Enable edit mode in the shortcode with edit="true":

[tablecrafter id="1" edit="true"]

Ensure your Airtable personal access token includes the data.records:write scope when using inline editing.

The data source connection is checked on each page load. If the source becomes unavailable — for example, if an Airtable API key is revoked or a Google Sheet is unpublished — TableCrafter displays a configurable error message rather than an empty table, so site visitors receive feedback rather than a blank page.

The shortcode accepts all column and filter settings defined in the table builder as defaults, but you can override individual parameters inline. For example, `[tablecrafter id="1" per_page="25"]` overrides the default rows-per-page setting for this specific embed without changing the saved table configuration. This lets you reuse one table definition across multiple pages with different display requirements.