Automations

Hi all! I just started using Airtable today, and my mind is spinning with all of the automation possibilities! I am stuck at the moment and could use some guidance- any help is greatly appreciated- thank you in advance! I’ve created a base that I am using to track the progression of people signing up to be a guest on a podcast. Here’s the desired workflow: We enter the names and email addresses of people we want to be on the show into the base. Once someone says yes, that contact record is moved from one status to another within a kanban view. I created an automation that triggers when the record is moved from one status to another in the kanban view. It sends an email with a link to a form. My issue is that I don’t know how to have that form update the current record that we created in step one, as opposed to creating a new record. Thanks for any help!

Hello :wave: Does anyone know if it’s possible to autopopulate a field with a link to the Slack message created as a result of a Slack automation?

Is it possible to only complete an action based on the output of a previous action? I would like to run a script when a field is updated, but I want to send an email based on the output of the script. If the script runs and doesn’t find any conflicts I don’t want to send an email. In this case I don’t really see a way to break out of an automation or send an email inside a script other than using outside API calls. How would you accomplish this? Would Airtable throw errors if I just put in a blank email in the to: field so that the step is executed, but it doesn’t actually send to anyone?

Hi everyone, I’m trying to write my first automation and could use your help with some basics. I need to use an automated script to modify multiple fields of the record and then I also need to take values to manipulate. The script below throws me the following error: TypeError: Invalid arguments passed to recordQueryResult.getRecord(recordId): • recordId should be a string, not undefined at main on line 4 I have an input variable defined: name: ID id: record (Step 1: Trigger) | Record ID Then my script looks like this: let table = base.getTable("Books"); let pitch = input.config; let allrecords = await seriesTable.selectRecordsAsync(); let record = await allrecords.getRecord(pitch.ID); await table.updateRecordAsync(record, { 'Status': 'Cancelled' }); let title = pitch.title;

Hi! I run a travel company and we have lots of client info loaded into airtable, including peoples dates of birth. I want to set it up so that I get a notification in my outlook email on the day it’s one of our clients birthdays. Is this possible? I’ve tried using the date field, but obviously peoples DOBs are in the past, so the dates don’t match up with our current calender to get notifications. Thank you!

UPDATE: See my last post for the ultimate solution. I came up with some inadequate solutions earlier in the post, so save yourself some time if you are looking up how to generate random items from a linked field. EDIT: to make this more clear for future readers—I was trying to do this in an automation script. It worked as a script app in Airtable, though my final script below is much more performant. I make heavy use of scripting in Airtable, as well as the API, and I am pretty comfortable with using both, but this simple script is kicking my butt for some reason… it either hangs after running for 3000ms CPU time, or quits with an “unexpected error”. At one point it also threw a “syntax error”, even though there is no syntax error, and that error went away on its own without me changing anything. AFAIK there is no way to ‘select’ records with a filter in Airtable Scripts, before fetching them all, so you have to select the whole friggin’ table (even if it’s 6000 records), and then u

Hi all, i’m new to airtable I try to send an email from gmail but 1 have 3 fields missing in the received email + an unreadable date / time format Could you help please ?

Hi everyone, I was delighted to discover recently the automation function within airtable, allowing me to remove part of the automation I had with third party providers (Zappier mainly). I am however unable to solve one specific automation : I have a database with a unique line for each of my customer with its details and linked documents. Each customer is delivered a unique line in the database with a specific ID Each of them is also provided with a link to an airtable form that allow them to send me documents (in form of attachments) that I need (ex. copy of ID, copy of birth certificate, etc…) They provide these documents throughout the year and not in one time. That is where I created the automation : 1- It takes all the attachment from the new record (each time they add a document, its create a new record) 2- it copy and past these attachments in the relevant fields in the main customer record 3- it deletes the new record used in step 1 to keep the database clean. Zappier added

I have a simple automation for a Pinterest automation. Pulls records from a field as it enters a view and pushes to a google sheet. Which is then picked up and pushed out to Pinterest via IFTTT. What I can’t figure out is why sometimes the attachment (image) URL is sent out as an AWS CDN link and sometimes it’s sent out as a dl.airtable link. The airtable links always work. The AWS cdn links work sometimes. More often that not I get an error that the image is no longer available. It’s the like the cdn link expires too quick for the automation. My push automation from google sheets triggers on when a new row is added so we’re talking about seconds here. Anyone have any guidance here? This is frustrating me to no end. My automation is almost there!

Hi there, I am struggling with an issue for over a week now and decided to ask for help. In my base, I have a linked field pointing to another table of search keywords, describing the Product on the main table. These keywords are being populated by multiple sources, firstly being Google Vision Block that writes image keywords into a text field from where they are supposed to be added into the Keyword Fields via Automation, secondly users manually entering keywords in the Keywords field itself, and lastly users who enter keywords in a separate field called Bulk Keywords, simply because filling down a separate column by hand is much much easier than adding the same keywords in many fields which already contain information, simply because copy&paste would cause this to overwrite the existing information. So far so good. Up to recently, i had Zapier going merging all of these fields into the main Keyword, which was working fine but was very very slow. I wanted to make this work within

