Base Design

Hi everyone,Is there a recommended way or best practice to clearly identify which base is the Sandbox and which one is Production (live data) ?I've run into an issue where I accidentally connect to the Sandbox base instead of the real one because they have the identical name in the selection menu.Is there an interface visual indicator or a technical identifier that you use to prevent this mix-up?Thanks in advance for any tips!

I’m importing data and Airtable determines that one field should be single select. This is totally fine but I’m wondering if it would be better to store the selections in a separate table and use a lookup.Is there a performance or size benefit to keeping all the possible choices for this column in a lookup table vs the single select options in the same table? So far, the largest number of choices from my data is 13 but there could be more.Let’s say I’m importing 8 data sets into new tables, each with a column that could be single select. The single select values would be unique for each table. Would it be worth the effort to populate the values from that column for all 8 tables into a separate lookups table? This raises the question of how to link that column or use a lookup after importing. Is there a programmatic way to do a lookup with a formula?

Hi all! I’m looking for ideas on the best Airtable approach for combining a high-level project roadmap with team capacity planning.I have a Master Projects table that brings together:Actual projects already assigned to the team Potential future projects that may be coming down the pipelineBoth use the same core fields, including Status, Assignee, Project Type, Product, Start Date, and Estimated Due Date. Potential work can represent either a specific expected resource or a larger initiative where we know significant work is coming but don’t yet know all of the individual deliverables.The goal is primarily team-level, monthly planning: helping our manager see committed and potential work together, identify especially busy periods, and gauge whether we appear to have bandwidth for additional work.I’ve tried Kanban, Timeline, and Roadmap Interface layouts, but none has felt quite “right” in terms of capturing both timing + workload. At this point, I also feel like I may be overthinking it

AirTable only facilitates Sunday-Saturday week view in the calendar view window/box. Since most of the world does not use Sunday-Saturday week layout. We’ve been asking for the option to change this to whatever we want. More than 50% of the world uses Monday-Sunday so for that reason (and common sense, e.g. ‘Sat and Sun comprise what most people call the ‘weekend’ is at the ‘end’ of the week’), we’d like the option to toggle that. Also, some people use other week formats.  We have been asking AirTable to fix this for over 7 years. It’s crazy that a tool which emphasises the customisability for users building apps/interfaces can’t facilitate such a basic format rule.  This topic was raised 7 years ago!! (2019) and it’s still unsolved:  Their initial proposal does not work

Hi everyone,I have built an interface dashboard with a list. In the development base I can open a record in the list to view the record details page. However when I try to publish it and use in another base I cannot make the details page appear.  Any thoughts what I could be missing?

I run an online business (ExpressCanopy.com) that sells custom pop-up tents, logo tents, trade show displays, and event branding products across the USA. We receive many custom orders with different artwork, sizes, and delivery deadlines.I'm considering using Airtable to manage customer orders, artwork approvals, production status, shipping, and follow-ups in one place.Has anyone built a workflow like this in Airtable? Which templates, automations, or integrations would you recommend for managing custom manufacturing or event product businesses?

Hello all!I'm working with a small school that is restructuring how we track staff time-off and homeroom assignments per year. Staff get reassigned to different homerooms each school year, and I need sick/personal-day totals to be tracked and reset cleanly per year without losing history once a school year closes. I was thinking a junction table might work but would love to hear any other options I might have overlooked or if I’m overengineering this!(Bold indicates table, all listed items are the fields. Homerooms, Staff Year Assignments, and Staff Time-Off would be the new additions)Staff (existing table)Homerooms    - Homeroom Name    - Active Status    - Assigned Students (linked to Students table)    - Current Staff Count (rollup from Staff Year Assignments table)    - Min Staff Required (formula)    - Ratio Status (formula for staff per student ratio)Staff Year Assignments (junction — one record per staff member per school year)    - Staff (link)    - School Year (link)    - Home

Hi everyone,I'm trying to build an employee shift schedule in Airtable where the schedule repeats every week. I don't need specific calendar dates—only the day of the week and the start/end times for each shift.I initially thought about using Date fields, but they always seem to require an actual date. I also looked at Duration fields, but those appear to represent elapsed time rather than a time of day.I'm wondering:What is the recommended way to model recurring weekly shifts in Airtable? Is it best to use Date fields with an arbitrary date and simply ignore the date portion? Are there better alternatives, such as text fields or another field type? How do you handle sorting by time and calculating shift lengths in a setup like this?I'd appreciate hearing how others have structured similar recurring schedules. Thanks!

