Base Design

Attached is a screen shot of a small part of a schedule of conference that a large number of rooms (80) across 4 hotelsthat has numerous sessions per day over a week. I’ve used AT for many years, but I’m struggling as to the best way to design this base to get the most benefit from AT. I want to move out of the g-sheet to unable sort, group and filtering by different staff at different properties with different roles. Any suggestions would be appreciated. I did contribute a base, but it is for a different style event. I want to be careful to not create additional complexity in the base design. https://www.airtable.com/universe/expc6PovQs6jz2O4C/master-plan-for-a-massive-corporate-event

I’d like to build a base to track our produce prescription program. We have coupons with barcodes to distribute to the patients. Ideally I’d like the health worker to use a barcode scanner to scan the first coupon and the last coupon for each patient. Then I need to populate a table of all the coupons distributed within that range for each patient. I currently have a table set up for “patients” where health workers would assign the coupons. Then I have a table for “Coupons” where I’d like the records to be each coupon code distributed. Any help in how to do this would be appreciated!

am currently experiencing an issue where Airtable is not working on both the mobile application and the

Hello,I have an events table with several events, each taking place on a different date. (Example: Event 1 on January 1st, Event 2 on February 1st, etc.)I would like people to be able to sign up as volunteers for one-hour slots for each of these events.What database structure would you recommend I create?Could I automate this process so that, once an event is created, it populates a new "slot" table by creating x new rows linked to each event, each row representing a different time slot?(Row 1: Event 1 - 9am to 10amRow 2: Event 1 - 10am to 11ametc.)Thank you very much for your help!

Hi all,I'm excited about the new Deep Matching functionality in AI Labs, but I haven’t been able to get any results yet. Here’s what I’ve tried so far: Tested with both large live tables (10k–50k records) and small test tables (10 records) Used conditional filtering to narrow results down to a single expected record Tried multiple models (GPT-4.1 Mini, GPT-5 Mini, GPT-5) Has anyone been able to get results successfully? If so, I’d love to hear what worked for you.Thanks!

We have a master base “template” created with all of the usual requests from a client and different bases per campaign. How can we duplicate a table from the master template to a campaign base with including the formulas? It works when you sync and unsync but somehow when duplicating the formulas are lost. Is there a work around?

Hi everyone! 👋I’m fairly new to Airtable and I’ve been trying to build a base where I can filter records based on values in a lookup field, but I can’t seem to get it working the way I want. I’ve read some community posts and tried a few different approaches, but I’m still stuck — so I thought I’d ask here for guidance. 😊Here’s what I’m trying to do:🔹 Base setup Table A: Projects – Contains project names and related client. Table B: Clients – Contains client details + a lookup field in Table A. In Table A, I have a lookup field that pulls the client industry from Table B. 🔹 GoalI want to filter Table A to only show projects where the client’s industry includes the word “Technology”.I’ve tried: Setting a view filter in Table A → Lookup Industry contains “Technology” Creating a formula field referencing the lookup Adding a rollup field But none of these filters ever show the expected records when I test it. I suspect I might be misunderstanding how lookup values behave in fil

Hi everyone 👋I’ve recently started using Airtable to track my daily puzzle performance, specifically for Letter Boxed, and I’m trying to build a cleaner, more automated setup.Right now, I have a simple table with: Date Completion status Number of words used Time taken Notes It works fine, but I’d love to improve it a bit.Here’s what I’m hoping to do: Create an automatic daily reminder to log my results Generate a weekly performance summary (average words, success rate, etc.) Possibly visualize progress over time with charts Maybe even trigger a weekly email report I’m still learning Airtable’s automation and formula features, so I’m not sure what the most efficient structure would be. Should I use a separate “Weekly Stats” table with rollups? Or is there a smarter way using formulas + grouped views?Would really appreciate any suggestions on table structure or automation flow 🙏Thanks in advance!

