Ask your questions about Airtable Automations here.
Recently active
Hi, how can I use script to prompt a user to confirm an action when a button is clicked on the interface? The Button is linked to a record picker on a Blank Layout.I tried adding this to my script:// Ask for confirmationlet confirmed = await input.buttonsAsync("Are you sure you want to perform this action?",[ {label: "Cancel", value: "cancel"}, {label: "Confirm", value: "confirm"} ]);if (confirmed !== "confirm") {output.text("Action canceled.");return;}But I am getting this error:Property 'buttonsAsync' does not exist on type '{ config(): { readonly recordID: string; }; }'.(2339)Here is my script:let table = base.getTable("Test Log");let view = table.getView("New");const recordID = input.config().recordID;let record = await view.selectRecordAsync(recordID);// Ask for confirmationlet confirmed = await input.buttonsAsync("Are you sure you want to perform this action?",[ {label: "Cancel", value: "cancel"}, {label: "Confirm", value: "confirm"} ]);if (confirmed !== "confirm") {output.text("
Edit after ~1h of investigation: it turns out these are rate limits that are the culprit. Which raises a new question: if I change the email address in the automation, will it impact the runs that are currently in progress? My guess is no. And so, if no, is there any way to trigger a re-run of the currently stuck runs? I several automations running that involve sending emails. They have both run over 6k times until yesterday around 8pm many runs are stuck in “pending”. There are several things puzzling about it:There isn’t a clear cut off when the automations started getting stuck. See screenshot below: several still pending from before 9pm on Oct 16, followed by successful runs, then everything after 10.15pm is pending.2.Runs stuck at different steps. The automation has two steps: find records, then send email. The earlier runs are stuck at the step of sending an email. This makes it hard to verify which part of the automation is malfunctioning.Earlier runs pending at the step “send
Unbenownst to us and without warning, we ran into our Business tier automation limits. We run a mission-critical medical company. Is there any way to escalate this internally at Airtable? I have already submitted support tickets and contact forms. Ticket # 01168252. My business is literally stopped right now due to this and the repair process will be significant, and we didn’t have any warning whatsoever.
Hi everyone! I’ve been trying to use Webhooks for a while to create a simple link that will allow my University’s Data Team to click a link to let us know that a query has been created. The Data Team will not use Slack either, so I’m basically trying to do an Actionable Message, but automating sending an ‘actionable’ link through our Microsoft Teams Channel.I have the Webhook examples below.The formula automatically generates the RecordID into the Webhook so that when it is sent, the RecordID appears in the Params. However, I can’t get that information to go into the Body, so I am not able to use the RecordID in my “Update Record” automation. (AirTable recommends using ReqBin for webhooks/testing, so that’s what I’m in) With University Guidelines and permission issues, I am only able to do this through AirTable and not any 3rd party tools. Do you have any suggestions on how I can do this? Thank you!
I have a multi-select form field.If they click Paid Social, I only want to show the questions related to paid social.If they click on Organic Social, Employee Advocacy, or Executive Advocacy, they get other set of questions.Additionally, can I hide all the questions until the preferred channel is chosen?
I am trying to create a task management database for a small farming operation. Each year, many tasks will follow the same pattern of dependencies, duration, and time between. I currently have 4 tables: Plants: As I add plants to the list, I can generate tasks for the Task table with an automation that pulls tasks from the Templates - Task List table. Templates: Lists the different available task templates. Templates - Task List: Lists the different tasks associated with each Template. Also links dependent Predecessor and Successor tasks. Tasks: The final output table, where tasks from the Templates - Task List table are added when the automation from the Plants table is triggered. This automation works. Certain details are included in the Templates - Task List table and called to the Task List via lookup or rollup fields, including Days Before Next Task and Duration. I also have a marker (checkbox) to indicate which task is the starting task in a sequence. Another automation (also w
Hey everyone,Just wanted to introduce myself to the community. I’m Lawal Aliyat, an Airtable and workflow automation specialist.I spend most of my time helping businesses scale past basic spreadsheets by designing relational architectures, setting up external API integrations, and building custom Airtable Interfaces. I love solving the puzzle of turning messy data workflows into clean, automated systems.Excited to hang out here, learn from you all, and jump into the threads to help solve some technical bottlenecks!Feel free to connect!"
Using an automation to assign a part number to any part who does not have a part number. Since this database is needing to retroactively run this script one at a time due it is nature of how it assigns part numbers. The best way to do this is to have the script run once, then identify the next record this script needs to run on (next record without a part number) and run again.However as it stands, the second automation run will not happen even when the conditions of the second record are changes to meet the conditions of the automation.Is this a known bug/limitation of airtable automations?
Hi,I use the Airtable trick of having an automation update an URL link field so that it becomes a named clickable link. In other words, turning https://www.airtable.com into Click here with [Click here](https://www.airtable.com).The URL to be “coded” is in a Concatenate formula field and directed to Calendly meeting bookings. They include pre-filled variables with both name and e-mail, as well as Calendly “questions” pre-filled from Airtable data.The problem is that my automations that look exactly the same suddenly come up with different results, with the faulty one leaving out the last pre-filled variable, “a3”.Here’s the correct one (data changed):https://calendly.com/site/book?first_name=Jane&last_name=Doe&email=jane@hotmail.com&a2=rectH64j36cathyrm&a3=recvmhk5664mnx53 And here’s the faulty one, with a3 empty:https://calendly.com/site/book?first_name=Jane&last_name=Doe&email=jane@hotmail.com&a2=rectH64j36cathyrm&a3=The automation that now produces th
I am trying to make a template schedule with predecessors (which I have) then use automations to generate a schedule for each new customer that gets entered. I can get it to copy over tasks, but the automation seems unable to generate them with predecessors.I realize I could just copy the full template table, but ideally all customers would be in 1 table (with groupings) since we use the same team to support multiple clients and I need to be able to see when someone is allocated somewhere else. Right now what we’ve done is add a table just for the clients. Then there is a trigger link there to say that they are starting their project. The Action takes a “find records” and pulls the tasks from the template file. Then I have a repeat for each in list of records, create record and I’ve copied most of the columns down. But when I try to add predecessor it doesn’t like that.
Hello, Our office has been using airtable for 4 years and have an Enterprise level plan for our specific organization. We have been using the Send via Outlook action for many of our automations. We have multiple colleague’s outlook accounts connected in all of our Workspaces so that we can send an automation out to a population from the colleague that specifically works with them. Recently, Airtable revoked access to both mine and my manager’s outlook accounts. It gave the error:“Something went wrong with your account. Please try to reconnect.” with a Red Triangle ! next to the account. I reconnected my account successfully by logging into my Outlook. I also notified my manager to reconnect her account on her end, which she did. However, her outlook is still showing as “Something went wrong with your account. Please try to reconnect” on my airtable account and all of my colleague’s accounts. It does not show this error on her account. I had her select “Connect New Account” and try con
Has anyone else run into this?I recently split some automations into a second connected base because I was running out of automation space/organisation in the original base.The setup now looks roughly like:Base A = operational/source base Base B = synced/helper automation base Slack notifications now trigger from Base BEver since doing this, Slack notifications have become inconsistent or delayed.What’s weird is:the automations often seem to trigger only after I manually open Base B again.The difficult part is that sometimes it works completely fine for hours/days, and then other times we start getting internal reports that Slack notifications aren’t triggering at all.So operationally it’s become hard to trust because the behaviour feels inconsistent rather than fully broken.It feels like:synced tables aren’t refreshing consistently or automations in inactive bases aren’t evaluating continuously or “record enters view” style triggers are unreliable across synced basesI’ve also noticed:
I want to create a signable form using some fields from my base. I want to insert an image at the top of the form, then a bunch of text from a .doc, then the signature field. How do I do that and what level of subscriptin do I need. I’m currently on free. This form will be sent to 28 unique email addresses.
Hi, this is the first time I experience this issue first hand, but out of the sudden all attachment added using a Google drive link via API to my Airtable record gets removed inmediately after being added. It was working alright , but it suddenly stopped working. I know this is a well known bug in Airtable but could not find any updates. Files are sep with with open sharing and download rights in Google Drive, I an sending the export link in PDF to airtable and it was working currently until it stoppedworking
I am utilizing the reminder feature in Airtable for the first time. I’ve created a few “test” CRM’s to see how the feature would work for me. Out of 5 “test” CRM’s, only 1 gave me the info I needed. I have attached a picture of what I want vs. what I’m getting. Any idea why one would work and the others do not?
I have two tables:InvoicesTime Invoices has a project, start date and end date.Time has a project, start date and hours. I’m trying to find all the time records between the Invoice start and end dates for a project and assign them to the invoice. But when I try to find the time AT only allows static choices, not dynamic. How can I make this work?
GTM Data & Automation EngineerThe Sports Playmaker (TSP) — RemotePart-time / freelance to startRemoteGrowth path to full-timeAbout TSPThe Sports Playmaker is a sports business consultancy helping brands, rights holders, and media properties grow through strategic partnerships and targeted outreach. We're building our first GTM data infrastructure and need one person to own it — from raw contact lists to sequenced campaigns landing in the right inboxes, at scale.What you'll ownClean, deduplicate, and verify large contact lists from Excel and CSV into Airtable Build and maintain Make.com automation flows across the full stack Run Clay for waterfall enrichment — pulling verified data across multiple sources before it hits the sending queue Set up and manage Instantly.ai: domain warm-up, multi-inbox rotation, and eventually sending under client domains Keep Attio up to date as our pipeline CRM, synced to Airtable via Make Produce clean, segmented, campaign-ready target lists for every
I’m coming from an Asana background and am trying to build a project management system in Airtable. I’ve watched several tutorials and gathered advice on setup architecture, but I’m running into a few issues with automation and record relationships.Current structure:Base TablesProjects (connected to my submission form) Teams Team Members Project Types Tasks Task TemplatesCurrent flow / logicRequest Type (submitted via form) → Project Type → linked Task Templates → Teams → Team MembersAutomation setupTrigger: When record meets conditions Lookup record Create repeating tasks based on Project TypeI’m running into two main issues:1. Task templates are not filtering correctlyWhen I submit the form, all task templates are being created rather than only the templates associated with that specific Project Type.From what I’ve read pulling “project type” from a linked field is an Airtable limitation, but many tutorials seem to solve this as they separate Projects and Templates. I’m wondering:Is
I’m planning an Airtable base for tracking search result data over time and would like to sanity-check the structure.The use case is keyword and competitor monitoring. An external API would return search results on a schedule, and I want to store each result with fields like query, search engine, date checked, position, title, URL, domain, and snippet.My first thought is to have one table for keywords and another table for SERP results, with each result linked back to the keyword record.For context, I work on TalorData, a Search API for SERP data, so I’m trying to understand the cleanest way people store recurring search result data in Airtable.For people who have built similar recurring data workflows, would you store each search result as a separate record, or store one full search result page as JSON in a single record?I’m leaning toward separate records because it seems easier to filter by domain, position, and date, but I’m not sure if that becomes messy as the data grows.
Hi!I need to track attendance for different cohorts put on throughout the year. Each cohort has multiple sessions and multiple attendees. When attendees are linked to a cohort, I would like to automatically create attendance records for every session linked to that cohort. Attendance statuses will be updated manually later. I am having trouble setting up the looping automation. I have never set one up before and I am getting stuck. Any help pointing me in the right direction is greatly appreciated! My base has the following tables:TABLE: CohortsFields:Cohort Name (primary field) Attendees (linked to attendee table) Sessions (linked to Cohort Sessions table) Session Record IDs (lookup field pulling Record ID from linked Sessions)TABLE: Cohort SessionsFields:Session Name (primary field) Linked Cohort (linked to Cohorts table) Record ID (formula field)TABLE: Cohort AttendanceFields:Attendance Record (primary field formula) Leader (linked to Leaders table) Session (linked to Cohort Session
Wanting the items in the chosen lookup to be actually added to the record.
Be careful updating field types!I have a few automations that watch a field for updates to set a field-last-updated timestamp. I discovered that if you change the field type of a watched field from multi-user to single-user, if there is data in the field, it will consider the field “updated” and trigger the automation.This is not documented anywhere that I could find! And it messed up my timestamps 😑
I have created an email automation thats pulling the information from our grid view. But how do I get this to go full screen as its only taking up the left side of the email.I have checked other email notification and it takes up the full screen but it looks like everything I’ve done is matched correctly.
Hi, I’m being asked to reseach wether its possible to sync filenames and links to files in a Sharepoint document library to an Airtable project. It need to only sync filenames NOT the actual data. Does anyone know if this is feasible?Thanks
J’ai une automatisation qui, lorsque je crée une entrée dans Table1, crée une entrée dans Table2 et copie la valeur du champ Nom de Table1 dans le champ Nom de la Table2. Mon problème c’est que l’entrée dans Table2 se crée, mais la valeur du champ Nom de Table1 n’apparait pas dans le champ Nom de Table2.Quelqu’un sait pourquoi? Merci!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.