Ask the Community

i have been working on some new automations and i just ran into an issue that i haven’t seen before. existing automations that (i assumed) have been working fine are not displaying correctly. they are showing what looks to be a Record ID instead of the field. and when i try to edit the conditions, it errors out. i reached out to support, but who knows if i will hear back from them.any ideas? 

Hello: I'm wondering if anyone has figured out any clever ways to get what's in an extension onto an interface. We have a couple custom-built extensions that we'd like to display on interfaces so we can leverage the interface permissions. Right now, we have to open up our entire base to someone in order for them to view the extension. Any ideas on workarounds or how you may have managed to display extension data on an interface. Below is a screenshot of what one extension looks like.  

I have a situation just arise in the last hour. In Script, when I use the select control to get a field from a Find action, instead of returning the Field Name, it returns the Field ID. The selection process seems normal, and I see the field name and the value in the picker, but it returns the field ID instead, which does not work. It’s happening in several places. I’ve tried shutting down and opening again and creating a new automation, but I can no long select fields. Any thoughts?    

Hemos creado recientemente una comunidad de usuarios de Airtable en el idioma español, con la idea de compartir conocimientos, soluciones y trabajos en plantillas (templates) en el idioma español para todos los hispanohablantes. Si quieres aportar a que existan más usuarios de habla hispana que conozcan esta maravillosa herramienta, por favor mándame tu correo y te agregaré al grupo de co-work que hemos creado. Necesitamos gente experta en Airtable con interés de compartir su conocimiento. Saludos

I’m working on the following project in the interface designer where I want to utilise two tablesInitiatives Type of workIn this interface page, I want to use the list view and use the hierarchy levelsLevel 1 - Initiatives Level 2 - Type of work  The goal is to being able to group the records by the status field from the initiatives table. So those records in the interface should be displayed like this Record A - Type of work 1 (showing status of every milestones; To Do, Queued, WIP, Done and who is/was working on it) - Type of work 2 (e.g. backend, frontend, sound, art&design) - Type of work 3  Record B - Type of work 1 - Type of work 2 - Type of work 3 ​​​​​​​However, I can’t emphasise enough  how I’m frustrated that the records can be only group by the bottom hierarchy level (Yes, I can still sort the records by the parental level but this is not the same) I think this is a missed opportunity. A good design, and friendly interface is a key element if a user would want to use air

I am trying to set up an employee scheduling table. The table has links to my events table and to my employee table. The events have a "Start date" and "end date". Is there a way to create new records in the scheduling table pulled from events in the events table for each date in the start to end range? Ideally it would have all the event info in each day of the range. Employees are scheduled for full days so i wont need times, i would just like the ability to be able to add employees to each day of the event. Thank you for any help!

Two similar linked records link the BOOKINGS/LICENCES and the COSTS tables with the REPORTS table. I create a new record on the junction REPORT table (primary field = ReportID), and I manually choose to bring which licenses from the BOOKINGS/LICENCES table and which costs from the COSTS table will be included in this particular report from linked record on each tables.  Then I created a linked record both on the BOOKINGS/LICENCES table and on the COSTS tables that automatically pulls into those tables the reportID number (primary field) and an associated lookup field, so I can know directly from the BOOKINGS/LICENCES table, in which report a particular license is included. Same from the COSTS table.  I replicated the same logic and created the same relations through linked records on both tables. It works perfectly on the COSTS table. For a reason I cannot understand and after several attempts it simply does not work on the BOOKINGS/TABLE . Neither the information about the record numb

Since the updates Airtable has implemented in the last week or so, I am having an issue when trying to run certain automations.Mainly I notice this with my Generating PDF script automations (integrated with Documint).I will set to Generate and the automation used to take 10-15 sec at most to generate the Documint PDF and paste into my attachment field, then update any other fields. We have several of these set up across bases that all operate without errors.As you can see in the screenshot below, the automation is taking a long time to trigger and usually I see the below as ‘You edited this record in 2mins’ rather than ...min agoI’ve also been having an issue with running the automation again and again on the same record - for testing and adjustments, and the automation not running at all. In these cases automation history log will show (correctly) that it ran exactly the time I clicked the trigger, but the action doesn’t occur in the record or revision history.Maybe this is something

I have an Automation that updates a Multi-Select field in a different table. When the update occurs it over writes what is currently in that field. Each name has a different color. I want to augment, or add to the existing data in the Multi-Select field not over-write it. Not sure how to approach the problem within Automation. For Example, a field of user names, each name is in a color bubble separated with a space. Initially the field is updated with the name “John”. A second update to the field with the name of “Tom”. The resultI was expecting is : “John Tom”, or “John, Tom” each name in a different color bubble, but what I get is “Tom” and an empty color bubble. Any suggestions.

