I keep running into this “brick wall” because recursive structures are necessary to many of my bases because many of the data I am managing are naturally hierarchical in nature (XML, JSON, folder/directory paths, org structures, etc). I understand that endless recursion can kill the platform but I would suggest that the limitation should be done at runtime and detect a maximum # of levels of depth before giving out an error. Otherwise, this tool becomes severely limited for some applications. Here is a simple example with 1 table “Employee”: https://airtable.com/invite/l?inviteId=invD1UFeDZHdOkhuD&inviteToken=f09215f8c21ddc2de45b656c06b84fdbaaca3330f1e28b1d86190a620a3fffd2 The column Manager is a link to the same table (Employee). The column ManagerPath is a lookup to the Manager link’s Path column. The Path and ManagerPath columns are currently not correct because I cannot enter the correct formula for Path because of the “circular reference” error. The formula for the Path column should be: IF(Manager != "", ManagerPath & "->", "") & Name Given the above formula, the values of Path and ManagerPath would have been: I think this should be a valid scenario and that the recursion should be allowed (up to a pre-defined limit of levels to prevent endless recursion/loop).
... View more