Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,192 Topics
  • 16,176 Replies
5192 Topics
G
GeorgexmNew Participant
asked in Automations
All automations have stopped working, while testing successfully

All of automations have suddenly stopped working, while they test successfully. It's not about one automation, but for every and each automation in the base. The question is, what could be causing this problem, as everything worked perfectly until now.   

224
Pascal_Gallais-
M
mattysheetsNew Participant
posted in Automations
All of my automations have stopped working

When I test my automations within the Automations tab they work fine. For some reason they are not working based on trigger on live tables. Please help this is a huge problem for us.

113
G
C
ComradeNew Participant
posted in Automations
All of sudden my Automations have stopped working and started giving errors

Airtable automations have stopped working altogether for me. The Automations worked perfectly fine uptil 27th of this month(Screenshot-1 attached) but all the of sudden it stopped working(Screenshot-2 attached). I have checked all the conditional formatting and also ran a test for automations and it works fine during test but it gives error in real time automations.  I have not changed anything in the automations and I have also checked that I have not ran over the automations run per month count but it stopped working for me. Is anyone else facing the same problem. Will be grateful if someone helps me sort it out 

212
G
P
PauBNew Participant
posted in Automations
Problem with input.config

Hello everyone,I did a trigger "When record is created" and script action where i want to get the record id to be able to update the record and all stuff. To do it, I'm using input.config() but not doing well in input variables. As shown in the picture, I've created an input variable named recordId and the value should let me choose something like "Record (from step 1)" that should be the record id of the trigger. I've never used this before and I'm a bit lost. Thank you all in advance.  

1464
S
M
MaxLaiNew Participant
posted in Automations
Problem with automation

I can't understand....All my automations dont work automatically.Here is an example:Trigger:When an entry matches the condition.Completed search fieldsIf everything is valid, then update the field of another table.All the tests work, manually it updates the fields, but never automatically.I tried to change the trigger by:When an record is createdAt a certain timeNothing happens. It never fires.I have no errors in the tests, and I point out again, I have no errors, the entries were intentionally created in order to match to obtain a result.I deleted all the automations I had, completely recreated the tables to start from 0 in order to find why, well it's still the same. And the reslut of the test : Same result for all triggers. I didn't forget to update the automation... I don't understand anymore. Especially since it worked 15 days ago when I created this same automation.If you have a suggestion, I'm interested

105
Alexey_Gusev
H
heraklioNew Participant
asked in Automations
Script loop based on dates not running when dates are not in same month...

