I85PREP
⌘ K
Airtable Builder Certification study materials
Airtable Builder Certification study resources

Airtable Builder Certification practice questions

One question at a time. Build your Airtable Builder Certification understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Airtable Platform and App Building

In an Airtable base, which field type is designed to link records in one table to records in another table?

  1. Rollup
  2. Lookup
  3. Multiple select
  4. Link to another record Correct answer.

Explanation

A link field creates the actual relationship between two tables and stores the referenced records. Lookup and rollup fields only display or aggregate values across an existing link, and multiple select stores plain text choices.

Question 2Airtable Platform and App Building

Which view type lets collaborators see records organized in columns by a single-select or linked field value?

  1. Form view
  2. Kanban view Correct answer.
  3. Grid view
  4. Calendar view

Explanation

Kanban views group records into stacks based on a chosen single-select or linked record field. Grid views present rows and columns, forms collect new entries, and calendars place records on dates.

Question 3Airtable Platform and App Building

What is the primary purpose of an Airtable interface?

  1. To define field validation rules
  2. To build a focused layout for a specific audience or workflow Correct answer.
  3. To schedule automated emails
  4. To store attachments uploaded by users

Explanation

Interfaces are purpose-built pages that present selected base data and actions to a particular audience. They do not replace field-level storage or validation, and automations handle scheduled email sending.

Question 4Airtable Platform and App Building

Which Airtable feature lets you automatically trigger actions such as sending a message or creating a record when a condition is met?

  1. Sync
  2. Extensions
  3. Automations Correct answer.
  4. Snapshots

Explanation

Automations run a trigger followed by one or more actions when conditions are satisfied. Extensions add in-base tools, sync imports data from other sources, and snapshots are point-in-time backups.

Question 5Airtable Platform and App Building

Which collaborator permission level allows a user to edit records but prevents them from changing the base structure?

  1. Owner
  2. Creator
  3. Commenter
  4. Editor Correct answer.

Explanation

The Editor permission grants record editing while restricting structural changes such as adding fields or tables. Creators and Owners can modify structure, and Commenters cannot edit records.

Question 6Airtable Platform and App Building

Which field type should be used to calculate a total of values pulled from linked records in another table?

  1. Count
  2. Rollup Correct answer.
  3. Lookup
  4. Formula

Explanation

A rollup field aggregates values across linked records using a chosen summarization method such as sum or average. Formula fields compute within a single record, Lookup returns a raw value, and Count is a summarization option rather than a field type.

Question 7Airtable Platform and App Building

What does a form view do when a respondent submits an entry?

  1. It creates a new record in the underlying table Correct answer.
  2. It stores the response only in the form layout
  3. It exports the response to a CSV file
  4. It overwrites an existing record chosen at random

Explanation

Each form submission becomes a new record in the table the form is built on. Form responses are not stored separately from the table or automatically exported.

Question 8Airtable Platform and App Building

What is the difference between a single select field and a multiple select field?

  1. Single select is required; multiple select is always optional
  2. Single select stores numbers; multiple select stores text
  3. Single select allows one value per record; multiple select allows several Correct answer.
  4. Single select links records; multiple select aggregates them

Explanation

A single select field permits exactly one choice from its options, while a multiple select field permits any number of the predefined choices. Both store text-style options and neither creates record links.

Question 9Airtable Platform and App Building

A builder wants a field that shows the number of days between a record's start date and today's date. Which field type should be used?

  1. Formula Correct answer.
  2. Created time
  3. Duration
  4. Date

Explanation

A formula field can reference the start date and use date functions to compute the elapsed time relative to today. Duration measures a fixed span, Date stores a date value, and Created time records when the record was made.

Question 10Airtable Platform and App Building

A team needs a view that only shows records where a status field equals 'Open' and that hides several sensitive columns from most collaborators. What is the best approach?

  1. Export the base to a spreadsheet each day
  2. Create a new table containing only open records
  3. Use a filtered view with hidden fields and share it with the relevant collaborators Correct answer.
  4. Delete the sensitive fields from the base

Explanation

A filtered view can limit records to those matching a condition, and hidden fields keep columns out of sight for that view. Sharing the specific view limits what collaborators see without altering the base structure.

Question 11Airtable Platform and App Building

In an automation, which component determines when the automation should run?

  1. The condition group
  2. The action
  3. The run history
  4. The trigger Correct answer.

Explanation

