Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,187 Topics
  • 16,131 Replies
5187 Topics
S
Stephen_HNew Participant
posted in Automations
Send email to business user, when a field name changes

Hello, I’m new. I have one table that has all my tasks. With a field called “Task Status”. I have another table containing People With the fields of “First Name” and “Email”. Which is linked to My Task table, under the name field name of “Business Contact.” I’m trying to create automation when I make a task status change in my table. Airtable automatically sends an email to only the person who is assigned to, under “Business Contact”. So far no luck.

10
S
A
Angel_BaenaKnown Participant
posted in Automations
Automation newbie

Hello @ll, I’m not a programmer and I’m a bit lost creating my first script. I would appreciate any tips or help: I have a table for product stock, with several fields but quantity is the most important. In another table, there is a link to this first table item’s name and I created a form to record in/out’s. How would be the script so when you fill the form with a +/- quantity it’s add/susbtracted to the first table quantity field? Thank you so much, Angel

00
A
B
Brad_LegassickNew Participant
posted in Automations
Automation creates 2 records instead of 1

Hi community - I have a really simple automation configured that when a form is submitted to the “Onboarding” table 2 records are created. 1 - A contact in the People table is created (works fine from form details only 1 record created) 2 - An Organization is created in the Organizations table. Here is the problem I get 2 Organizations created, 1 with no values except the Organization name, the second record has all the values from the form. I have disabled automations & submitted the Onboarding form & only the single Onboarding record is created. I then enable the automation & suddenly 2 records in the Organization table are created. I have attached screenshots of the record creation steps in the automation. I cannot see a duplication in the automation process. I took any Integromat/Form software third party scenarios out of the equation & use a native Airtable form & it still duplicates the new Organization record. Any help is appreciated. Cheers Brad

193
B
L
Luis_Pedro_CuelNew Participant
posted in Automations
Formula to check if a record exists on another filtered table

Hey guys, I’m trying to develop an app to keep track of employees schedule (entrance and exit hour). With that, build an application to show the employes that are working and absent. I have two tables: The table were I have the information of the employees. The table of attendance, in this table a field is link to table 1. My question is, can I make a formula that return TRUE if the worker is in table2 (which is filtered to only show the records that have the date of TODAY), and FALSE if it isn’t. If you need any extra information about the tables, feel free to ask. Thank You :slightly_smiling_face:

11
JonathanBowen
P
Philippe_LarroqNew Participant
posted in Automations
Is it possible to send an email/calendar invitations from an updated field in a record?

Hi, Thanks for taking the time to read my comment. I’m using Airtable to create meetings between people. I have a database “members” with people information (mail, phone number) and another one “meetings” in which I have people meetings expectations. I’m trying to see how I can send an email to a person to propose a meeting with another one and if the person accepts, to send a google calendar invitation. Right now I’m thinking of this: Add a linked record to add a person record in a field in the “meetings” db and send an automated email to the person (I need the email person and the meetings expectations). If the person accepts the meeting, then I’ll use another record with a checkbox and then send a automated google calendar invitation with both people email addresses. It’s confusing for me if I’m processing the automation tools in the right way, what do you guys think? Thanks!

160
P
F
Franck_BezuNew Participant
asked in Automations
About automations with PDF attachment

Hello everyone, I’m currently failing on something pretty easy to solve I think. I’d like to create an automation that will send an email when a record matches certains conditions. I also want this email to contain an attachment that is always the same (PDF file), that is not in my airtable. I cannot find any easy solution. Does someone have one ? Thank you Franck

534
F
J
jgh99New Participant
posted in Automations
Automate new record for date

Hi. I am trying to create an automation that tests if it is current date and if date field is empty, and if this criteria is met trigger to create a new record with date field as current day. Can this be done? Thanks!

11
Justin_Barrett
J
Jack_KnutsonNew Participant
posted in Automations
Want to Use New Record Data for Building a Calendar Automation

