- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 29, 2022 05:51 AM
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.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 30, 2022 02:04 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 30, 2022 01:45 AM
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-...
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 30, 2022 02:04 AM
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