The trigger is the event that starts an automation, such as a record being created or a schedule firing. Actions define what happens, conditions refine behavior, and run history logs past executions.

Question 12Airtable Platform and App Building

A base has an Orders table linked to a Customers table. A builder wants each order record to display the customer's email, which lives in the Customers table. Which field should be added to Orders?

  1. A rollup on the email field
  2. A formula referencing a text field named email
  3. A lookup on the email field through the link Correct answer.
  4. A count of linked customer records

Explanation

A lookup field follows an existing link and returns a field value from the linked record, which fits displaying the customer email. A rollup aggregates rather than retrieves a single value, and a formula cannot read across a link without a lookup.

Question 13Airtable Platform and App Building

What happens to records in a table when a collaborator uses a form view to submit data?

  1. They are added as new rows in the table Correct answer.
  2. They are saved to a separate responses table
  3. They remain pending until an owner approves them
  4. They replace the oldest existing row

Explanation

Form submissions are appended as new records in the table the form is based on. There is no automatic replacement, separate response table, or approval step unless one is built with automations.

Question 14Airtable Platform and App Building

A builder needs two tables to reference each other so that a project can list its tasks and each task can show its project. What is the recommended approach?

  1. Create two separate one-way links that are not connected
  2. Use a lookup field in each table
  3. Create a single link field and enable the symmetric link option Correct answer.
  4. Use a multiple select field in each table

Explanation

A link field can be configured to create a matching field in the other table, keeping both sides in sync as a single relationship. Separate unconnected links or select fields would not maintain the relationship automatically.

Question 15Airtable Platform and App Building

Which interface element would a builder add to let interface users create a new record directly from the interface?

  1. A number element
  2. A chart element
  3. A record picker element
  4. A form element Correct answer.

Explanation

A form element in an interface lets users submit new records into a chosen table. Charts display data, record pickers select existing records, and number elements display numeric values.

Question 16Airtable Platform and App Building

A builder wants to restrict a shared view so external viewers cannot see records outside their region. Which approach best supports this?

  1. Hide the region field in a single shared view
  2. Send a CSV export of all records to each viewer
  3. Create a filtered view per region and share each view with the matching audience Correct answer.
  4. Rely on viewers to filter the view themselves

Explanation

Separate filtered views, each shared only with the relevant audience, limit what each group can see. Hiding a field does not hide records, and relying on viewers or exporting full data does not enforce the restriction.

Question 17Airtable Platform and App Building

Which statement about Airtable extensions is accurate?

  1. They add tools such as charts or maps that work with base data Correct answer.
  2. They are required to create a form view
  3. They permanently alter field types in the base
  4. They replace automations for sending notifications

Explanation

Extensions are add-on tools, such as chart, map, or summary tools, that operate on data in the base. They do not change field types, replace automations, or gate the use of form views.

Question 18Airtable Platform and App Building

A builder wants a formula field to return 'Overdue' when a due date is before today and 'On track' otherwise. Which function best supports the comparison?

  1. ROUND
  2. CONCATENATE
  3. LEN
  4. IF Correct answer.

Explanation

The IF function evaluates a logical condition and returns one value when true and another when false, which fits this branching logic. CONCATENATE joins text, ROUND adjusts numbers, and LEN counts characters.

Question 19Airtable Platform and App Building

What is the effect of setting a field as required in a form view?

  1. The field is hidden from all respondents
  2. The field is automatically filled with the previous response
  3. The field becomes a linked record field
  4. Respondents must provide a value before submitting Correct answer.

Explanation

Marking a form field as required prevents submission until the respondent supplies a value. It does not hide the field, prefill from prior responses, or change the field type.

Question 20Airtable Platform and App Building

A builder wants a rollup field to show the latest order date among a customer's linked orders. Which rollup aggregation should be chosen?

  1. SUM
  2. AVERAGE
  3. MAX Correct answer.
  4. ARRAYJOIN

Explanation

MAX returns the greatest value among the linked records, which for dates is the most recent one. SUM and AVERAGE combine values numerically, and ARRAYJOIN concatenates values as text.

Question 21Airtable Platform and App Building

Which configuration in an automation ensures an action runs only when a record's status equals 'Approved'?

  1. Disable the automation's run history
  2. Add a second trigger after the action
  3. Add a condition on the status field before the action Correct answer.
  4. Change the action to a delay step

Explanation