Hey guys! I was working on syncing Calendly with Airtable through Google Calendar to create a new event in my view. I realized I needed to include a company name for easier tagging so I went back into Calendly and added a company name in the questionnaire. I filled it out as a test and want to retrigger the data so I could add that field to the automation. Similar to how in Zapier you can find new records to test with. Is this possible? I tried creating a new automation to find the new data with included the company name but it pulled the same old record. Thanks!

51
A
Y
Yaniv_GatignoNew Participant
posted in Automations
How can I create an automation action that users can add to their base?

Hi. I’d like to create a custom action and allow other bases to use it. Can I do that by building an app, or do I need to talk to the dev team?

11
A
R
Renee_BarneyNew Participant
posted in Automations
Automation working in some bases, but not another

I’ve created an automation that works great in two of my bases. I just replicated in a third base and it won’t work. It gives the error “Updating the record failed due to insufficient permissions.” I can’t find any differences in the automation at all. I’m completely baffled. Any idea what insufficient permissions means?

30
R
T
Tommy_CNew Participant
posted in Automations
Use Custom JS Packages in Automation Scripts?

Hi All, Is it possible to install JS packages (using npm/yarn) such as lodash or a custom script that can be used in Automation scripts? Thanks, Tommy.

50
T
N
Noah_ColemanInspiring
posted in Automations
Automation on/off toggle stuck

My automation’s status is “off” in the list, but when I edit the automation, the button is toggled “on” and I can’t change it or delete the automation (because it says it is on). It’s the same in browser or on desktop. Any help will be greatly appreciated.

00
N
J
Jarl_RosenlykkeNew Participant
asked in Automations
Help needed - Updating a record triggers send email action twice?

Hi, I’m new to airtable and could really need some help. I’m trying to automate a flow where an email is send to a client every time a new attachment is added to an existing record. For that purpose i’m using the build-in automation feature. The trigger I’m using is “When a record is updated”, View “Grid view”, and Fields “Attachment”. The action i’m using is the Gmail: send email. All this works fine. My problem is that is sends the email twice when I upload a new attachment? I have tried the same setup with Slack, and also here is triggers the actions twice. What am I doing wrong? Any help is much appreciated! Best regards, Jarl

292
J
E
Emily_TheysNew Participant
posted in Automations
Automation for "done" checkbox

I’m fairly new and trying to create an automation so that when I have completed a task, it goes to the bottom of the page, or a separate tab once it’s clicked as “done.” I’ve made a new column with a checkbox, but what’s the process for automating? Thanks so much!

21
Kamille_Parks11
K
Katoo_RaemdonckNew Participant
posted in Automations
Automation: conditions help!

For work I would have to automate our airtable, we use it to log projects and each project has a different supervisor. Now i would have to automate the system to send automatic emails whenever something changes in the “row” of that specific supervisor. I tried this via the conditions trigger with: WHEN supervisor is X OR … basically every “column” So that when something is updated for their project that specific person gets an email. However, this does not seem to work? As it only gives an update when only 1 field changes and not when for example 3 fields get updated accross multiple projects or even just 1? How can I fix this? I am looking forward to a response! Thank you :slightly_smiling_face:

25
B
3
32Stories_teamParticipating Frequently
posted in Automations
'Fields Matching Condition' Automation - Field status re-entry / re-triggering of a field match condition

I have just discovered that the automation for when “record enters a view” will only trigger the first time that it enters into that particular view, for both AT’s new automations and Zapier. Bit of a nightmare tbh! Is this the same for the automation triggered when a “field matches a condition.” My particular use case is for example using the kanban to monitor a workflow whereby a card may need to re-enter into a particular single select status (eg. imagine there was a status of ‘pending’ and I wanted to the re-trigger an automation to notify the right individuals each time it entered that status via slack) I cannot even find a workaround using the automation for “any field updates” and a last modified field. Thanks

32
3
S
Sal_OhcinKnown Participant
posted in Automations
Amazon purchases - importing and categorizing

