Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,187 Topics
  • 16,131 Replies
5187 Topics
N
Nicolas_VerlonNew Participant
posted in Automations
Create New Rows in a new Table, from different Cells in a same first Row

Hi, I have a issue: A form in my table provide: Name - Instruction 1 (from customer) - Instruction 2 … Instruction 10 => I Would like to create a new table from this entry (automatically), with one rom per Instruction. Line 1: Name - Instruction 1 Line 2: Name - Instruction 2 … etc Someone could help me please ? If a tool is easy to create such a process. Thank you so much.

31
R
S
Scott_BrennerNew Participant
posted in Automations
Periodically send email when data is missing?

I have a table with four columns: Email address, Thing 1, Thing 2, and Thing 3. The possible values for the “Thing” fields are “YES” and NULL (empty / no data). Is there a way to automate a periodic (say, weekly) scan of the table that looks for NULL values and generate an email to the corresponding email address on the row saying which things are NULL?

45
ScottWorld
Tristan-ARG
Tristan-ARGKnown Participant
posted in Automations
Client answers by email and updates a record in airtable

Hi Everyone, :wave: Maybe someone can shed a bit of light :flashlight: about how to do this, if possible. :speech_balloon: Actual Scenario: When a member of the team (there are 5 members) makes a question about a certain proyect (we have many at the same time, around 100) the related client receives the question automatically in its email. But in order to answer he has to go into our portal (we use miniextensions.com) log in, find the question and answer it. Which is quite a slow process. :star_struck: Desired Scensario: When a client receives a question he can directly reply the email, and his answer will be updated to the related record. Any Ideas where to start? I guess integromat would be needed for this, or webhook to trigger an airtable automation?

313
Tristan-ARG
N
Nanette_MattoxNew Participant
posted in Automations
Using Formula to Fix Time in Automated Email

I have an automated email going out to notify people what day/time the Round of edits are due. The date and time look fine in my record but the email says “Please complete your edits by 2021-04-09T09:52:00.000Z”. This is not easily readable. I’ve learned about adding a formula to the table that corrects this but it’s specific to only one field. DATETIME_FORMAT({RD1 Comments Due}, ‘M/DD/YYYY \at h:mma’). That works in the body of the email when I select this formula record to get RD1 Comments Due. Now I want to have an automated email for RD2 Comments Due. Do I have to make a 2nd Time Formula for that field?

52
N
L
Luke_Branford1New Participant
asked in Automations
"Find Records" automation & dynamic variables - only manually entered values accepted?

Hi, I’ve been using the “Find Records” aspect of automations and super helpful. It doesn’t seem to be well documented anywhere though, and where I am very confused is that often there will a value from a previous step that I want to use (dynamic), but it is not available, only <>length. Unhelpfully rather than being greyed out, or not visible, I always end up clicking through to find it’s not available! From what I can tell, you can not use any of the following as a dynamic variable in the Find Records automation: Formula value Linked record Roll-up Considering those make up a large percentage of my tables, it’s a little frustrating! Indeed it seems that the only values you can actually use dynamically, are ones that have been manually populated. But that means either having to actually populate those fields manually, or using an automation to print the value int he field (so it looks like it has been created manually). But that seems an awful waste of a precious automation giv

685
Justin_Barrett
A
Alexandre_HusseInspiring
asked in Automations
Handle error in automation

Hello all, I have an automation that is looking for a record with specific values. Sometimes it does not find the matching and it is normal (it is a use case.) I would like to know if there is a way to catch the error of the find function ? If not I was thinking of doing it with a script but I found it strange that in automatisation it is not possible to catch error or even do conditional branch. thanks for your help Alex

322
A
L
Locky_KeaneyNew Participant
posted in Automations
Compare a new record to a field in a different table, run task based on result

I have 2 tables, Customers and Requests. Requests a made with a form view with the typical customer details (Name, email, etc). I would like the send an email to new customers. The automation flow would be: Trigger: New record created in Requests Action: Check the Email column in Customers to see if there is a match. If the email from the Request is not found, send an email to the Customer to complete the new Customer form. I have tried with the inbuilt automations. Once the records is created, I can find a record, but I wan’t to run the send email step if there is 0 records returned, but the Automations only allow you to run the next action if something is found. I also tried to write a script for it. With scripting, once you implement the input variable you can no longer test the script. It also won’t let me return a boolean value. I wan’t nothing to happen if the email is found in Customers, and to only run when a new Request record is created.

10
L
J
JOSY_GEORGENew Participant
posted in Automations
Few questions on use of Airtable

