Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,194 Topics
  • 16,180 Replies
5194 Topics
W
WeianNew Participant
asked in Automations
How to avoid firing the triggers while I'm still typing

I have a field of long text, and I set an automation that could help me send a notification Email to my collaborators after I update that field. However, the trigger would be fired several times, when I was still typing(no matter using when the record updated or when record matches conditions)Is there any way to make the trigger only be fired after I finish typing? (for example click else where and leave that filed)Thanks a lot!

457
L
H
HisshamNew Participant
posted in Automations
NEED HELP Syncing AirTable with Google Cloud Platform. AirTable API Consult

Goal: Sync data from Google Cloud Platform with AirTable every 5 minutes.Problem: Some of the data syncs but not all the data. In other words, what is reflected in AirTable does not always match what is in Google Cloud Platform. The problem does not happen all the time which makes it difficult to troubleshoot.Any clues or links to figure out how to fix this issue are greatly appreciated. If you know of any consultants with expertise in AirTable API and synchronization with Google Cloud Platform are greatly appreciated.Thank you!

91
ScottWorld
T
Team111New Participant
posted in Automations
Create new Webflow CMS items from Airtable using Make (Integromat)

Hello ‌👋‌We are trying to publish new blog post articles from Airtable to Webflow using Make (Integromat).The table for the new articles is set up identically for the fields in the Webflow CMS collection. There are quite a few fields to map, some of which are single-select and multi-select fields. (Example below)https://ibb.co/Kyp5xQ7These single-select and multi-select fields are Webflow collections for category and topic tags used in the articles and are multi-reference fields in the Webflow CMS. The single-select and multi-select items are set up in the same base as separate tables to the articles table. The articles table uses a link to another record field to add these to the article record.https://ibb.co/Yjqvr2Dhttps://ibb.co/02Ys3x9https://ibb.co/df7dfrBWe have added the Collection ID and Item ID in each linked record table. This is not essential at this stage, but adding new items to these linked records/collections from Airtable may be necessary. We suspect this w

241
J
A
Arkay_PadNew Participant
posted in Automations
Automation Email Limit - Enterprise Plan

Is there a limit on sending a number of emails to collaborators and non-collaborators? Is see there is a 100 email limit in the Pro plan and wanted to find details for the Enterprise plan. I appreciate your help.

101
ScottWorld
B
BreaNew Participant
asked in Automations
Automation Email Limit

Hi Airtable and Airtable Community! Huge fan of your product and work. Is there a limit on the number of emails that can go out in a given period of time using the Send an email action? Thank you, Brea

173
ScottWorld
B
BeatrizNew Participant
posted in Automations
Filter records

I organized my timeline groouped by rooms and I filtered the events so that only the ones happening on today or later. The thin is that airtable stop showing the rooms that doesn't have events planned in the futur neither. How could I do so that only the past events disapear but the rooms (even empty) continue showing?

42
B
J
Jennyb_BadassNew Participant
posted in Automations
1 View to bring in the next days schedule at said time

Attached Screenshots. Issue 1: View - Slack-Send Tomorrow's ScheduleThis view will send tomorrows(Friday) employee schedule to a Slack channel at 7pm every night. I'd like this view to automatically change to Saturday's Schedule, on Friday Morning. Issue 2: View - Working Schedule_Current Week + View: Working Schedule_Next WeekI'd like these Views to Auto Populate as many fields as possible, except Employee Names. Main fields would be the date with start and end times. 7 Lines for Summer Camp 10am-3pm, 3 Lines for Summer Camp 8:15am-3pm, 3 Lines for Open Level Fly 4pm-6pm, ect. Then on Sunday at set time_Current Week removes last week and populates new week, then the Next Week Schedule View pulls in. Appreciate the help!   

11
TheTimeSavingCo
JasonSears78
JasonSears78Participating Frequently
posted in Automations
Issue with return character breaking HTML with Gmail Automation

I'm generating HTML emails and sending them using the Gmail automation.  They work great, except when a user puts a return character in the form used to generate the email (i.e. hits return on the keyboard inside the field (type=long text, rich text NOT enabled).  When there's a return character, even though the HTML looks solid, and is passed directly to the gmail automation, when the email is received on the client, where the return character was a bunch of closed HTML tags are inserted ( </p> </td></table> </div> etc) which totally breaks the HTML code and makes the rendering awful.Anyone else dealt with this?

115
ScottWorld
E
ethangParticipating Frequently
asked in Automations
Airtable Automation: Send an Email 1 Day From Now - What is the time of day?

