Contacts/ Company Database Management

[Shannon_Murray]

[First time Airtable user]
I am working to create a master database of contacts linked to their segments in the industry. And in those new tables I want there to be more information on the companies.

Table 1: Master contact list
I want this table to hold all contact information of the person including if their company that they work for is in the Top company list on other lists that I have. These lists are detailed statistics and information on each company in my industry.

Other tables I thought I might have are: Clients, Topp Supplement Companies, Top Raw Material companies, etc.

I need help in organizing this data to where if I go to a person. And I know they are the CEO of X company, then I can see if that company is in the other lists I have (maybe in another table?) and from there I can see all of the information I have on this company and having all of this linked…

If this makes any sense at all please let me know and if you have any suggestions that would be greatly appreciated!

Thank you!!

[Elias_Gomez_Sai]

You need to use Linked Record and Lookup fields:

Airtable Guide

Linking Between Tables - Airtable Guide

With Airtable, you can create relationships between individual records.  Building on our Martian example, we can connect our Mars supplies with the vendors that manufactured them.  This will display the name of the vendor in-line and make it easy to...

Airtable - Support

Guide to formula, lookup, count, and rollup fields

Formula, lookup, count, and rollup fields (columns) are powerful field types that allow you to compute a value based on values in other cells. These fields are configured in the field configuration...

[Hayley_Parrish]

Hi there,

I’m looking into our company upgrading to Pro version and I am wondering if there is the required restrictions and security that are in place so that the CEO is the owner, then two administrative users with full access to everything but cannot delete the the accounts and then the remaining team to be just a user or editor? So if a member of staff left the company, the information in Airtable cannot be deleted or relocated by anyone except for the owner? Is this something that can be applied to ensure the company has complete ownership of the documents?

Thank you in advance :slightly_smiling_face: