Ask the Community

Hi people!I am trying to establish an automation which appends a row to Google Sheet when the certain cell in Airtable is filled.Everything is ok except that duration data from a formula cell is not synced as h:mm as in Airtable but instead I get some strange number such as 3427.Is there any way I can correct this?Thanks so much!

I was told Airtables had better database like features than Notion, but cant find them I have 3 tables, A → B → C , and want to get data from A in C but cant find a wayFor example I have a clients table, a contracts table and a monthly payments table, in payments table i link to the contract to be paid (and ofc contracts links to clients), clients table include a field security_deposit. I want to calculate the amount to pay for the given month, and include a checkbox to mark its the first payment. Another thing (that Notion can actually do) is to reference a column of a linked table in a formula, I cant find away to reference data by formula in Airtables.For example, in Notion using gui i cant do what i want, but I can use a formula to achieve it.This would be something like: if( first, contract.map(current.client.map(current.security_deposit)), 0 ) 

I’m having an issue with an automation getting stuck when trying to update a Google Calendar invite, but only in a conditional set of automations. When I test it with the exact same instructions without the other actions it works fine, so I know that the configuration is good. The automation is triggered when 3 fields match conditions. The conditional actions are based on 2 different fields with the first two actions having one of the fields the same (status), and the other field being empty or not. These first 2 sets of actions work just fine with no issues. The second set of actions is a different status, and whether the other field is empty or not. The emails go out fine, so I know it’s getting to the correct conditional actions Then it gets stuck on the first calendar updateHere is what I see in the history. I have no idea what the error message ERR_UNESCAPED_CHARACTERS means. As stated, this exact same configuration works just fine on it’s own.  

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!

After creating a Blank interface, I used "Add element" to add record-pickers for tables A, B, C, and D, as shown in the image. For each table, I arranged the relevant fields vertically.What I want to achieve is to visually group the vertically arranged sections for tables A, B, C, and D. I think just giving each section a different background color would be enough.However, it seems that such a basic feature doesn’t exist, so I’m wondering if I might be missing something.Thank you!  

Hey all!I’m currently developing an extension for Airtable, and at the moment, all of the logic resides in a single file, index.js, as generated by the initial project setup.Is it a requirement of Airtable’s extension framework that all code must remain in index.js, or is it safe to refactor the logic into multiple modules/files for better organization and maintainability with TypeScript?I’d appreciate any official guidance or best practices. Thanks in advance!

Hello, since today I am having a problem that does not allow me to work with Airtable. When I try to paste a code snippet into a text field of any type the program gives an error and crashes. I have done this many times before and there have never been any problems… But today there is no way… PD: I’ve tried it on a friend’s account and the same thing happens… I’ve restarted, cleared cache and so on but there’s no way…

I have an Airtable node in n8n/If I run Execute Workflow,  If “Execute Step” id :rec7hUqA1NtQcoTZ4createdTime; 2025-07-28T20:53:58.000ZBooks: 1RecordID: rec7hUqA1NtQcoTZ4      

Here’s what I have:Meetings table with Meeting Status single-select field.Tasks table with Task Status single-select field.What I want to do:When Task contains (blah)and when Task Status is Completed.ThenUpdate Meeting Status to Completed in Meetings table.I did this exact same thing a while ago with the same tasks table and an exam table, and it works perfectly. Here’s a screenshot: But when I set it up exactly like this one, it doesn’t work? I’ve even duplicated the automation that does work, only changed the action’s table and field, and it still doesn’t work.How am I doing it differently from the first? How do I make it work? It needs to only work on the single meeting that is connected to this task (there is not more than one).

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. 

Buenas tardes a todos, tengo una tabla de clientes que tiene un campo casilla de verificación que se llama Realizado, y me gustaria crear una automatizacion que cada 12 horas el campo de verificación realizado se modifique a 0. quiero decir que recorra toda la lista clientes y modifique el campo a 0 que todas las casillas marcadas se desmarquen. gracias.

I currently have a table called template table with about 100 items in it. I want to run an Airtable Automation, so when a new record is created in a second table (Request Table) and the name of the record matches the name in a field from the Template Table, I have a step to find all records with that name in them. Let’s say for that new record from the Request table there are 10 matching records in the template table. What I want to do now is go into a new table and copy those 10 records and essentially create 10 new records in the new table with all of that information.I created an automation for this consisting of 3 parts:Trigger: When Record is Created (Request Table)Action1: Find Records (Template Table)Action2: Create Record (New Table) The problem that I am facing is that instead of creating 10 records in the new table, it takes all 10 records found in action 1 and puts 10 items into a single field for all fields in the table I am copying over. I want 10 records, but I am gettin