A conditional check placed before an action prevents that action from running unless the condition is met. Additional triggers, disabling history, or adding delays do not enforce the status check.

Question 22Airtable Platform and App Building

A builder needs a count of how many linked records exist for each record in a parent table. Which approach is most direct?

  1. A single select field listing record names
  2. A formula field using LEN
  3. A lookup field on the primary field
  4. A rollup field using COUNT on the link Correct answer.

Explanation

A rollup field with the COUNT aggregation returns the number of linked records per parent record. LEN counts characters, lookups return values, and select fields do not count links.

Question 23Airtable Platform and App Building

A builder wants to prevent users from entering a value in a number field that exceeds 100. Which field setting should be used?

  1. A default value of 100
  2. A validation rule with a maximum value Correct answer.
  3. A description on the field
  4. A conditional color rule

Explanation

Validation rules enforce acceptable input by rejecting values that violate the rule, such as exceeding a maximum. Defaults, color rules, and descriptions do not block invalid entries.

Question 24Airtable Platform and App Building

A base uses a formula field that references a lookup field to compute a total. A collaborator reports the total is blank for some records. What is the most likely cause?

  1. Those records have no linked records, so the lookup returns no value Correct answer.
  2. Formula fields cannot reference lookup fields
  3. The formula field type must be changed to rollup
  4. The base has exceeded its field limit

Explanation

A lookup returns a value only when linked records exist, so records without links yield no value and the dependent formula evaluates to blank. Formulas can reference lookups, and this is not a field-type or field-limit issue.

Question 25Airtable Platform and App Building

A builder shares a base with a group that should view records but never edit them, while internal staff need editing rights. Which combination best satisfies both requirements?

  1. Give everyone Editor access and rely on trust
  2. Give the group Commenter access and staff Owner access
  3. Give everyone Creator access and hide the edit buttons
  4. Give the group a read-only shared view link and give staff Editor access Correct answer.

Explanation

A read-only shared view restricts external viewers to viewing, while Editor access lets internal staff modify records. Broad Editor or Creator access would allow the group to make changes it should not.

Question 26Airtable Platform and App Building

Which Airtable object stores records as rows and fields as columns?

  1. A workspace
  2. An interface
  3. An automation
  4. A table Correct answer.

Explanation

A table is the fundamental container of records in an Airtable base, where each row is a record and each column is a field. Workspaces hold bases, interfaces present data, and automations act on data.

Question 27Airtable Platform and App Building

Which field type lets a user pick exactly one value from a predefined list of colored options?

  1. Attachment
  2. Checkbox
  3. Single select Correct answer.
  4. Multiple select

Explanation

A single select field constrains entry to one predefined choice from a configured option list. Multiple select allows several choices, a checkbox is binary, and attachments hold files.

Question 28Airtable Platform and App Building

What is the primary purpose of a view in Airtable?

  1. To control which collaborators can log in to the base
  2. To permanently change the field types of a table
  3. To create a separate copy of the table's records
  4. To display the same underlying records with different filters, sorts, and layouts Correct answer.

Explanation

Views are saved presentations of the same records, letting builders apply filters, sorts, groupings, and layouts without duplicating data. They do not copy records or alter field types.

Question 29Airtable Platform and App Building

A builder wants to import a spreadsheet of contacts into a new base. Which action accomplishes this?

  1. Create a base from a CSV file upload Correct answer.
  2. Enable a sync integration to a third-party app
  3. Convert an existing interface into a table
  4. Add a new workspace and invite collaborators

Explanation

Airtable can create a base directly from an uploaded CSV file, mapping each column to a field. Workspaces, interfaces, and syncs do not import tabular files in this way.

Question 30Airtable Platform and App Building

Which collaboration feature lets teammates leave comments on a specific cell?

  1. Cell-level comments Correct answer.
  2. Revision history
  3. Base sharing links
  4. Field descriptions

Explanation

Airtable supports comments attached to individual records and cells so collaborators can discuss specific data. Field descriptions document fields, revision history tracks edits, and sharing links grant access.

Question 31Airtable Platform and App Building

What does a gallery view primarily emphasize when displaying records?

  1. A kanban board grouped by a select field
  2. A calendar of dated records
  3. Large visual cards, often with a featured image Correct answer.
  4. Dense spreadsheet-style rows

Explanation

Gallery view renders each record as a card, and it can feature an attachment field as a cover image. Grid, calendar, and kanban are separate view types with different layouts.

