Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,191 Topics
  • 16,161 Replies
5191 Topics
M
Meghan_WeederNew Participant
posted in Automations
Assigning Collaborator in order (TRUE Round-Robin)

Hello I am trying to find a way to assign the collaborator field in order - Like a TRUE round-robin We are currently running an automation where status is “Status A” and the Collaborator field is empty THEN - run this script (below) and update the record. const collaborators = [ {name: "Person 1"}, {name: "Person 2"}, {name: "Person 3"}, {name: "Person 4"}, {name: "Person 5"} ] const chosenOne = collaborators[Math.floor(Math.random() * collaborators.length)]; output.set("chosenOne", chosenOne.name) This automation runs randomly - I need an automation that will assign 1,2,3,4,5 in order and then repeat that order.

322
kuovonne
P
Paul_Warren1Known Participant
posted in Automations
Microsoft Teams Automation - Has it worked for anyone?

Hello Friends! Has anyone been able to use Airtable’s “native” Microsoft Teams Automation integration? I’m not sure if it is worth the time trying to get it to work. I tried about 18 months ago with no success and am considering looking at it again. I don’t see any evidence of anyone using it on the forums, but my searches aren’t nearly as advanced as Bill’s :stuck_out_tongue: Thank you for any thoughts! Paul Warren

334
P
A
Alex_CurtisParticipating Frequently
posted in Automations
Round Robin Lead Assignment - Find Record With Longest Date

I have 2 tables which gets populated when there is a new web enquiry. a list of advisers I want to assign one adviser to an enquiry on a round-robin basis. I’m assuming creating a column for the date/time they last had a lead then finding the adviser record with the longest date would be fairly straight forward but I can’t seem to work it out. Is there an automation to find a record based on the furthest date from today?

103
A
S
Stefan_AlvNew Participant
posted in Automations
Send a Slack and email message** has failed

Greetings to all I am new here and I really find it quite difficult to navigate through all this. Anyway, I daily get this message which I really cant short out "…Send a Slack and email message Your automation Send a Slack and email message has failed 2 times in Rewards registration between 01/05/2022 at 7:22am and 01/05/2022 at 7:23am…" “…Airtable’s permission to use the configured Slack Automations account has been revoked. Please reconnect the account or select a different Slack Automations account for this step…” I would be grateful for a step by step solution to that Thanks in advance Stefanos

40
S
J
Jakob_KiskerNew Participant
posted in Automations
Turning a list of linked records into separate records

Hi community! For a job-sharing matching platform I’m aiming to automate the matching process. There are three parameters that define the matching: 1) Location 2) Specialty 3) Seniority I have managed to automatically link a person (A) upon registration to all other matching persons (B, C, D) . Those matching persons (B, C, D) are all shown in column named “matches” in the row of the newly registered person (A) Rather than having all matches in one column (A+B+C+D) I want to have for each match for rhe newly registered person (A) a separate entry in a new table (A+B ; A+C ; A+D). Do you know how to do this? Many thanks Jakob

385
Alexey_Gusev
Oli_Steadman
Oli_SteadmanKnown Participant
posted in Automations
Who gets the notification of a failed automation

I built an Automation for a customer and it works well, except about 1 in every 500 executions the Trigger fails to feed through to the Action. I get a helpful notification in Airtable and via email: Your automation Name has failed 1 time in Table on 04/07/2021 at 8:53am. These are super helpful and I’d like an option to have them send to the customer instead of just to me. But I don’t see a feature (e.g. in Automations drawer) for configuring this (e.g. a field for “Owner/s of this Automation” or “Subscriber/s to this Automation” where I could paste their email address). I guess if we wanted to “switch” the notification/subscriber then I could ask customer to manually Duplicate the existing Automation whilst logged in with their account, and presumably this would create a copy of it with them as new sole owner. But then we’d either have 2x Triggers on each event (not appropriate in this example where the Automation deletes a row i.e. it’s an Action you’d only perform once) or, if I su

831
C
N
Nicky_EngertNew Participant
posted in Automations
Automation with lookup

Hi, I have seen that automations involving lookup fields are currently not supported by Airtable (based on similar posts from 2020) but I am unsure how to work around my problem, if there is one, and am looking for some help. I have 2 tables. When table 1 receives a new entry from a form an automation creates an entry in table 2. Currently I approve the entry in table 2 by checking a box. Table 1 is meant to look up table 2 and similarly add a checkbox, plus look up the name field associated with that record and also link the activities field across both tables. Currently I am finding that I need to manually enter the lookup of the name in Table 1 for the other fields to update. I would like to automate this once the checkbox is filled in table 2. Does this make sense and is it possible? TIA

1233
Alexey_Gusev
L
Leland_FowlerNew Participant
posted in Automations
Automated XML Import on Watch Folder

I have a folder (on a local server) that receives xml’s as processes are completed. I want to parse a value from the new xml into an existing entry in airtable. I looked at zapier but it seems like it can only work with other cloud apps not a folder on a shared drive. I’m currently looking at doing this with a python script but would like it use the existing infrastructure in airtable more if possible.

