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