My attempts to use a value from a Rollup field in the record Name field result in a circular reference error. Is this expected behavior or a bug?
Solved
Rollup Value in a Formula Doesn't Work
+8Best answer by Darryl_Oliver
Jacob at Airtable Support helped me resolve this. There was no obvious circular reference, but the issue was apparently caused by using formulas to create primary field names in the related table that referenced the primary field name in the host table. The circular reference was caused by the rollup because it was referencing the linked records; whose names were referencing the host table. Don't worry, I'm confused too. 😕😕
+27You haven’t provided enough detail to determine whether or not this is a bug.
What are all the relevant fields, and what are the formulas used in those fields?
+8You haven’t provided enough detail to determine whether or not this is a bug.
What are all the relevant fields, and what are the formulas used in those fields?
Rollup Formula - Formatted as currency with no decimals.
Name Formula
+8Jacob at Airtable Support helped me resolve this. There was no obvious circular reference, but the issue was apparently caused by using formulas to create primary field names in the related table that referenced the primary field name in the host table. The circular reference was caused by the rollup because it was referencing the linked records; whose names were referencing the host table. Don't worry, I'm confused too. 😕😕
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.