Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,187 Topics
  • 16,131 Replies
5187 Topics
A
AnnieTacticombaParticipating Frequently
posted in Automations
If Cell Contains Value Then Multiply Using #

HelloI have a question about if cell contains "value", then multiply by # formula.  Is it possible to achieve the result I intended in column C?Column A, single select = High, medium, lowColumn B, numerical value = 5Column C, formula, = If column A is high, column B with 0.7, If column A is medium, multiply Column B by 1, if column C is low, multiply by 2. I am hoping I am able to multiply by a specific number under certain conditions.  Without manually typing in a value in the columns.  Just being able to select a value in the single select column makes the task and viewing easier. Thanks in advance!Annie

2022
A
A
adayNew Participant
posted in Automations
Sum of status

Hi! Does anyone know if there is a way to do a sum of each status?For instance I have 5 statusStatus 1 - 14Status 2 - 29I am trying to get a view or a script to be able to automate an email that shows how many items are in each status. thank you!!!

21
TheTimeSavingCo
T
teshannonNew Participant
posted in Automations
Twilio beta automation: send SMS to linked records

Hello, is there a way to run an automation for every linked item within a record? I am either short a few brain cells or this may be a setup issue.I have a business table and a member table. The business can have many members, and the member can have many businesses. However, I want to send a specific text message (via twilio beta) from each business to only their linked members. Is there a way to do this? Twilio throws an error (blank value) when I pick values from the linked member list. I almost think I need a third helper table with single member to single business links. For consideration, the member list would ideally be unique values. Additionally, I would be looking to build this out only to send a message on a member's birthday. Thank you!

103
TheTimeSavingCo
Jeff_A
Jeff_ANew Participant
posted in Automations
Hoping for help with getting script for repeating events working

This is the first time I have written a script myself as I have been self-learning over the past couple months. I am trying to build a script that will run when a record is created that creates repeated events. I have users who submit events through a form on the interface and added 3 fields focused on the workflow. The flow I am hoping for is if someone checks off Repeating Event it will look at the Frequency field (single select) and the End On field (date) the workflow script will then create events with the same field values at the same times through the date specified in End On field. I know i could probably remove some of the script and use the conditions in the workflow but I have confused myself to the point of not knowing how to move forward without breaking anything more than it already is. Any hints or assistance would be greatly appreciated.// Declare variables let table = base.getTable("Table 1"); let currentRecord = //cannot figure out how to make it pull the current

53
TheTimeSavingCo
M
Muhammad_FaheemNew Participant
posted in Automations
Setting up Automations

Hi everyone,Thank you so much for looking into this and helping me out on this.We need to set up an automation that triggers alerts based on a particular due date and a single select, I have created this quick Loom video showcasing the base we have set up and I tried to clarify the automation as well.Here is the video: https://www.loom.com/share/8015ae2596a64b7aa04c0343d55309cfI would really appreciate any help in this regard. Thank you so very much and I will be looking forward to further responses.Cheers!

31
L
Drew_Nemer
Drew_NemerKnown Participant
asked in Automations
Assigning Client based on Last Name

Does anyone know how to simply program an automation that would allow for clients to be assigned to employees based on first letter of last name.So if clients with last names starting with:A - G --> Employee 1H - M --> Employee 2N - S -->  Employee 3T - Z --> Employee 4i figured this might be a combination of a formula field that just isolated the first letter of last name. But i think there should be a quick second step that would maybe group letters in alphabetical divisions easier than just manually input a condition automation for each letter.  

102
Drew_Nemer
J
Justin_EppleyInspiring
asked in Automations
Automation to remove a single linked record, not all

I have a table of products that includes a linked record field to a “tags” table. Each product can have multiple tags. I want to create an automation that auto applies one of the tags, called “New Product”, to the product and auto removes the same tag at a later date but does not remove all the other tags in the field. I was able to get the first part to work wonderfully – I have a field that is the last modified date and I setup an automation to apply the “New Product” tag to the the product if the item enters a view and the last modified date was within the last 30 days. But, I can’t figure out how to remove the tag without also removing every other tag in the field. Any thoughts or threads of wisdom? Thanks, Justin

1097
Karlstens
Ed_Hohlbein
Ed_HohlbeinNew Participant
asked in Automations
Add Daily Image from Pexels or Other Free Image Site

Hi good people. I'm building a base to track my handstand progress. I'd like the base to go to Pexels (or another free source for images) each morning, grab a picture of someone doing a handstand, and add it to "today's" record. Can anyone head me in the right direction to build this automation? Or have some advice/insight on how to make this happen? Appreciated in advance. 😁

273
Ed_Hohlbein
E
emmyizycNew Participant
posted in Automations
QUESTION: Does Gmail automations work for non-collabrators on the plus plan?

Hi, i am just getting to know about airtable and I set up automation and connected my gmail. i want it to send emails to email addresses in my record when a condition is met. but it is telling me I cannot send an email to non-collaborators on my current plan. my question is1. If I upgrade to plus plan will I be able to send emails to everyone including non collaborators?2. Is there a way to send emails to non-collaborators on the free plan?