110
L
E
Edward_ZevNew Participant
posted in Automations
Sending webhook upon some trigger in airtable

How we can build the automation when airtable send webhook to third party system when some event happens, ex. checkbox checked or status updated?

73
kuovonne
I
Ishaan_PotnisNew Participant
posted in Automations
Update record every 2 minutes automatically

Hello everyone! I want to fetch current time and add two minutes in it and update the timestamp in the record automatically. Is this possible? Example: The current time here is 05:44 PM so I want to add 2 minutes in it which makes it 05:46 PM. How do I put this into a loop so that every 2 minutes the time will be updated automatically?

143
B
T
Tina_LopezParticipating Frequently
posted in Automations
Getting links and images from Google Docs

Hello, I am pulling my articles from Google Docs. I use Zapier to connect Google Docs to Airtable. I notice that it pulls the content, but the links and images that are originally in the google doc don’t translate to the Airtable record. Is there a way to have that copied over? Or maybe, is there an alternative solution? All the help is appreciated, thank you!

331
A
E
Ed_BrooksNew Participant
posted in Automations
FIND & REPLACE Airtable Advance Search within Zapier

Hi I am trying to create a formula to do a find on two fields and if they are an exact match replace the third field content with a new URL in my ZAP (Zapier). The very first field is being used as a UID: – RECORD_ID() Airtable formula named “Handle” & – Text field named “Variant_SKU” IF they match Replace – Text field content named “Image Hi Src” I hope this makes sense, thanks in advance for your help.

20
E
I
Irene_NavarroParticipating Frequently
posted in Automations
Irregular behaviour in "Create G Calendar event" automation

Hey everyone, I was very excited to have an interview scheduling system using Airtable Forms in the base my team uses to hire over 100 teachers per month. As a reference to set up a booking system, I followed this Youtube video as well as this Airtable base by ScottWorld to avoid time zone problems (our candidates are all over the world). After having candidates booking interviews via Airtable, the “Create G Calendar event” automation would do the last interview booking confirmation step by creating a G Cal event as soon as an interview time slot would be booked. Unfortunately, the automation misbehaves when the user is not using the same date and time format as we are (HH:MM DD/MM/YYYY). The events are not added to the day the candidate has booked. I have tried several times and in several ways to find the core of this problem by changing, but I have failed miserably. When testing the automation internally from different devices and in different time zones, it has worked fine. However

156
I
E
Elliott_ZelinskNew Participant
posted in Automations
Single and multi-reference fields not pulling into Webflow via Airtable Zap

Airtable–>Zapier–>Webflow (single and multi-reference fields not pulling into Webflow collection.) Watch this, and let me know if you see something I don’t. Thanks!

10
E
A
AutomagicalNew Participant
posted in Automations
Salesforce Automation - Updating Records

Hi, I’m trying to update Salesforce Records using the Beta automation. I was able to successfully create new records, but when I try to update records the automation test fails: Salesforce reported an error while processing this action: NOT_FOUND: Provided external ID field does not exist or is not accessible I’m not quite sure what to enter as the Salesforce record ID. The Salesforce record type doesn’t have a primary key. Is that what’s causing the error or is the record ID something else?

132
ScottWorld
A
AubinNew Participant
asked in Automations
Automating update record when an Outlook calendar event is changed

Hallo everyone, During these holidays I am evaluating Airtable as our company new CPRM. Trying different functions… We prefer to create event in our Outlook calendar and would like to create and update records in AT CPRM base Activities table. I found the way to create record via automation. I am having issues on updating the record when the event is changed in Outlook calendar. Could you please indicate me the way forward or around?

313
ScottWorld
T
Tina_LopezParticipating Frequently
posted in Automations
Create a new date when content batching

Hello, Is there a way to create an automation where a new date is populated for 2 weeks later. For example, I have my google docs linked to my airtable. When I open a new document, it creates a new record. I want my assistant to schedule that content 2 weeks from the time of writing, so there needs to be a date created. However, I want the date to only be on a tuesday or thursday. I content bath my work for 2 weeks and that will plan next months content and the content created can only be posted on Tuesdays/Thursdays, so not exactly 2 weeks from the time of creating the record. Any help will be appreciatied!

51
Justin_Barrett
Issam_Chaouch
Issam_ChaouchInspiring
posted in Automations
Converting Numbers to Words script does not work in automation

Hi all, I am not a developer and I am trying to run a script that converts Numbers to Words each time a cell is updated… I found this script in a topic here, but I get this error when testing : TypeError: output.markdown is not a function ** at main on line 1** It is supposed by automation to convert in words when updated a cell called ‘Salarynumbers’ in another cell called ‘SalaryWords’ in a table named ‘Animateurs’ This is the script : output.markdown('# Numbers to Words'); // establish the words arrays let a = ['','one ','two ','three ','four ', 'five ','six ','seven ','eight ','nine ','ten ','eleven ','twelve ','thirteen ','fourteen ','fifteen ','sixteen ','seventeen ','eighteen ','nineteen ']; let b = ['', '', 'twenty','thirty','forty','fifty', 'sixty','seventy','eighty','ninety']; // get the name of the table let table = base.getTable("Animateurs"); // get the records from this table let result2 = await table.selectRecordsAsync(); // Update the records for (let record of r

