Automations

hi there, i was trying to capture text w the mid feature for text inside a bracket in my title column imported from google calendar however for some reason it's not grabbing it. What should the formula be? The text that needs extrapolating to a different field is within the "[" and "]" [TEST] Restaurant Name: Name of Event. Any thoughts? I'd then like that text to trigger a dropdown menu in a different field.  THank you!  

Hello, I feel like this is relatively easy but I am stuck. I have automations set up to send out a welcome email each time a project is sold. I have spec sheets and standard documents I want to send with each email. They are standard forms that are the same for each project. I want these to automatically attach to a record when it is created. I have the forms set up as their own table. How do I get Airtable to link these forms whenever I create a new record? thank you

Hi All,So I have a question about the best way to merge data. I manage a scholarship program for a festival that happens once a year. We've been using airtable the last few years to manage the staff, artists, and scholarship recipients. We saw a lot of success converting our emails into Typeforms last year and want to expand on that.We use a typeform application for people to apply and then pull those who are selected into an 'Accepted' View. We intend on sending 4-5 typeforms with questions so we will need to merge their answers into each of their 'Applicant' profile. The typeform will ask for the same email address they applied with and I would use that to direct the merge. This is going to create a lot of multiple 'accounts' and I want to make sure our data stays tidy and manageable. Rundown:1. John Snow is accepted.2. We send out  Typeform 1, 2, 3, and 4 out to John3. John fills out the typeformform as he recie

I have been using Airtable and created a column in which I have added links to Twitter, Facebook, LinkedIn, and Instagram profiles. I manually added the follower count, but I want to know if it is possible to update the follower count automatically for these social media platforms in real-time. Can you please help me with this?

Hi, I have researched the forum but cant find the problem to my solution. Every time a record is updated in UseCases, I calculate a field call Environment_textual (example value would be "Negligible risk").I have another table called Environment_pics where I store pictures for each rating (e.g. there is a pic for "Negligible risk"). I want to create an automation which takes Environment_textual and copies it over to the linked field, so I can the picture in the UseCases list.I get an error for the last step.Should I copy the result in the linked field in UseCases or in the linked field of Environment_p

Hey my Gmail automation appears to be set up correctly with a publicly hosted web image that should send in the body of the text. It works in the preview but when I send the email it doesn't show. Could anyone point out where I'm going wrong please? The subject and body of text pulls from my airtable and sends in the actual email, then I use (<img src="image web address">) to attach the image (This does not send). Does this need to be configured in a particular way to send via Gmail that I'm missing? Cheers! 

Hi All,I'm having difficulty automating a task that I need for my database. Essentially what I'm trying to do is to have a default value in the "Link to Field" selection, which is then removed when another option is added. The data is currently pulled in from another table using a 'Link to Field' column, I currently have the automation working to add default option back when options are removed but having difficulty creating the script to remove the default option when a second option is added.Below is my current code, which pulls the current options from the cell and checks whether they are the same as the field being updated, which then passes those choices to an updateOptionsAsync, from which my understanding is the wrong function to be calling.Any help would be greatly appreciated!! let inputConfig = input.config();

Hi,I want to automate my work with emails to clients every 3 monthes.the problem is my languge is RTL (right to left).how can I send the clients emails that are RTL?with HTML it doesn't work since the variables doesn't work in HTML.

 Hi,For a property management company, how should I go about creating the next quarterly report?I have organized a board for:AssetsFaultsClientsEvery quarter, I aim to send each client a separate email containing a report detailing:The income generated by their assets (income for each asset is recorded on the Assets board, and a client may have multiple assets)The expenses associated with each asset (expenses for each asset are recorded on the Assets board)The expenses related to faults that occurred during the quarter (these are recorded on the Faults board).Subsequently, I wish to display to the client the total income minus the total expenses.How can I provide this data to the client while ensuring that I do not share information pertaining to other clients?Thanks.

Hi community, I’m building up automation with Gmail sending records to the mail address of the person who filled out the form. I used the Rollup field to pull the email address from the other table. I’ve run 50+ times testing trigger and all the steps which showed no error, but it never succeeded while actually performing the automation after submitting the form. I’ve also tried to delete and rebuild automation for 3 times but still in vain. I also assured that every cell of mail is not empty. I attached some screenshots of the conditi

I have a simple Zapier automation running creating a record in Base2 after certain criteria met in Base1, this is working fine. But I need to include a User in Base2, and Zapier doesn't seem able to do that unless I have a corresponding User field in Base1 -- but Base1 has no Users fields! I can't add everyone on my team to Base1 just to be able to do this automation, besides that it's adding them to a Base they never need to use and wasn't built for User Fields at all, it also will cause mayhem from the useless "you've been mentioned on this card" emails everyone will get. I just need a corresponding Name (linked record text field) to correspond with a User, without actually utilizing a User Field in Base1. Any advice? Airtable support doesn't help with Zapier and I didn't find any existing articles on this.  

let table = base.getTable("Orders"); let field = table.getField('Order Info'); let record = await input.recordAsync('Choose a record', table);I know that if I make this script, I can press the button and then select the record to run the automation.But what I wanted was to press the button and the script would already get the record without me choosing it.Is there any way of doing this?

HelloI've creating a function to act as a rudimentary web scraper to grab some meta data like the page title, description etc using the `fetch()` api. In an automation, this works perfectly as expected. But in a scripting extension, my `try...catch` throws an error message of "Failed to fetch".Are there some restrictions/limitations between automation scripts and extension scripts when it comes to using `fetch()` ?

