Automations

I have a base that is largely used for planning.I have a lot of automations. Often one action sets off a chain of 4-5 automations.Because I use this base for planning, records get deleted often as part of my workflow (i.e. I change my mind).An unfortunate, unexpected irritation with this is that reasonably often, an action will set off an automation > I delete the record before the automation is finished (these are usually simple automations "if Record A Field A = x, update Record B field A" - most are not long and convoluted).And so, I have a significant and frequent number of "failed automation: record not found" emails and notifications.Is there any way to prevent this happening?

What is a good website  to parse data from a pdf into airtable. For example if I wanted to parse info from a rental application (contact info, lease info) into airtable what is the best website to do this

Hello, I’m new to Airtable, (trying to help a friend build an efficient solution) and I’m looking for some advice. We have a form with a rather large multi-select field. Users must enter their name, date and select any number of options from the multiselect field. The information comes into the table in the way you would expect: But in order for it to work with my friend’s processes (and existing tables) they need a way to break the record up (ideally on form submission) into multiple records: I found a way to do it with automations. I created an automation for each Option to check to see if that option has been selected, and then create a new record. Unfortunately, this is time consuming and will not scale well. Can you recommend how to build an automation script (or other solution) that can automatically parse the multi-select field into multiple records, one for each selection? Thank you,

Howdy good people!Hoping someone can advise with a product code lookup scenario. Our team sells training subscriptions. New subscribers submit airtable forms to notify of catalog onboarding. Each subscription is tied to a certain product (9 product types currently). Product name auto-populates in a multi-select 'Product' field upon form submission in an 'Offline Subs' table. Each product has a set unique code stored in another table (Product Codes). We need to auto lookup and match the product name with corresponding product code and auto populate this in a 'product code' field in the 'Offline Subs' table (see attached). Playing around with lookup fields and can't see an automation option, imagining that this will require a script to achieve?I don't have any coding/scripting experience so hoping someone can share a similar successful script or use case experience. Any assistance greatly appreciated. 🙂

I have a very simple automation that runs every 15 mins. It finds rows from a table that have data in a specific column and then uses a repeating group to send a slack message to each of the channels listed in those rows it found. This typically works 90% of the time but usually a handful of times a day it errors out for Slack API rate limited. Sometimes it errors out with 4 groups that it found but will also error out with 1 group. Experiencing similar issues related to the repeating groups for slack messages.  Any help is appreciated.  

Hi, I am new here. I have some columns like name, email, job title. I have 3000 rows of these data. I want to send personalized emails to all of these 3k users with their name and job title. How can i do it? Is there any automation or extension available which can help me with sending these email automatically?Thanks for help.

We are currently using dedupe to identify duplicates in our records.Since our records is growing, we need to do it in automated way everytime there's a new record coming in.Here's the scenario:When a new property address will be added, there should be an automation that will automatically check the current records that we had, and it will tag this new property address if it's a duplicate or not.We just want to have an accurate solution if there's a new entry coming in, it will automatically mark or tag as duplicate.You can just imagine a Google Spreadsheet, if there's a duplicate it will suddenly highlight the column with duplicates.Do you think it's possible?

Hello there, I want to create a form in Softr, connected to my Airtable DB, where my employees will input their availabilities for “next week”, so I need to generate automatically the “next week” concept. I have created a table “weeks”, with the following columns :Week number Year To generate the concept of “is next week”, I want to create a date field “today” that updates automatically on a daily basis, and then in the field “is next week”, put a formula. However, I don’t know how to automate the update of the date at “today’s date” . Can you please help ? :) 

Hey there, I am currently building some automation scripts in conjunction with my API. For performance reasons i would like to call multiple promises in a Promise.all function. However it seems that whenever I try to make an array of promises that by calling my async function (without await) that it already executes the fetch call to my API. Which shouldn’t happen.  let promises = records.map((record) => {  let firstPromise = asyncFunctionWithFetchCall1(record);  let secondPromise = asyncFunctionWithFetchCall2(record);  return [firstPromise, secondPromise];});let results = await Promise.all(promises.flat());here firstPromise and secondPromise already execute the fetch call within the functions.Has anyone experienced this before and is there a fix for this? Thank you! 

