I have a Table with organizations. Each org has people attached to them via a People Table. Each organization has a status. One of them can be 'Contact The Organization'. How/where do I create a View to show me all the people I should contact, for all orgs. I want a grid view with columns to display Contact details such as Name, Email, Phone plus the org name they are associated with plus a few other org columns such as Status and Country.
Insights are much appreciated.
I found what I was looking for here: https://community.airtable.com/t5/other-questions/pull-in-data-from-another-table-based-on-a-linked-field/td-p/99192
In the `People` table, create a lookup field for the `Organization` table's `Status` field
From there, filter by that lookup field for the value `Contact The Organization`, which should give you a list of all the people you should contact for all orgs.
Your contact details are all there since it's the `People` table, and you can grab the other Org columns such as Country via more lookup fields
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.