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.

Input from multiple tables

Solved
Jump to Solution
1343 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Nik
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I am trying to create a table that has one input field - the name of a product. This field is used to look up the article number of the product from another table - the catalogue.

I then want to use the article number to look up data from a third table, which will tell me whether this product is in stock or not. I don't want to use a second input field to keep the use of the table as simple as possible.

Can you help me out with a solution to my problem?

Thank you for your help in advance.

1 Solution

Accepted Solutions
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

@Nik Here's a sample table structure with the inventory lookup:

Product Lookup Table. Simply search for product name and it returns whether in stock or not.

Screenshot 2023-11-02 091220.png

 

Catalogue Lookup Table. Converts product names into SKUs

Screenshot 2023-11-02 091302.png

 

Product Inventory Table. Converts SKU's into whether product is in stock or not.

Screenshot 2023-11-02 091316.png

 

Let me know if that works for you! 

See Solution in Thread

3 Replies 3
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @Nik can you share some screenshots of your current setup / table structure? Helps us to better visualize what you're trying to achieve. Thanks!

Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

@Nik Here's a sample table structure with the inventory lookup:

Product Lookup Table. Simply search for product name and it returns whether in stock or not.

Screenshot 2023-11-02 091220.png

 

Catalogue Lookup Table. Converts product names into SKUs

Screenshot 2023-11-02 091302.png

 

Product Inventory Table. Converts SKU's into whether product is in stock or not.

Screenshot 2023-11-02 091316.png

 

Let me know if that works for you! 

Nik
5 - Automation Enthusiast
5 - Automation Enthusiast

@Arthur_Tutt thank you for your quick response! This solves my problem 🙂