Anyone else finding the base ‘find in view ‘function frustrating to use lately? As soon as I start typing it immediately starts searching so pauses the ability to continue typing resulting in letters being missed. The only way to use it effectively is to type r e a l l y  s l o w l y or paste the word(s). It never used to have this issue and, since I use the find function regularly, it’s having a severe impact on my workflow. Advice welcome.

Hi everyone,A table in one of my bases (ΣΥΝΟΙΚΙΕΣ) disappeared today, July 23, 2026, sometime after 19:00 GMT+3. It's not in the base trash, and it doesn't appear in the revision history available on the Free plan (2 weeks).I've already emailed Airtable support, but wanted to check here too:Has anyone experienced a table just vanishing without an explicit delete action? Is there any way for a Free plan user to recover a deleted table, or does this require contacting support directly? Does anyone know if Airtable keeps backend snapshots beyond what's shown in revision history?This was manually entered research data for my PhD dissertation, so any pointers would be hugely appreciated.Thanks in advance!Σοφία

I have been experiencing a problem with the project management template base not pulling projects and tasks into the my task page. When I update the project and tasks page, it does update timeline, kanban, management view, etc but for some reason that one tab does not work. I checked all conditions and it is the same as other boards I have used under this template and has not deviated. I took it a step further and tried a new project management template base and the same issue is happening where tasks do not map to that page. Is there a fix for this problem as our PMO manager liked the rolled up project view v granular details?Thanks in advance.

I manage a monthly image competition for a professional photography group that is presently managed in spreadsheets.  I’ve created four tables and I think I’ve linked them, but the look up fields don’t always populate from the linked tables. Can I invite someone to look at my workspace and help me figure out what I’m doing wrong? Any guidance would be greatly appreciated!

Hello Airtable Team, First of all, thank you for creating such an amazing platform. I've been building increasingly complex systems in Airtable for several years and I would like to share a few feature requests that, in my opinion, would significantly improve the platform for advanced users.1. Cross-base linked recordsCurrently, linked records work only within the same base.It would be extremely useful if a "Link to another record" field could reference records from another Airtable base.This would allow users to build larger "Life OS" or enterprise systems without duplicating data across multiple bases.It would also reduce duplicated data and improve data consistency across multiple business domains.2. Rollup → Range()A new Rollup aggregation function that returns the minimum and maximum values in a single formatted result.Example: 5–8instead of 58or requiring formulas afterwards.It would be useful for dates, prices, years and many other numeric values.3. Full-screen Record DetailOne

I’ve built out a fairly robust Jira replacement for our Agile team. This base has separate tables for Tasks and Sprints (among others). All Tasks have a Status, ending with ‘Done’ and all Sprints are either ‘Complete’, ‘Active’, or ‘Backlog’. My question is - what’s the best way to move any incomplete stories to the next sprint when I’m closing out the current one? I’d need to 1. Change current Sprint to ‘Complete’, 2. Change next Sprint in the current view to Active, 3. For any Tasks that are not Done but are in a Sprint that’s Complete, change them to the Current Sprint. I feel like that’s too many steps to tie to one button click, or that it would all happen too instantaneously for the stories to get moved correctly. I expect that this has been solved by others - does anyone have a nice solution?

I am looking to get help on structuring my base to track Deals, Tasks, and Subtasks without overcomplicating the fields and inputs. What I am struggling with is that some Tasks don’t have any Subtasks, so I created a separate “status” field for just Tasks. Right now I have Tasks and Subtasks in separate tables with Subtasks linked to their appropriate Tasks. This is fine, but it’s a little awkward and annoying that I have two status fields now at two different levels. Especially in interfaces.  Why do I have a status field for Tasks and Subtasks? I want to automate when all the Subtasks are complete, then that parent Task is filtered out and no longer shows on my interface. If a Task doesn’t have Subtasks, then I need to have a separate status field for Tasks so when they are complete, they will also filter out when complete.  In short, I imagine there is a solution or more efficient alternative given this is a very basic Project-Tasks-Subtasks structure that thousands of people probab

I have created a base for cataloguing books/manga. The problem I’m having is with audiobook narrators. When a book is logged, they sometimes have two different narrators. They log the narrators names and the strengths and weaknesses of each narrator. For a specific example, lets say there are two narrators. Narrator 1 is Julia Whelan and Narrator 2 is Will Damron. Narrator 1 strengths (a multi select field)  “Distinct Character Voices” and “Emotional Resonance”. Narrator 2 strengths are “Good Articulation/Pronunciation” and “Good Rhythm and Pacing”. Then the information is supposed to go to a narrator table where it logs this information. Because they narrate multiple books, these strengths can be added to with other books. The issue is that as far as I can figure, a lookup field won’t work because they need to apply to only the correct narrator. A rollup has the same issue. I can do it via automation but that gets really messy and complicated because it will create extra little bubble

