Base Design

Hello!I’m working on moving our team into an interface for a better UI experience (and for more control on what is seen and editable). We currently have our work split among two tables (actually there is also a need to connect a completely separate base, but one problem at a time).Is there a way for me to have dates from both tables in one single calendar view that I could have as an interface page? The tables have a parent (projects) and child (tasks) relationship where the tasks are linked to the project record. However, not every project has a connected task.Can I build this with lookup tables and formulas and automations?

Hi everyone, Table A is meant to be just an overview of the project. The start dates, deadline given, and date returned will be entered manually as they change often. Here is a screenshot of the relevant part of Table A.Table A Now I’m creating Table B. In Table B I want to keep track of how long it took the team to finish each phase and each stage. Here is a screenshot of what I have so far:You can see in Table B I will list each stage of a phase and I want to track the start and end dates for each stage. Ie it’s more detailed than Table A. I’m wondering if there is a way to capture the dates in Table A and put them in Table B. In Table A the “Phase” and “Stage” columns are

I've only been using Airtable for a short time, and coming from RDBMS, I admit I'm struggling a bit.Right now, I'd just like to get the equivalent of a “select distinct ... from...” and I can't seem to do it.I have a table with a column called category.How can I create a view containing one row per distinct category?I want to use it in n8n...Thank you for your help. 

Hi all, I’m pretty new to both Airtable and Make, and I’m helping a friend in the construction business (mainly renovations), set up an Airtable system for his workflow. I’m stuck on the best way to create Quote Request records for subcontractors.Here’s the setup:Jobs table – All jobs for each project (linked to Projects table). Each Job is allocated a Trade (Electrics, Carpentry, Plumbing, etc.). After reviewing all Jobs for a project, my friend allocates specific Subcontractors (multi-select linked to Subcontractors table) who should receive quote requests.  This is done by Trade.  He has Subcontractors that could cover more than one Trade. He does not want to auto-allocate subcontractors by trade, as he may not ask all subcontractors in a trade to quote.  However, not sure whether auto-allocating and then removing subcontractors not wanting to send quote requ

Hii have a table with fields, where we can upload pictures. I need to make sure, that there is only one picture pe field alowed… how can i do this?At the mament its possible to upload more than on picture.ThxChristian

Hi all. I am pretty new to working with AirTable but have managed to figure out most of what I need to know thanks to the documentation and this community! I have one question by which I am flummoxed, however: linked record filtering.We have a base with a bunch of different tables in it, including one for Team Members and one for Tasks. In the Tasks table we have a field for Status, which is a single-select field with four options: Not Started, In Progress, Completed, and Deferred. Tasks also has a field that allows them to be linked to particular team members.In the Team Members table we have a field that pulls in all of the tasks associated with a team member. I’d like that field to be filtered by task status, so that only tasks that are not completed are shown. I’d think that turning on “Filter record selection by a condition”  and using a static filter like this would work:

I’ve spent weeks trying to understand how to properly manage linked record fields in my base, and I’m still stuck. No thanks to ChatGPT - total waste of time. I should have come here a lot earlier. Here’s what I’m struggling with:  I have one main Entities table that contains artists, labels, distributors, producers, etc. In other tables (like Songs and Releases), I need to link to Entities in multiple ways (for example: Artist, Featured Artist, Label, Distributor, Producer). Every time I create a separate link field for each role (e.g., “Artist Name,” “Label”), Airtable automatically creates a new reciprocal field in Entities, which results in multiple “Songs” or “Releases” columns there. This clutters the Entities table and makes it impossible to keep clean.  When I delete these extra reciprocal fields in Entities, it turns my original link fields in Songs or Releases into single line t

