Functions to pull in client email

Topic Labels: Formulas
435 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I will preface with saying I have a hard time with functions. Not my brain thing. So, as much as I have searched for solutions I suspect my search terms weren't correct enough to find the answer. So I am hoping someone here can help.

I need my email column in "table 1" to pull the email from "table 2" IF client is "who ever".

Ex., in the client column of '"table 1" I enter Sally. I want the email column of 'table 1" to pull Sally's email from "table 2" and add it to the email column.  If it's Dave then pull Dave's email, etc... 

My client list is growing so more clients will be added. Can this be done without using "multiple select"?

I hope I am clear in my explaining. 

Thanks in advance. 

1 Reply 1

A simpler way to achieve this in Airtable is to link your tables together using a linked record field, then create a lookup field in table1 on the email address field in table2. Now when you add a client via the linked record field, the email address will populate in the lookup field.