Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,190 Topics
  • 16,153 Replies
5190 Topics
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
K
kriteNew Participant
posted in Automations
Webhook Record Existance Checking

Things being used: Webhook Reciever, Conditional BlocksWhat i want: I have a constant data send webhook setup, syncing some data to the table,I want to setup something like if Record_Id(From Webhook) is not listed in a field of Airtable then only it will create records,I have tried this But it's not working for me, 

21
Karlstens
J
JDARNew Participant
posted in Automations
Add a timeout before the execution of a script

Hi everyone! I wanna know how to add a timeout before this script:  const REQUEST_METHOD = "POST"; var scriptConfig = input.config(); var webhookUrl = scriptConfig.WEBHOOK_URL; var requestConfig = { "method" : REQUEST_METHOD, } if (REQUEST_METHOD == "POST") { // Adds scriptConfig content as JSON body of request requestConfig.body = JSON.stringify(scriptConfig); requestConfig.headers = { "Content-Type": "application/json" }; fetch( webhookUrl, requestConfig ).then(function(response) { output.set("status", 'ok') }) } else if (REQUEST_METHOD == "GET") { // Adds scriptConfig content as query params of request const qs = Object.keys(scriptConfig) .map(key => `${key}=${scriptConfig[key]}`) .join('&'); // Appends queryString parameters to URL webhookUrl += '?' + qs fetch( webhookUrl, requestConfig ).then(function(response) { output.set("status", 'ok') }) } e

694
B
M
McgeckleNew Participant
asked in Automations
Conditionally Sync Data Between Bases Using Airtable Sync

Is there a way to use Airtable sync to conditionally sync data from one base to another? I need to only sync specific records and not all of the records in table.If it is not possible using Airtable sync, is there any other way of accomplishing this?

674
Alex_Wolfe
Z
zeremKnown Participant
asked in Automations
How to create two stages with different tables in automation?

Hey friendsI have one table that contains all the names of the people who paid money and one table of cold leads.I want to automate that when a new record is created in the payer's table, a V will be marked with that user based on their email in the cold leads table 1.I created an automation that looks for the email of the person who pays in table 1, but I can't find an option to "update records" for that email in table 1 because I can't find his record ID.I would love to understand what I am doing wrong.Thank you! 

80
Z
R
RSkInspiring
posted in Automations
How to add the new value to the existing value using Airtable automation

Hi, My Airtable use case is to maintain Farmer’s finances. We have developed a WhatsApp bot, and by using webhook triggers the information gets stored in Airtable.I am using webhooks to populate the Expense Amount field. For eg: The bot asks the question about the Expense Amount, as soon as the user answers this question, the webhook triggers, and the value of the Expense Amount gets updated.What I am trying to achieve is, if the User enters the Expense Amount for the same expense type, the field should add/sum the new value to the previously populated value. For eg: If the user John, enters the Expense Amount for E1 as 200 again then the Expense Amount field should be 300(100 + 200).I want to append the new incoming values in the field and not overwrite it. Any advice or help is appreciated

292
R
R
realestateairNew Participant
posted in Automations
automation email doesn't show formula?

I've setup an automation email but it seems the formula field is not showing the value. Thank you in advance for the help.     

252
R
T
tdang79New Participant
posted in Automations
Script exceeded execution time limit of 30 seconds

Hi All, I’m trying to run this automation script that works on a base with 500 records but now throws this error after I migrated some records and now have a total of  ~3500 records.Can someone help me to fix this error.Thank you in advance! //on which you want to run the vlookuplet mainTable = base.getTable("Technology Returns");let mainTableRecords = await mainTable.selectRecordsAsync();//lookuplet lookupTable = base.getTable("Warehouse Returns");let lookupRangeRecords = await lookupTable.selectRecordsAsync();//Replace "Item.barcode" with column name which has the values you want to look up for (let record of mainTableRecords.records) {let lookupValue = record.getCellValue("WebSPOC");//Replace "Barcode" with column name which is the range to search in//Replace "Name" with columnn name which value should be returnedfor (let rangeRecord of lookupRangeRecords.records) {if (rangeRecord.getCellValue("WebSPOC") === lookupValue) {let returnValue = rangeRecord.getCellValue("Re

1075
Karlstens
P
prolificNew Participant
asked in Automations
Having trouble with output.set

Hey Guys, Im sure there is a very simple answer here but i am very knew to javascript in general, i appreciate any insight anyone can give me. I am using the airtable script function to post new users to an external application via it's rest api. I am successfully able to create the new user but i wish to record the ID number that is returned in the call back, i would like to use this in later steps in the air table automation but cannot get output.set to work. My script looks like so let inputconfig = input.config();console.log(inputconfig);let name = inputconfig.namelet password = inputconfig.passwordlet username = inputconfig.usernameconst options = {method: 'POST',headers: {accept: 'application/json','content-type': 'application/json',authorization: 'Bearer samsara_api_lxxxxxxxxxxxxxx'},body: JSON.stringify({name: name, username: username, password: password})};let response = await fetch('https://api.samsara.com/fleet/drivers', options).then(response => response.json()).the

220
P
B
Brad_AttigNew Participant
posted in Automations
Automating emails based on attendance

We run a 10-week workshop and want to send emails out after each workshop to the attendees. Right now we have a multiple select field with Wk 1, Wk 2, etc and we use that to track who attended. Now we want to send emails out and I can figure out the best way to trigger emails using that single field. Wk 1 is easy, if they have Wk 1 they get the email. if not, they dont. But once we get to Wk 2 it gets more challenging.I don't want to end up with 10 fields one for each week because the team that uses the base will never update it so I'm looking for creative ideas on how to trigger each email. I'm also not opposed to creating some fields at the end of the table that update based on weeks selected but I'm not sure how to do that either.Thanks,Brad  

75
TheTimeSavingCo
A
abender14New Participant
posted in Automations
Automated mail digest of 3 random records

I want to create an email digest that automatically sends an email with 3 randomly chosen records from one of my tables. The idea is that it randomly sends me 3 per week until it has cycled through all of them and then restarts (all records become eligible again). I messed around with email digest automation but was struggling with the part where you randomly select records and record when it has already been sent (thus making that record ineligible until all have been sent). Any ideas for how to accomplish this? 

73
kuovonne
S
Sylvain_DionneKnown Participant
posted in Automations
Connect CSV to Airtable

hello, i want to automticaly update or create data from MS SQL server to Airtable (see attached file)The process is:I have a view in a table in a DB on MS SQLEveryday automatic execution of the view to create a CSV file on Google DriveI want Airtable update existing records that have been modified in csv file and create new records that have been added to csv file.I already check with Pabbly Connect, I can upgrade if I manually change records in the csv file, but what I want is if the a new release of the csv file have been updated on google drive, Airtable is updated.ThanksSylvain 

00
S
K
kimmochiNew Participant
posted in Automations
Create Multiple Records date using script

Hi,  I would like to run an automation to create the next 7 day scheduling, adding the next 7 working days in calander it would be best if i can copy the last most recent row values as well, but some fields will not be copiedat minimum i would like to run a scrip to add the next 7 days Example: The last date is 25th Dec, i would like the script to add 7 rows 26 Dec 27 Dec 28 Dec and so on  

44
K
S
Stephanie_HekkeNew Participant
asked in Automations
Automating repeated tweets

Hi Everyone! I have a base with 30 tweets that I'd like to automatically publish everyday. Once I get to the end of those 30 tweets, I'd like to start from the beginning and repost them. I am familiar with the "post a tweet" automation provided by airtable, but I'm unable to find out how to make it restart from the top once it reaches the end of my base.Has anyone figured out how to do this?

30
kuovonne
T
Tina_LopezParticipating Frequently
posted in Automations
Auto link records if it's the same week and create new record in table

Hello, I want to link 2 records if they are scheduled in the same week, and then create a new record in a table that stores those linked records. I also want the original 2 records to have the newly created records ID. My goal is to do the following: If two records are in the same week, create a record (let's say record A) in table X, then update those two records with record A's record ID# If anyone could show a visual example on how they would do this that would be highly appreciated as I work better with visual learning.  

22
T
M
MaxGNew Participant
posted in Automations
Email a class Roster to instructors once class is full

Hello,In one base I've created tables of instructors, students, classes, locations and training dates and linked them.  I've automated signup genius to populate my students table when someone registers for a course.  I've set the total number or students for each class and a calculation of % of full.  When it reaches 100%, i have an automation update a record on the class page indicating it's full (although I'm not sure that's really necessary).  When that happens I want Airtable to email (through my Outlook) a roster of the students assigned to that "full class" to the two instructors associated with that particular "session" or individual class.  I cannot figure out how to do that. 

94
TheTimeSavingCo
R
Ruben_RossvoldInspiring
asked in Automations
Airtable Automations

I get served a list of 500 company numbers every weekday at 5 am, i need to have available information for my sales agents by 7.30 am in the morning.This i solve by using an API that collects the information from a government website where i come from. It's the only source available.The API is limited to just one company per request.I have solved this code wise using a for of loop which loops over my table, sends an api fetch request based on the number, then inserts the information, then starts the next loop.The issue I'm facing is the limit of 50 fetch requests pr automation.The only solution i can come up with myself at my current code/situation is to make the automation limited to 50 runs pr automation, then make 10+ scheduled weekday runs.I have access to 50.000 monthly automation runs so that's no issue, but there has to be a better/ More elegant solution than this?Here's an example API link:https://data.brreg.no/enhetsregisteret/api/enheter/929135180/roller?The number marked in

134
R
P
Patrick-KennedyInspiring
asked in Automations
"unknown attachment type" automating a PNG upload to Facebook Page

I have an automation which makes a Facebook Pages post.Trigger: when a record gets a PNG added to an attachment field.Action: Make an FB Pages post with the attached PNG file.Odd thing is that the trigger and actions all work in manual testing mode, but when left on autopilot they don't....though occasionally one might (see the bottom of the run history in the pic)Anyone have any success making FB Pages posts w/images included?Any idea how to make an image file type that live automations are happy with?Thanks!

900
P
L
Luigi3New Participant
posted in Automations
Split one record in multiple records

Hi all,I need to create from a single record, multiple record, in the same table. If in one field there is a specified keyword, I would not a single row but 2 or more records. Is it possbile?The "source" record could be added from a form or if is it possibile from an email.Thank you very much.Luigi

735
Karlstens
G
geophileParticipating Frequently
asked in Automations
Exit automation script before reaching the end

I am writing an automation script that takes an input X. I lookup X in a table, and then go on and do stuff with what I've found.But if the lookup comes up empty, (no qualifying records), I want to exit the script. I could do this:if (X was not found in table) {    output.set("error", `${X} was not found`)} else {    // do stuff}But this gets messy. If I need to lookup X, and then Y, and then Z, then each additional lookup results in more indentation of my code. What I'd like to do is this:if (X was not found in table) {    return from script}"return" isn't allowed. Googling has not provided an answer.Is there any way to do what I want?

1050
G
P
philipppoNew Participant
posted in Automations
(Auto)Copy word definition from a web dictionary

Good day! I want to link certain text lines from a web-site (say, Cambridge dictionary (https://dictionary.cambridge.org/dictionary/english/do))and automatically create word definitions in my spreadsheet. Is there such an option in AirTable or Bubble.io? Thank you

61
TheTimeSavingCo
T
Townsquare_ContNew Participant
posted in Automations
Trouble Connecting to Facebook Page

I'm an admin on 300+ Facebook Pages. When I try to select a page to tie an automation to, I receive this error message: "Facebook returned an error. Error hashes: rm0604cd3138feed20, ufm7db6c9a23a36fa83"Anyone else encounter this or know of a workaround?

62
P

Badge winners

Show all badges
Terms & Conditions