Skip to main content

Base Design

Need help with your Airtable base design? You've arrived at the right place.

  • 3,356 Topics
  • 8,395 Replies
3356 Topics
K
Kaitlin_FrancoNew Participant
posted in Base Design
Duplicating records across multiple tables?

I am looking to add a record to multiple tables within the same base. So if my tables are per client and I want to add a record to every client, do I need to physically add it to each one or is that a way to add it all at once? Thanks

156
M
M
M_M1New Participant
posted in Base Design
Emulate an outer-join in a View?

How might one emulate an outer-join in a View? Example, I want my base to store recipe info in 3 tables; Recipes, Steps, Step Details. One Recipe has many Steps. One Step may have many Step Details. The Recipes table has fields like Recipe Name, Description, Prep Time.The Steps table has fields like Procedure. The Step Detail table has fields like Ingredient, Quantity, Measure. Since the Page Designer block must be based on only 1 table, I tried creating a view based on Step Details to lookup fields from Recipes and Steps. Problem: if there is a Step with no associated Step Detail (ie. no ingredients), then that Step does not show up in the view! It seems that if your table structure is more than 2 tables deep, you cannot pull all needed fields together in one view. I am currently evaluating Airtable as a platform for much larger projects. If the above is correct, that is a deal-killer. Suggestions anyone? Tig

132
M
O
Once_Upon_A_TimNew Participant
posted in Base Design
Trouble with Linked Records and Quantities

Hi folks! I have run into an issue that I can’t quite figure out. I have a base where I want to track inventory and profitability for our Event Decor company. The base has a table for Inventory items and a table for Events. On the inventory table I have a quantity field that is used to keep track of how many of a certain item we have in stock. In addition, this table tracks what events the items have been used for and also tracks the profitability of each inventory item. The problem is when I have an inventory item with multiple quantities. I have no way to specify the quantity used for their event in the events table because every inventory item is displayed in 1 cell. This means that if we have two items in stock but the event only uses 1, I have no way to input that and then perform calculations on that.

74
O
M
mayorcesarNew Participant
posted in Base Design
Automatically populate records from one table in another table

I’m trying to create my own version of the sales CRM. I manually copy in new leads (job numbers) in my first table and then I’d like those same job numbers to automatically appear in a second table so that I can group them by company which submitted them. I’ve tried it with a lookup but that doesn’t automatically pull in new data, which is what I would like - an automated lookup. Anybody ever ttried something like this?

611
Justin_Barrett
M
Maureen_RobisonNew Participant
posted in Base Design
Summary table within a base

I have an Escrow Tracker Base where each table is an individual property that is tracking the timeline of documents and dates of Escrow. I want to create a table that summarizes the entire base and need some help setting up.

20
M
S
Scott_HelikerKnown Participant
posted in Base Design
Upadating Linked Record when Record Gets Moved To Different View?

Trying to have a linked record updated when it gets moved to a different view so it does not register on that linked table… See here… Thanks for input to correct this Loom Loom | Send a video. Not a thousand words. Get your message across with instantly shareable videos for work. Capture your screen, record your front-facing camera, and narrate it all at once, then instantly share with a simple link.

10
S

Badge winners

Show all badges
Terms & Conditions