Automations

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

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 result2 = await table.selectRecordsAsync(); // Update the records for (let record of r

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

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 reservation table.

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

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

Hi guys, in the spirit of Christimas I’m in charge of a support group for people in need. We have got a lot of applicants who really need our help to make sure their kids are going to get a gift this year. I’ve got a ton of gift cards in a single column in excel, and I’d like to distribute all the gift card codes to the recipients. Now here’s the kicker: the recipients have different amounts of kids, which means they need different amounts of giftcards. I’m trying to figure out an automation that links a number of times from the recipients sheet to the gift cards code sheet, while never linking to the same code more than once. The route I’d go would be to make a formula field which counts how many links are in a ‘link to an another record’ field, and if there’s less than the number of children in the family (a manual number field), then it keeps adding a new link from the gift card sheet. But the last part is not really doable in automations, as I see it…? Worst case: I’ll do it by han

I have a database with a column with all email addresses of my clients. I would like to send an email automatically to all of them, but can’t find the way. Maybe a Zapier integration? Everything helps. Thanks!

Hello! I have a table in which a student’s “Start Date” is captured in a date field. There is then a # field that indicates the “# of weeks” the student is in the course. Then lastly is a formula field that takes the Start Date + # of weeks = Graduation Date. A student is allowed to renew for an additional 12 weeks. I would like to create an automation where the following occurs: Trigger = Record Meets Conditions Action = Run a script that would take the records current # of weeks + 12 and put that new total into the # of weeks field. I simply cannot make heads or tails of scriptwriting to get something that works and am hoping someone else can assist. I feel like this is probably something very easy, and I really don’t want to add a few more fields along with messing with the original formula for Graduation Date, if I don’t have to :slightly_smiling_face:

Hi! I am sending text-only information from a form in my Softr Web Application to Airtable and create a new row for each entry in a table. Later on, I retrieve this information and display it in my Softr Web application in a Grid view, including a image for each record. As I don’t want users to upload/provide images, I would like to add placeholder images for each record created in Airtable (and display them then in the web application again) As for the moment, I couldn’t identify a way, using automation, to add a placeholder image to new records created by Softr in Airtable. Is there any possibility to link an existing image from another table or similar?

Hello, I created an automation when a record is updated it sends an email to certain team members. I am having a hard time sending the the URL field that attaches to that record. How can this be done? Thank you

New to implementing anything but the simplest “send email” automation, so hoping I did my initial design right. We’re trying to build a log for tracking if timecards from various crews (construction) have been submitted. Table A has a list of all the shifts that we’ve scheduled coupled with the day the shift starts (IE we can have a 12/14/21 Day Shift, Swing Shift, Or Night Shift). This table would be filled in the office (calendar view) and we would assign a foreman to each shift. The Primary field (right now) is a formula combining the date and shift, so a typical record looks like this: Date-Shift (Formula) ||| Date (Date Field) ||| Shift (Single Select Field) ||| Foreman Name (Linked Record to a Foreman Table) Then Table B is for the foreman to fill out via a form view. They get a date picker field, a shift select field, a foreman linked record (just like Table A) and then an attachment field to upload their timecard file. Would look like this Date-Shift (Formula) ||| Date (Date Fi

Hi all, I have a question about whether a script could be developed to integrate automation with the “Task Tracker App” functionality. Specifically, whether an automation based on conditions being met could then trigger an action such as starting, pausing, or stopping a Time Tracker App being run on that Record ID. Apologies if this has been answered or addressed, I have not been able to find anything on this community or FAQs. Appreciate it! Best, DL