Base Design

I have created a table with my suppliers and the products the offer. I have the following tables:SuppliersProductsInvoicesInvoices linesIn Suppliers I enter every company I work or might be interested in working in the future.In products I have all the products offered, each product has a price and the supplier that offers that product (It has many other fields but are not important here)In Invoices lines I put the content of each invoice I create in the Invoices table and when I recall a product, it recalls as well the price.The problem is sometimes I have exactly the same product offered by multiple companies and one of the ideas of this database is to be able to make a price comparision.So I want every product to be connected to multiple suppliers and to have the price that every supplier asks for such product. And then, when I do the invoice lines and I recall the product, i’d love for airtable to recognize who is the supplier of that invoice and automatically recall the price that

HOW can we HIDE or MOVE the "Uncategorized” column on a Kanban view embedded on a website?Use Case:I’m a Film & TV Producer with an option on a novel.If you look at: Hardcastle - Heather Hale Productions you’ll see we have embedded a public-facing “Casting Strategies” character short lists that links to an Airtable Kanban.UNfortunately “UNcategorized" is the most prominent LEFT column. ;-/Even though it is collapsed on the Airtable base - that doesn't translate to the WordPress website.I would much prefer if we could hide or filter it out so that if/when that "UNcategorized" column is empty, its empty column won’t show at all (much less be so prominent (first thing most eyes fall upon: top left-hand corner).Worst case scenario, if we could at least move it all the way to the far right, it’d be less prominent, less distracting and a little more forgivable (design/use wise).Any ideas?Suggestions?Bueller?THANK YOU!Already Checked:Airtable Card Layout - Embedded ViewEmbedding Airtable

I’m building a master Airtable CRM workspace for my cannabis brand.- Sales rep table with tiered commissions- Dispensary accounts with reorder tracking- Orders table with linked SKUs and auto commission calculations- Monthly commission dashboard- Follow-up tracker for reorders- Owner + rep-level dashboards  Budget: Open to hourly or flat rate — please share your estimate   Timeline: Want to get this done ASAP this weekDrop your portfolio or DM me here if interested. Thanks!

Hi All,I have 2 date fields as below.Planned Start DateActual Start Date. Need to get a view in Airtable to show me both the dates on the chart for a task, what was planned date and when is actual start date. 

Hello, I am using airtable as a data source  project management tool for video editing projects. I have two tables, the first is a table containing all the data about a project then second table contains information about each draft video created for a project, and this table it linked to the master projects table.In my app, I have a table block that displays all the projects we are working on with each project populating a row in the table. In a perfect world I would like a column of that table to tell where what was the last “thing” done in the project. In reality that ask may be too big, so instead I would settle for at least knowing the name of the most recent draft video posted to a project.I need populate a field in the projects table with whatever the most recent row in the drafts table that is related that project.For example, we have a row that contain info on project “football game”, and there a field called “current draft”. On day one there are no draft videos created yet so

Hello Airtable Community,I'm in the process of designing a custom Business OS for my construction project management company, and I've reached a critical architectural decision point. I'd love to get your expert feedback on the best way to structure our Project Team roster.The Goal:For any given Project, I need a single, clean, and scalable way to see the entire team involved. The challenge is that our teams are a mix of: Internal Employees: (e.g., our Project Manager, Principal, Dev Engineer) who are managed in a dedicated Team Members table with specific internal data like their job titles. It is my understanding that it is best practice to keep your employees in a separate table from the standard Contacts CRM table. External Stakeholders: (e.g., the Client's Property Manager, an external MEP Engineer, a contact at an incentive program) who are managed in our main Contacts table, which is linked to a Companies table. My top priority is to create a system that is simple for my team

Hello Airtable Community,I'm in the process of designing a custom estimating and service OS for my construction business and have run into a common but complex data architecture challenge. I'd love to get your expert opinion on the current best practice for solving it. Let me preface this post by stating that as someone who is new to Airtable, I used AI to help me craft a clear posting but this problem is real and something I have been struggling with for a few hours now. The Goal:I want to create a field in my Cost Catalog table that automatically and dynamically looks up the price for an item from its designated "Primary Vendor." This price needs to be used in our estimating templates.My Table Setup:I have three core tables involved: Cost Catalog: My master library of item definitions. Each record is a unique item (e.g., "350 Gallon TES Tank"). It has a linked record field called Primary Vendor which points to the Companies table. Companies: My master list of all vendors, suppliers