I have an AWS Lambda function written in python that is initiated by a Zapier trigger that I set up. As I pass some input parameters to the function in the Zapier trigger, I can access to the input parameters in my python code by using variables such as event[parameter1] . It perfectly works. I’m trying to access the same Lambda function in Airtable Scripting environment. In order to do it, I set up an API Gateway trigger for the Lambda function, but I can’t figure out how to pass input parameters in the vanilla JS environment. Below is the code that I have, which gives me “Internal Server Error” . Your help would be definitely appreciated! const awsUrl = "https://random-id.execute-api.us-west-2.amazonaws.com/default/lambda-function"; let event = { "queryStringParameters": { "folder_id": consFolderId, "email": email } }; let response = await fetch(awsUrl, { method: "POST", body: JSON.stringify(event), head

Hey everyone! I need some assistance. We have automations linked from an external scheduling website Calendly. When a record is created there it updates on Airtable and assigns a person to interview them. Here is what I need to do: When that record is created it makes a new table for me with all the information and interviewer In that table I need to update or create a new list that links that interviewer ( we have 3 separate ones) to a public name so first and last names are not listed in an email automation I can not for the life of me figure out how to get it to automatically find the interviewers record and create a field with just their first name so I can link THAT in an email. Any help would be awesome. Thank you!

Hi all I have a situation where shopify inventory levels in airtable can be changed manually by a user or automatically by shopify when a product is sold. I have an automation that watches changes to the stock level value and on change, triggers an automation to update shopify via a webhook via integromat. The problem is that when an order is placed in shopify, this automatically changes the stock level in airtable via integromat, but, this also triggers the airtable automation which then updates shopify again. How can I prevent the automation from running if the stock level change was a result of an automatic update from shopify rather than a user created update action to the stock level please? I have tried looking at last modified by but this doesn’t change whether it’s an automation of a webhook that changed the value. Any help would be gratefully received. Thanks Claire

Hello everyone, I am really enjoying Airtable, but I am running into an issue using the send Gmail email action with an image attachment inside an automation. When this email with image attachment is send, the image doesn’t show up as attachment, but a weird file-type does: These images in my base are just simple jpegs from around 350kb. When using the ‘Airtable send email’ action the attachments work fine, but I need to use gmail. Any help is super appreciated!

I ran into a problem using functions like DATEADD({Date 1}, 10, ‘days’). It took forever to find the syntax error AirTable was reporting. It turned out that the ’ coming from some keyboards (mac, ios) was not recognized as the right character. I could fix the formula by copying and pasting the single quote but I could not type it. I was wondering if I was using the wrong key but I could not find another single quote.

New to automations, so excuse this if it’s ignorant, but I am trying to create an automated email when a record is changed in one table. The email needs to be sent to a collaborator that is a lookup from another table. Below is a quick breakdown of our setup: Base has two tables. One table for projects, another table for tasks. The tasks table is linked to a record within the project table, and using lookup pulls necessary data into the task table. Specifically, the project manager is a collaborator within the project table, but is a lookup on the task table. I need to be able to notify the project manager when tasks change automatically. TIA

Hey Airtable community, i need your help ! I have a question :slightly_smiling_face: I have a table in airtable called “invoice” where all of my client invoice informations goes (Name/mail/adress/total paid/…) i use these informations and connect them with zapier to a template, the infos autocomplete this template. I wanted to know if same thing can be done with new automation function directly through airtable. From what i’ve leaned it’s not possible airtable can only transfer data to specific header columns and not to a template. Thanks for reading !

I’m trying to set up an automated email that fills in the contents of a multiple select field. Is there a way to insert the multiple select field in something like a plain english list? For example, I have a multiple select that has [Sam; Suzy; Pete]. I would like to insert the sentence “Sam, Suzy, and Pete” into my email. Thanks!

Hello – I have two tables and have an automation running from conditions met on the first table to create new records on another table. I have several automations running between these tables with no issues for some reason, one of them keeps creating two extra records. I’ve even tried deleting it and recreating it. Any ideas? You can see here that it is only meant to create 5 records but it’s creating 7.

Hey guys, does anyone know why there is +07 at the end of this line? also, for some reason, it’s not picking up the correct rows (i.e this test returns a row that has last modified on the 8th [it is now the 10th]) any ideas on how to be more specific with the date?

Hi, I would like to sort a table without sorting the last 2 columns, is there a way? Thank you. Jill

Dear community, We help our customers by notifying them when their employees certificates expire and they need to renew certificates. Employees have 10+ different certificates and I would like to automatically update the expiry data for the certificates to “5 years from today” when it expires. But how do I update the specific date field in the record when I have multiple date fields in each record? How does the automation know which date-field to update? Can I refer the to date that just expired, and if so, how do I do that. Hope some of you have a solution. Thanks, Jon

I am trying to create an automation that triggers when a record reaches the last stack in my Kanban view (Placed 1st Order) that the action is updating the record to checked a box in the columed called Customer. I’ve created the trigger, but I’m getting tripped up on the action. What record ID am I suppose to add? And When I choose the Customer field, it doesn’t let me tell it to check the box.

I am trying to create a duplicate table in the same base with few records. I have used trigger actions and trial run was tested successfully. trigger( a new record created in s_table in base_1) to action( create new record in s2_table in base_1) the s2_table has custom modifications so that the records to integrate it to Hubspot via zapier. . The only change in the field type from original to duplicate is primary services ( multiple select ) and primary services ( multi line text in s2 table).>> reason( for Hubspot integration) I will appreciate it if some one help me with the automation issue?

Hello everybody, Quick introduction i’m a beginner in Airtable and Bubble io, i have a bubble io website where clients write down their invoice linked to airtable, my project is that when i click on a button on Bubble io, Bubble Io creates a new line in Airtable in a table called “invoices” with informations the client just typed and previous informations already in Airtable linked to the current mission. So here’s my issue : I use a workflow to create a new record in Airtable, i link the data with an External API (for the data i already have in airtable) but when i link the already existing data composed of formulas 'in airtable (for example : Data 1 & " - " &{Data 2}*) the constraint is red and it doesn’t work. When i initialized the Table in the Airtable plugin i specified that the formulas were a “text” data. In the example under this post, you can see a screenshot, the red circle represent the data with a formula which i want to put in my new line, i simply want to take t