Base Design

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.