Hey guys,  Anyone ever made a inventory management system that handled multi level assemblies? Looking to build something that will help me track assemblies with various quantities or parts inside them, various warehouse locations and hopefully also link back to zapier for integration with a website. I would like to be using a full ERP system but they estimate months to have it implemented so looking for something in the mean time.  Database would only have around 70 finished parts made up from 200 or so parts total. If anyone has a template would be amazing! Thanks

Hi all, I’m having a hard time finding an answer to something that seems like it should be easy, but I can’t quite figure it out and other examples don’t fit my use case very nicely. I tried making sense of dynamic filters, but it wasn’t doing what I needed it to. I’m working on an advertising sheet across multiple vendors, categories, months, and stores. In essence, we have one tab in our sheet where all of our bills get dumped. It has the vendor name, amount, and single-selects for month, store code, and category. I’m creating a linked database that creates a pivot table of all of the vendors as the rows and columns for each month of the year, using rollups to calculate how much we spent with each vendor each month. Sounds simple. However, I’m running into issues with trying to filter the table by store. Many stores utilize the same vendors, so when I try to filter by store code, it’s totaling all of the bills per month for each vendor that the store code I selected utilizes. The iss

spreadsheets Hi, I’m trying to recreate the structure of the attached spreadsheet in Airtable, but I'm running into trouble because each checklist item needs a different field type. I'm a PM, and I'm building a checklist that I want to go through once per project. Each checklist item requires a different field type. After discussing with ChatGPT, I was told that if there are 10 field types, I should create 10 separate fields and input each item only into its corresponding field type. But this checklist isn't just for me — about 20 team members will need to fill it out frequently. If it's structured this way, it becomes very inconvenient for everyone to use. What would be the best way to structure this kind of checklist in Airtable?

I have a single select field with options A, B, C. How can I limit a user’s ability to select an option twice? Once an option is selected they should not be able to select the same option again. 

rtf text fields are very limiting because there is no ability to add tables and advanced formatting such as callouts, toggles, dividers or images/videos.It would be extremely useful to have a few more elements in a similar way to Notion.Do you know if there is a plugin/addon to achieve something similar and make a more functional built-in editor?

Hey there, I am wondering if anyone knows how to use Fillout to generate unique forms for people in the airtable database. The idea is this: let’s say on some column in Airtable, Bob is only eligible for groups 2, 4 and Adam is eligible for groups 1 and 3, is there a way for Fillout to read this information on airtable and then create a personalised URL that gives Bob a form asking him to pick only between groups 2 and 4, and similarly with Adam? And can it do so while having a ‘live-booking’ functionality - so within Airtable, we have a Groups table that displays the remaining seats, so if group 2 currents sits at 0 remaining spaces, Bob will only have a form that asks him to pick group 4 (not a great example but hope you see what I mean).I would really appreciate any insight into this :)

I run a nonprofit that runs mentoring programs. I have a table that has a unique ID per mentor/mentee (a list of letters and numbers). That is the primary field. Their names are then in another field. There are about 72 people engaged in the program.I want them to be able to fill out a form for their mentoring activities/hours per month. I’ve created a new table, where the primary field is autogenerated. I’ve created the form, but I’d like for them to be able to choose their name from a list on the form so that it connects automatically to the main table and shows how many hours, meetings, etc for each person.Unfortunately I can only add the ID linked record for them to choose from, which is an internal number that they don’t know. Any creative thoughts on how I can get them to choose their name and have it still link/connect?Screenshot of Form. Add participant=Unique ID right nowScreenshot of Activity TableScreenshot of Main Table (Active Participants) 

Hey experts, I’m a beginner of Airtable and I’m setting up the bases & interfaces to present my team’s resource allocation plan.I have set up two bases: Task & Timeoff. And I have created an “Utilization Interface” as shown in the below screenshot.I’m wondering if there’s a way to show the timeoffs in this interface as well? If so, should I merge the two bases (task & timeline) together? Or if there’s any other best practices that I can keep these two bases separated but still show both the task and timeoff in the same utilization view?Thank  you so much for your guidance!!

