Ask the Community

Hi all.I’m using the Form builder to make multiple forms for an upcoming event. We have 3 different casts, each needing to submit an agreement form. All the performers are listed in the same “Cast” table, with multiple views separating the casts. In the Form, the linked field to select their name is filtered to the appropriate view. However, when I change the view on one form, it changes the view for all 3 forms to be the same. Same problem if I use a condition instead. Please see the helper text at the bottom of the screenshot next to the cursor for the warning. How do I get each form to use its own appropriate view or filter? 

We have 3 tables:Table A:  List of Projects with a fields about the projects + lookup field from Tasks Table B:  List of Employees with fields about the employee + lookup field from Tasks Table C:  List of Tasks with fields about the task + lookup field from Projects+ lookup field from Employees.We’ve have a calendar interface to show Tasks and want to color code the calendar item by the Project it’s associated to.  Since it’s a lookup field and not a single select field, we can’t do this natively, so have to do it by configuring the color conditions.This is very simply done by:              Where Project  has any of ProjectBob set the color to Blue,  etc.It works perfectly in Sandbox.  When it’s published to Production, it doesn’t work. We’ve tested it with just a single condition to ensure there weren’t any nested condition problems and it still doesn’t work.The only thing I can think of is that the “has any of” condition works through a reference value set in Sandbox and since our P

I’m dealing with a table with many fields, and finding it unwieldy. I’m working on a map of the fields that lists them in the order they appear in the Master List and also logs info about each field. Screenshot below.  Is there anything in Airtable or any integrated app that can do this automatically?Any other tips for managing tables with many fields? 

I have two bases, let’s call them Recipes and Catering. The Catering team syncs in the Dishes table (two-way sync), as well as the Ingredients table (one-way sync). Each Dish record includes a Main Ingredient field that links to the Ingredients base. The Main Ingredient field has a selection limitation (you can only add in-season Ingredients to a dish).The Catering team is not able to fill in the Main Ingredient field on Dish records because of the selection conditions. This happens whether the condition is “Ingredient is in-season” or if I create an “in-season ingredients” view and limit selection to that view.The AI help bot tells me there’s no way to get around this short of a) removing the selection condition entirely, or b) setting up a second linked record field and a complicated sync/automation situation to fill in the original Main Ingredient field. I think that’s the conclusion I came to as well, but I want to check with my fellow humans first to see if anyone else has a solut

Airtable Consultant Needed – Staff & Freelance Crew Rostering SystemHi there!We’re looking for someone, ideally Melbourne-based but open to virtual support, to help our TV production company design and build a staff and freelance crew rostering system in Airtable.We produce a diverse range of television content, from full outside broadcast (OB) seasons across sports such as the NBL, A-League and AFLW, to ad hoc TV commercials and feature-length documentaries. Our staff and freelance crew often work across multiple projects, so we’re looking for a centralised system that gives our management team a clear, up-to-date overview of who is booked, when they’re working and which production they’re assigned to.What we’re looking to achieveIdeally, we’d like to create a centralised rostering system that brings together crew bookings from multiple project-based rosters, while allowing individual Production Managers to continue managing the rostering for their own productions.Key functionalit

Hi Airtable Product Team,I am writing to request clarification regarding the planned increase to the per-base record limit.We have contacted Airtable Support on three separate occasions about this update. We were informed that the limit is expected to increase to 1 million records per base by the end of this year, and that as Enterprise subscribers we would be among the first to receive it. However, we have not yet received clear confirmation that this change will be implemented, or when.We have used Airtable for nearly three years, and a significant part of our business operations now runs on the system we have built on the platform. At our current growth rate, we expect to reach the 500,000-record limit by early  2027. Given this timeline, our management team needs to decide soon whether to continue with Airtable or begin planning a migration to an alternative platform, and that decision depends directly on whether the limit increase will be available to us.We would therefore greatly

Hello,I’m new to Airtable and still learning, but the automations I’ve set up so far have already made my life much easier.I’m currently stuck on setting up invoicing. I have three clients—A, B, and C—and each client is assigned a different services package. For example:Client A: Package 1 Client B: Package 2 Client C: Package 3The packages and their pricing can vary by client. I’d also like to include a discount field that I can adjust manually when needed, although discounts will only be used occasionally.At the moment, I have the client details in one table and the services and pricing in another. All invoices need to be issued monthly on the 1st.I’d like to automate the process of creating PDF invoices and sending them out. Could someone please advise me on the best way to set this up in Airtable?Thank you, and apologies if my explanation isn’t clear.

