Not within the same table, unfortunately. Almost all other database apps offer this functionality natively, so it’s definitely not a silly question at all. It’s actually a necessity in database apps!
Unfortunately, the only way you could do this within Airtable would be to run a script to do it. Here’s a sample script: https://builtonair.com/script/same-table-linked-records-backlinks/
You could also do with an external automation app like Make, but scripting is likely the quickest & easiest way to do this.
Separate Relation and Organization tables can solve this problem.
Record links in the same table will not generate bi-directional links.
Add the following fields to the relation table
Organization name(Primary)
Type: Formula
Formula: {Organization}
Organization
Type: Link to another table
Link: Organization table (single)
Customers
Type: Link to other tables
Link: Organization table (multiple)
Key Customer of
Type: Lookup
Linked record field to use for lookup : Organization
Editor field you want to look up : Customers
@Anna11 wrote:
When there is a link field that links to records within the same table, is there a way to show the records that are linked FROM (as well as linked TO)?
Airtable does NOT have native support for backlinks to same-table links. However, you can maintain same-table backlinks using two same-table link fields and automation scripts. I sell scripts to maintain same-table backlinks on my Gumroad store. This package includes both a button script that you can run to set up your initial backlinks, and an automation script for ongoing maintenance of the two linked record fields.
Note that the script that @ScottWorld linked to does not include an automation script for maintaining links, and does not take advantage of features like Script settings because they were released after that script was written. While it is useful for initially setting up a backlink field, it will not maintain it for you automatically.
Very cool, @kuovonne! I didn’t know you had a script for this! Looks like you have multiple great scripts here.
p.s. @kuovonne You had a typo in your first few words. You meant to say “Airtable does NOT have native support.”
p.s. @kuovonne You had a typo in your first few words. You meant to say “Airtable does NOT have native support.”
Thanks for the catch. I was typing late last night while also taking care of last minute things for a major trip.
Thanks for the responses, @ScottWorld and @kuovonne (and @ScottWorld, I didn't think it was a silly question 😂)! This seems like a major gap in Airtable's functionality and not difficult to add from a technical standpoint - does anybody know if it's on the roadmap?
Airtable doesn’t release its roadmaps, even to its top Airtable consultants like myself.
Sadly, Airtable is also a very customer-hostile company. I have rarely seen them implement any customer feature requests in the last 6 years. Unfortunately, they are by far the worst software company in terms of customer and consultant relations that I have ever dealt with in my entire life.
For a more professional database app that has this functionality natively built into it, you can always turn to FileMaker. Contact me if you need referrals to FileMaker developers, since I no longer do that anymore.
I would say that there is a 99.999% chance that this feature will never make it into Airtable.