A few questions if anyone could answer my queries that would be great, Can we email a link to the form of an existing data update using mini extensions automated? (By this I mean, I have a table with existing data inside it and the few columns have to be filled out by the respondent, I need to send the link of each form to different email ids, which is in the order of 60 people each with different mail id. Can I enter the mail id’s into each row and somehow make the link send to the corresponding mail?) 2.When I use miniExtensions to update the existing data, if I share my link with someone who does not have an account can he be able to enter the data and save it in the forms? Is there any way to export to Microsoft word from airtable? Any help is appreciated. Thanks

00
J
R
Recruiting_IPPCNew Participant
posted in Automations
Increase the number of automations per base?

Hello! Is there a way to increase the limit of automation per base or are we really limited to 25? We’re currently working on a base that needs 10 tables and each table requires to have 5 automations (for email reminders). The first table (lets call it the General Phase) triggers the automation in other tables so I’m concerned that if we are really limited to 25 per base, I would have to create another base (Base 2) so I can complete the rest of the automation per table. This will conflict with the integration that we have for General Phase. There must only be 1 General Phase table. I hope you can help me out. Thanks in advance.

112
R
F
FF_2020New Participant
posted in Automations
How can I know when the automation will run if the trigger is 'when a record matches conditions'

I created automation like this: trigger: when a record matches conditions - Has started (column name) = N action: send a slack message I tested the automation, it works. But when the automation will run?

68
T
K
Kristen_TcherneParticipating Frequently
asked in Automations
Automation email with semantic date

I have an automated email set up, using Gmail, for informing someone when their video is scheduled to be published. This is trigged once the publish date date field is set. I have changed the publish date date format from ISO to friendly format, but it still publishes the scheduled date as ISO format in the automated email. Does anyone know how I generate an automatic email with the friendly date format? Thank you!

83
ScottWorld
M
Monica_CastigliNew Participant
posted in Automations
Facebook post that fail

Hi, is already 4 days that I’m experiencing that my automation is reporting a fail on Facebook; I’m receiving an email from Airtable advising about that, but seems everything’s ok with my automation, also because it worked for some weeks without any problem. What’s wrong? Tks Antonio

103
M
J
Javi_BGParticipating Frequently
posted in Automations
How to automate email summary, grouped by client's email

Dear community. I need to set up an automation, which should be simple, but i’m new with automations in Airtable. I have a table of orders. Sometimes, several orders have been made by the same client. I want to be able to send just an email for every client, in which they will be able to see a table of all the orders they made. How can i create this automation? Thanks in advance for your help, Javier

217
J
A
Alter345Known Participant
posted in Automations
Duplicate fields with automation

Hello I have a a process automation that when a lead is converted to a customer (single select field), airtable automation create a new record in a client tab and a list of tasks to do accordingly. I have 2 types of tasks, 1 for product 1 and 1 for product 2. Everything works perflecty … however, when i selected 2 products for one customer I have a duplicate customer fields … I checked with the delete duplicate script, but i want it to be automatic. I attached screenshot, so maybe you can help … many thanks in advance ! Maybe there is some workaround with the automation set up. Is there anyway i can update when the client is existing, instead of creating a new line ? thanks !

52
A
Diane_Elkins1
Diane_Elkins1Known Participant
posted in Automations
Email automations message - contact your workspace administrator

Hello! I have an automation set up to send emails and I received the message below. Does anyone know why? I thought we could send up to 100 emails a day.

92
R
R
Richard_FoxwortKnown Participant
posted in Automations
Diagnose script interactions

I am trying to figure out an issue where attachments in my Airtable records are being deleted - allegedly by me according to the record history - when I am doing nothing of the sort. I am using Integromat to create an Airtable record from incoming emails - the script includes populating an Attachments field in Airtable with certain email attachments. I then have a native Airtable automation that classifies these incoming email message records based on their content and updates a Message_type field That all works just fine, however in many, but strangely not all cases, the attachment then mysteriously gets deleted… Here’s the record history pane from one of these records (I’ve obscured the data fields) The Activity history shows the initial creation of the record via API, including an attachment, from Integromat, then the classification step using my Airtable script - in this case is a ‘no match’. All this script does is set a value in a ‘Message type’ field based on sting matching aga

2530
C
S
Sara_StahlbergKnown Participant
posted in Automations
Automation for Single Select Field

I am trying to set up an automation such that the following are true: Record A has a field with Step 1 in it (single select). I want the automation to auto-create (based on conditions I’ve defined) a new record that carries over similar information but changes that single select field to Step 2. Is there a way to do this?

41
Justin_Barrett
G
gloria_wParticipating Frequently
posted in Automations
Custom reminder trigger