Bonjour,J’utilise Airtable pour des formations en visio. J’ai créé une nouvelle formation. Mais quand on souhaite ajouter un nouvel acteur, voici le message qui apparait au moment de valider : "Looks like you missed one of the required fields: FORMATION" Cela impacte uniquement cette nouvelle formation. On peut inscrire normalement des acteurs sur les autres formation créés bien avant. J’ai bien sûr supprimer et récréer cette nouvelle formation de deux façons différentes : en dupliquant une autre formation ou en créant simplement une nouvelle. Le résultat est le même. Quand je suis dans mon tableau de bord dans la partie “inscription” et que je clique sur FORMATION, je vois que cette nouvelle formation apparait mais pas avec les autres et qu’elle ne contient ni la date, ni l’horaire alors que cela est bien indiqué sur le tableau Airtable.Auriez-vous une solution à m’apporter ? Je vais avoir besoin d’ajouter d’autres formations dans les prochaines semaines; ce problème est très bloquant

Our inventory system works as such: In the Project Materials page on our AT Dashboard, engineers go to the Place Request table and add their items,. I move items into the Need To Order page and add prices/links and then review them, and then move whatever is approved into the Approved To Order page, so on and so forth. We also have an Ipad with a Place Request Form on it so people on the floor can remotely request things, as they don’t have computers, and it automatically puts it into the Place Request page. For certain items, I want people to scan a QR/Barcode associated with an item and have that act of scanning put that item into the Place Request page. Is this possible? I have looked at the various extensions that exist for scanning but they don’t seem to do what I’m trying for or I’m just not understanding how they work.

Hi there, We have trainees who begin with us starting throughout the entire year however we notice if the trainee’s start date is September the academic year tag that is put on that student's position is academic year 2025 - 2026 instead of 2026 -2027. Is there a way within our automations/formula to change how that tag is put on trainees' positions?  Thank you for any help you can provide! Best, Mackenzie LaChance 

Bonjour,Unitialement il y avait plusieurs statuts utilisateurs : lecture seule / commentaire / éditeur.J’ai un forfait business et je ne voit plus le statut “commentaire”, est-ce normal ?D’autre part, il m’a semblé avoir lu quelque part que le statut “commentaire” était disponible pour toutes les personnes invitées sur une interface. Visiblement ce n’est pas le cas, est-ce normal ? quelles sont les conditions pour pouvoir commenter uniquement ?

 Subject: Step-by-step setup for Option A (Tenant-Month linked table for conditional formatting)Hi Team,I have a table where debts and payments are recorded as separate rows per tenant and month. I want the paid/unpaid status color to show directly on the debt rows (and optionally on the monthly summary).Could you please provide step-by-step instructions on how to set up Option A (using a Tenant-Month summary table with linked records, rollups, and lookup fields) so that debt rows can be conditionally formatted based on payment status?Thank you!

Hi, I currently have a semi-functional workflow but would like to optimize the view of work submissions through the forms on my interface. My team works with equipment rentals and starts by entering job information such as location, dates, renter company details, contact, etc. The next step in the interface would be to add the specific equipment that is being rented out for the job created in the first step. Each piece of equipment is associated with start and end dates for the rental period, and my main issues comes with being able to view the equipment and job details on one page in the interface. Since Airtable’s native form layout is built to submit fields to one table at a time, I have broken it into two form submissions within my interface but this does not allow for a clean view of both the job and its details, plus the equipment that goes along with that job. Is there any way to accomplish this with relative ease? I’m still new to interface building but as far as I can tell, th

Hello! My automation skills are pretty basic and I’ve struggled to build an automation to suit this specific need.I’ve built out a hierarchy where I have a parent record table (deliverables) and another table that is my tasks and subtasks. The tasks and subtask records are created through a form in the interface page for my “deliverables.”I basically need the automation to look at the task record, see the deliverable record that it is linked to and apply that to the subtask that is created. I’m adding the task record (via the form) and then I’m adding the linked subtask (also through the form).The process of creating the task record via the form automatically links it to the deliverable record. But once I go another step down in the hierarchy to the subtask, it only links to the task.So I’d like an automation that can link it up to the same deliverable record that the task is linked to. Hopefully this makes sense. Thanks!

how to help them

Request:Please add support for freezing or pinning columns in Airtable Grid view so selected columns remain visible while scrolling horizontally.Why this would help:This would make wide tables much easier to work with by keeping important identifying fields in view during data entry, review, and reporting. Some columns would need to stay pinned while moving across the rest of the table.

