Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Multiple Nested Reference Tables and Automation

Topic Labels: Base design
372 0
Showing results for 
Search instead for 
Did you mean: 

Greetings, I have a base for job hunting that I would like to share with others, but it currently requires too much manual entry to be widely practical. The structure of the base is:

Company -> Positions <-> Contacts <-> Activity

Every table is optionally linked to all the other tables.

The problem is that, let’s say I’m looking at a Contact, and I want to indicate that I spoke to someone on the phone – in the Activity record I may need to link to up to two additional tables manually (Company, and Position) even though the Contact record is already linked to a particular Company and Position.

Is there a way to automate filling in these record links so that the base is easier for folks to use?

Here is the ERD of the base for those so inclined:

0 Replies 0