Hi there, I have an email automation that is set to send an email 1 day prior to an appointment date. The date conditions are simply based off of date, not time. Do you know what time the email should expect to trigger?Thanks!

160
E
B
BoaglawpllcNew Participant
posted in Automations
Search using text embedded in URL?

Hi. I'm wondering whether there's a way to search a table or interface using text that's passed through in the URL itself. Like this: https://www.google.com/search?q=test which searches Google for "test." I think no because the search uses Javascript, but maybe there's a way that I'm overlooking. Bonus question: What's your preferred method for quickly getting to a table or interface and drilling to a specific record quickly? Thanks,David  

192
B
J
JordiNew Participant
posted in Automations
Run Script get new record

Hello guys,I have created an automation that is being executed when a new record is created, what I wanna do is to get that specific new record in the script, the last one, how can I do that? 

211
Alexey_Gusev
P
PerrowManagemenNew Participant
posted in Automations
Bad Email Address Notifications

Several of my automations send emails, inevitably I get some bad email addresses and will get a notification in AirTable of a bad email address. Is there a way to incorporate these notification into my automations to alert the person entering information of the bad email?My use case:Hosts are entering Guest information, I want to send an email to the Host that they entered a bad email address automatically.Thanks,Tommy 

11
ScottWorld
E
Ella11Inspiring
posted in Automations
Automation fix testing error invalid inputs

Hello,Could someone please help point me in the right direction?I have an automation which is triggered by clicking a button in an interface. I want the automation to send an email (containing a grid summary of some records) and then update the status of the same records to indicate that those records were sent in the email.However, the updating of the record status is not working.This is how the non-functioning step is configured.Once the email is sent, I need the status to change from 'required' to 'ordered'.This is how the conditional logic is configured.This is the error message. I have gone through the 'how to fix common issues' steps.The ultimate goal is prevent someone from placing an order twice and confusing our suppliers so any method to prevent the same records from be emailed more than once would be great.Thanks in advance! 

201
E
A
AlexW-DPParticipating Frequently
posted in Automations
Contacts lookup from multiple email addresses

Hello,I have set up a zapier automation that, when an email in my gmail gets a particular label, will create a record in Airtable. Zapier will pass along the "to" email address(es) into one of the fields.  If there are multiple recipients on the email, the info is passed along as email1@test.com,email2@test.com with a comma separating the addresses. Here is my issue -- is there any way for me to set up an Airtable automation that will read those as two separate emails and then link this record with two contact records I have in Airtable?  I can make the Airtable automation work if the email was sent to a single recipient, but it cannot seem to recognize the comma as a separator in order to match/link multiple email addresses with multiple contacts.Thanks for any suggestionsAlex

403
A
S
sslavinecNew Participant
asked in Automations
Embeding Form into Slack Notification

Hello All 😊I am using an automation to send  a slack channel reminders to fill out an airtable form each month.I would like to embed the form in the notification. Is this possible?I've copied the 'Embeded Code" given by airtable into my automation but when receiving the slack notification, the form does not show. Is this possible? 

893
S
K
KP42New Participant
posted in Automations
Assigning Assets by date

HelloI am trying to create some asset management system, and having a play with Airtable to see if i can get the functionality we need I have a table of ToolsI have another table with Field Work, with a start and end date. they are linked together with a link field where people can select which tools will be going on that job. I need to make sure there is some way of flagging a conflict if a tool is assigned to a record on the same dates.this flagging can be either a notification/flag, or refusal to assign tool, i dont mind as long as the users can see that their is a tool conflictCan anyone help with a way to automate this? or a different way to go about it?Many thanks!Kate

61
ScottWorld
S
SpelaUKnown Participant
asked in Automations
Automation: - I want formula field to stop the countdown when the date field is not blank

Hi!I have a date field and a formula field (today MINUS date field) and another formula field that countdown (3 MINUS subtraction between today and date field) - I included photo of these fields. This is because the customs allows only 3 days for import the product. So I want an alert (countdown from when the customs contacted me that the product is at the customs).Now I want to add another date field (let's call it date field #2).I want automation (or formula field) that when I enter date in date field #2, formula field stops the countdown. Is it possible to do that with automation or another formula field? And also, how it's done? 🙂Thanks a lot guys!

14
S
C
cesruaNew Participant
posted in Automations
Automatically Update linked records when parent record si updated

Hi all!As a novice user, I'm having a hard time automating a process. Hope I can get some help:I'm creating an app to track bets in a sports game so:I have a parent record "The game" with these fields: Date | Game | Result (Win / Loss)Linked to the game I have different bets, usually more than one) with these fields: Status (Open, Closed) | Bookmaker | Odds | BetThe automation should be:1- When the game result is updated2- Find bet records associated with that game3- Change those bet records' status to ClosedReading many threads I've seen that I may need to write a script but want to validate before starting to learn how to do it.Thanks in advance