Hello all:I have a table that stores our department's class offerings schedule. The important fields are:Lecturer's name Course number  Day of the week (Multiple select - as there can be multiple days the class is offered)  Start time of the class (the date does not really matter here; We only care about a typical week) Duration of class (in minutes) - helps to compute the end time of the sessions. I would like to generate a view that shows us the Weekly Schedule that is “date Agnostic” for an entire semester. The columns will be the weekdays, and the rows will be the time frames of each day (running from 7am to 9pm). I would like the classes to be filled into a “calendar-like” view based on their time and day of offering. This will aggregate across all classes, and i would also like to apply filters to it. We achieved it in Tableau, but it would be nice to have it in Airtable, where all our data are typically stored. Thanks for your help. 

I’m very new to Airtable, here’s what I’m trying to achieve. I have a table named Inventory: Name, Category, Price.A table named Project: Address, inspection date, images, Reno Estimate. Ideal process: From the Project I want to select items (30-50 items) (ideally a multiplier field. eg: 1x, 2x etc) from the Inventory list. (Or even just a checkbox) So for the Project I’ve selected what Inventory items I’ll need and the total of their cost.Hope that makes sense.

Hi All, Our team is having trouble with the cells running into the other pages when printed. This doesn’t affect everyone, just some people which makes me think it might be a setting issues. Any thoughts?“So the problem of the grid lines not closing between pages is still there, but it looks less messy than having long columns of text and pics in the body of the report. I tried using the Page Designer Extension or an outside program as suggested by others, but they require you to basically restart the whole template.”

For the love of all that is holy, WHY!?In this most recent UI update, Airtable seems to have randomly increased the margin width on the Interface side pages, messing up many of my pages and making it much harder to fit three elements per line in many circumstances.Example 1:The lines in each section of this page used to fit the width exactly.Example 2:The Action Menu dropdown was to the right of the Status field. Now it is pushed to another line.It is no longer possible to have a section division, and fit three total elements abreast. I hope to god this is a bug and not an intentional choice... 

Is it just me, or is anyone else seriously frustrated by Airtable’s recent UI update that removed base color customization?I used to rely on those colors to quickly distinguish between different bases — especially when juggling multiple tabs (client work, internal projects, staging vs. production, etc.). It was such a simple but powerful way to reduce mistakes and navigate faster. Now that everything looks the same, it’s way easier to click into the wrong base or waste time scanning titles.For a platform that prides itself on organization and efficiency, this feels like a strange step backwards. Color coding was more than just a cosmetic feature — it added real clarity and boosted productivity.Anyone else feeling this pain? Has anyone found a good workaround? Just me?Would love to know your thoughts — maybe if enough of us speak up, they’ll reconsider bringing it back!

Hi there,  I run an auto detailing business by myself and I am trying to create a booking system so my customers can automatically book a detail without having to message me. I have three different locations that I operate out of, and I would like for them to be able to choose the location and time.  Here is the tricky part.. I cant be double booked, so I need to find a way to limit this..  Any help is appreciated I currently have two tables set up, Appointments and services. All fairly basic stuff. Thanks 

Hello! I am looking to create a database that is similar in structure and function to the “Brand and compliance checker” demo in Airtable’s AI Playbook (https://www.airtable.com/ai-playbook/brand-and-compliance-checker)Instead of brand guidelines, I am using different scenarios and their criteria to analyze real estate records. I have 2 tables. One is the property data (similar to the “Product Shots” table in the video) and one is the scenario/criteria table (similar to the “Brand Guidelines” table). In the properties table, I have a single column for each scenario (similar to the “Brand Check” fields in the demo) that the AI will resolve to either “Yes” or “No” depending if the record matches the criteria. I would like to know the best and most straightforward way to link the tables or instruct OMNI to reference the specific criteria in the scenario/criteria table when checking the data. Any assistance would be appreciated.

I am a photographer and cinematographer. As such, I have innumerable external drives with images and clips on them. Each drive has a top level file ‘listing.txt’ that has the entire folder structure, down to each filename. This can have tens of thousands of lines. I want to create a base that lists all of my drives and has ‘listing.txt’ as an attachment. Easy.  BUT!!! I want to make the base searchable, so if I type in ‘badger’, the base will return the drives that have a file or folder that contains the word badger. Can I make the listing.txt file searchable? Or, do I need to break it up into 100000 character chunks and have numerous long text fields. (I have tried unsuccessfully to do this - but I don’t really know what I am doing!).  Insights welcomed, and thanks in anticipation,Roy Dunn

On my form, I have a couple of questions linked to a single select field.  It's automatically naming the button and I don't know how to edit that.  Instead of Add record or Add show, I just want to change it to Add Committee Preference.