Help

New Script: Same Table Linked Records Backlinks

Topic Labels: Scripting extentions
22153 64
cancel
Showing results for 
Search instead for 
Did you mean: 
openside
10 - Mercury
10 - Mercury

Explainer Video:

Base:

Code:

64 Replies 64

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
4 - Data Explorer
4 - Data Explorer

Thanks. that was it. much appreciated

Theo_Michel
6 - Interface Innovator
6 - Interface Innovator

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. : )

Antoine_Caffin
4 - Data Explorer
4 - Data Explorer

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
10 - Mercury
10 - Mercury

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

openside
10 - Mercury
10 - Mercury

actually - its the “Flow chart” app

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

Sal_Ohcin
6 - Interface Innovator
6 - Interface Innovator

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?

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

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.