Automations

I have an automation that copies fields from one table to another once the checkbox is selected. One of the field is “Marketing, Communications & PR”. When the automation runs, it splits it into two items “Marketing”, “Communications & PR”. I want to have it as one sector when it is copied to the 2nd table. I tried some of the ideas mentioned previously but got confused. I can try “Marketing Communications & PR” which might solve the problem but don’t like it.Is it possible to solve this issue? Thanks a lot.

Hello all,I'm working on an automation that was working prior. Now when i changed fields on other tables (added lookups and notes that are not in automation) that were affecting it stopped working.I was working on a backup and I restored it back to normal and still not working.After running some test I see that the first step that is create record its not populating, therefore when I link back to that record it doesn't recognize it. None of those fields were changed but I did add lookups to that table and deleted a few fields that weren't necessary.I went back to revision history to see if I'm missing something but everything seems to be the same and now I cant link records. don't know what to do.Also the webpage asked me to refresh several times.The testing was working on the main CRM and when it stopped working on the backup it stopped working on the main as well (where I wasn't working at the moment)

I have three Tables. - Commit Items, Invoice Header, and Invoice Detail. Lets assume that For Commit No ACB001 there are 4 Records in Commit Items Table with many records for other Commit Nos.. When the invoice is received for Commit No ABC001 and entered on Invoice Header table with Invoice No and Commit No ABC001, I would like automation to grab four records from Commit Items table and create those 4 records + Invoice number in Invoice Detail table. How do I achieve this? Just a reminder, I am new to AirTable.

Hello all,  I want to update a record and use the famous trick to have another table and submit form.In the form a field contains the record_id of the line I want to update in the original table.When I submit the form, the automation fail, when I copy/past content of the cells in another line, the automation works.Here is a screencast to see the problem : https://youtu.be/DSfKKBnmfe0 And exemple of the lines (line 16 works well, line 15 breaks) : 16    rec4CbEaxD0FOSwWL    rec4CbEaxD0FOSwWL        Screenshot 2026-01-14 122852.png (https://airtable.com/appNAdRee7AIuvFLH/tblvVVZzS2tZ1btmg/recKXwRxIfZIWB847/fldD1Py2VRj2AtySo/attJtOQ7i1jcZtgKR)    Devis signé    checked    checked        15    rec4CbEaxD0FOSwWL    rec4CbEaxD0FOSwWL        Screenshot 2026-01-14 122852.png (https://airtable.com/appNAdRee7AIuvFLH/tblvVVZzS2tZ1btmg/rec16w5uCNmtP2gXq/fldD1Py2VRj2AtySo/attyeeGMrStyZYyDk)    Devis signé    checked    checked

Hi all!I'm trying to make something in Airtable which I think should be possible, but I haven't quite wrapped my head around how to make it do what I want.Here's the situation:I want a team to fill out a form with information which can apply to specific regions and/or date ranges. If one or both of the regions does not have an entry for today, I want to send them an automated email reminding them to submit an entry.I've got a base structure which looks something like this:The form part is easy, I have no worries there. Also, I was already able to set up formulas in the last 2 columns which determine if today or tomorrow is between the start and end dates.I thought I could then use logic in Automations to send an email if it encounters entries where:“Today within ra

Hello, We have went over the automations rate for airtable on business plan 100k. However, there appears no easy way to upgrade and a base that runs an app stuck with no ability to resolve. We’ve sent support email but no response yet.  Any solutions or way to get in touch with airtable so we can resolve this issue. This is costing us big. No response from their sales form either yet.    

Hi, I hope you're all doing well. I wanted to let you know that I'm building a chatbot in n8n, and I need the IDs for my "Base" and "Table" sections. I'm using an AirTool node for this; however, I don't know how to access them through AirTool. According to Gemini, it should look something like this:Copy the IDs:The code that starts with app... (Base ID).The code that starts with tbl... (Table ID).

Hi I am a New user to airtable. I need to create a quiz platform. I decided to use airtable for backend.But couldn't connect both and lack of guidance. Can you anyone please help me work around it its kinda emergency.

I have 20 project managers. Every Monday i need to email each of them independently their list of jobs that meet specific criteria they need to take action on. I am starting to run out of automations for this base and am trying to consolidate this into a single automation rather than an automation per PM. Here is what I am trying to accomplishat scheduled time (good on this part) find records - find the PM by email address (this is a record within the table) I've taken this line out because it does not seem to be able to dynamically pull each PM, but m not sure how tog et the automation to accomplish this step. find records - when status1 <100%, and status1 due date is empty (good on this part) find record - when status2 <100% and status2 due date is empty (good on this part) send email - the PM defined in pm email address in the table gets an email listing the records in parts 3 and 4. These records are sp

I have a table called “Tickets” that my team enters project requests. Each ticket has a due date. A second table called “tasks” are specific things that need to be done to complete the project. Some of these tasks must be done a specific number of days (lead time) before the ticket due date to meet the deadline.I have a third table with standard tasks with a field called “lead time” that I use as a template to populate the tasks for each project.I want to be able to automatically enter the task due date based on the pre-defined lead time and the ticket due date. These dates need to editable to account for holidays and other conflicts, so I can simply use a formula.I want to create an automation that will look at the ticket due date and calculate the task due date (subtract number of days from said task due date) and enter it into the task due date. I can handle most of the automation, but I’m a bit out of my league trying to grab data from one tabl

