Skip to main content

Kind of new to using Airtable.


Let’s say I have two tables. The first table is a master table with a whole bunch of information. For purposes of this ask, I am condensing to exactly what I need to know, but ideally this table will have a lot more info based on a client. The second table is a list of people involved and their role and what clients they have.


A client can have 1 manager. But a manager can have multiple clients. So, what I want to do, is have a formula (or some other function) set up so that the Table1:Manager field auto-populates the Table2:ManagerName based on if the Table1:ClientCode value exists in Table2:Clients. I want it this way so that if clients get moved around managers, then it can update easily on my master table without as much manual intervention.


Basically:

Grab Table2:ManagerName where Table1:Clients is in Table2:Clients and insert it into Table1:Manager for Table1:ClientCode.


Table1

Name | ClientCode | Manager

GoKart | GK | ??

RollerSkate | RS | ??

FunZone | FZ | ??


Table2

ManagerName | Role | Clients

John Doe | PM | GK, FZ

Jane Doe | PM | RS


Is this possible?

You need to link your records together so you can take advantage of Lookup fields.




Seems like the {Clients} field in Table 2 should be a Link to Another Record field pointed at Table 1’s {Name} field. You could then add a lookup field to Table 2 to pull in the client’s {ClientCode}. The process of linking two tables together automatically adds a corresponding field in the other table, so when you look back at Table 2, there should be a link field already created for you for {Manager} (it will be named whatever Table 2 is named) that fills in automatically whenever you link a Manager to a Client in Table 2. Since links are reciprocal, you could also link Clients to Managers from within Table 1.

Reply


Terms & Conditions