List records

List records from table in base

List records from table in base 

records[].id
records[].createdTime
records[].fields.name

Airtable combines the power of a database with the simplicity of a spreadsheet. With Ultradox you can create apps and automations on top of Airtable.

Prerequisites

  • You'll need an Aritable in order to use this building block
  • Creating a new Airtable account is very easy and you can sign up for free

Use cases

  • Compile and send reports
  • Perform calculations and updates on records

Authorization

When using Airtable building blocks for the first time you will have to connect Ultradox to your Airtable account.

Check out the Overview to get detailed instructions how to connect.

Configuration

Click on the bold text in the title of the building block to open the configuration dialog.

Filter by Formula

Airtable provides a powerful query language to list records matching a formula.

The following list gives a few examples how to query records based on the Restaurant Field Guide template:

Query

Description

name = "Slider Bar"

Load all records where the name column matches Slider Bar

name = "${restaurantName}"

Load all records where the name column matches the value of the restaurantName variable.

FIND("Cafe", name)

Load all records where the name column contains the string Cafe

FIND("${substring}", name)

Load all records where the name column contains the value of the variable  substring

FIND(RECORD_ID(), '[${foreach fields.goodOptionsFor entry , }"${entry}"${end}]')

Loads all records from the Special Diets table that are referenced from the Good Options For: column in the Restaurants table.

This example assumes that you've loaded a single record from the Restaurants table in a previous block.

Questions and Feedback

If you have any comments on this page, feel free to add suggestions right to the Google document that we are using to create this site.

If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.

Last Updated: 3/5/18