Airtable Builder Certification flashcards
Airtable Builder Certification · Build recall with a focused review session.
32 cards. Read the term and the definition here. The deck at the top of this page is optional.
- Base
- The top-level Airtable container that groups related tables, views, automations, and interfaces into a single collaborative app with shared permissions.
- Primary field
- The first field in a table that labels each record, especially in linked record pickers; it can be renamed but not deleted or hidden.
- Grid view
- A spreadsheet-style view of a table where filters, sorts, groups, field visibility, and color rules are configured independently of other views.
- Form view
- A view that presents selected fields as a data-entry form and can only create new records, not edit existing ones.
- Single select field
- A field type that stores exactly one choice from a predefined list of colored options and can accept new options during data entry.
- Kanban view
- A board view that stacks records into columns by a single select or linked record field, useful for tracking stages of a workflow.
- Base collaborator permissions
- Access levels assigned per base: owner (full control), editor (edit records and structure), commenter (comment only), and read-only (view only).
- Attachment field
- A field type that stores one or more uploaded files per record, each with a filename, size, and optional thumbnail preview.
- Linked record field
- A field type that stores references to records in another table or the same table, optionally allowing multiple links per record.
- Lookup field
- A field that displays a chosen field's value from linked records; when multiple records are linked it returns an array of values.
- Rollup field
- A field that aggregates values across linked records using a function such as SUM, COUNT, AVERAGE, MAX, or ARRAYJOIN.
- COUNT versus COUNTA
- COUNT tallies only numeric values in an array, while COUNTA tallies all non-empty values of any type, including text and links.
- ARRAYJOIN function
- A rollup or formula function that concatenates array values into a single text string, separated by a specified delimiter.
- ARRAYUNIQUE function
- A function that removes duplicate values from an array, commonly wrapped around a lookup before aggregating or joining.
- Junction table
- An intermediate table holding two linked record fields that resolves a many-to-many relationship between two other tables.
- One-to-many link
- A relationship where one record links to many records in another table, configured by enabling multiple links on the many side only.
- Formula field scope
- Formulas evaluate per record and can reference other fields in the same record, including lookups and rollups, but not other tables directly.
- Self-linking records
- A linked record field that points to its own table, used for hierarchies such as parent tasks and subtasks.
- Interface page
- A configurable screen within an interface, set to a record review, dashboard, form, or blank layout and bound to base tables.
- Record review layout
- An interface page type that lets viewers step through records one at a time and edit fields inline in a controlled order.
- Interface element
- A building block placed on an interface page, such as a grid, list, record detail, chart, button, text, or form.
- Interface visibility rules
- Settings that restrict which records or elements a viewer sees, based on user identity, field conditions, or filters.
- Interface chart element
- A visualization bound to a table or view that requires a category field and an aggregation such as count, sum, or average.
- Interface button element
- A clickable control that can open a URL, launch a form, or trigger an update or automation to guide user actions.
- Publishing an interface
- The step of granting access to an interface via base collaborators, specific users, or a share link, with optional editing rights.
- Automation trigger
- The event that starts an automation, such as record created, record updated, record matches conditions, schedule, form submitted, or webhook.
- Record matches conditions trigger
- A trigger that fires once per record when it first satisfies the conditions and does not re-fire while it continues to match.
- Record updated trigger
- A trigger that fires when a record changes; specifying watched fields limits firing to changes in those fields only.
- Conditional action group
- An automation block that evaluates a condition and runs different action branches depending on whether it is true or false.
- Repeat group
- An automation block that iterates over a list or array, running its actions once for each item in the list.
- Find records action
- An automation action that queries a table with conditions and returns a list of matching records for later steps or repeats.
- Automation run history
- A log showing each automation run's status and the input and output of every step, used to diagnose failures.