72
TheTimeSavingCo
D
Donna11New Participant
posted in Automations
Webhook triggered automation - fires before record created by separate webhook

Hi, I am trying to find a workaround for an issue I have with an AT automation that is triggered by a webhook. I am using 2 system webhooks (I can't control when they trigger) from ActiveCampaign. One is for 'deal created' which I am using as the trigger to create an airtable record. The second is 'deal updated' which I am using to update the airtable record (the aim is to keep the deal stage in the AirTable up to date). I am getting automation errors in AirTable because the deal updated webhook also fires in the same minute as the deal created webhook fires which means that the AT 'deal updated' automation runs an error with the update record upon most new deals. I am planning a workaround and wonder is it possible to restrict the conditions in the AirTable (deal updated) automation to end if an additional condition (field value in the webhook body) to the webhook trigger is not in place, or proceed if that data point exists? I have set-up an automation in ActiveCa

142
TheTimeSavingCo
D
DavidtInspiring
asked in Automations
Outlook Automation doesn't send mails to external addresses

hello!i'm trying to send emails via the outlook automation. everything works like a charm, apart from the emails not arriving at all. so it doesn't work at all 😞 unless the receipient of the mail is an address with the same domain as the one i am sending from, that seems to work. but if i try to send to a gmail address, i simply never receive the email. does anyone have any idea why this might be? very sad.

222
D
L
lucacordoneNew Participant
asked in Automations
Create CRM from an existing customer list

Hello, I would like to create a CRM from an existing customer list, with an event management function.In particular I have: a "customer" table and an "event" table.Customers must register for the event by submitting a form (which inserts data into the "event" table). When the customer already exists, a tag is created into the "customers" table referring to the event. Or in any case a link between the "customers" table and the "list" table.Do you have any suggestions? Thank you!

11
TheTimeSavingCo
Kelly_Vorrasi1
Kelly_Vorrasi1Known Participant
posted in Automations
Update all records within a group based off one record

I'm trying to put together an automation that will update a date field within a group based on a selected record in that group. I put together an automation that watched a view with only the main records and then pulled all the other records from that group into a list and then updated the record with that main record's date. However for some reason when I went to update the 2nd group with it's own automation, it started updating both. Is there an easier way to do this? Based on the image below, I want the date for CEE to go into all the CEE countries and the date for Benelux to go into all the Benelux countries. 

33
TheTimeSavingCo
C
Clement_LapierrParticipating Frequently
posted in Automations
Cannot update a field with dates

Hello everyone,I am trying to follow ongoing contracts on a timeline view. However, the timeline will not display items that don't have a Start and End Date.Following  some other topics, most notably this one, I am trying to find a workaround where an automation automatically updates the End Date to match Today's date.A Checkbox is ticked for all contracts flagged as "Ongoing". The "Find" step locates the ones where "Ongoing" is ticked, and the "Update Record" steps supposedly updates all End Dates with the "Today'scDate" field value.However, as seen on the attached screenshot, I get an input error. I used the "Find & Update" method quite frequently and never got this result before. I usually use "When record matches conditions" trigger, maybe the error lies within the trigger ?  Also attached is the formula of my "Today's Date" field in case the error lies in the formatting, but I checked it so it matches Airtable's format (I am in Europe).Thanks in advance !&n

144
C
C
carineNew Participant
posted in Automations
Today's date when status changes

Hello, I’m trying to create an automation: –TRIGGER: status of the record is changed to “Completed/Published” (I managed this part, I think) –ACTION: the “Published Date” field is automatically filled-in with today’s date (here’s where I get lost) Is it possible to do this, and how? (I tried various things but am getting “test failed”) Next question: Would the user still be able to manually change the “Published Date” field? For example, let’s say our content was published yesterday, but the user only updates their record in AirTable today, so they would need to manually correct the date. Thanks for your help!

315
C
S
Symp1236New Participant
posted in Automations
Filtering just for a variable Email ending

Hello I would like to make a simple verification process with a form (where after stored on successful verification further steps follow)In a form the email is queried - which will end up in the same row as another email (from a database) -> can I build a view which filters only by the end of the email address?Field 1 (submitted field)= @123.comField 2( which is in my databank) =@123.com When field 1 ending of emailadress contains something of field 2 -> Success, enters new ViewMaybe I think too complicated, would be glad about help.

31
S

Badge winners

Show all badges
Terms & Conditions