I’ve spent hours on this and can’t figure it out. My goal is to simply click a button to trigger a N8N webhook trigger. Can anyone help me?

DescriptionI have a Tasks table with a multi-select field (e.g. values: A, B, C).I also have a Subtasks table linked to Tasks.Goal:When the multi-select field on a Task contains A and B, the automation should create two Subtask records: one Subtask called  A one Subtask called B (both linked to the same Task) Current setup: Trigger: When record is updated Field watched: multi-select field on Tasks Run Conditional Logic If condition are met: Type = A → create record A in subtask table Otherwise If condition are met: Type = B → create record B in subtask table Problems:Type in Task table = A & B, but the

I’m working with a company that manages products, materials, and services across multiple Airtable tables.I want to use the Airtable API with Python to perform data integration / migration between two tables: A source table containing general product records A destination table where records must be created based on specific selected fields One of the main challenges is that I cannot rely on fixed column names, and I need a way to define which fields should be considered by the script when creating new records.I’ve read that working with JSON is the recommended approach by Airtable, but I’m unsure about the best practice to: Select only specific fields from a table Map them to the destination schema Maintain a relationship with a linked table (“categories”) My question is:What is the recommended way to automate field selection and mapping

I’m trying to build an automation so that if I put ‘Regular’ in the ‘type’ column in the bookings table it will automatically populate the ‘populate issues’ column in the same table with all the entries in a list (‘issue date’) from the ‘Issues’ table. I can’t work out how to build this automation and get a ‘Received invalid inputs’ error. Can anyone help?

I have a button and I would like to attach an automation task to it. Is there a way to do that, I see that you can attach a script for a URL but not an automation.

Hello, I have built a table with links to spotify, Instagram, twitter and tik tok and I also include the number of followers of each of the artists in the table. I update this data by hand and I would like to know if there is a way to automate this update or to do it on demand for a previously selected group of artists. Thank you!

How would I create an automation that whenever a record is created it should generate a PDF from my page designer extension, and place it in an attachment field - in that record.

I would like to populate a linked filed with the lookup field coming from different table. How do I automate this

I’m trying to work out if I can create an automation to do multiple tasks or if they all have to be separate (which might max out my allowance)…I have a table which tracks my book contracts. Each contract may have up to 5 titles on it and each title could be produced in up to 6 editions.  I’d like an automation that creates a record in my edition table for each planned edition…So,Test title 1 HardbackTest tile 1 PaperbacketcI can get this to work if each automation is separate but feel like there should be a way to group it somehow. However, at the moment when I try to create a chain it comes up as ‘otherwise’ so it doesn’t run the paperback if there is a hardback. What am I missing? 

Hey Airtable fam,I'm trying to build a deal flow CRM in Airtable, and I'm looking for a way to automatically pull investor data from Pitchbook into my base. I'm currently doing it manually but it drains my time.I'm wondering if anyone has found a good way to automate this process. I've been looking at a tool called the Pitchbook Investors Scraper on Apify, which seems like it could work, but I'm curious if there are any other solutions out there.I'd love to hear how you're using Airtable to manage your deal flow and any tips you have for automating the data entry process. Thanks!

Hi everyone,What are the recommended best practices for sharing complex Airtable bases with multiple stakeholders while maintaining data integrity, permission control, and performance—especially when using linked records and automations?Thanks in advance.

I am going around and around a lot on this problem and still trying to fin. d the right way to go.I have a table of invoices. The invoices are numbered sequentially. Right now I have to enter each invoice number by hand after checking a summary table I made that lists the latest invoice number used +1 from a formula.I would like to have the “latest number used +1” inserted into the invoice number field of the new invoice being created. I imagine that it I not as hard was I am making it. I will tell you that I am TERRIBLE at automations. I find them unintuitive and frustrating. It’s probably me.But I am guessing that an automation is what I need..So invoice table is “Invoices: House” and summary table is “Invoice: Next invoice Number”. The summary invoice numbers in the “Invoice: Next invoice Number” table are in a rollup field and the Invoice Numbers in the “Invoices: House” field is a numbers field if that matters.Any help is appreciated.Be

Hello,I’m trying to automate the population of resumes as attachments to a candidate table once a form is submitted.  I’m having trouble getting the resume file to attach to the resume field.  When I do it like this (within a loop through the uploaded resumes), I get an error saying “Invalid String”.  That’s likely because the “ContentReference” is a JSON formatted string.  I don’t see an option to insert the resume file itself, only metadata.  How can I actually auto-insert the resume file itself? Thank you,Robert

Hi Guys,Our staff submit invoices to airtable page and Airtable generate the form with Xero id however currently Xero submission Id is empty hence please guide us how to sync the data connects with Xero.If there is no direct connection/integration we can find with Xero and Airtable please guide steps to fix it.ThanksRegards,Being

Hi All. I have a problem that I hope is just a result of me missing something simple. I have an automation creating Outlook events from a list of Airtable holidays and birthdays. The “create” automations work fine. I was also able to capture the Event IDs from the Outlook events in the corresponding record in Airtable. Now I’m trying to generate a second automation for record updates using the event IDs and am running into an issue. When I input the data, the “Event ID” field shows up in the “Calendar” field, and the Event ID field is blank, so the automation won’t run. Photo included. Any ideas?