Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,191 Topics
  • 16,172 Replies
5191 Topics
V
Vanessa DNew Participant
asked in Automations
generate a "today date" that updates daily

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

406
BuildForAT
M
Mitchel WijtNew Participant
asked in Automations
Airtable async function executes without an await keyword

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! 

677
BuildForAT
V
ValterParticipating Frequently
asked in Automations
Google Drive Sync: File picker is empty despite Team Plan and Admin permissions

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 "

19210
V
Yka
YkaNew Participant
asked in Automations
Email Automation and avoiding multiple email CCs

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.

826
Mike_AutomaticN
K
KassandraNew Participant
asked in Automations
X / Twitter API

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

575
Mike_AutomaticN
Y
Youri van der MijnNew Participant
asked in Automations
Structuring Editable vs. Non-Editable Account Lines in a Multi-Table Budgeting Setup (Staff vs. OPEX)

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

221
TheTimeSavingCo
J
jakepapNew Participant
posted in Automations
Downloading a PDF file from an Extension

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 

1884
P
TheMortgageMeister
TheMortgageMeister
asked in Automations
Add the same email attachment to every automated response

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.  

9910
ScottWorld
Mike_AutomaticN
Mike_AutomaticNGenius
asked in Automations
Errors with repeating groups on automations?

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!  

12312
Mike_AutomaticN
Y
Youri van der MijnNew Participant
asked in Automations
Best Practices: Conditionally Create Rows in Another Table Based on New or Updated Records

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

602
Alexey_Gusev
S
SenRathParticipating Frequently
asked in Automations
Automation - Converting Field Data/Text

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

814
Mike_AutomaticN
B
bforrerNew Participant
asked in Automations
flexibility with dates/schedules

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

532
B
A
agaborNew Participant
asked in Automations
Maximise how many times an automation is allowed to run per day

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?

343
Mike_AutomaticN
CodeKnight
CodeKnightInspiring
posted in Automations
Airtable Prefill Form Link Generator

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

513
ScottWorld
CC-JennK
CC-JennKNew Participant
posted in Automations
Sync w/ Google Sheets - One Way from Google to AT

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

6473
Andy_Cloke
B
BethHansonNew Member
asked in Automations
Creating a Task List from Automation Alerts

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!

273
TheTimeSavingCo
B
Booksy.buzzNew Participant
asked in Automations
Email signature using Outlook

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?

1788
ColeenRoss
B
b_cummingsNew Participant
asked in Automations
Find Records automation - Need help with strange error: "No valid nested options"

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!

3579
J
ceo13
ceo13New Participant
asked in Automations
Automation not triggering despite checkbox being toggled

Hola a todos,Tengo una automatización que se activa cuando el campo de la casilla de verificación "Asignar o actualizar" está marcado. Funciona bien la primera vez que se marca, pero el problema es que este campo se puede marcar y desmarcar varias veces (ya que se esperan actualizaciones regularmente). Me he dado cuenta de que, aunque la casilla de verificación se vuelve a activar (se desmarca y luego se vuelve a marcar), estos cambios no se registran de manera consistente en el historial de revisiones y, como resultado, la automatización no se vuelve a activar.¿Alguien ha experimentado esto antes? ¿Existe una limitación conocida con los cambios de casilla de verificación que no se capturan como actualizaciones, o una solución alternativa para garantizar que la automatización se active cada vez que se marque la casilla?¡Gracias de antemano!

717
Mike_AutomaticN
R
Robert_TellierNew Participant
asked in Automations
How to use your own openAI assistant in Airtable automation?

Hi Community,Is it already possible (with a workaround) to set up your own programmed OpenAI assistant in the automations? I see the different LLMs listed but not yet the option to connect to your own assistant.Anyone have a solution for this - would be super valuable

3367
Andy_Cloke
K
Kris_WignessParticipating Frequently
posted in Automations
Find Record Automation - What if Not Found?

Hi all. My first question on the Community forum, so please bear with me. Now that Airtable has added a Find Record action in automations (Yay!), I am wondering if anyone has figured out how to create an action in the event that a record is not found matching the criteria. I have found a need for this automation a few times. To give one example, here is a summary of a scenario: I have two tables - an “All Contacts” table and a “Submitted from Form” table. When someone submits their name, phone, town, state and email address, that info goes into the “Submitted from Form” table. When a record enters the “Submitted from Form” table, I want to search the “All Contacts” table to see if any record has a value in the email field that matches. If there is a matching value, then I want to update the record in “All Contacts” to the current info for the other fields. [So far so good, using the current/new automations] If there is no match, then I want to create a record in “All Contacts.”

1129
ScottWorld
Darryl_Oliver
Darryl_OliverInspiring
asked in Automations
Google Doc Integration - Record Limits?

I’ve created an automation that uses the Google Docs integration to create a report. Records found by the automation are added to the GDoc in grid format. Unfortunately, each grid tops out at 10 records in the GDoc, even though the Find records actions have a limit of 100 records. Any ideas?

525
Mike_AutomaticN
D
dzassNew Participant
asked in Automations
Airtable Script Automation: to separate registrations in a table

Hi everyone, I’m new to using Script in airtable and was using ChatGPT to help me write my script. Basically, I want the script to read my table (titel is Workshop registration) and when people register, they can click on as many workshops as they want. The script was to then separate the 1 registration into multiple, and it worked! However, I changed one of the columns from single to multi-select and it messed everything up, including the set up. It also just started to bug out a lot. Do you guys know what I could do? I’m not a coder at all and was primarily using ChatGPT to help me write it. 

1005
B
M
mshah72Known Participant
posted in Automations
Table format in emails

I want to create a table in my send email automation because there are several features that I want to put in the email and formatting as a table makes it easy to understand. I tried creating a table using markdown and HTML but it isn't working.  

3636
Mike_AutomaticN
metricsmule
metricsmuleNew Participant
posted in Automations
Airtable, ChatGPT, AI Images?

What’s the best way to create an automation with Airtable + Make/Zapier + ChatGPT + AI image generator (Midjourney, Leonardo AI, etc.)?  For example, enter a basic prompt in an Airtable base. Then, via Make it sends the prompt to ChatGPT, in which ChatGPT assesses the prompt and rewrites/improves it. The automation can stop there or go even further by then sending ChatGPT’s improved prompt and sending it to an AI image generator to instantly create that image?

2176
Mike_AutomaticN

Badge winners

  • First Topic
    Dwalz3has earned the badge First Topic
  • Welcome
    Dwalz3has earned the badge Welcome
  • Certified Airtable Admin
    nitinjainhas earned the badge Certified Airtable Admin
  • Certified Airtable Admin
    CaitlenBerghas earned the badge Certified Airtable Admin
  • Certified AI App Builder
    stagandforgehas earned the badge Certified AI App Builder
Show all badges
Terms & Conditions