Hi,
Airtable seems to only offer a lookup for a specific string. I am trying to do a lookup based on another cell’s value.
Example:
Company receives a request for one table. In turn, it needs to make a request for quotation from 3 companies for wood. So you want to a lookup that says "If (Table Request) + IF (Vendors Chosen), Lookup {Contacts: Table Request : Vendor).
As in, show me the applicable contacts that relate to this particular vendor and this particular request.
Thank you!
Airtable is a relational database software, not a spreadsheet. As such, you have to explicitly link records together for Airtable to know what you want to look up.
It sounds like you need four tables: Companies, Vendors, Requests, and Contacts. It is possible, depending on how you prefer to divy up your data, that Companies and Vendors could occupy a single table and use a “company type” field to differentiate vendors from suppliers.
The Requests table would have two link to another record-type fields: one to link to the Companies table, and one to link to the Vendors table. The Contacts table would have a link to another record-type field connected to the Vendors table (and potentially another one connecting to Companies, if you store contacts for both vendors and companies and if vendors and companies are separate tables). That way the Requests table could have a lookup-type field to pull in any linked Vendors’ contacts.
Airtable is a relational database software, not a spreadsheet. As such, you have to explicitly link records together for Airtable to know what you want to look up.
It sounds like you need four tables: Companies, Vendors, Requests, and Contacts. It is possible, depending on how you prefer to divy up your data, that Companies and Vendors could occupy a single table and use a “company type” field to differentiate vendors from suppliers.
The Requests table would have two link to another record-type fields: one to link to the Companies table, and one to link to the Vendors table. The Contacts table would have a link to another record-type field connected to the Vendors table (and potentially another one connecting to Companies, if you store contacts for both vendors and companies and if vendors and companies are separate tables). That way the Requests table could have a lookup-type field to pull in any linked Vendors’ contacts.
Thanks Kamille.
I actually have an additional table for “vendor contacts”. My problem is the below
Vendor A only sells Apples, Oranges, and Bananas & employs John Smith
Vendor Contact John Smith only sells Apples and Oranges
I have a request for Apples and I have invited Vendor A.
How can my lookup automatically bring up John Smith’s Contact info?
Best,
Karim
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