Hi there,I'd like to set up an automated weekly email for pending leave applications, but only if there are actually pending leaves. When I tried using conditions linked to individual records, it sent multiple emails. And when I used scheduling as a trigger, it still sent an email even if there were no pending leaves. I have an interface with this summary, but can't seem to use it in the automation. Has anyone figured out a solution for this?

Hey folks,I'm having a strange problem with updating records in my Airtable. I set up an automation where it checks if a record with a specific user ID exists. If it does, it updates the record, and if not, it creates a new one.I deleted all the records from the table. Now, even though the table is empty, the update is failing because the automation is finding two record IDs that don't exist anymore.Empty Table:Run automation :The update will fail as it refers to the previously deleted records' IDs. Is it a cache issue of some sort?Any ideas on how to fix this?Thanks!

Hi Airtable Community,I have a table with events. New events can be added via a form and various needs can be requested for the event using a multiple selection field.A record is generated in a second table for each need.I have currently created an automation for each selection option as I have not yet found a way to do this dynamically. However, as there are now around 30 different needs, I would like to make the automation dynamic. Any ideas for a solution? The problem is that the need has to be named correctly and I can't pull this information dynamically from the multi-selection field.Thank you and BestMirko 

Hi Community. I'm new to Airtable automations so apologies for what may be an overly complex workflow - any suggestions to improve it are welcome. Goal: send an automated email when someone "invites a friend" on a website. Email will say "Hi {friend's name}, your friend {user's name} {user's email} recommended you join this site", etc. How I've set it up so far: Airtable table with fields Friend's name, Friends email, User's name, User's email Concatenate formula to combine the above fields into a message something like "Hi {friend's name}, your friend {user's name} {user's email} recommended you join this site"Automation to send an email using the text from the Concatenate formula Problem: there doesn't seem to be a way to format the text so when the email sends, it's just a long string of unformatted text. Does anyone know a better way to set this up? 

our airtable is automated in sending email notification whenever a new data is added in google calendar. however, i've noticed recently that it sends email notifications excessively and was wondering how to fix it. it's excessive to a point where if you just adjust the time in an event in calendar, it sends email notifs as seen below. the trigger to the action is "when a google calendar event changes"even though i can change the script logic to only add the guest if the change in event was a new guest, it will still run the automation and therefore count towards the number of automations run each monthis there a way to figure out why the google calendar events are changed? i can't see it when looking into it

Hi,I'm looking at trying to create a simple invoice e-mail to be sent out as a result of an automation. I can basically get all the needed data in, but struggle with getting visually at least semi-appealing ;).I read the manual about markdown and that some html can be used. I also looked at the instructions regarding including images in the mail. However:with the limited html on offer, has anybody been able to build any form of layout (other than vertical listing 😉 )? Could CSS and <span> be used to, say, get a right side header column? Or should I try to build views of the relevant tables and insert the data as grids?if I include images (one top banner, one logo) as attachments from a table, they are not just plain images, but have some frames around them. They are also clickable links, which is not good. Based on the instructions I can't decipher if it's possible to have inline images *that are not linked*, but actually a part of th

Hopefully useful for someone. If you set a variable called ‘Shorten’, then you can use this script to pull the URL and turn it into a bit.ly link which you can then use to automate something else! Feedback always welcome. let inputConfig = input.config(); let response = await fetch('https://api-ssl.bitly.com/v4/shorten', { method: 'POST', headers: { 'Authorization': 'API CODE FROM BITLY GOES HERE', 'Content-Type': 'application/json' }, body: JSON.stringify({ "long_url": inputConfig.Shorten, "domain": "bit.ly", "group_guid": "THIS CAN BE FOUND IN THE URL OF YOUR BITLY ACCOUNT" }) }); let bitly = await response.json() output.set("bitly", bitly)

Hi, I'm new to automations on Airtable and am facing an unusual error:"Name is "foo", Invalid filter on Email (Invalid choice name or id: foo@bar.baz)"My "Find records" step has two conditions (OR), attempting to match on "Name" or "Email".Here you can see a successful test, when a match is found:It is also successful when no match is found, BUT when only "name" is used, and not both name and email, finding 0 results (expected behaviour).  BUT when adding the email condition bac, when there are no matches, it gives the error: This seems

Hello! My gmail automation email is going to spam. I created an auto responder using gmail and airtable automation. All my emails are going straight to spam. Is there a fix for this ?

Hi all,When someone submits a form, I already know we have a relatively empty record that exists for that submission. I want an automation to do the following:Trigger: When a form is submittedAction 1: Find a record by matching phone numbers in the table to the form submission.Action 2: Update the record in the table with the new information submitted on the form (5+ fields, some of the fields are drop-downs and some are free text). In my test, it all seemed to go well, and then when we actually submitted something, it stopped working.

Hello,As the title implies I am looking for an automation to catch records created by a form and notify via email when there is a discontinuity from the last submission. For example if the miles entered on a particular vehicle in the last submission were 101 but the next submission starts at 101.3, an email is sent to notify of the discontinuity.Thanks!

I have two tables in my Airtable database: "Interfaces" and "Participants Backend V1". In the "Interfaces" table, I have columns like "int_Email", "int_Name", "int_Dance Course", and "int_Today's Date" (Ceckbox). The "Participants Backend V1" table contains columns like "bac_Email", "bac_01.01.2024", "bac_02.01.2024", etc... "bac_31.12.2024"I am looking for a script that does the following:Look through every row in the table "Interfaces"When a row in the "Interfaces" table has the "int_Today's Date" checkbox checked, the value in the "int_Tanzkurs" column of that row should be read.This read value should then be entered into the "Participants Backend V1" table in the row with the same email and the columne of today's date (for today it would be the column "bac_01.05.2024").If there is already a value in that cell, the new dance courses should be added with commas separated.Does anybody have a recommendation? Is this possible