Question 32Airtable Platform and App Building

Which statement describes how a linked record field behaves?

  1. It restricts a field to a fixed list of colored options
  2. It connects records in one table to records in another table and can be configured to allow multiple links Correct answer.
  3. It performs arithmetic on values in the same record
  4. It stores a static text copy of a value from another table

Explanation

Linked record fields create relationships between tables, and the field can be set to allow one or many linked records. Lookups and rollups surface linked data, while formulas compute values.

Question 33Airtable Platform and App Building

What is the effect of grouping records in a grid view?

  1. Records are exported to a separate base automatically
  2. Records are collected under shared field values with collapsible group headers Correct answer.
  3. Records are deleted if they share a value
  4. Records are permanently merged into single rows

Explanation

Grouping organizes records into sections based on shared values in a chosen field and adds collapsible headers. It does not merge, delete, or export records.

Question 34Airtable Platform and App Building

A builder wants a formula field to combine a first name and last name field with a space between them. Which approach works?

  1. Use the concatenation operator or a concatenation function to join the two fields with a space Correct answer.
  2. Use a multiple select field with both names as options
  3. Use a lookup field pointing at the same table
  4. Use a rollup field that sums the two text fields

Explanation

Formula fields can join text using concatenation, for example with the & operator or a concatenation function, inserting a literal space between values. Rollups, lookups, and selects do not join text within a record.

Question 35Airtable Platform and App Building

A builder needs a view that shows only records created this week, but the filter should not affect other views of the same table. Which approach is correct?

  1. Create a new table containing only this week's records
  2. Delete records older than one week from the table
  3. Add a filter condition using a date-based condition in that view only Correct answer.
  4. Change the primary field to a date field

Explanation

Filters are scoped to the view they are configured in, so other views of the same table are unaffected. Deleting records or duplicating tables changes data rather than presentation.

Question 36Airtable Platform and App Building

What does a lookup field return when the linked record's source field is empty?

  1. An error message in the cell
  2. The text 'null'
  3. A blank value for that record Correct answer.
  4. A zero value

Explanation

A lookup surfaces the value of the source field through the link; when the source is empty, the lookup shows blank. It does not substitute zero, errors, or placeholder text.

Question 37Airtable Platform and App Building

A builder wants each record in a Projects table to show the number of related Tasks. Which field setup achieves this?

  1. A single select field listing task quantities
  2. A formula field that counts the characters in the project name
  3. A rollup field over the linked Tasks field using a count aggregation Correct answer.
  4. A checkbox field marked when tasks exist

Explanation

A rollup aggregates values from linked records, and counting the linked records yields the number of related tasks. Formulas on local text and select fields cannot count linked records.

Question 38Airtable Platform and App Building

A builder wants a number field to display currency values with two decimals. Which configuration accomplishes this?

  1. Add a filter condition to the view
  2. Convert the field to a single line text field
  3. Change the table's primary field
  4. Set the field's number format to currency with two decimal places Correct answer.

Explanation

Number fields offer formatting options such as currency and decimal precision, which change display without altering stored values. Text conversion, filters, and primary field changes do not format numbers.

Question 39Airtable Platform and App Building

How does Airtable handle a formula field that references a field which is later deleted?

  1. The formula becomes invalid and reports an error until it is updated Correct answer.
  2. The deleted field is automatically recreated
  3. The entire table is locked from editing
  4. The formula silently substitutes a blank value

Explanation

Formulas depend on the fields they reference; removing a referenced field breaks the formula and produces an error that must be corrected. Airtable does not recreate fields or lock the table.

Question 40Airtable Platform and App Building

A builder wants records in a Tasks table to be sorted so the highest-priority items appear first in one specific view. What should be configured?

  1. A sort on the priority field within that view Correct answer.
  2. A grouping on the assignee field within that view
  3. A new field that stores the sort order permanently
  4. A filter on the priority field within that view

Explanation

Sorts order records within a view based on a chosen field and direction, and they apply per view. Filters hide records, grouping organizes them, and no extra field is needed.

Question 41Airtable Platform and App Building

Which statement accurately describes the relationship between a base and its tables?

  1. Tables in a base cannot reference each other
  2. A base can contain only one table at a time
  3. A table can belong to several bases simultaneously
  4. A base can contain multiple tables that can be linked to one another Correct answer.

Explanation

