New Script: Same Table Linked Records Backlinks

[openside]

Explainer Video:

Base:

Airtable

Same Table Backlinks - Airtable Universe

Title: Same Table Backlinks License: MIT Author: Openside (Team behind On2Air products and BuiltOnAir community) Sites: https://openside.com - Openside...

Code:

gist.github.com

https://gist.github.com/on2air/b68450a877ab99fe4a93ef7f9c387568

same-table-backlinks.js

/*****
 * Title: Same Table Backlinks
 * License: MIT
 * Author: Openside (Team behind On2Air products and BuiltOnAir community)
 * Sites:
 * https://openside.com - Openside Consulting Services
 * https://openside.com/#products - On2Air Products
 * https://builtonair.com - All things Airtable Community
 * 
 * Reach out for all your Airtable needs

This file has been truncated. show original

[Justin_Barrett]

It looks like your code ends at line 8. You only copied and modified the configuration portion, which is useless without the rest of the code after it.

[Jordan_Toplitzk]

Thanks. that was it. much appreciated

[Theo_Michel]

Thanks for sharing @Paul_Warren! I understand now, although I have reservations about the fact that it runs the full table fixup on each change, but that probably isn’t actually such a big deal. I also would like to support multiple parents/children for each record.

To that end, I created a script that tries to automatically create backlinks based on the pattern that @Justin_Barrett suggested. (storing the previous version of the back/forward links and using them to calculate the diff after a change) I welcome any feedback y’all might have. : )

gist.github.com

https://gist.github.com/theomichel/855ba66396c4a0101f0f4d3e667158b3

backlinks.js

/*
* This script attempts to automatically create back-links for an Airtable linked record
* that references the same table. It supports an arbitrary number of links per record. 
* It is susceptible to race conditions if multiple changes are made in quick succession.
*/


function setDifference(setOne, setTwo)
{
    setOne = setOne != null ? setOne : [];

This file has been truncated. show original

[Antoine_Caffin]

Hello @openside, this script is awesome!
I have a question about the Family relations graph that you are showing at 1:30 in the video:
how can I build this? I don’t find it in the apps…

Thanks for you help

[openside]

Thanks @Antoine_Caffin - I believe that is the “Org Chart” app

[openside]

actually - its the “Flow chart” app

[Antoine_Caffin]

thanks!
yes that’s the one…
not awesome to build a family tree, but it’s a start :slightly_smiling_face:
++

[Sal_Ohcin]

I am noticing that some of the records disappear when I Run the script. And then re-appear when I run the script again. Strange bug… not sure I understand why. Anyone come across this?

[openside]

Im guessing you have a filter that is showing/hiding them based on the updates.

[Sal_Ohcin]

I don’t have an Airtable filter applied to that spreadsheet.
The table is setup to allow linking of multiple records… not sure if that is causing the problem.
I could try to share a screenshot if that’s helpful.