I’m running into an issue with an automation that should create a new record in a table and link it back to the source record. Here's my setup: Loom incase you dont want to read below :) I have two tables: New Applications, which contains fields like Full Name, Cohort, Officially Onboarded Date, and Status (single select). Board Buddies, which has a linked record field called Member Who is Onboarded (links back to New Applications). It also has fields like Cohort, Officially Onboarded Date, and Name that are lookups or formulas based on that link. The automation is set up like this: Trigger: When a record in New Applications matches conditions (Status = Roster Member and Officially Onboarded Date = TODAY()). Action: Create a new record in Board Buddies, and set Member Who is Onboarded = {{Record ID}} (from the trigger). The problem is that the automation fails with the error:"Creating the record failed due to insufficient permissions."I’ve tried: Wrapping {{Record ID}} in square br

I want to make sure I'm not missing something. I have an automation that copies some data columns from one table to another, when a button is clicked on an interface. It does this for batches of data, and I have a checkbox to mark when the automation reviewed a record.This is easy to setup using the Repeating group feature.However, I also now want it to check for duplicates. Rather than creating a new People record, I also want to check if that person exists.This would require using the Conditional Logic tool in automations. However, I can't seem to use both Conditional Logic and Repeating Group. I'd like to 'Repeat' through every record, then use a Conditional Logic by finding if a match exists.I'm guessing my only option would be to script this using Javascript in the automation. Is that correct or am I missing something? 

I have an automation that runs everyday, looks for records with certain conditions and if they exist, adds them as a grid to an email that is sent out. The problem is, if there aren’t any records that day, I get an error because it still tries to send the email. Conditional logic(else do nothing) to prevent an email from being sent if there were no records would make sense to use here. I don’t see those options coming up when I try to add actions. Am I missing something or is this a bug? I’m not looking for an script alternative. If there a way to do this using the block logic I’d like to know.

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

I'm trying to create an automation that when a form is submitted to one table (Touch Points) then it also updates another record in a different table (Global Worker) I’ve got the RECORD ID formula showing in Global Worker table, and am Linking the automation to it.However I’m getting the Received Invalid Inputs. Not sure what I’m doing wrong here. ​​​​​​ 

Hello, I need help in resolving an issue with an automation I created that includes an  integration with documint.   The workflow begins with a form where several names can be submitted to recieve an award certificate.   In my automation each of those names creates a record in a table and then upon creation of the record I have the “award” generated in Documint.  It seems that Documint cannot handle multiple requests at once, so it kicks back an error.  I need to create a delay between requests in some way.  any suggestions? 

I am using the Python client for the Airtable API. I am trying to read records from a multiple select column, and all I get back are values that look like the following: ['reccUldOjxhd0jlJW']. These seem to be a hash or maybe a pointer? How can I get the actual values?

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

Hi!I want to send invite for event and I want to track who RSVP. How do I build base or connection? I am thinking weebhook. So every member gets email with the specific webhook (record id), but where (in which table) do I put it?These are my tables: Members/Events/SpeakersHow can i send email to every member with a link (webhook), that when the member click on "i am going" button in email, I can see the list of all who clicked either "i am going" or "i am not going".I already created webhook in make and I added it in AT and customeyed it with record ID.https://hook.eu2.make.com...' & "?Record=" & RECORD_ID()I put this field in Members table.Then I create automation:Trigger: if the date of event is 1 week before today - in table Events1st action is find records - in table Members (so that i can send emails to them)2nd action in send email with webhook. and here my problem accour. I can only select "list of "webhook") in the email, because webhook field is in the members table).

Hey All, I am stuck trying to change a ROLLUP % field into a string so that it can be displayed in an automated GoogleDoc. At the moment when I try to create a string it fails to display anything in GoogleDoc tests, just shows a blank space. In the automation plain I can select the field without a problem. The ROLLUP % I am trying to turn into a string is a summary of one of the criteria in our survey → the roll up field is called “CourseDesign%” IF(values, (AVERAGE(values) / 5)) My attempt at creating a string is: IF(LEN(CONCATENATE({CourseDesign%}))>0,CONCATENATE((ROUND({CourseDesign%}*100))&“%”)) Any assistance appreciated! Thanks :slightly_smiling_face:

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

I have a list of “Hire Days” in a table. Each record has a bunch of information including the assets being used on that hire day, the staff member and the Day (as in Date) of that hire day.  When a ‘new record’ is created, it want it to trigger an automation. The automation will be a script that compares the day and the asset of the new hire day record. If there is already a record with the same day AND same asset, I want the script to produce “Clash”, otherwise “No Clash”. Can anyone help me?