Automations

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? 

Hi everyone, I have a question about automations and what the best practices are when dealing with external API calls.We have an automation that enriches records by pulling data from Google Maps. Every time a new record is added to the table, a second automation is triggered: it uses an enrichment API to find an email address from the website, verify it, and then update the record.The issue is that this enrichment step takes a few seconds for each record. Because Airtable runs automations one-by-one and queues them, this causes huge backlogs of pending automations, which slows everything down and sometimes causes the system to get stuck or bug out.My question is:What’s the recommended best practice to avoid infinite queues or stuck automations when using external APIs that take a few seconds to respond?Should we batch records? Or is there a better architectural approach?Any guidance or suggestions would be greatly appreciated.

Hello everyone,In short, I am trying to use an automation to combine multiple single select linked fields into a single multi select linked record.I have two bases: projects and team. Depending on the complexity and size of the project, there may be 5-15 resources assigned. We assign these resources through their own single select linked field so that we can utilize the timeline/utilization function. This makes doing things for the entire team complicated - such as creating a distribution list for the team members -  as we have to create a lookup field for each resource's email, another field to combine them, and another field to format it. I thought a simple automation could address this issue. It is pretty simple: when one of the 15 single select linked records is updated, it updates the multi select "team" field with all the assigned resources. I am running into two issues: 1)If I don't put a separator, then the multi select merges them all together (Instead of the field h

Hi everyone,I’m facing an issue with an Airtable automation and would appreciate some help.In my automation, I’m trying to Find records whereProject Number  contain  Project Number fxBoth the values are sameIt give error:-  Invalid filter on Project Number (Invalid filter value: [ "P454" ])Could you please the solution for it.

We're trying to send a email with a unique booking code from a list of booking codes sent to us when a form is submitted.

Hey all, I noticed that my automations that rely on new rows as triggers on Google Sheets no longer seem to be triggering. I created a new base and a new sheet and tested, just to discard issues on my sheet or AT base, but it looks like this new automation didn’t work either. Is this issue happening to anyone else? I checked the status pages of Google and Airtable, but couldn’t find any info. 

Hello - I duplicating an automation and was able to make 7 duplications but I am not able to duplicate anymore. Is there a limit on how many we can duplicate? 

Hello! I need some help with an automation setup.I’ve created an automation that ends with a loop step, and I would like to add one final action after the loop completes — for example, sending a notification once the last record in the loop has been processed.However, Airtable doesn’t allow adding steps after a loop, so I’m not sure how to handle this.What is the best practice to be notified when the entire automation (including the loop) has finished running?Is there a recommended workaround or pattern for this?Any advice would be very helpful, thank you!!

Hi!I have setup email automations through Airtable (trigger: when a record enters a view - action: to send email through gmail).The issue is the email is being sent at midnight, which makes it evident that it is not a personal email from our team. How can I setup either the filter on the view, or the trigger/action so that all of our emails are sent at 8am PST? We have an enterprise account, so I feel like this has to be an easy solution, however everything I'm finding seems to incorporate like four additional columns and formulas, which seems really inefficient...

I have an automation that 1st Finds Records from a table then Inserts the Found Grid into an Email. I have static Emails and also want to Use Emails from the Found Records.  If all the Found Records Emails match is there a way to just add 1 instead of it putting in multiple identical Emails in the To:I imagine maybe a script but do not know how to write those. Bull

So as we know, we can now enable the creation of records in tables that have been synced from other bases. It's great. Massive improvement. But can someone confirm for me whether we should be able to do the same using the Create Record action in Automations? Should spend my time doing a workaround or bug hunting? Because it isn't working for me.thanks,

Hi,I created an email automation, successfully ran tests and they all worked. I even saw the test emails on my sent folder items. However, when I published by toggling the "on" bar, the automation emails were not sent. I even created an update record to verify that emails have been sent, I performed a test to confirm the triggers were correct. It worked! the email test was seen in my sent folder of my email box, the update record trigger for that one I tested worked but the mass email automation has not been sent. What am I doing wrong or perhaps how long does it take for the email automation runs to work successfully? 

I'm trying to set up an automated email to email our clients with a feedback form (not an Airtable form, we use a different platform). The feedback form needs to be tailored to each individual, so I've added a field for the link for each record. In the automated email, I'm using the "choose data from" tool to insert the form url from the record. However, when I generate the preview, there is nothing left. I've attached screen shots of the draft email vs the preview. How do I make the link appear in the email??

Hi! I'm new at this. I want to send a scheduled email to a subgroup of contacts and pull in specific Airtable data into the body of the email and pull in the email addresses from the database. I'm using the gmail integration.In the "To" field I'm using the + to pull in email addresses from the base structure and the test keeps failing. It says "Invalid email address in the "to" field: fldU4hKNRZaMDR6U3".  The other fields in the body of the email that I'm pulling in from the base structure say FIELD ID instead of what the actual field name is and so I think those are also not working properly. I feel like I must be doing something incorrectly. PLEASE HELP. Is the email address in the To field what will act as my key to pull in all the other relevant data? I'm not clear if I need to set up a lookup/key mechanism here since the trigger is a specific time and not meeting a condition. To get to the subset of companies I plan to add a condition. THANK YOU!  I'm havi

I have an automation that reminds me to complete a task once every month, however, I realized what I actually need is a reminder specifically on the second Wednesday of every month. I’ve been having a lot of trouble figuring out an automation for this new reminder requirement and would love some assistance if anyone has any tips or advice.

Hello the community,I want to write a script which will read the data from a csv file which is in the attachment field "doc"  in the table "fileImport"The csv has 4 columns:Nom,Ligne,Jour,Valeurhere is an example of the data:Nom,Ligne,Jour,Valeur Bornet Marc,AL / ASD,2024-04-01,2Doe John 85%,AL / ASD,2024-04-01,17I want to parse all data and to create/update/delete records in the table "Planning" and writing the data in the appropriate field:Nom,Ligne,Jour,SV how can I do such a script 

When I first started working on this automation script, Airtable presented a list of records to choose as the input for running tests. That was all fine.Later on, I deleted that record, and now the script is failing because the record doesn’t exist. But I don’t see any UI for changing or selecting a new record to use for the test input.Is that not possible?  

Hi everyone 👋I’m importing data into Airtable, and one of the fields arrives as a JSON array that looks like this:[ { "key": "Label", "value": "Sample A" }, { "key": "Code", "value": "0716" }, { "key": "Category", "value": "Lotus" }]Instead of showing the raw JSON, I’d like the field to display something more readable, for example:Label: Sample ACode: 0716Category: LotusI tried changing the field type and using simple formulas, but it still shows the full JSON array.Has anyone done this before?Is there a formula, script, or automation that can parse this JSON?Any suggestions would be really helpful, thank you! 

I have two separate bases. When a form is submitted in base1, a record is created. When a specific record matches a condition, i want to use an automation to create a record in base2.Ive tried using the sync feature in the data layer, which appears to pull base2 data layer into base1 data layer but when i go to the automation, the table I want to create a new record in is there, but is greyed out and cant be selected. I went through permissions with someone from airtable, but we still can’t figure out what the issue is. This is from the automationIn the table field i can see the table i want to create a new record in, but it is not selectable. IN the data layer, it is listed as grid view   

Is it possible to change the sent from email, from the default of automations@airtableemail.com to something of our choice? Or by a per project basis?

I want to update a record when a field condition is met, and currently the “Update Record” automation only seems to use any value/change to the field. What I am trying to do when the “Status” field is updated, and ONLY when it’s Value is changed to “Used” do I want to execute the update. Right now when the value is changed from Used to Unused, it runs the automation. Any guide on what combination of actions I can use to do this?

Hi everyone —I’ve built an automation that:1️⃣ Triggers when a Project Overview record enters a view2️⃣ Creates a related record in Prelims Summary (Client Breakdown)3️⃣ Updates the original Project Overview record to link back to that new recordEverything works — the link is created — but in the run log, the Linked Prelims (NEW) field shows two entries: ["rechvSfKKM3dFqypl"] ✅ (green — works) "rechvSfKKM3dFqypl" ❌ (red — literal string) I’m currently setting the linked record field value in the Update Record step as: ["Airtable record ID"] (using the dynamic variable from the Create Record step with the “+” button).Is this expected, or should only the array appear?Could something in the input mapping or type conversion be causing the duplicate string entry?Any insight from others who’ve built dynamic link automations like this would be great — thanks!

Hi all,I have 2 connected fillout quizzes.The first is set to create a record, which is working fine.In the end screen, I have a URL button linking to the next quiz.The second quiz is set to update a record, but in the results, it creates a new record.I add an ID in the URL parameter for both quizzes.Where do I go wrong, or what am I missing in the process?

Hi! I’ve tried a few different ways of doing this and can’t seem to figure it out. I’m importing some data into a new base and there’s a field that has update notes on different lines all formatted the same. I’d love to figure out an automation to add each line to a linked table as separate updates connected to the parent field. Has anyone attempted this before?Sample long text:6/24/2025: PB approves DM7/8/2025: revised draft sent to client7/10/2025: sent revised draft to sales/CST's7/14/2025: sent revised draft to client7/15/2025: final draft  7/24/2025: final approvals + sent execution copy7/29/2025: f/u w/ client + PE + email FE PDF to client 

I am doing a hiring and searching for jobs database. I have made the form for everyone involved but would like for them to be able to change their availability status after having submitted the form. Is that possible? I haven‘t upgraded my subscription, I am still using the free version. I am new in airtable, still trying to figure it out if it is the answer for what I am looking for before I start paying.