Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Complex (for me) Structure question

Topic Labels: Formulas
Solved
Jump to Solution
583 2
cancel
Showing results for 
Search instead for 
Did you mean: 

OK, hope someone can help here:

I have a table names “ProdCo” - companies I’m following: In this table, I have a field named “Owner” - that links to a table - same name - where I put, among other things - email addresses:

I now want to target certain companies for a sales initiative. I made a “check box” field in “ProdCo.” table to tag these companies.

My question: How can I most efficiently generate a list of these Companies with their owners with their email addresses, I cannot for the life of me figger that out.

Thanks in advance for any thoughts, Perry

1 Solution

Accepted Solutions

You can use a Look Up field (in the ProdCo table) to pull the Owner’s email address through from the Owner’s table. You can then use a Filter to filter out those companies that you don’t want to target. You can also hide any fields that you don’t wish to see, so perhaps you only show the company name, the owner and the owner’s email address. You can then save this configuration as a View.

See Solution in Thread

2 Replies 2

You can use a Look Up field (in the ProdCo table) to pull the Owner’s email address through from the Owner’s table. You can then use a Filter to filter out those companies that you don’t want to target. You can also hide any fields that you don’t wish to see, so perhaps you only show the company name, the owner and the owner’s email address. You can then save this configuration as a View.

Thank you, worked like a charm :raised_hands:t2: