Same Table Backlinks

Explore

Title: Same Table Backlinks

License: MIT

Author: Openside (Team behind On2Air products and BuiltOnAir community)

Sites:

https://on2air.com - On2Air Products

https://builtonair.com - All things Airtable Community

https://openside.com - Openside Consulting Services

​

Reach out for all your Airtable needs

​

Explainer Video: https://www.loom.com/share/9f90bb7bf95b4581a12a9750edb3a376

​

UPDATE: We now have an automatic linking feature - https://on2air.com/content/on2air-help-center/app-documentation/actions/function-single-table-linked-records-sync-backlinks - plus 60+ more Airtable functions in the On2Air Actions app.

​

https://on2air.com/on2air-actions/

​

Here's a tutorial: ++https://on2air.com/content/on2air-help-center/more-details/tutorials/how-to-create-links-to-records-in-the-same-table++

​

​

Description: Typically when creating a Linked Records to another table, it will auto-create a field on the other table holding the backlinks back to the current table. However, when creating links within the same table, it does not generate the 2nd backlink field.

​

This script will do that for you. This is useful to see where a single table linked record field is in use within the same field.

​

Instructions: Configure the links array below with the information to generate the links. If no links are configured, it will ask for user input, so its ok to leave blank.

​

The 3 configuration items are:

table: The table name containing the linked record

view: (Optional) if set, then will filter records to check based on the view

source: The field name that is a linked record to the same table that is what you are already updating. This field does not get modified.

dest: The destination field that will determine all the places each record is used as a source. This field will get replaced each time script is ran

Explore
Updated January 25, 2022 at 9:06 PM
Copied 417 times

Dan Fellars

Founder at On2Air Airtable Apps to run your business https://on2air.com
Explore the base
Grid view
Grid view