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?