Automations

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?

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

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

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 delete

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

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.

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

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?

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!

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.

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

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!

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?

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?

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!

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 resul

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 airta

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.

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?

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!

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 re

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} G

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

Hi, I need to send product info to people, and the general email is the same every time, but with different links in the email depending on which product they ask about. I’ve set up a view for each product that can trigger the correct email, but that requires a different view for each product along with a different email automation for each product. Is there a cleaner way to do this? Thanks.

Hi folks, I’m kind of new to Airtable… I created an automation to send an HTML grid to email. it works fine and I get the selected view to my email as a readable table. I tries to send same view to slack but it sends only html markdown (not in a table and not readable) what’s the way to send to my slack account HTML grid view same as in emails P.S - when sending records to email I can choose fields but when I send to slack the only option is a markdown no fields to choose