61
J
E
eyal11New Participant
asked in Automations
Twilio action started failing today

We had Twilio automation running perfectly sending sms to a phone field on every new record added to a base.Today the automation started failing noting "Twilio reported an error while processing this action: An unexpected error occurred, please retry or contact Airtable support."When looking in the Twilio console I don't see related errors in the error log.Attached is a screenshot from the automations run history.I am new to airtable, and not sure if there's some better way to report such cases. Would highly appreciate your help! 🙂

30
J
L
Lydia_JacksonNew Participant
posted in Automations
Airtable and Power Automate Connector Help

Hi all – I’m building a workflow using Power Automate to create forwarded emails as “activity” records in Airtable. I’m having issues understanding the Airtable Connector in Power Automate and wondering if anyone has successfully used the “create a record” action before. I’m a little stuck with the required field “body”, and weirdly this required field isn’t mentioned in the documentation here: Airtable (Independent Publisher) - Connectors | Microsoft Docs. What exactly is “body” associated with in airtable, and how should I think about what content should go there? For more context, I’m creating a flow that pushes emails into airtable as a new record. I thought “body” might just be the name of the new record, so I tried pulling “subject” from the email, but the string type is not accepted. Thanks!

6795
D
D
David_Evans1New Participant
posted in Automations
Use Script to tag who created a Note that is created by Automations

Want to have a button that creates a new note field which is Triggered by an automation, although I want the Created By field to have the tag of whoever created instead of; Created By: Automation. Is there any way to do this without a script and if I had to use a script, any suggestions?

20
D
J
Jeroen_SarinkParticipating Frequently
posted in Automations
Generating unique serial numbers

Hi all,CaseI've been working in Airtable for a few months now, preparing to launch a platform for our production planning (replacing our current Excel workflow). Each item that enters our production queue is scheduled for a specific week (2023-03 for example) and should get a unique serial number. The serial number consists of a prefix + an incrementing index number, as follows:Prefix = Producer code + Year + Month letter. E.g. A23A for an item with Producer code 'A', planned for week 2023-03.Incrementing index number = 3 digitsFinal result e.g. = A23A501ProgressI've currently set it up so that the calculated prefix for each record links to a table ('SN prefix') containing all prefixes used and the next available index number (rolling up the existing index numbers and adding 1).When a new record is added, an automation fires a webhook, sending the record ID and prefix part to Make.com. Make then requests the next index number from the prefix table and fills out the serial number in the

1114
J
Paul_Van_Dooren
Paul_Van_DoorenKnown Participant
asked in Automations
Automate recurring date from linked table

First things first, for all you airtable users, all the best for 2023!Context:I've got a newspaper that appaers 6 days of the week: monday, tuesday, wednesday, thursday, friday and saturday.Every day i have in this newspaper 2 free spaces that needs to be filled up with an advertisement.I would like to use airtable to make a kind of reservation tool so i can follow up when the correct advertisement must appear in the newspaper.Through a form the user must be able to input:the name of the advertisementa start date of the apparitions (date selection from a linked table to exclude double bookings)a frequency of apparitions (1 = one day / 2 = two days / 3 = three days / ...)ProblemI really don't have a clue how i can automate that airtable assigns the dates to the record when the frequency is more then 1.And then for the icing on the cake... the frequency should be every other day => monday - wednesday - friday - (sunday) - tuesday - thursday - saturdayExam

140
Rupert_Hoffsch1
P
plyskeInspiring
posted in Automations
Adding a delay to an Automation

Hello everyone!I've created an Automation that fires when a Record enters a certain View (date). However, if a colleague of mine creates a Record, sets the date till today which triggers the Automation, the Automation will start firing which will end up in an empty e-mail sent.So I want to add some sort of a delay to this Automation in order for my colleague to have a chance inserting the data to the different fields.I've read back and forth on different forums. The closest I've come is this solution:"I’ve used LAST_MODIFIED_TIME() comparisons on multiple occasions to build automation triggers, and have never run into issues. My trigger formulas typically look like this:AND({Field To Watch}, NOW() > DATEADD(LAST_MODIFIED_TIME({Field To Watch}), 5, "minutes"))This ensures that the field actually contains data, and that data was last updated more than five minutes ago. If both conditions are true, the formula will output a 1; otherwise it outputs zero. The datetime returned by LAST_MO

831
E
S
ScullerNew Participant
posted in Automations
Create a frontend website table that users can sort/filter on

Hi,Newbie here..I would like to create a front-end table on a website (linked to or using data imported from an base), that has the ability to allow users to sort, search and filter records.How would you suggest I go about this process?Thank you.

00
S
D
DanielRozinNew Participant
posted in Automations
Duplicate contacts

Every time that user go inside to the CRM (From Integromat).I would like to check if the phone number of the user exists in the Airtable.If the number is existing, I want that the lead will be updated with the last source of the lead.If the phone number is not existing, So open a new line.How can I do it correctly?

