Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 25, 2018 07:37 PM
Is there a way to setup ‘is-a’ relationship among tables?
ex: We have a Person table with atttributes like email, name etc.
We want to setup Employee table that inherits all attributes of Person but has more attributes like salary etc.
Is it possible to setup “Employee is a (Inherits from) Person” relationship?
Jun 26, 2018 06:59 AM
No, you can’t. I think you have 2 options here:
Based on the nature of the base one or the other could be better.
Nov 30, 2021 10:05 AM
I am trying to utilize the lookup fields but when I go to use the result in a formula, the shortcoming is that it will create a circular reference. I have an accounts table and a parent accounts field which links to another record in the same table. Is there a way to break the circular reference in this scenario?
Nov 30, 2021 10:34 AM
Circular references are a bit of a pain in Airtable. Airtable determines if something is a circular reference based on the field definitions, not how records are actually linked. You can create a gap in the circular logic, and then use an automation to bridge that gap by having the automation copy the lookup value into an editable field. However, note that you can end up using a lot of automation runs very quickly when implementing a system like this.