Hello everyone,I'm running into a very frustrating issue with the Google Drive Sync feature and I'm hoping the collective experience here can help, since support is currently unresponsive.My Goal: I want to set up a one-way sync from a Google Sheets file to a new table in my Airtable base, to use that sheet as a data "dictionary".The Problem: I am on the Team plan. When I start the process from Airtable (+ Add or import -> Google Drive), I successfully authenticate my Google Workspace account. However, the next window, which should show me the files in my Drive to select from, is always completely empty.I have already performed all the troubleshooting steps I could find, but with no success.Troubleshooting Checklist (What I've Already Tried):✅ Plan Confirmed: My base is correctly on the Team plan. ✅ Ownership & Permissions: I am the Owner of both the Airtable base and the Google Sheet I want to sync. ✅ Google Sheet File Permissions: I have set the file's sharing permissions to "

I created an automation to notify an assigned person, however when an assigned person gets an email, the previous assigned person also gets CC’ed with the same notification. I am using a multiple users field.  Created a simple workflow trigger that listens for that field to be updated and sends an email. It works great when only 1 person gets assigned. However when a 2nd person gets assigned it triggers an email for the 2nd person and creates CC for all the previous people. I want to only notify each person once, not multiple times for each assigned person.

Ive tried to set p a workflow automation to X - but Im getting errors?  

Hi everyone,I’m working on a budgeting setup in Airtable and would really appreciate some community insight.We currently have a well-structured “CostComponents Employees NL” table, where we define specific account-level budgets per employee. These accounts all roll up under OPEX, and more specifically under the top-level group account “610000 – Staff Costs”. Some of these accounts belong to the group accounts:611000 – Direct Staff Costs 612000 – Other Personnel Costs 613000 – Car CostsNow here’s the situation:Certain accounts are budgeted at the employee level only and should not be editable elsewhere. Certain staff related accounts are budgeted at high-over level (not on employee level, Other OPEX accounts (not staff-related, Operational Costs) need to be budgeted at account level, under the following group accounts: Housing Costs Office Costs IT Costs Marketing and Travel Costs General Costs We are looking to build a unified “Chart of Accounts Budgeting Table”, where: All relevan

Hey,I have an extension in Airtable that creates a file for each record within a Table. Is it possible to download each file as a pdf and populate a file field in the same Airtable record? Each file generated by the extension doesn't have a unique URL (that I can find) to that records extension file making it difficult to download automatically. Please help!Thanks 

I have a Form that is submitted and an automation to respond with the same attachments to every form requestor. I realize I cannot add just a add a PDF straight to that field in the automation for emails. SO My question is how do I somehow get it to pull up and attach the same document to every form request? I am wondering also what it means to add an attachment via Table and Field Id’s , can i reference an attachment in a certain record? : These are the options on what I can add as an email attachment.  

All automations which include a Repeating group on a given base are erroring.When testing, error shows: “Rate limit exceeded: too many jobs have been created.” -see image below.When running on its own, error shows: “Invalid Input List”No automation runs limit has been met, No API call limits have been actually exceeded, Find Records limit has not been exceeded, Repeating Group limit of items/records which can be looped has not been exceeded. Automations worked great for months/year, but started erroring all of a sudden yesterday. Nothing has changed. I tried building new automations with repeating group, and even new automations fail. (started implementing scripts instead of repeating groups, and scripts do work) I already reached out to support, but did not receive a human-like answer yet.​@ScottWorld ​@TheTimeSavingCo ​@kuovonne any thoughts, ideas, similar experiences? Wanted to share this with you.Thanks guys!  

Hi everyone!I’m working on a workflow in Airtable where I want to automatically generate rows in a second table (CostComponents) based on new or updated records in a first table (Employees).In my specific use case, I want to create a predefined set of rows depending on the “Resource Type” of an employee (“Existing employee”, “New hire”, or “Freelancer”). For example:    •    For “Existing employee” → generate 16 rows    •    For “New hire” → generate a different set of rows    •    For “Freelancer” → generate yet another set of rowsEach generated row has static fields like “Cost Component”, “FTE”, and other data pulled from the Employees record.I’m currently using Airtable Automations with “When record created” and “When record updated” triggers, combined with a Run script action. The script seems to run, but doesn’t create the rows. I’m curious:    •    Is this the best (or most scalable) approach?    •    Are there other ways to handle this kind of row-generation logic within Airtabl

I am running a scraper to fetch data into my Airtable. Sometimes, the Company name is in full; for example, International Business Machines.I want to batch convert (correct term?) them into IBM. I am half done with the automation -- When a Record Matches “International Business Machines” .But what comes thereafter is the challenge -- I assumed it should be Update Record but unable to input the “IBM” text. Any help would be greatly appreciated. thanks

Hi. I’m not a coder and I’ve only been using Airtable for a few months. I’ve mostly used chatgpt when I’ve come up against something I can’t figure out on my own (which is mostly anything that requires coding) and it’s mostly done OK with a little back and forth. For my current problem it keeps giving me bad info so I’m turning to you all. I’m building a database for my company to track various data points about the projects we manage. I have a table called ProjectsList for this. For each project, we get many associated elements and I try to capture various data points on each element. This is done in ElementLog table. When we receive a schedule for a project, I log ScheduleStart and ScheduleEnd. In a normal world, every schedule would be a 5-day workweek and have the same holiday days off, etc. and it would be easy to set up fields that count work days/weeks between schedules, can do countdowns from today to start date, or tally days remaining in the schedule if we’re within the sched

Hi,I have made a mistake in one of my automation, and what was supposed to run 1-2 times per week ran over 20 thousand times overnight. Luckily this happened on May 31st, so I did not need to wait for my quota to reset. However this made me wonder if there is some kind of safeguard feature in Airtable that would, for example, maximise the number of daily runs for each automation?

I made an excel sheet a few years ago to help with generating a prefill form link.I hope it helps you! https://www.dropbox.com/scl/fi/gfzbhrx7fwns17kpxq7gb/Airtable-Prefill-Link-Generator.xlsx?rlkey=6sa39tyrcjd49senl02n7jbl4&st=fyoer74g&dl=0

I am newish to AT so maybe I am missing something.  I have read a few, slightly older, threads where users are looking for a two way sync solution and there have been many third party for a few solutions to their connection needs.  I don't need a two way sync, looking for one way from Sheets to AT.I am working on a project to link multiple content calendars and projects. Some of those calendars live in Google sheets, in the future we may be able to lure those teams over to using AT but that is not in the cards at the moment.What I am looking for is a solution that does not require us to have a subscription to yet another service.  I mistakenly thought that AT would have been the solution for these calendars that live in different systems.Is there a way currently to one way sync a Google sheet to AT?  I want AT to be the source of truth but the teams will be working out of sheets to make updates, so would just need those updates to be reflected in AT.  Updates c

I have discovered airtable in the last few days, so very amateur! I have created my first couple of automations to send an alert to managers e-mail when specific actions need to take place. The trigger e-mails include complete an absence review meeting if a staff member exceeds Bradford score of 150, and another is complete punctuality investigation meeting if employee is late more than 3 times in a month for example. The information like absences, probation due dates, lateness are stored in different bases. I would like to know whether it is possible to use these alerts to create a task list from all bases so I don't have to go into multiple bases and tables to find outstanding tasks. I would then like to be able to upload an attachment of say a performance review and this to automatically update to a completed task. Thanks in Advance!

Hi,I have set up an email automation using Outlook. Is it possible to add my email signature to this email and also change the from name to the business name instead of my personal name?

I'm setting up an automation to find records from webhook data. The field I need to match appears grayed out by Airtable with an error, "No valid nested options". Please see image.I've never seen this error message before, and a google search was of little help.Can you help explain what this error message means and how to resolve it?Thanks!