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?
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.
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.
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?
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?
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.