Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Lookup with if statement

1118 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jacob_Turley
6 - Interface Innovator
6 - Interface Innovator

Hey All!

Really hoping this can be solved!

I am building out a CRM in airtable, and I am wondering if this is possible.

So I have companies, and contacts. Contacts have a “type” i.e. primary, alternate, general etc.

There could be 20 contacts linked to a company record, but is there a way to do a lookup with an if statement(or rollup maybe?) that I can dynamically link to? Basically, I want a primary contact field on a company and have it look through all the Contacts and display the one that is the primary.

0 Replies 0