Hi community,I'm struggling to understand why this whatsoever perfectly working tiny piece of script stops doing so when (seemingly) the 'start' date and the 'end' date are not in the same month.I am rather new to Airtable script editor so I couldn't find a step-by-step run mode, or a variable value watcher, but it seems that the 'days' variable is not computed correctly when 'start' and 'end' belong to a different month (for instance, 2024-07-15 and 2024-08-07 - however works perfectly with 2024-07-15 and 2024-07-31, and then 2024-08-01 and 2024-08-07)... leading to not entering the 'for' loop at all.Any clue anyone? Many thanks in advance!  let table = base.getTable('Man.days'); let inputConfig = input.config(); const start = new Date(inputConfig.StartDate); const end = new Date(inputConfig.EndDate); const days = end.getDate() - start.getDate(); var date = start; for (let i = 0; i <= days; i++) { let record = await table.createRecordAsync({ [

100
H
C
cgresseNew Participant
asked in Automations
Delete entries based on condition

Dear All,Newbie here! To simplify our current workspace, we would like to duplicate our main base (let's call it A) and delete any entries in the duplicated version (B) with a deadline after June 2023. B will be used as archive for our past work.Then we would like to run an automation in A to remove any content with the deadline set till June 2023 (so we are only using what is for use " current content")This is a one-time automation; we do not need it to run multiple times. How can I set up the script for each scenario? Thank you in advance for your support and guidance, Best regards,Catherine 

100
C
J
Joel_BurmanNew Participant
posted in Automations
Automate sending an event invite (or attached.ics file) when record created and collaborators addded

Use case: Within an table (called ‘Meetings’) user creates a new record (i.e. a meeting) User adds date/time, text description, attendees (collaborator field), videoconference link (link field), etc. Automation sends a invite to each attendees email address (from collaborator field) as an email with .ics attached or alternatively as an MS Outlook Invite. NB. this is not the same as much of the functionality which just creates a record in a user’s calendar - as this doesn’t provide sufficient notification/visibility to the attendee that they’ve been added to a meeting. They need to receive an email - which can then create an event in their calendar. I can send an email from a record easily, but making this an invite/event or adding an ics had eluded me. Any suggestions welcome?

446
Gather
M
Matt_GuyNew Participant
posted in Automations
Google reported an error while processing this action: Mail service not enabled

Hi all,I've followed the advice, and every other ticket on this subject that I can, specifically disconnecting and deleting previous Gmail, integration, connections, and re-adding them, including adding three different accounts in case that's the problem. I've also created a new automation to see if that's the issue, although the air table processing seems to be okay. I've also waited a few days and tried it all again to see if it was a temporary problem somewhere on the stack, still no luck.I just keep getting Gmail related errors like those below. What can I do? Any help appreciated."Google reported an error while processing this action:Request had insufficient authentication scopes."   

331
S
A
Andreanne_St-GeKnown Participant
asked in Automations
An attachment url is disallowed

Hi there!I need to send calendar invites by email automation to people I book for events. I'm using Make to create the calendar invite and upload it as a file in Airtable.Then, I'm using automations to send the .ics file as an email attachment to people I book for my events. They can then download it from their email and it creates a calendar invite for them. Everything seem to work just fine when I test things.However, I have two types of emails to send via automations : Initial invitation when I'm booking someone to an event :Triggered when the entry matches conditionsSends email with .ics attachmentThis one doesn't work and the error is 'An attachment url is disallowed' Updates (for when something changes such as the event duration) : Triggered when the entry is updatedSends emails with .ics attachmentWorks fine! Any idea why my initial email won't send? My guess is that it's because the trigger is too fast and the file hasn't completely uploaded to Airtable

870
A
B
brewster3New Participant
posted in Automations
Send email 'insert value from field' is not formatted

In airtable I have created an automation 'send email'. I 'insert value from field', the field being a number. The number comes from an Airtable field which is a formula that is formatted to $123,456. The 'insert value from field' is not formatted and comes out in the email as 123456.123456789. How can I pass the field format to the inserted value?

31
TheTimeSavingCo
Cole_Wedemeier
Cole_WedemeierInspiring
asked in Automations
How to maintain % format of formula field in automation

Hello!I have a formula field set to format as a percent in the table. That field is then part of a linked record lookup field in a table that will trigger automation to send emails. I want to share that percentage in the email. However, when I use the lookup field in the body of the email, it only allows me to include the number as a decimal.  Is there a way to get this to show the percentage?The original formula field formatted as a percent:The lookup field settings:The automation's email token:The result in the email:Thanks in advance for any help you can provide! 

83
Cole_Wedemeier
R
RahmanberradaNew Participant
asked in Automations
Need help with Field Update Automation

Hey all, I have a table which is a  synced report from Salesforce that shows me opportunities coming up for renewal. I also created a different table with the same fields but is populated from the Salesforce report "SFDC Renewals Report" via automation: When condition is met (opportunity ID is not empty) - then create record in the second table "AE<>RAE Worksheet". My issue is that we moved accounts around in Salesforce and now some accounts have a different Renewal Account Executive or Sales Person. I cannot figure out how to automate the update of that Renewal Account Executive field in the "AE<>RAE Worksheet" to match the one in the synced salesforce report.  Any help is greatly appreciated

155
R
M
mohsinNew Participant
posted in Automations
Creating a custom table/grid with multiple rows in email automation

Hello,I have a Table that captures customer orders information through an Airtable form. Each order can contain anywhere between 1 to 20 products. Gist of problem and my data below with just 2 products: Ref #1: Name1: Size1: Color2: Name2: Size2: ColorOrder 001Product XSBlueProduct OXXLRedOrder 002Product KMBlackProduct CSBlackI have an email automation that gets triggered when a form is submitted. I somehow want the information in email in following format.Order 001 summary: NameSizeColorProduct XSBlueProduct OXXLRed What I have tried:Add records as List - too long vertically, not useful at all.Add records as Grid - too long horizontally, same issue as above.Try to manually format as table with HTML/Markdown: didn't workCurrent workaround: Add 20 separate grids (attached pic), but if order has only 3 products, 17 empty grids are in the email. Excerpt from automation below.Tried using helper grid views and scripts, but couldn't approach problem in a meaningful way. 

421
Workflow_heroes
J
jpghelfiNew Participant
posted in Automations
input.config may only be called once

I'm calling in a script more than once input.config, to show input variables, but the error say that I can.. so, how can I display 2 or more variable within a script?  

121
dilipborad
S
SercleNew Participant
posted in Automations
Bulk Reduce Image Size

Hi!Has anyone come across a way to bulk / auto reduce image size for uploaded attachments to Airtable? I also use Zapier and I am looking for a way to do it without taking on another monthly subscription only for this task. Thank you!

192
Saravanan_009
D
Dan_HalliwellKnown Participant
posted in Automations
Quick Teams Call anyone for a simple sync fix?

Is there anyone that could assist me for a 5min video call to see why my syncing of pages are not working please or do airtable have a support team that can help?Thanks all

42
D
B
Building_EnclosNew Participant
posted in Automations
How to Implement Real-Time Auto-Suggestions for Company Names and Addresses in Airtable Interface?

I’m looking to streamline data entry in my Airtable base by implementing real-time auto-suggestions for the 'Company' and 'Company Address' fields within the Interface Designer. Specifically, I want users to be able to start typing a company name or address, and have Airtable suggest existing entries based on what’s already in the table, similar to how Excel auto-suggests based on previous entries.I’ve explored options like linked records and single select fields, but these either require extra steps or don’t provide the seamless experience I’m looking for. Ideally, I’d like this functionality to be constantly available while users are working within the Interface, without needing to run scripts manually.Has anyone successfully implemented something like this, or is there a recommended approach or workaround that could achieve this within Airtable’s current capabilities?Thanks in advance for your help!

102
Sachin_191
M
MarineSoratoNew Participant
asked in Automations
Automation

Hello community,I have a table called attendance where each record is the date of the event, the participant, the payment.I want to automate the fact that each time a record is created from this table, it updates the list of participant from the table Event.Thanks for your help,Marine

53
Sachin_191
S
sreevi14Participating Frequently
posted in Automations
Duplicate check

Hello,I'm trying to perform duplicate check in a table and have only unique records maintained in the table.For Example: ID Name0000 ABC0000 ABCThis should return one unique row and update the table.Can it be done via automations? Looking for the steps here. Thanks.

113
S
K
K277_2New Participant
asked in Automations
Automation between columns

HelloI would like to know if it is possible to build an automation --> if Column B (Actual timeframe) changes and does not match with Column A (Initial timeframe), then the Column C (On time?) would change to YES or NO (single select option YES/NO)? Additionally, the actual timeframe value comes from Miro board. Thank you in advance! 

31
Pascal_Gallais-
C
Craig_TooheyKnown Participant
posted in Automations
Sort list function not sorting the Manual Sort field correctly.

Hi, I'm using an automation to Find Records on a quote and then to Sort this list before duplicating these records onto a Purchase Order.  I'm using the Sort list function and the the Looping function to go through each record, referencing the sorted list instead of the original set of records from the Find Records step.  Unfortunatley I'm using Manual Sort, and Airtable doesn't recognize its own Manual Sort means of using lowercase and upper case letters to sort this list properly.  Has anyone else run into this?For example, in this list: c1KWVc1KYc1KZc1Kbc1Kdc1Kec1Kgc1Ki The sort results put C1Kb as the first result, while Manual Sort puts C1KWV as the first record... Thanks in advance for any tips or suggestions.  

263
A
S
SzakalNew Participant
posted in Automations
Facebook automation reconnect

Hello,  My facebook automation dont't work.I need to reconnect all the time. When I relogin to account it work idk for 5min ? and  then i need to connect one more time...;/How to solve that issue? 

63
D
A
Andreanne_St-GeKnown Participant
posted in Automations
Icons that allows you to create a calendar invite in email automations

Hi folks!I recently received an Airtable email that allowed me to download a calendar invite using a button inside the email. I was wondering if there was any way to do this using email automations? I've included the email I'm talking about as an attachment. 🙂 Thanks a lot!

42
A
D
Debbie_BenkovicKnown Participant
asked in Automations
Trouble setting up new automation

Hi everyone. I am trying to set up an automation where when a diagnosis field for a trip in one table is updated it finds the corresponding person (that is connected) in another table and updates a diagnosis field in that table where only different diagnosis is entered. Attached is what I have started. It doesn't run. I tried adding a find records step but couldn't configure the condition (screen grab also attached). Suggestions please!

1810
Pascal_Gallais-

Badge winners

Show all badges
Terms & Conditions