Ask the Community

I have a table with 8000 records that lists out where in our warehouse we keep our items. I’d like to group the locations of the same item by listing the locations in one cell and deleting the duplicate records. How could I go about doing this? ExampleItem                                      LocationItem 0001                             Shelf 1AItem 0001                             Shelf 1CItem 0002                             Shelf 1BItem 0002                             Shelf 3AItem 0002                             Shelf 5CItem 0003                             Shelf 1A Desired outputItem                                      Location        Item 0001                              Shelf 1A, Shelf 1CItem 0002                              Shelf 1B, Shelf 3A, Shelf 5CItem 0003                              Shelf 1A

I want to make sure, that we can only add one image into a field. at the moment i can add several images and i don’t know, hot to make sure, that only one image is alowed.ThxChristian

Hi! I have an automation that has two find actions.Find a record (a person) on table 1  Find an interaction on table 2 After the two find actions have run, I have a conditional logic group in order to update the record from table 1. In the first condition, I want to check if a value from Table 2 exists on the record found on Table 1. The value is a formula field on Table 2. However, when I try to make a condition using a formula (either “Activation name” or the array version of that formula, “Activation name array,” it is greyed out and gives the error Cannot assign list of string with strings. How can I use a formula as a condition here? 

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 Single or Multiple Select and will change as we progress through the phases. In Table B the “Phase” and “Stage” columns will not change because I want to capture the timeline for each stage in each phase.  So I want “Real Start Date” in Table B to capture the “Start Date” in Table A if it matches the same Phase and

I am slightly confused as to whether this functionality exists, GPT seems convinced it does but I can’t make it work.I am on the ‘teams’ plan for reference. What am I looking to achieve:Via interfaces, filter records from my ‘People’ table. (straightforward enough) Then select these records in bulk (100+ of them). I am using a grid as this allows me to tick all the records nice an easily. The problem comes when I want to update a field for all of the selected records. The purpose of updating this field is to move them to another table - ‘Projects’.  I have found 2 potential solutions: An automation that adds a new record into the relevant project based on a dropdown.  A script trigger by a button within interfaces that moves the selected records to the designated place. The issue with both of these options is that I can’t do it on a ‘bulk’ basis. Even if I select multiple records it just wont allow me to action them all at once.Any thoughts? Is this possible or am I wasting my time?I

PDF OCR badly needed. Note the Vision block only supports images. Any thoughts/ideas on bulk OCR of uploaded documents?

I am no geek when it comes to sheets, most of the stuff I do comes from watching a video on youtube. I have a retail booth at a flea market and I get  my items from various resources, Some items come from estates that I buy, some from garage sales, some from a local auction house etc. I use the cents in the pricing to help identify where the items were purchased. For an estate sale, the price would be, for example, 10.31, so I can look at the daily sales report and immediately identify every item sold ending in .31came from the estate sale. What I’m wanting to do is  list the different sources I use and have sheets track and total each item based up the cents.  So in the Cell that has a heading Estate Sales, create a sum formula with the criteria of searching the sales report looking for every item sold that ended .31 Thanks in advance for the replies.  If this isn’t possible, is there a way to copy and paste selected random cells.  When I highlight multiple cells using the ctrl tab, c

Are there any plans to make a more robust print/export/embed functionality in the Interface feature? I know there are some graphs that can be printed, but I want to be able to export the full Interface as a PDF. We are using the Interface for an org-wide dashboard of our shared goals and the best way I could figure out how to do it was to take screenshots and recreate it in a separate program, which in addition to being cumbersome, creates a low-quality final product. Can you please prioritize this feature so we can use the interface as a share-able dashboard with a broader audience? We don't want to have to have everyone in our org to have to log into Airtable to see the dashboard, we want to be able to embed, print, and share.

Hi, I’ve recently downgraded from a team account to the free account. I duplicated my bases to make sure there were less than 1000 records and archived older data but I’m still getting the error. I’m not using any attachments or AI automations. Is there another criteria I should look for as I’d like to continue adding data to these bases.

Hello im trying to build an ERP for my food business we manufacture and package fast food, so my main goal using airtable is to control raw materials, receiving of raw materials, production control, finished product control, recipes, and inventory.Since my Finished product (recipe) consists of various ingredients, im wondering if its possible to populate said ingredients taken from my recipe table to my production table every time I add (manually) the quantity of items to be produced in the day. or if the is a simpler solution would be great, im trying to control de raw materials consumption during production.    

Hello! I am struggling to create an easy database template for importing data from a manual CSV export with some weirdness to it. Then an interface for data visualization that once was done using a platform that linked directly with the app generating the data. The app generating the data exports two CSV files, one for a list of “interactions” and one for a list of “buttons”, so I started with a table for each with the same fields. Each interaction row contains a lot of data pertaining to the user, so I added a 3rd table of Users in Airtable, and just made those fields in the Interactions table lookup fields to pull from Users. The Interactions can have up to 12 Buttons, and the export has several columns for each button - some of it is unique to the interaction and some applies to every use of that button, so I have put that info in the Button table and the fields in Interactions are now a lookup. The Interactions records also include date and time of the start of the interaction, and

Can’t imagine this isn’t a bug, but I’m open to hearing explanations. I have a table built from a Salesforce report sync. One field is Account Name. If account name contains a comma, lots of other things break because Airtable doesn’t handle commas correctly in linked records (there’s a feature request open to address this). So I have a very simple automation that should fix things.When a record enters a view I have 2 actions:Run a simple script to grab the account name, strip commas, write the new account name to a separate field in the table. This works fine. Send a Slack message that includes the new account name from that just-written field. This does NOT work. Account name is always empty in the Slack message.If I test the automation by generating a preview of the Slack message, the account name is there correctly, without commas. It seems Airtable does not wait for action 1 (the script) to complete before running action 2. But that couldn’t be… right? 🤔To test, I added a delay a

I’m trying to create a base for researching and resolving potential duplicates in another system. This system produces reports on a monthly basis that I’m trying to use as my starting point, ideally without any data cleanup of that file. So far I have 3 Tables:Imports Individual Records Group RecordsMy imports file/table has one row per individual record. Each individual record has a field called duplicate group ID. When two individual records have been identified as possible duplicates, they have the same duplicate group ID. I was trying to do something like:when a record in the imports table meets conditions linked record field “Group Records” is empty Another condition that checks for another automation to run first that corrects a field in the import file. find records that have the same duplicate group ID create one group record  create one individual record for each record found that have the same duplicate group idThe problem I’m running into is that the automation is triggere

Hello, I have built an interface on top of a table. Within this table I have dates and I have put a column formula to get the week number. I've created a chart in the interface and I'd like a drop-down that filters by the week number but currently only allows me to filter by the date. Please help.

Hi everyone,I run a niche website that publishes daily puzzle solutions for the NYT Letter Boxed game. I’m currently posting answers manually, but I’d love to streamline this process using Airtable. Has anyone used Airtable to schedule or automate daily content updates to a website or blog?For context, here’s my site: NYT Letter Boxed Answers and tips– I post daily solutions, tips, and strategies.I’m curious to know: Can Airtable be used as a lightweight CMS for this kind of content? Are there any integrations (like with Zapier or Make) that could auto-publish new rows to a WordPress post or static site? How do you manage formatting or templating for content blocks coming from Airtable? Would appreciate any insights or advice from those with experience. Thanks!

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 requests to, may somehow be a better option - thinking about time consumption in deciding and allocating subcontractors in compari

Hi,i am totaly new to Airtable and i am working with the 14 day trial version.if i try to add any extension, it seems, that i can not work withit becaus it seems to be “locked” and i can not change anything in the extension.Is this because of the trial version?ThxChristian

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

I’m running into a confusing problem involving PDF attachments and third-party apps (specifically Noloco) that are connected to my Airtable base. Here’s a detailed explanation:Background & Problem I am using n8n (automation platform) to upload multiple PDF attachments to a field in Airtable. In Airtable itself, everything appears correct: The PDF filenames are always displayed exactly as expected (both in the UI and in the API attachment objects). Noloco (an app builder which connects directly to Airtable) is showing incorrect or strange filenames for some attachments: Instead of the real filename (e.g. 2025-08-06-21-43.PDF), Noloco sometimes displays a generic value like uc as the filename. However, for attachments uploaded manually to Airtable (via UI), Noloco displays the correct filename. What I Have Tried I have checked the attachment objects both in the Airtable API and via scripting: The filename property is always correct and matches what’s shown in the A

Hello everyone,I'm facing a challenge with automating the synchronization between two tables: "Meeting Notes" and "Tasks."Goal:When an entry of type "Action" is created in "Meeting Notes," a corresponding task should automatically be created in the "Tasks" table. Changes to an entry in either table should be automatically synchronized in the other table.Current Implementation: I've created a formula field in both tables that checks if the entry has been modified within the last 15 minutes: IF( AND( DATETIME_DIFF(NOW(),LAST_MODIFIED_TIME(), "minutes") >= 1, DATETIME_DIFF(NOW(),LAST_MODIFIED_TIME(),"minutes") <15 ), 1, 0) An automation is triggered by this formula field when it's "1" and the type is "Action." The automation then creates or updates the corresponding entry in the other table. Problem:The formula field remains at "1" even after the 15 minutes have elapsed. This causes the automations to be triggered repeatedly and unnecessarily.Question:Does anyone have an i

I’m struggling with styling in my extension.  I can see in the browser Airtable defines over a hundred theme constants useful for styling elements.  I want to import these into my own style.css so I can refer to them, but I can’t find a way to do so.I have found useColorScheme() and other ways to access theme constants within typescript, but I don’t want to style everything programmatically.  If I want to style in CSS, am I obliged to maintain my own list of constants?

I am very new to Airtable and have been trying to figure out if there are ways for me to automate some of the things I’m doing -  I have ad copy written in one column and I have another column for sorting the ad copy by length (i.e. One-Liners, Paragraph, Essay) - is there any way to automate my length field to auto-populate based on how many lines are in my ad copy field? I tried running a field agent that was ‘if {ad copy} is 1-2 lines…’ and it worked for some records but many had errors. I also tried using the AI assist and asking it ‘if records have 1-2 lines under {ad copy} then categorize it as ‘one-liners’ under {ad copy length}’ but had the same issue where sometimes it worked and other times it ran into errors. 

Hi,One table has the entire list of our shows with an ad budget attached to each. Another table has an entire list of each ad placed, but our ads include multiple shows in each one so there’s already a linked record there, then a formula to calculate total ad spend versus how many shows are in that one ad so that we know how much is spent on each show per ad.Is there a way to use a rollup field or formula field to add up our ad spend per show and attach it to our show list in the first table? I need it to calculate correctly for each show, not just spit out the total amount.  

Hi, everyone! I’m Leif B. -- I run Airtable for the Marketing & Communication team at Memorial Sloan Kettering Cancer Center. I just presented with Denise and Ameer from Mayo Clinic and UNC Health respectively. Would love to keep our convos going in this community space!