Hello, I inherited an Airtable base that essential keeps track of new subscribers. It was set up to calculate the enrollment date (ex: 7/24/2025) and extrapolate the year registered into a new column. However, currently the column mostly remains blank and/or it has enrolled everyone in the year 2022. This information is then supposed to be reflected on another table with their information. I am new to using Airtable and any information or direct you can provide is greatly appreciated on how to input an effective dynamic date formula. 

Hello, I copied a database from another account, it worked perfectly (almost), the forms followed well, but the automations did not follow... and that was the most important thing for me. Did I make a mistake?

I have it connected to a table with the months in it and they are supposed to click which month they want.  Now, it’s doing this? 

Hello!I am hoping someone can help. I am trying to create an order entry/invoice database where I can track customers, products offered, sales, contracts with vendors, etc. My main priority right now is tracking product sales by unit/# of customers. I have a database set up right now with the basic - Product, Customers, Line Items (customers can order multiples products and qtys of each), and invoice tab to generate the invoice number and collect data to use for the page designer extension so I can send a PDF invoice with the data stored in airtable. I followed one of GAP consulting's videos to set it up. The issue I have is there is no streamlined way to set this up for ease of use. BC the data is stored across multiple tables you need to go to each table in a specific order to enter the data. It is not intuitive for the person I am setting this database up for. I tried to use forms to make it easier, however, to enter a new order you need to go to multiple forms in order to update in

Hello there! I need some assistance understanding why these return different results. DATETIME_DIFF(“8/18/2025”, TODAY(), “m”) = 0MONTH(“8/18/2025”) - MONTH(TODAY()) = 1 Thanks in advance.-K

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. 

I have a name field that sometimes has one name and sometimes has two. If there are two names, they are seperated by a comma.What is a formula I can use to show only the first names, with an ‘and’ in the middle if there are two.John Doe                                    JohnJohn Doe, Josh Frank             John and Josh

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 everyone 👋If you've ever run into Airtable API limits or just need a faster way to access your base data regularly, I’ve put together a simple workflow that might help.Using CSV Getter, you can sync your Airtable base to a Google Sheet on a schedule.Results:✅ Faster access to your data✅ Fewer Airtable API calls✅ Automatic backups in Google SheetsThe Google Sheet acts like a proxy API. You can use it for lightweight querying or integrations, without constantly hitting the Airtable API.I wrote a short guide with a diagram and step-by-step setup instructions here:👉 https://www.csvgetter.com/blog/say-goodbye-to-airtable-api-limits-with-this-google-sheets-hackWould love to hear your thoughts or questions!- Gavin

Hello - I have a event data table ( nested in a event base) where I have list of potential events where my clients could participate. One of the column in the table is year column where I have a added a field agent to check the year the event is happening by routing the field agent to the event website cell.  So the field agent goes to the event website and check the year of the event and outputs that in the year column. I want the field agent to go back to the event website on a regular basis to keep checking for the year. Because the year column is connected to a secondary trigger automation where multiple field agents goes to the event website and collates the details about the event (Description, Target audience, topics discussed and others) For the year, when the field agent checks the website today, it might be still 2025 but tomorrow the website might have been to the subsequent year which is 2026.  So the question is is there a way to automate the regular event website checks. 

Hello, I've built my site and linked my forms from the backend and captured in AirTable perfectly. This forms contain data from buyers/sellers landlord/renters(property field), I want to know if Omni can assist me in creating a matching feature so I can link buy-sell or landlord-renter requests that come in with certain perimeters which then matches and creates a new set of data, that i can follow up with. Is this possible?

As the title states, I need to know how to make comments made on an image viewable in a shared view. I don’t need the ability for people to comment, I just need the comments that I made visible to them! Seems silly that I can share all the other information on an airtable, but I can’t easily share comments that break down what an image shows to more clearly convey the information being shared...

Hi, hi. Happy Midsummer. I hope you are all wonderful. I have the most simple task that I cannot figure out for the past ten days. I'll attach an image here. I set up my inventory tracking system. I included a button to receive packages of inventory and a button to delete used packages of inventory. I cannot connect these buttons to update my current inventory column. My buttons open beautifully to the form, but when I input two boxes were received, nothing is updated in my current inventory. When I update two boxes were used, nothing updates as well.Let me know what additional information I can give you if you have a possible code. I've tried a bunch, and it seems like such an easy task, but nothing is sinking on my end for me to make it usable.Thank you. Thank you for your help. I appreciate you so much.Lisa  

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 :)

Hi, I have this table where i would like to filter by the ID of the player. But I strangely cannot find a way to do it.  Thanks a lot for your help,Laurent

Hello guys, this error always comes up when I'm trying to add data using a pop up form on an interface level: Worker responded with {errorCode} for {path}, {action}, {modelClassName} (Please see the First Image)Also when I'm trying to add data manually on the backend, an error message also pops up (please see second image). Both of this are occurring on the same table. I'm the author/owner of the base.What do I do? Thanks in advance!