I’m building two workflows in Airtable, Workflow A and Workflow B.Workflow A includes Task 1, Task 2, and Task 3. Workflow B includes Task 4, Task 5, and Task 6.Task 3 in Workflow A cannot begin until Task 2 in Workflow A is completed and Tasks 4 and 5 from Workflow B are also completed.What’s the best way to set up Airtable so I can track cross‑workflow task dependencies like this? These two Workflow’s overlap with eachother so is there a way I can set up like Status’s for each task that when one task is blocked until xyz tasks are marked as completed?

Hi to anyone so grateful.I gone through every setting and cannot change the setting so I canadd a record/bottom row or duplicate because its says "you cannot create a new record because it is configured that no one can add a new record? with a lock sign in the bottom left.I have tried unsynching, changing permissions and checked the plan but no luck at all.Any step by step ideas are so welcome?Thanks

I built a fairly complex Airtable architecture about 12 months ago. Since then, both our operational model and my own Airtable knowledge have evolved significantly.I now want to redesign parts of the structure, including primary fields, relationships, automations, AI usage, and reducing manual inputs, so it’s more scalable and aligned with how we operate today. This means that filtering by year or creating views won’t be a viable solution as would break the data schema needed for the old data and built metrics to work.The challenge is that I have 12+ months of historic data that’s critical for KPIs, forecasting, and performance tracking. I don’t want to lose that history, but I’d like to effectively “start fresh” in 2026 with a cleaner structure focused only on new data.Additional considerations: I need to ensure the archive and the live 2026 base are not structurally connected, changes in one must not affect the other. The build is heavily reliant on connected data (linked records,

Hi, I’m new to Airtable and looking to build a database that holds multiple certificates with obtained dates and expiry dates. Is it possible to set one table with all the types of certificates and then link another table with the employee details so that they all end up with a list of different certificates or will I have to enter a whole heap of individual records? I will be use Softr as the app. Thanks for any advice, I havent found a template that does the trick. 

Airtable novice here. I hired a consultant to build an app to track assignments for my company (organized by client contracts). The consultant never really finished the job but the app is about 90% useful however, it’s populated with assignments from a closed contract. Is it possible for me to copy the structure of this app without copying all the inputs? The tables, views, automations and interfaces are good but I need to update the data to reflect the current contract (different pricing schedule, assignments, vendors, etc.)

Hi, I’m another newbie that’s too inexperienced with Airtable to find what I need in this forum. I have tried and tried to solve a problem I have but with no success so I wonder if anyone who knows Airtable well could help me please?I have managed to set up 1 master table and 3 other tables that have data related to the master table. All tables have a common record. I am trying to link the tables, as you would do for example in a relational database like Micrsoft Access, in order to create a view where for each line of data I choose/expand in the master table, the related data from the other 3 tables is also displayed. I just can’t get this to workI suppose the problem might be in the way I have tried to link the tables together?If anyone could spell out in very simple terms what I need to do to sort this out, I’d be very grateful. Thanks 

Is there a way to wrap the text in a filed name?

Im problem solving some workflow issues and finding that lots of lookup fields are not populating data for the vast majority of records. From what i can tell its only populating data for about 1000 records foir each of the fields i checked thus far. I also happened to notice that base views now have a new “showing the first 1000 records of XXXX. Load All Projects” warning/button combo at bottom of screen. Perhaps it is tied to this? This is critical malfunction for our system … hoping someone has a solve here?

Hey all. I have a client to which I am creating some template tasks.  The problem I am facing is that.When the client changes its status, I need to create x amount of tasks. Example attached. I have an automation that adds another relation to Client-Tasks that displays the immediate next task So client has 2 relations to tasks. One to all tasks, one to just the next task, which uses the field.Next task for search to find the right taskThe problem I have is that after my automation creates the template tasks it sort them randomly Even though I have set up a sort list step first.Always the next tasks is a different one.  If I sort the tasks manually everything works good, but I am having a problem with the first step.So I need that:1 the first tasks are created in the right order based on the template order and sorted correctly, and also then I need to be able to manually sort them. Otherwise the client would never be able to mode them  

I would like to start off by saying that I have been researching, watching how-to’s and reading the forum for a few weeks now trying to wrap my mind around this issue and I am humbly asking for a hand with this issue I know can be solved (but not by me, apparently) Attaching a diagram to hopefully give the jist of how my current base is laid out. It’s more complicated but this illustrates what I’m struggling with. I am a chef, working on a tool for our restaurant to track costs and recipe development trial and error. I have three tables set up - one for ingredients (has metrics like cost, case size, purveyor, etc). Then there’s an Inventory table, which is effectively looking up ingredients and attaching additional attributes like whether or not something is ‘on hand’ or whether it’s been prepared in one way or another. These records then go into the Recipes table where (like any recipe) they need to have quantities unique to the recipe. I have figured out how to manage recipe price tr

Hi everyone,Looking for real-world experience / benchmarks from folks running large Airtable bases.I’m currently redesigning our team’s base. We’re at ~330k records today (hard limit is 500k) and we’re already seeing performance issues (slow loads, sluggish automations/scripts at peak times, recalculation lag, etc.). Our first version was built to meet immediate needs, and we’re now rebuilding with a more best-practice / scalable approach.Airtable Support mentioned (and we’re also observing) that even with ~170k record “headroom,” the base can still struggle well before 500k depending on schema + computation complexity. We suspect a big contributor is heavy rollups / formulas / long calculation chains across linked records.What we’re considering / already doing: Reducing rollups + nested formulas, especially ones that fan out across many linked records Breaking long “calculation chains” into fewer dependency layers Keeping “fact” tables as thin as possible (minimizing computed fiel

Hi! I wanted to put up a topic about a feature which would tell you which fields should be killed. Airtable could develop something which ranks fields by dependencies and “data completion” (data completion being a stat calculated by “Number of Records where Data Exists” / “Total Number of Records”. This way, we could know if theres not a lot of people using this field and secondly, whether there are dependencies. Omni is great but lots of bases get too many fields over time and we have to start deleting them. I want features that make my bases more elegant/simple.

I have a table of contacts that includes zip code for each contact. I want to provide a view of contacts for a given county. I can get a list of zip codes for the county, but it's too many zip codes to list each one as a separate condition on a filter.I thought about setting up a zip code table and using a linked record from the contacts table. Is there a way to create a new linked record field that links based on an existing already-populated column? There are too many records to select linked records manually.Or, is there a way to create a view with filter criteria that references another table?Thanks for any suggestions.

Hi all!I’m having an issue of forms responses not populating into my data table after the form is submitted. This is a unique problem though, because what seems to be happening, is that when a response is submitted, by anyone, it pushes the last response through but doesn’t appear itself.For example, a coworker submitted a test response last Friday. I received the confirmation email on Friday, but the response didn’t populate into the data table UNTIL I submitted my own test response. I immediately saw my coworkers response populate into the data table but not mine, even though I received the confirmation email for my response. Has anyone encountered this before? Thanks in advance for any help you can provide!Brandon

Submitting our form causes buffering. The device used to fill out the form is a cell phone.I am not sure if it’s a data issue or maybe the size of the logo used in the form.Can anyone advise about this issue? Thank you

Hello! I am baffled by this issue. Essentially, I am creating a way for my office to check-out certain items (laptop chargers, phone chargers, etc.) using QR codes. I’ve got a form that allows people to use their phones (yay!), and I’ve got an array of QR codes that are just text based and give the name of the item, so every time someone scans them, the text pops up with the item name, and then they answer form questions like:whether the item is being checked out or backed in (the person enters this themselves), the name of the person doing the checkingAnd this is great. My fields track all the information I need, the QR codes work, etc.  BUT I CANNOT FOR THE LIFE OF ME LINK these records to my “Equipment” table, which I am making so our tech team can keep an eye on things like:Is this item available or checked out currently? Who was the last person to check it out? When was it last checked out?As you can see, I’ve tried a linked field, but I have to continuously select the Equipment N

I’m creating a list of property. Each item has one or more owners pulled from a separate table. I need to be able to add multiple owners for each property and assign a percentage of ownership. Eg. Property A is 100% owned by Bob    (owner is pulled from another table but percentage is specific to this record)Property B is 50% owned by Bob and 50% owned by Jim. Any ideas?