10
D
K
Kosta_KondratenInspiring
posted in Automations
Webhook Automations with Data Passed

So I’m really confused about where JSON inputs figure in Webhook Automation with scripter combinator. Let me explain - so I have a webhook - let’s call it whatever here is a random one: https://hooks.airtable.com/workflows/v1/genericWebhook/appzNOZaonMIXQNnZ/wflafthnU7LpwoV3K/sampleWebhook So I’ve just configured it with Insomnia and everything works and comes back with Success and that’s great - I’m excited but… I want to pass variables to this Webhook… however no matter what I try it just doesn’t register. Here is the JSON I’m passing to my Webhook: {“Company”: “HereBoy”, “Text”: “More Flavor”} Here is my code in the script: let table = base.getTable("SMS"); let inputC = input.config(); await table.updateRecordAsync('rec69N1WoIfzlUXJ1', { "LinkID" : inputC.Company, }) Webhook seems to be registering the values that are coming in when I check: But when it’s a “set in stone” text it works - however my custom variable isn’t registered… if I could pass custom variables to the we

81
Karlstens
A
adayNew Participant
asked in Automations
Send group of records to one email

Hi there!Does anyone know if there is a way to do the following:Say you have a customer that orders 5 items, you have each item as a record and then the customer in a different table with the email address. I would like to trigger a button to start an automation to email a customer with the grouped 5 orders tagged to that customer. Thank you! 

111
Karlstens
S
seidumohammed64New Participant
asked in Automations
Fetch API data into airtable until every data point is retrieved usng offsets and limit

Please any guide on this? I am  trying to fetch all the data from the products endpoint of an API using a limit of max 500 data point per fetch and an offset that increment per every fetchSo if the offset is 0, and the fetching max limit of 500 the next offset = 500, 1000, 1500 in that order.I already have to script fetching the data at max of 500 but I have to always manually set the offsets which is time consuming so I want this to be automated in code. If I can get a sample code that does similar I will be glad 

50
S
M
MygrateNew Participant
posted in Automations
Send email at a (changing) future date

hi guys, is there a way to create an automation that sends an email at a date recorded in a base? the date is a future date and it changes depending on the record.

31
TheTimeSavingCo
Z
Zehava_RubinKnown Participant
asked in Automations
Using Timed Triggers and Last Modified in script

Hi the following is what I would like to accomplish:When a records specific column changes, wait 30 min and if it hasn't changed again, send out an email.Is this something that is possible in airtables automation?Thank you

220
TheTimeSavingCo
Y
yva2002New Participant
posted in Automations
Issue with input.config when Adding a subscriber using Mailerlite API

Right now, I have set up a base with a form. Upon submitting the form, I want this script to run to add the preferred email & name as subscribers in the Mailerlite API. Here's the script, it's pretty straightforward. I make a POST request to the MailerLite API using data from input.config to create the body of the request. let inputConfig = input.config(); //selecting preferred email for mailerlite if (inputConfig.other_email != null){ inputConfig.preferred_email = inputConfig.other_email; } //constructing record for mailerlite let content = { "email":inputConfig.columbia_email, "name":inputConfig.name, "groups": ["1",] }; //setting up mailerlite API call var myHeaders = new Headers(); myHeaders.append("Content-Type", "application/json"); myHeaders.append("Accept", "application/json"); myHeaders.append("Authorization", "Bearer {$api_key}"); var requestOptions = { method: 'POST', headers: myHeaders, body: JSON.stringify(content), redirect: 'follow' }; fetch("https://connec

65
Y
D
Dreuna_New Participant
asked in Automations
Search databases when creating a form

Hello,I'm new here and I need help. Firstly, English is my second language, sorry for the grammatical mistakes.I want to set an automatization when someone submittest a form to Table "Dary" (donations), I want it to search two other tables "Kontakty" (Contacts of individuals) a "Firmy" (Contacts of companies) if there is a record of the donator. If yes add the donation to the donator's record. If not create a new record in its respective Table.Is it even possible? Thanks a lot.

104
D
M
mrwinter11Participating Frequently
posted in Automations
Automated date automations breaking when combined

Hi,I have built two automations which work great independently, but when I use both of them in my table one errors out with a "Could not convert string to date" error.Here's what's I've got going on:Automation 1 looks for a Name field with no Start Date and End Date, and when it finds one, it auto-completes the next available Start date which it looks up from a rollup field (using Max values). This works fine on its own.Automation 2 looks for a non-empty Start Date with an empty End Date and auto-fills the End date from a separate formula field. This also works fine on its own.However, when I turn both automations on, Automation 1 runs fine, and auto-completes the next available Start Date, but the second automation fails with the error above.I can go check the Run History of Automation 2, which gives me the failure, so I fire it off manually to test it and it finds the relevant records and fixes it perfectly.I am guessing I may need to make Automation 2 wait a while longer before it t

81
M

Badge winners

Show all badges
Terms & Conditions