Hi all, wondering if anyone can help me out here. I am tracking some data which is time-sensitive and set up a trigger following Airtable’s recommended steps but I would like to customize it further by having the reminders triggered within 30 days before the due date. For example - if the item is due on 1 May, I would like the reminder to be triggered in April. How could I modify the formula? For reference, this is the existing formula as recommended by Airtable: IF( AND( {Due Date}, NOW() >= {Due Date} ), “Trigger Reminder” ) Thank you! Any help would be greatly appreciated.

144
G
S
Sven_KleinNew Participant
asked in Automations
Formatting Gmail Message - basic question

Hi all, maybe a stupid question but I’m confused about how to format my automated mail. What my Airtable looks like: What my Mail looks like: What should i do that both look the same way?

102
S
Y
Yongjoon_KimNew Participant
posted in Automations
'When a record matches conditions" Malfunctioning

So we’re managing our project management status on Airtable and we have ‘project management stage’ field(single selection) in the master view. I’ve set up an automation based on this field, using ‘when a record matched conditions’ as a trigger. It worked well, when the ‘project management stage’ field started to meet the condition that I set up. HOWEVER, what’s really frustrating is that the automation keeps getting triggered even though there is no change/update on the data field that I set up as the automation trigger. I checked all the change history of the record, but no change has been made to the field. Why is it happening? Why is it so buggy? This is extremely frustrating especially when we try to use this feature for external-facing purpose. I’ve been an advocate for using Airtable in our team, but I keep losing trust in Airtable whenever I see this kind of sloppy bugs and malfunctions. If the feature is not fully ready and tested, Airtable team SHOULD NOT release the feature t

11
ScottWorld
H
Howard_GoldsteiKnown Participant
posted in Automations
Automation Help

Hi all! I have a table that will have a check box field , which when checked will create a new record in the table (can do this easily). I want that record to be a duplicate of the original. I have 4 steps I would like to happen automatically if possible, but I have not found a way to do these: Is there a way to duplicate the record whole without having to add all the fields (there are a lot) to the action? I then want one field in the created record to have a value auto-populate from a different field in the original? I want to link the two records in a Link field that is present in each record. I want to check a box in a field of the original record to indicate a status change. Any and all assistance is much appreciated! Thank you in advance!

26
kuovonne
Jessica_Pena
Jessica_PenaKnown Participant
asked in Automations
Update Record when date is before today– Not working on existing records, please assist

Hello Community, I am having an issue with an automation and would love some guidance. The automation is intended as follows (w/ pics below). Trigger: When Production Status field IS “Scheduled” AND Review Status field IS “Approved” AND Publish Date field (actually called Archived Publish Date in my table) IS “before today” Action: Update records’ Production Status to “Live” I can see that the tests are working, and the automation triggers when I add a new record meeting the above conditions, but when I run the automation, nothing changes to my existing records meeting those conditions. I was really hoping that it would update all pre-existing “Scheduled” records to “Live” to save time on data entry.

62
Jessica_Pena
M
Michael_Day1New Participant
posted in Automations
VLOOKUP Style function - HELP!

I have two tables set up. One lists a host of project related risks (Table A), the other is a database of risk summaries (Table B) Table A has a formula field which calculates a risk number (integer output) based on some user inputs in that table. There is a column next to this which I would like to output a Text response based on the calculated risk number. This text response is stored in a column in Table B. The link between the two tables is the Risk Number. Table B is a database of all the risk numbers and their associated data points (i.e. explanations, text outputs etc.). Each row in Table A will have a changing risk number as the project develops and as such, will need to “pull in” a text response stored in Table B each time. I can’t work out how to pull the text from another table based on a calculated value in the other. Any help with this will be greatly appreciated!!

11
R
Peter_Borg
Peter_BorgKnown Participant
posted in Automations
Strange limitation on Automations 'find records' action

I’m trying to create an automation that updates a record in one table based on a trigger in a different table (same base). The trigger table row contains the key to find the record in the action table. So I use the ‘find records’ automation action. Problem is, I cannot specify my key. I’ve selected the ‘Dynamic’ option as shown in screen print, which gives me the blue cross so I can inspect and select items from my trigger record. But when I click through to the column with my key I don’t have the option to ‘insert’ the value. Instead I can ‘continue’ to the columns properties and can ultimately insert the length property, but not the value itself. The column is a formula. Am I missing something here?

21
Justin_Barrett
D
Debbie_WolmaranNew Participant
posted in Automations
Automatic record create is not working

I created a new automation: Trigger - when a record is updated Action - create a record in another table I have selected the table and field to create the record. Unfortunately this is not working. Do I need to choose a record to link for it to work?

11
ScottWorld

Badge winners

Show all badges
Terms & Conditions