I’m looking to import and categorize my amazon purchases. I have all of my purchases in a spreadsheet that I downloaded from Amazon (after I requested it). It lists each item by ASIN (a unique ID# for each product) but it does not include the category (e.g., Home and Kitchen, vs. Baby vs. Food, etc). I can search by ASIN on a third party website (https://amazon-asin.com/) and it will give me the category. Does anyone know how to write a script that can go to a webpage and retrieve the category text? I’m not good with writing code so curious if this is possible. And if so, can someone assist me or point me in the right direction? Thanks so much

316
M
S
Sophie_Mona_PagParticipating Frequently
asked in Automations
How to update a record from a Calendly cancelled event

Hello everyone, It may sounds stupid but I have an issue to sync cancelled events (Calendly) to my Tickets Table (Airtable) via Zapier. Basically, when someone cancels their attendance on Calendly, I don’t know how to change their status from ‘Booked’ to ‘Cancelled’ on Airtable via Zapier. I am using Calendly for my ticketing/attendance management. I have different kinds of recurring events, with different times/dates, with different users booking/cancelling their ticket. On Airtable my ticket table has a single select column called ‘Status’ so I would know when someone has booked or cancelled their attendance. The problem is I don’t know how to make Zapier updates the status column automatically from Calendly when it’s a cancellation (I know how to create a record when someone books though).

124
S
M
Michal_PietrzykNew Participant
posted in Automations
Unable to parse datetime: ""

Hello, i have this error message, when my automations try to create google calendar meeting from record. Cell has “date” value All test pass. The only way to sync is duplicate existing record… and it’s working.

90
M
T
Titan_AnggaraksNew Participant
posted in Automations
Unsynchroned Airtable record and GForm Response

at first this did not happen, until one month of use. suddenly it happened, not all of the recorded data from Gform entered the airtable, after I matched it was really lacking, 36 data should only enter 21, and when I repeat I delete and fill in Gform again, there should be 36 recorded data entered, but on the airtable only goes in 21, sometimes 30, 29, 34

10
T
B
Brienne_O_TarthNew Participant
posted in Automations
Add "Wait" to Actions

Please add a “Wait” option to the list of available Actions, where a user can require a certain amount of time to pass (in minutes, hours, days or weeks) before an Action can run.

10
B
K
Kelly_RogalaKnown Participant
posted in Automations
Automations for GCal events are off by one hour

I have set up a simple automation to create an event from a date and time field. These are PDT and my GCal is set to Los Angeles time zone. However, the event that gets created is one hour behind the start and end time listed in Airtable: 1st event should start at 9:30 am on 11/13 2nd event should start at 21:30 (9:30 pm) on 11/13 Here is what arrives: Off by one hour!

33
ScottWorld
B
Binthout_BVParticipating Frequently
posted in Automations
Automation stuck

I have an automation that’s being ‘stuck’ in a vicious circle: I can’t press the ‘Update’ button on the bottom (well…I can, but nothing happens) I can’t switch the automation off because it isn’t updated I can’t delete the automation because it isn’t switched off In the meantime the automation keeps generating error reports by email, which is annoying my boss ;-). Can somebody shine a light on this? :slightly_smiling_face:

61
KrysFree
H
Hari_BalasubramKnown Participant
posted in Automations
API error AUTHENTICATION REQUIRED AND RATE_LIMIT_REACHED

I have been using dashdash and airtable for quite sometime now. All of a sudden , I started getting errors today. The message is AUTHENTICATION REQUIRED. In some other applications I got an error message RATE_LIMIT_ REACHED ( Rate limit exceeded) Please try again. There is no change in anything as such. I changed the API key and tried . But the same results. Can someone please help ? Hari

133
B
J
Jose_GuerreroParticipating Frequently
posted in Automations
I can't create a google calendar event base in the row selected timestamp

I can’t create a google calendar event base in the row selected timestamp, i have the google calendar account connected, but in the automation i insert the date base on my record date field and generates an error in the run test. it’s posible to crate a google calendar event base on my records date field?.

35
M

Badge winners

Show all badges
Terms & Conditions