Base Design

Hello, Here’s some preliminary information to help you help me I have four tables within one base: Companies (primary field: Company Name) Articles (primary field: Article Title) Topics (primary field: Topic Name) Authors (primary field: Author Name) In the Companies table, there is a Topics field linked to the Topics table, and an Authors field linked to the Authors table. In the Articles table, there is a Topics field linked to the Topics table, and an Authors field linked to the Authors table. The question How can I link associated Authors to the Topics table – taking into account the relationship between the Authors and the Topics on the Companies and Articles tables? And how can I link associated Topics to the Authors table – taking into account the relationship between the Topics and the Authors on the Companies and Articles tables? Thanks a lot in advance :raised_hands: :slightly_smiling_face:

Hey all, I’m trying to create an estimating tool that pulls pricing details from one base and sums them together. I have 10 “item” fields and 10 “quantity” fields. The item field is linked. The goal is to select the item, enter a qty and then get one big total for all the prices as well as the individual totals for each item * qty. Problem 1: I now have 10 linked fields on the services base. I can just hide them, but I don’t understand this at all. Problem 2: Do I have to create 10 lookup fields to pull the pricing details into the estimate base and then have that be the data that’s used for the formula? Is there an easier way? Thanks!

I am not sure why I can’t get my head around something that I think is easy but: I have a table of Videos that we air on a cable channel. One of the fields in the table (not the primary field) is a code# the station gives us. Each month, they send me an Excel list of the Code and number of airs that month. It does not include other fields. I can add the Code number to the Videos table but am lost after that. I need to copy and paste the Code# and # of airs into Airtable and then have a rollup showing the total number of airs per video for the life of the video. I know I need a linked table but for the life of me I can’t figure out how to do this because it is linking the Video Title rather than the Code #.

Is there a limit for how many links you can have from a one to many relationship?

Hi there, For an upcoming conference, people submitted around 150 abstracts. Each one has been reviewed, with a numeric score and optional text content. So each abstract is a singular thing, with one average score. But each abstract has multiple comments And each reviewer is one person, but has multiple comments. I kind of think this page: https://support.airtable.com/hc/en-us/articles/218734758-A-beginner-s-guide-to-many-to-many-relationships is what I’m looking for but I got lost after pretty much the first step. Do I need a junction table? Multiple junction tables? Is the example at the bottom of the page, Example 3: Clients, client orders, products, and manufacturers, what I’m looking for? Thanks!

Newbie here. I have two tables I am trying to link… table #1. which has basic plant info…name, details, photo. this is the master list of all the plants I’m interested in growing. table #2. these are all the plants that I have seeds for. I made the second table and was able to grab the plant name from table #1, but now I’d love to include a photo of this plant from from table #1. I tried making a new field on table #2 with the same name, and nothing happened. question: do I have to manually link all the photos for every plant on table number 2?

We are loving Airtable so far and getting ready to add some new users for our company! We are hoping to put together a “style guide” or best practices guide so that we all keep our bases, options, etc. consistent. Do you know if a template for something like this exists or is there a way to create a base that would work like this for us? Or, what does your company do to ensure bases work efficiently?

Hi everyone, I am fairly new to Airtable and I am building a process management tool for my restaurant business. What I am struggling with is the junction table and many-to-many relationships. I have read every example that Airtable provides, like the junction table one with students and classes. Am I understanding it correctly that the junction table has to be manually completed with all possible combinations? In the project that I am working on I have this same issue with vendors and processes. For each vendor we have to follow many processes and each process can be associated with many vendors. I therefor created 2 tables. Table 1 shows all vendors and is linked to Table 2 which lists all processes like Record Invoice, Pay Invoice, Place Order, etc… These processes are not the same for each vendor. I linked Table 1 & 2 and added the processes for each vendor in the linked field which generated the opposite on Table 2. Great so far! Now each combination Vendor 1 + Process 1, Vend

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

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

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.

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?

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.

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.