Hi, we need to set up an attendance tracker (I know how to do the student and class dataset) for teachers to track students attendance in three activities each afternoon (same teacher tracks all three, and there are 6 teachers / classrooms). I know how I could do this in the form but are limited to each student with the three activities. I want to give the teachers a form to fill it that looks like a excel table, with all the students names on the left, and the three activities on the right for them to mark as present, absent, or partial. We do not want to use a portal as those are expensive. Will I need to use another application on top of this to do it? If so, which one if we want one place that the teachers go to for a drop down list of their classrooms, and then to fill out the matrix. In addition, how would you set up the attendance data table in airtable. Thanks!

I am needing to build a dashboard to represent TAT on Account Implementations for various teams. I am being asked to use a field history report that will give me a date and time stamp when Stage or the Platform Setup field is changed. We want to be able to show an overall TAT but granular time spent in the various options. Historically I have had a report that would be a single line item per Opportunity with the date stamps out the right in columns.Is there a way in airtable, or before airtable, to help me consolidate or accurately report the metrics? Here is a snapshot of the data from the field history report I am being asked to use: 

Hello! I am importing messy data entered over many years in many different formats. I am hoping there is an easy way to merge similar single select fields in one.For instance, in the screenshot below there are 50+ ways that people have entered this info over the years, but I would like to consolidate those into under 10 categories. So I would want to take the “Large” single select option and then pull in the various fields such as: “lg” “Lg” “large shade” “large?” etc.Hoping there is a simpler way to do this because there’s a large volume of records.Thank you for any thoughts! 

Hey all! I am building a base to track degree progress over about two years for a small group of students. These students need to do four internships in these two years, and I am trying to use a gannt view to set four semesters as dependent on each other. I am having trouble with how to move students backward. For example, I have linked fields to the specific semesters that students are doing internships in: First internship: Fall 2026 Second internship: Spring 2027 Third internship: Fall 2027 Fourth internship: Spring 2028 I am trying to build the system such that if I change the second internship to Fall 2027, it will change the value of third and fourth internship to Spring 2028 and Fall 2028 respectively (but NOT change the semester tied to first internship).  Has anyone done anything like this? 

Dear Airtable Community, for a Project Gantt Plan I have differnt swimlanes that are grouped by Workstream Tags. The gantt view used to show the Tags in a column on the very left side of the table (directly next to the column of the different views). Now this column with the Grouped Workstreams disappeared and there is no option to show it again only when I change the Layout from Gantt to stacked. Please help

This seems to be a grossly missing option for sorts.  I should be able to check a box to decide if I want blank fields to show at the top or bottom of a sorted column.  I know there is a workaround, but I shouldn’t have to create a workaround for a painfully missing feature.  How do I submit this as a feature request and get everyone to upvote it?

Hi everyone,I’ve been managing our entire product catalog in Excel, but it’s getting short. I really need to have a better workflow, and I’m trying to figure out if Airtable is the right solution for my company or if I will hit a wall soon.I interact a lot with the products, change prices frequently, and need a highly visual and optimized system. Here is my specific scenario:The Data & Workflow:We manage around 3,000 to 4,000 products.I have a Master Products Table with historical data: UPC, Name, Brand, and Image Every single day, I receive 5 separate Excel files with updated prices and current availability. Each file belongs to a different customer tier (VIP, Wholesale, Distributor, etc.). If an item is not in the daily Excel, it means it's out of stock for the day.My ultimate goal is to use Airtable Interfaces (Gallery View) to show the active products with their respective prices, export them to PDF, and send them to clients.Based on your experience, is Airtable truly the right

I’m looking for experts to build an all in one inventory management system with CRM capabilities. Each item in our stock is unique. The system needs to work in multiple currencies and track purchases, sales, partnerships in items, stock value, consignment etc. UK based but open to international developers/experts too. 

Hopefully a quick yes/no.I have several published datasets right now serving multiple bases all within one workspace.I’m about to split out our workspace into several for permissions control reasons. Will the dataset still be available to other workspaces (all under the same account), or is a dataset limited to just the one workspace it is created in?