Skip to main content
Besides posting data into an Airtable, you can also use the Airtable Search Table Records to pull data out of Airtable. For example, if your team stores a product inventory database in Airtable, you can use this steptype to look up a particular product in that database and return quantities of those products currently in stock.

​
Step Configuration

In addition to the general step configuration options, this step has the following specific options that can be configured.

​
Base IDs and Table IDs in Airtable

When viewing a table in Airtable directly, the URL can be broken down into 3 parts. You will need the Base ID and Table ID to configure this Airtable steptype. Breaking down the Airtable URL

​
Base

Use this field to set the Base ID for the database to be searched.

​
Table

You can use this field to specify the Table’s ID in Airtable you need to search.

​
Manual Query

This section will only appear after entering the Base and Table information.
This Airtable steptype can construct an Airtable search query using FlowEQ’s criteria logic feature. But you can activate this switch to bypass Criteria Logic and write your own Airtable query from scratch. With Manual Query turned on, you will have the option of placing Placeholders into the query. These placeholders are text entry fields presented to your team in Sidekick to complete. This allows you to construct the majority of the query and your team to provide the unique strings actually to search with.

​
Fields to Display in Sidekick

This section will only appear after you’ve properly configured a Base and Table.
Here you can specify which fields from Airtable you’d like to display to your team in the Search Results in Sidekick. This is useful for presenting only the information they need to pick the right record rather than potentially overwhelming them with the entire Airtable record.

​
Define Search Criteria

You can either use an advanced Airtable Formula to define your search criteria or use the Criteria Logic feature below to build out your search conditions.

​
Airtable Formula

Here you can see a representation of the Airtable search formula as it is being constructed by the Criteria Logic feature below.

​
Criteria Logic

With Criteria Logic, you can construct the logic arguments to search Airtable. This feature works similarly to how logic arguments work in Zendesk’s automations and triggers. In the ALL or ANY conditions, you can click Add New Criteria to create new arguments by filling in the following fields.

​
Field

Select the Airtable field you would like to search

​
Condition

Select the condition you want to compare against the Airtable field.

​
Value

Enter the value for the preceding field and condition fields to match. Here you can also use FlowEQ variables to pull in information from your CRM or other systems connected to FlowEQ.

​
Run Airtable Query

Click this button to test the Airtable query you have constructed.
This query will not work if CRM variables have been used in the query since Flow Builder is outside of your CRM, so there is no CRM field to pull this value from. For a successful test, we recommend replacing this variable with the actual value that would be rendered in its place.

​
Airtable Variables

After running the Airtable Search Table Records step, FlowEQ will create several variables you can use in later steps in your Flow. These will have the following format: 
<%= airtable.record.<Column Name> %>
So for example, if your Airtable table has a column named “Product Name”, you can reference the value in that column from the selected record using the following variable: 
<%= airtable.record.Product Name %>
If your column name has any of the below special characters, they will be replaced with an underscore (-) in the variable name:
  • / (forward slash)
  • . (period)
  • [ (left bracket)
  • ] (right bracket)
  • * (asterisk)
  • ` (backtick)
Last modified on January 27, 2026