Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Oct 09, 2020 04:05 PM
This is not possible to do in AirTable.
It results in Circular Reference.
My main table has over 200 fields so I was trying to build a “relief” sister table to take some of the fields and move them. So each table individual records would be linked. Every time I create a record in Main table with 150 fields (filled and computed fields), the sister table would have a linked record created and I would fill in some of 50 fields (some are computed).
It all worked until but now I am at the end of the effort and found out I can’t do that because it creates a circular reference.
From what I see, circular reference in AirTable is different from circular reference in Excel. I paid attention to make sure I don’t create the type of circular reference one would get in Excel. But with linked Tables in AirTable there is another aspect that needs to be taken into consideration, and that is the PRIMARY field of table because that Primary field can’t be computed using a Formula IF the result of the field is computed from another field from a linked table.
The drawing shows my situation but of course much simplified to give the general idea.
The reason I was doing it to have less fields in the Main Table. Yes, I can use Views etc… but it’s just difficult to deal with many fieds in AirTable, because:
Anyhow, I am not complaining about it, I am just explaining the reasons I was going to build this structure to have that sister table to way I have designed it.
Solution: There is a solution to this where I would use Automation in TABLE_AAA to COPY contents from Field_51 into another “staging” field, let’s call it Field_51_staging_field. then Automation would copy the contents from Field_51 into Field_51_staging_field. Then I can use the formula in Field_1 to point to Field_51_staging_field.
It’s a crazy work-around but I don’t know what else would be a solution… other than move the fields from the Sister table back to the Main table.
Let me know if there is anything else that could be used to resolve.
UPDATE:
OK, never mind. I gave up on this setup and have merged both tables back into one. AirTable is not Excel and what I was trying to do is not how AirTable works. So that’s fine.