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 nested ‘Link to another record’ fields are not supported currently.
To set it up, follow these simple steps:
First, you need a ‘Link to another record’ field in your Airtable table. For these examples, I will link a users table to my Post table, as shown in the screenshot below:
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’).
The second option is unavailable if the ‘Allow linking to multiple records’ option is unchecked in the ‘Link to another record’ field settings. This option will be useful if you want to map a ‘Link to another record’ field with an ACF repeater field.
To use it in the best way, here are 2 examples of usage:
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 :
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.
The mapping allows you to find the data from the linked table. You can now map the email with a Post Author.
After completing your mapping synchronize everything, you now have all your posts with their dedicated Author !
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]’.
I have created a custom Post Type with ACF where I want to display my Users informations.
Back in the Air WP Sync plugin, again, make sure you selected the main table, not the linked one.
Map your Linked records with ACF properties.
This will allow you to display every informations from you linked records !