124
Issam_Chaouch
G
Geraldine_PfulgNew Participant
posted in Automations
Count the numer of time an email adress is present

Hello guys, I’m new to airtable in the hope to find a solution for a serious issue I’m having. Bascially I want to be able to send tailor-made emails to my customer based on the number of purchases they made on my website (1st purchase = email 1 / 2nd purchase = email 2 / etc.) So to do this I’m using woocommer, zapier, airtable and my autoresponder. At this stage I’m able to send my woocommerce data in airtable via zapier but I’m struggling to make the count work. What I need is that everytime someone lands in my airtable, the system automatically check if the email address is already present. If it’s not the case then attribute the number 1 and if it’s the case it counts how many time the email is already present to give the right number. Then I’ll be able to use this information to send people to the right autoresponder list using zapier again. In excel I’ve been using countif but I’m not sure how to create this automation in airtable. Could someone help me? Many thanks, Géraldine

81
Justin_Barrett
B
booo_UrnsNew Participant
posted in Automations
Automating Airtable Scripts

I’m currently using the Airtable script ‘Convert URL’s To Attachments’ to populate a column w/in my table with images coming from a URL. My table’s data is refreshed once per hour - so currently my images need to be downloaded after each refresh (manual at the moment) I’m trying to automate this process by using this script w/in the Automations settings for my base but do not see a way to select an existing script when setting up the automation.

4016
kuovonne
K
K_JollyNew Participant
posted in Automations
Running python code using pyairtable when a new item is created in a table

If I want to run a python script when an item is created in a table using pyairtable, is this possible or will I only be able to do this through an IDE/terminal? If I can import my script to the website, will I need the plus, pro, or enterprise-level account?

1182
kuovonne
N
NabilNew Participant
posted in Automations
Airtable automation: Trigger for sending an email for every record updated in a table

Hi, dear community, In AIrtable automation there is an option to send emails to several people for every updated record. Now the problem is it sends individual emails for every individual updated record. I wanted to know if there’s a way I can use to automate the emails for all the updated records in a table at the same time. Meaning if I have 10 records in a table, and I updated them all at the same time, I want to send an email to my teammates containing updates for those 10 records at along. Thank you and really appreciate your help!

102
N
K
Kiera_SaltzNew Participant
asked in Automations
Can't "find records" using autonumber field

Suppose I am trying to grab some records from table 2 using a set of linked records from table 1 with an automation so I can show a list or gallery of these records in an email. For whatever reason no matter how I do it, Airtable will not let me use an autonumber field to do this. I’ve tried it both as a primary and non-primary field, I’ve tried using a formula, I even tried creating a formula that gets the record ID and then seeing if Find Records could find that (which resulted in an “unkown error”). I don’t know why any of this is the case when its essentially performing a sort of janky database join. I’d appreciate any suggestions for workarounds. If you are curious what exactly I need this for: I have a series of equipment reservations. I want to list the equipment details in an email detailing the reservation. The trigger needs to be a form on the reservation table.

142
Alexey_Gusev
E
Edouard_VerstraNew Participant
posted in Automations
Get the time when value was updated from cell

Hi :wave: , This is my script now: let ranking = base.getTable("Ranking"); let record = await ranking.selectRecordsAsync(); for (let line of record.records){ let tweet_url = line.getCellValue("tweet_url"); if (tweet_url != null){ let status_location = tweet_url.indexOf("status"); let id = tweet_url.slice(status_location+7); let link = `https://api.twitter.com/2/tweets/${id}?tweet.fields=created_at`; let token = "AAAAAAAAAA2pr2rjtB9ewZtrXtic5AXxsWdAC"; let response = await remoteFetchAsync(link, { headers: { Authorization: `Bearer ${token}` } }) let file = await response.json(); let datetime = file["data"]["created_at"]; let t_location = datetime.indexOf("T"); let time = datetime.slice(t_location+1,t_location+9); console.log(time); await ranking.updateRecordAsync(line, {"tweet_time": `${time} GMT`}); console.log("time updated

31
Justin_Barrett
V
Valdemar_TKnown Participant
posted in Automations
Automations - Action - Send SMS automations - Vonage

Hello, I want to achieve the following, using automation, when the condition matches. Send SMS via 3rd party (in my case either Vonage or Twilio). Currently, Twillio cant send SMS only via app integration when the record is created or updated. I need it to send when the condition matches. Has anyone managed to solve this case? Theoretically, Vonage supports sending via some code Curl, Node, Python, PHP etc… but all require some external packaged and since Airtable supports only vanilla JS, i have a problem in that. Has anyone got any ideas how to create a work around here? Thank you

74
V

Badge winners

Show all badges
Terms & Conditions