A base is a collection of tables, and those tables can be linked to form relationships. A base is not limited to one table, and a table lives within a single base.

Question 42Airtable Platform and App Building

A builder wants a form to collect an email address and ensure it is a valid email format. Which configuration helps?

  1. Mark the field as a multiple select
  2. Add the field to a gallery view
  3. Use a single line text field with no validation
  4. Use an email field type for that question Correct answer.

Explanation

The email field type validates that entered values match an email address pattern. Plain text fields accept any string, and select fields and gallery views do not validate email format.

Question 43Airtable Platform and App Building

A builder wants to see which records were modified in the last day across a table. Which feature is most appropriate?

  1. A gallery view with a cover image
  2. A rollup field counting linked records
  3. A view filtered on the last modified time field with a relative date condition Correct answer.
  4. A single select field marking status

Explanation

Airtable tracks last modified time, and a view filter with a relative date condition can show records changed within the last day. Rollups, gallery layouts, and select fields do not track edit recency.

Question 44Airtable Platform and App Building

A builder wants to display a chart summarizing records by status inside a base. Which feature provides this?

  1. A formula field that outputs an image
  2. An extension that renders a chart from table data Correct answer.
  3. A checkbox field labeled chart
  4. A linked record field pointing to a charts table

Explanation

Airtable extensions add functionality such as charts and summaries that read from table data. Formulas, links, and checkboxes cannot render aggregate visualizations.

Question 45Airtable Platform and App Building

A builder wants a view where records are arranged in columns by stage, and each record can be dragged from one column to another. Which view type fits?

  1. Calendar view using a date field
  2. Kanban view grouped by the stage field Correct answer.
  3. Form view collecting stage values
  4. Grid view sorted by the stage field

Explanation

Kanban view stacks records into columns based on a grouping field and supports dragging records between stacks to change the value. Grid and calendar views do not provide drag-between-stacks behavior, and forms collect input.

Question 46Airtable Platform and App Building

A builder needs to copy selected records from one table into another table while keeping field mappings. Which capability supports this?

  1. Adding a filter to the destination view
  2. Copying and pasting records between tables with field mapping Correct answer.
  3. Renaming the destination table
  4. Changing the primary field of the source table

Explanation

Airtable allows records to be copied and pasted between tables, mapping source fields to destination fields during the paste. Renaming tables or filtering views does not transfer data.

Question 47Airtable Platform and App Building

A builder has a formula that returns a blank result even though the referenced lookup field appears populated in the grid. Which cause is most likely?

  1. The lookup returns multiple values, so the formula must handle an array of values Correct answer.
  2. The view is sorted incorrectly
  3. The table has exceeded its record limit
  4. The formula field type cannot reference lookup fields at all

Explanation

When a lookup resolves to multiple linked values, it produces an array, and formulas must account for multiple values rather than assuming a single value. Sorting and record limits do not cause blank formula output in this way.

Question 48Airtable Platform and App Building

A builder wants to ensure a linked record field in a child table points to exactly one parent record. Which configuration achieves this?

  1. Convert the linked field to a single select
  2. Limit the linked record field to a single record Correct answer.
  3. Add a filter to the child table view
  4. Enable a rollup on the linked field

Explanation

Linked record fields can be configured to allow only one linked record, enforcing a one-to-one or many-to-one relationship. Rollups, selects, and filters do not constrain the number of links.

Question 49Airtable Platform and App Building

A builder wants a single field to show a running total of values across records ordered by date. Which approach is most appropriate?

  1. Use a form view to recalculate totals on submission
  2. Use a multiple select field listing totals
  3. Use a checkbox field to mark completed records
  4. Use a formula or rollup in combination with a view sorted by date and grouped appropriately Correct answer.

Explanation

Running totals require ordering records by date and aggregating cumulatively, which is achieved by combining sorts and groupings with formula or rollup logic. Checkboxes, selects, and forms do not compute cumulative sums.

Question 50Airtable Platform and App Building

A base has a rollup that sums order amounts, but the total is lower than expected. Which explanation is most plausible?

  1. The table has too many views configured
  2. Some linked records are missing values in the field being summed, so they contribute nothing Correct answer.
  3. The rollup field type cannot sum numeric values
  4. Rollups always round values down to the nearest ten

Explanation

Rollups aggregate only the values present in linked records; blank values in the source field are skipped and reduce the apparent total. Rollups can sum numbers, and view count does not affect results.