How to use Airtable “Link to another record” field with Air WP Sync

In Airtable, the “Link to another record” feature allows you to establish powerful data relationships. You can create connections between fields, records, and perform calculations seamlessly. Our Air WP Sync plugin now supports the “Link to another record” functionality in Airtable.

⚠️ Please note that we only support one level deep in “Link to another record” fields.

To set it up, follow these simple steps.

In Airtable

First, you need a “Link to another record” field in your Airtable table. For these examples, I will link a Users table to my Posts table, as shown in the screenshot below:

In Air WP Sync Pro

In the plugin, you will need to allow including “Link to another record” field(s):

⚠️ Note that mapping with a “Link to another record” field might significantly increase synchronization time.

After it’s done, in the mapping settings, each “Link to another record” field creates a group in the selection list (“→ Relationship Name”).

Within this group, you have the option to choose between selecting the first linked entry or all entries (“[All records] Field Name”).

To use it in the best way, here are 2 examples of usage:

Synchronize Post with Users

Have you ever wanted to import multiple posts into WordPress while assigning them to different Authors? Our plugin now allows you to do that.

In this example, we’ll see how to synchronize posts from Airtable, assign them to users, and set their status. After using the functionality, you can assign each user to a post author.

To do so, follow these steps.

Airtable settings

Within the settings, ensure you’ve chosen the main table, not the linked table. After selecting the main table, fields from the linked table will become available in the mapping selection list.

Field mapping

The mapping allows you to find the data from the linked table. You can now map the email with a Post Author.

Synchronize

After completing your mapping synchronize everything, you now have all your posts with their dedicated Author !

Link multiple records to ACF Repeater field (Pro+)

You can now use an ACF Repeater field to display data from your linked base. When mapping with an ACF Repeater field, you can only select Airtable fields prefixed with ‘[All records]’.