Hello! I’ve had this issue for some time now but finally have the time to sit down and really figure it out. Except I can’t figure it out. Base 1 has Table 1, which is synced to both Base 2 and 3. Base 2 and 3 are not allowed to create new records, I have to go back to Base 1 to add records in. Syncing is enabled for both (see below). I need to be able to edit Table 1 from all 3 bases and have the changes show up for each base. Base 1 settings: Base 2 settings (same as Base 3): Message when I try to add records to Base 2: 

Hey there, please pass this to the support team - passing on feedback - the new look is driving me crazy, not being able to collapse/reduce the left hand nav is frustrating, it takes up 25% of my screen with information i reference infrequently compared with the data in the table. arrgggghhhhh! anyhoo, love airtable thanks and have a great week

TWO TABLES MTO AND CATALOGUE.  MTO HAS MANY RECORDS - EACH HAS {XQTY} AGAINST A LOOKUP FIELD CALLED LINE_MATERIAL (WHICH IS LOOKING UP THE PRIME_ID ON CATALOGUE).THERE MAY BE 10 RECORDS ON MTO WITH DIFFERENT XQTY VALUES ALL FOR THE SAME LINE_MATERIAL.I WANT TO SUM THE XQTY - GROUPING BY LINE_MATERIAL - AND UPDATE THAT TOTAL TO THE MATCHING RECORD (LINE_MATERIAL = ID) ON THE CATALOGU TO DATAFIELD SUM_1.I HAVE TRIED JAVASCRIPT, AUTOMATION AND OMNI AND CLAUDE - AND SO FAR NOTHNG WORKS. USING JAVASCRIPT IS THE PREFERRED WAY LINKING TO AN ACTION BUTTON BUT THEN YOU HAVE TO ACCOUNT THAT THE VISIBLE VALUES IN AIRTABLE ARE NOT REALLY THERE BUT RECORD_ID IS….TRIED EVEN TO ACCOUNT FOR THAT BUT NOT MADE IT WORK EVERY TIME SO FAR !!!!THANKS FOR THE HELP GANG…...MIKE IN LONDON 

I can’t figure out how to make links between two tables work the way I need them. Here’s the situation:Table 1 contains a list of Companies. These Companies are differentiated by Type (multiselect) and split into multiple views based on that: Producers view and Architects view.Table 2 contains a list of Projects. Each Project has a Project Owner field (link to Companies, single record) and Project Participants field (link to Companies, multiple records).So far so good. Back to Table 1, for each Company I need it to show the following fields:Projects (Participant) - Link to Projects and show all Projects where a Company is referenced as the Project Participant Projects (Own) - Link to Projects and show all Projects where a Company is referenced as the Project OwnerThis is where I get stuck: When creating a link to the Projects table (2) from the Companies Table

Previous year i joined pro plan and connect my bank account.In June pro period ends iam going to stop pro plan.But i don’t know why it happens airtable automatically withdrawn my money.I lost 16,450 Ruppies ,I don’t want it please help me

Hello! I’m new to this community and hoping someone can point me in the right direction. I need to create a base that can match college students with alumni for 1-on-1 meetings, based on career interests. Each person will have up to 3 career interests, but meeting pairs only need to match on one of those interests.  Each student must be matched with only 2 alums Each alum should not have more than 2 students (but can have fewer)I created a base with 3 tables - Students, Alums, Career Interests - and linked the Student table to the Alumni table so I can see all of the matching alums for each student. I just cannot figure out how to limit the matches to just 2 for each person. Is this possible in Airtable or do I have a lot of manual work ahead of me?

I've never been fussy about colors, but the new options for base themes are a big step backwards for me.  The old bright, bold, cheery, energetic & fun colors that made the Airtable experience feel enjoyable and different from your average boring, serious database, have been replaced by: A) a dark, dreary version (my green base now looks exactly like Excel - uugh) or a mushy pastel version (were people asking for more 'washed out' low contrast header options?).The fun bright colors were part of Airtable's experience (and brand) for me.  Is there a way to bring them back for my workspace?  

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

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

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

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 p

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 Ta

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 vend

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.