New Extension: Automatic Linked Records

My first ever extension just got added to the Airtable Marketplace!

Introducing: Automatic Linked Records

  • Make sure every record, old and new, is linked where it needs to be.

  • Connect Linked Record fields to Single Select fields - when that Single Select field is updated, the Linked Record field will also update.

  • Set up multiple ‘rules’ so that numerous linked record fields are updated simultaneously.

Here’s a quick video showcasing what it does.

I made Automatic Linked Records for myself as I got tired of using automations with fussy steps to make sure records were linked where they needed to be.

I’m happy to receive any and all feedback! I have an update in the works to fix some of the more obvious issues, and would love to extend the extension’s capabilities in the future, but it depends on how much people like it.

2 Likes

Welcome to the community, @heyolivehaus!

Congratulations on getting your first extension published in the Airtable Marketplace!

Your extension looks very helpful! :slight_smile:

1 Like

Thank you! That means a lot from you, Mr. @ScottWorld :saluting_face:

I’ve been working with Airtable for 3 years now, and this is exactly what I wished was available on the marketplace.

I know a similar thing can be accomplished with automations, but automations can be finnicky. This just makes sure no record is missing its links.

1 Like

Congrats on getting your extension published!

What a great reason to write your own extension.


Am I reading your website correctly that this extension is $10/base/month? Is it necessary to purchase a license before using the extension? Do you offer a trial version or limited functionality for free? (I believe that used to be a requirement that Airtable had. It would be good to know if Airtable dropped that requirement for third-party marketplace extensions.)

Is your extension designed to be always open? I assume that the extension will not run unless it will run, thus this might not be the best fit for someone who needs to use different dashboards or someone who works primarily in an interface.

I noticed in your screen shot that approximately five records are updated every five seconds. I can see how trickling updates will help minimize the impact on other interactions, but if there are thousands of records to update (such as in an initial setup), it make take a long time to get them all updated. Is there a setting to do a faster one-shot update?

What happens if there is no matching record in the target table? How does your extension handle that situation? Will it create a record, show a message, make the link whenever a matching record in the target table is created, or something else? What if the primary field value of the target table changes? Will existing links be changed?

1 Like

Am I reading your website correctly that this extension is $10/base/month? Is it necessary to purchase a license before using the extension? Do you offer a trial version or limited functionality for free? (I believe that used to be a requirement that Airtable had. It would be good to know if Airtable dropped that requirement for third-party marketplace extensions.

That’s correct. I tried to keep the pricing as simple as possible. You don’t have to purchase a license before using it. You get to use one ‘Configuration’ in the extension free.

A Configuration works like this:

  • Select a Table
  • Select a Linked Record field
  • Select one of two modes for updating the Linked Record field
  1. Linked Record Selector: Select a record from the table associated with the selected linked record field and update the field with the selected field
  2. Match to Existing Field: Select another field to ‘match’ to the linked record field whenever it updates. For instance, I use Single Select fields often. I like how they look and function better than Linked Record fields, especially for client bases. When the Single Select field is updated, that new value is added to the Linked Record field
  • Choose whether to Append the selected record to what already exists in that Linked Record field, or Overwrite it.
  • Turn it on.

(sorry for the long-winded explanation, I just thought it would paint a clearer picture)

Is your extension designed to be always open?

I’m assuming this is the case, as frankly, I’m not sure it’s possible to operate an extension without it being ‘open’. I just developed under the assumption that this had to be the case.

I suppose I could consider some sort of server ping to ‘wake’ the base and extension, but I haven’t considered it before now.

Is there a setting to do a faster one-shot update?

It depends on what Airtable ultimately allows me to do. I’ve considered batch-updates, but I’m relatively new to Airtable extension development, so I’m not entirely certain what’s allowed or possible.

I’ve toyed with the idea of unlocking faster updates when you purchase the subscription, alongside some other additional features. That way free users can still access the extension and the free Configuration, but the subscription is made more attractive.

What happens if there is no matching record in the target table? How does your extension handle that situation? Will it create a record, show a message, make the link whenever a matching record in the target table is created, or something else? What if the primary field value of the target table changes? Will existing links be changed?

The plugin updates by record ID. Based on the selected record (or, matched record), a record ID is found and updated with that record ID. So, if the primary field changes, it shouldn’t (theoretically) break the extension.

If I’m being 100% brutally honest, I coded the extension for myself and while I was rather proud of it, I didn’t know how much people would like it, so it’s versatility was limited. For instance, the ‘Match to Existing Field’ function only works with single select and date fields. It does - technically - work with Short Text and Long Text fields, and even some formula fields, but those are not offically supported.

It’s turning out to be surprisingly popular, so I will probably develop it further, but I mostly wanted to see if people were interested at all.

Thank you for the thoughtful questions, @Kuovonne. I hope this wasn’t too long-winded of a reply.

That’s not what I am seeing. The “Add Configuration” button is disabled when I first install the extension.

I don’t believe that it is possible to “wake up” an extension if its dashboard is closed.

Batch updates are possible. You should be able to submit requests in batches of 50, with up to 15 requests per second. I don’t recommend going that fast in the background because it tends to bog down anyone else using the base, but it could be useful for one-off processing on request by the user.

Congrats on your extension’s popularity!
I think you started out great–make functionality you know that you will use and then go from there. People will always want more, and trying to build everything in a first release is rarely worthwhile.

1 Like

That’s not what I am seeing. The “Add Configuration” button is disabled when I first install the extension.

Thank you so much for pointing this out. You’re absolutely right. I have been working on this to get it resolved. I believe the new payment plan may have adjusted some of the marketplace requirements, but I can’t speak to that completely. I know having unlimited extensions makes free features much more easily exploitable, so I’m experimenting with different ways of ensuring users get to give it a try before buying.

I don’t believe that it is possible to “wake up” an extension if its dashboard is closed.

I didn’t think so, but I am curious how extensions evolve as the interface does. ‘Add-ons’ are already coming to interfaces, and I’m assuming those - like ‘Workflows’ - are just rebranded extensions.

Batch updates are possible. You should be able to submit requests in batches of 50, with up to 15 requests per second. I don’t recommend going that fast in the background because it tends to bog down anyone else using the base, but it could be useful for one-off processing on request by the user.

I have been tinkering with speed upgrades to the automatic linking, but I’m trying to ensure the extension doesn’t bog down the base for other users, as you say.

Congrats on your extension’s popularity!
I think you started out great–make functionality you know that you will use and then go from there. People will always want more, and trying to build everything in a first release is rarely worthwhile.

Thank you :pray: I have quite a few projects going on, but depending on this extension’s popularity, I may devote more resources to it.

That said, I have an update incoming to fix some of the more glaring issues.

1 Like

I don’t think “workflows” are rebranded extensions. I think “workflows” are automations in Airtable-land.

1 Like

I believe I miswrote that. I’m hoping that the ‘add-ons’ that are in Interface beta are extensions in Airtable-land, kind of like how ‘workflows’ are as you said.

Or perhaps they’re opening up interface widgets so that developers can create their own widgets. I’d love that.