Display a list of linked fields


#1

Now that Airtable allows self-linking, I’ve come up with an interesting situation.

Suppose I have memorized a list in a table. There is an element, a link to the next elements and a link to previous elements.

+------+------+----------+
| this | next | previous |
+------+------+----------+
| a    | b, c | -        |
| b    | -    | a, e     |
| c    | d    | a        |
| d    | -    | c        |
| e    | b    | -        |
| f    | g    | -        |
+------+------+----------+

As you can see, there’s duplication of information. For example, element “a” precedes “b” and “c” as it is clear either from reading the next field for “a” or the previous field for “b” and “c”.

How do I compute field previous from next or visa-versa?


Formula to check if a certain record exists