Hi Airtable Community,I'm looking for a way to configure Airtable Automations so that emails are sent directly from my Microsoft 365 mailbox or from a shared mailbox that I have permission to use.Currently, when I use Airtable's native Send Email automation, recipients see:AirtableAutomations<noreply+automations@airtableemail.com>Any guidance would be greatly appreciated.Thanks in advance!

Hello,I signed up for Airtable under an offer advertising the first month at no cost (€0).However, today, October 9, 2026, I received an invoice for $28.80 for my workspace “My First Workspace”.I do not understand why I have been charged when I understood that my first month would be free.Could you please explain this charge, review the promotional offer associated with my subscription, and arrange a full refund of $28.80?I would also appreciate confirmation that no further unexpected charges will occur.Thank you for your prompt assistance.Best regards

Hi, I have two interfaces in my workspace. One is a form, where my team will enter information at the beginning of each job, and will eventually return to the submission to add/remove/edit the data for completion and processing. The second is a list, that displays the submitted forms. I am unable to add/edit the information in the existing submitted forms, both as admin and editor. Is there a setting or another interface that I can implement to allow for changes to be made to these submissions without going to the data tab within my workspace? I am trying to keep my team from having to navigate anywhere in the space aside from the interfaces as they are using the mobile app.

I am using Airtable to record attendance for a small school. The base has two tables:Students, in which each record is a student Attendance, in which each record is a class session. There is a link between the two, so each Attendance record has a list of all students present, as well as the Class Name, and Date. Each record name in the attendance table is unique, and is a concatenation of Class Name and Date.   Each Student record has a linked list of all sessions attended. I want a field that reports the Class Name of the last session attended. I have a rollup field that reports the date of the last session attended. Here is a screenshot of that rollup: Is it possible to use Rollup to report the Class Name of that most-recent session?  

I’m building an automation that reports a date, and I created a field that uses DATETIME formula so that the date shows up in a readable format, as suggested on other threads linked below (thanks ​@ScottWorld and ​@John_Reid !) The problem is that the DATETIME formula output is not showing up in the email automation. Screenshots below-- The formula field that uses DATETIME formula to format the date in a readable format  The email automation set up   Email automation output    Any help troubleshooting much appreciated  Previous threads that were helpful  

I have a formula field that uses DATEADD to subtract 2 weeks from a date in another field. It produces the right date, but that date is formatted in a way that’s hard to read. Is it possible to configure the formatting so it shows up as MM/DD/YYYY ? Screenshot to show how the formatting shows up in an email automation. It’s the internal due date that I’d like to format. differently.  Somwhat related, I’d like the ‘application due date’ to format as MM/DD/YYYY as well, if possible.  

I’m having an issue with an Airtable automation where the same record occasionally triggers the automation multiple times even though I only expect one run per change. This results in duplicate actions being performed and makes it difficult to keep the workflow consistent.The trigger is based on a record being updated. Some records cause the automation to run twice unexpectedly. The duplicate runs happen intermittently rather than every time. There are no intentional loops or duplicate automation steps in the setup.Has anyone dealt with duplicate automation runs like this? What should I check in the trigger configuration or record-update logic to prevent the same change from being processed more than once?

I'm curious how other people organize information when working on a project that involves lots of different technical resources.For example, with a retro gaming or emulation project, you may need to keep track of emulator information, compatibility notes, configuration settings, game information, troubleshooting solutions, and other reference material. After collecting a lot of information, it can become difficult to remember where everything is.I've been looking at different ways to keep these resources organized so I can quickly find useful information later. Airtable seems interesting for this because information can be grouped and filtered instead of just being kept in a long list of bookmarks.One example of the type of technical reference I keep coming back to is:https://ps2biosonline.com/I'd be interested to hear how other Airtable users organize research or reference material for their own projects. Do you use separate tables, tags, linked records, or another system?

Hello,We utilize Airtable to organize our service center jobs within a university setting. One issue we continually run into is there is no way for us to share the job status, or any updates to the record status, with the submitters once it is in our Airtable instance, short of sending emails. Airtable Portals does not work well for our needs, as we have 100s, if not 1000s, of unique job submitters yearly. Some submitters have only one job come through our system, others have dozens. What I would love is a way for submitters to see a job ‘ticket’ where they can view any updates to their job status - what the current ETA is, if it is still under review or actively being processed, etc. They don’t need to be able to interact, just view selected data under the record. We have a budget I could utilize to pay for an extension, but paying per ‘submitter’ doesn’t makes sense given we have so many unique, one-time submitters. Any thoughts on the best options given our use case? Thank you!