Automations

Hi guys,I’m building a CRM within Airtable and need to create a two-way sync between Airtable and Google Calendar so if an event is created/updated/deleted in one, it automatically updates in the other. This is the current setup I have: A separate ‘Meetings’ table for events created within Airtable and a separate table that’s integrated with the Google Calendar (on the interface, it will all just be one calendar). I am trying to create an “Update Record” automation so if an event is updated in Airtable, it updates in Google Calendar but I’m running into some issues and with the vice-versa automation.The trigger runs successfully but the action always fails:

Hey Airtable Community!First time community user so please be kind! I work for an Event Production company, we are beginning to explore the possibility on switching to airtable.  We currently use an Edoc software called Pandadocs for our proposal writing.I am trying to figure out the possibility of when Documet completed → Airtable duplicates a prebuilt base and then takes the pricing table information in the doc and pushes it into each table accordingly.I will admit there is still a lot of details still up in the air, such as what is a table and what is a view? But I am focused on how mechanically I can make that kind of automation and what guardrails I should look out for? 

I’ve been building a workflow that connects Airtable to a CMS so blog content can move from planning to publishing with less manual work.The setup usually includes title, slug, content, images, publish date, and status fields, plus a draft/review/publish flow.I’m curious how others here manage content operations: do you keep Airtable as the source of truth, or do you use it only for planning?Happy to share the structure I use if anyone is trying to reduce manual blog publishing work.

Hey all, figured I’d ask this question and see if anyone has advice/experience, plus it’s been awhile since an Outlook integration thread in case of application changes…So I’ve got an active automation setup integrated with an Outlook calendar wherein people submit tickets and dates, and when a date is created an automation fires to create an Outlook event, with the Outlook ID written into the record for reference. Then when certain conditions are met, another automation fires to update the Outlook Calendar event by referencing the ID. For the most part (like 97% of the time) this works fine, but I’m having a devil of a time on that last 3%. Some of this is accountable to people using the data layer and fulfilling update conditions at creation, those are able to be rectified. The real bothersome one is that rarely the creation automation gets thrown the error Microsoft reported an error while processing this action: An unknown error occurred. I appreciat

I have created a “Release Planner” base in Airtable for coordinating all the steps we have to complete for a software release. I created one table called ‘Template”, and I copy that template to a new table for each release.Now, I want to set up automations to notify me and the assigned to person daily while any task is open, across all tables. I seem only to have been able to set it up on one, but then it doesn’t copy over when I copy the template to a new table. And I can’t seem to set it up the right way every time, plus it’s time consuming. Does anyone have a hack for creating a base-wide notification? Or a way to copy automations across tables?Happy to do scripting, but I would need detailed instructions, as I haven’t done that in Airtable before.Thank you!

Hi all, I am running into a challenge again related to automations and multiple select fields. I have a table where locations are input as “city, province” (I live in Canada). For example, “Toronto, ON”. When a record is approved, an automation kicks in and has to populate the location field in another table. The problem is that when I assign the location field in the 2nd table as a multiple select, the automation splits the city and province (“Toronto”, “ON”). I tried making the location field in the 2nd table as a single line text but still the problem exists. I have spent so much time trying to figure this out but am unable to. Is there a way around it? Thanks so much.I am attaching screenshots showing how the location is populated in both tables.

Good Morning, I am working on building a table where my daily sales data is entered, and that data point from this year can be compared to the same day of the week from the previous year. I am not a professional developer, so forgive me if my knowledge is at the beginner level. Currently, all of the data is populating correctly, but I have to manually enter in the SelfLink value. I have tried to create an automation for when a new record is created, however have been unsuccessful so far. Here is a screenshot of how the relevant points from the table are set up. My question is, do I need an automation, or is there a lookup field that I could enter into get the selflink field to automatically reference the corresponding day from the calendar week number of the previous year?Any direction on h

I’m running into an issue where the hyperlink is not being created in an automated email that includes a link to an Airtable form that includes prefilled fields using Markdown. I have hyperlinks in almost all my automated emails, which is a lot, and all the others seem to work fine, except for these ones that include pre-filled fields.  Example of a link with prefilled fields that is not producing a hyperlink[Home Assessment Scheduling Form](https://airtable.com/appi09WiT6MFsy9zo/pagYdHzqnzsTRVhmn/form?prefill_Efficiency Arizona Applicant Name={Applicant}&prefill_Your Email Address={Applicant Email}&prefill_Street Address={Full Address}&prefill_Project Number Form Submission={Project #}&hide_Project Number Form Submission=true) I thought maybe it had to do with spaces, but I’ve tested it with underscore, no spaces, and even found something saying using a + or %20 between wo

Hi everyone and Airtable Support team,I am writing to request a one-time reset or waiver of our automation quota for the current billing cycle.What happened: I was performing a bulk field update in our base (which contains approximately 18,000 records). I converted a Single Select field to a Link to another record field. I did not realize that this conversion would trigger an existing automation for every single record in the base simultaneously.The result: Our entire monthly quota of 25k automation runs was exhausted in a matter of minutes.The impact: Our entire content and editorial workflow is currently paralyzed. We rely on these automations for assignment notifications, status updates, and external freelancer communications. Without a reset, our team is unable to move work forward for the remainder of the month.Support history:

Hi guys,I have been trying to format my gmail body using html tags but i am not getting my desired output. The formatting looks awfl when sent to customer. Extra spaces have been added above & below the text despite setting the padding to 0. Here’s the formatting i have been using: <table role="presentation" width="100%" border="0" cellpadding="0" cellspacing="0"><tr><td align="center" style="padding:0;background-color:#ffffff;">  <table role="presentation" width="100%" border="0" cellpadding="0" cellspacing="0" style="max-width:520px;">   <tr><td style="padding:0px 16px 14px 16px;"><span style="font-family:Georgia,serif;font-size:10px;color:#aaaaaa;letter-spacing:4px;text-transform:uppercase;">Faisal Silk  ·  Order Update</span></td></tr>   <tr><td style="padding:0 16px 0 32px;"><span style="font

In a rich-text enabled long text I can use [] to create a check list.Trying to create a checklist by default in an automation using the same function but it doesn’t seem to work. Is there anything different I need to do if this is a capability? If not i can look into adding it to a script that I have earlier in the automation.

Hi,I’m a bit confused regarding exactly how to navigate the different situations when wanting to append data with Update Record automations. I see some seemingly random errors that I quite can’t understand.The basic use is clear,  add “back” the existing data that was in the field, then add the new data separated by a space or by a comma if it’s an array.But, how to deal with these situations?you don’t know if there is existing data in the field, so which input variable do you place first? The variable for the existing data, or the new? I seem to get errors if having the existing data variable first, indicating it can’t fill first an empty variable then process the comma and the new data.   if you use the values under FLATTEN in the variable token, should you use a space or a comma as delimiter? As FLATTEN transforms an array to a comma-separated string, shouldn’t one then use space? Or, should one not FLATTEN the data, and

I have a table (“Active”) with thousands of records, each with at least one photo, the table is refreshing more slowly everyday (we upload small file images). To help speed things up I have created a copy of the table (without data) and setup an automation to copy any given record to a new table (“Archive”) when two field values are met ( “status”=SOLD, and “Archive” checkbox is ticked). This is working now that I’ve mapped all of the fields from one table to the other. I want to continue the automation to delete the record (from the “Active” table) that has been duplicated from the “Active” table to the “Archive” table. Tutorials say to add an additional action, “Delete Record”, but I find no such choice when adding an additional action. It seems this should be an evident action, but I’m stuck. We have a “Team” level subscription so I’ve read the option should be available. We’re using Safari on Macs. All advice appreciated. 

Hi,It seems that the Google Calendar: Create Event requires a hard coded (chosen) calendar to place an event in. We have used a shared calendar for this, but it gets somewhat messy.Hence, would it somehow be possible to have the event placed in a dynamically chosen calendar? Either <current user> or somehow derived based on a variable (e-mail addresse for example)?Rgds,Björn

Hello,We’re working on an Airtable automation and wanted to sanity‑check whether this setup is supported or if there’s a better approach.We have a table called Research plan with a linked record field (Research study) pointing to another table. In the Research study table, there’s already a Persona field populated.Our goal is: when a new Research plan record is created and a Research study is selected, automatically populate the Persona field on the Research plan with the Persona from the linked Research study.We tried doing this with an automation:Trigger: When a record is created (Research plan) Action: Update record (the same Research plan record)However, the automation fails with the error: “Updating the record failed due to insufficient permissions.”We’ve confirmed:The automation owner has edit access to both tables The Persona field on Research plan is not a formula or rollup

I’ve tried almost every workaround I can think of. As a temporary solution, I can force “Deep Match” to always return something (a "fallback" record), but I haven’t found a way to trigger an automation after “Deep Match” runs successfully and finds nothing. Does anyone know of a workaround, or can point out what I might be missing?

In an automation with multiple logic branches, I like to end the Otherwise step by sending an email to myself with details to be research to find out why things didn’t go as expected. I find that works well most of the time. It also prevents the automation from outright failing.But when things are busy and the automation runs frequently, it is harder to find the exact run that failed. Is there any way to include the automation runtime in that Send an email step? I don’t see any way to get at those details.

Hello,i want to know if is possible to copy automatically fields from a table New Books to anther table Books.They will have the same fields. The table Books contents all the existing books on a library and the table New books, all newly purchased books.  A form in softr will be filled with new books and it will be showed in table Books.   

Hi there, It appears that there are a lot of threads but I can’t find an answer. I want to be able to add some images and font sizes and colours. I’ve tried connecting to GMail and setting up a signature but it doesn’t include the signature in the email body. I also have a field with the persons name in the airtable base, however that isn’t displaying for some reason.  This should be pretty straight forward. I’m open to paying someone to do this.  Thanks in advance. Jared.

Hello,i want to know if is possible to copy automatically fields from a table New Books to anther table Books.They will have the same fields. The table Books contents all the existing books on a library and the table New books, all newly purchased books.  A form in softr will be filled with new books and it will be showed in table Books.   

I’ve been banging my head against a wall trying to get this to work and at this point I’ve come to the conclusion this might not be possible. I’m hoping that there is a wizard out there that may be able to help with this issue.  So context:My base contains 3 tables. An inventory, a customer table, and an orders table. There are linked fields in both my Inventory and my Orders table that link to the customers table. Within my Inventory table there is also a linked field that links to the inventory. What I want to do is whenever I add a piece of inventory to a record in the Order table, that it adds the customers name to the item within the Inventory table.  I’ve tried getting Omni to help me set it up, I’ve tried getting the support chatbot to help, and I’ve even tried Claude to help me with no results. If someone could share the correct setup I’d be eternally grateful. If I’m knocking on a door that doesn’t exist

Hello team, Is there a way to set up an automated outlook email(event) to be sent from a shared inbox and not my personal inbox in airtable?

I currently have a sign-up form that collects both a name and email address. When the person signs up, I have an automation set up to send a confirmation email. I have a bizarre situation where one person somehow keeps submitting their name and email address in what I assume is unicode bold, sometimes courier, and sometimes in a type of cursive. Whenever this happens, the confirmation email fails. The person who signs up on this form is older, and has no idea what she’s doing. I am hoping to be able to somehow convert all the unicode fonts into something that is readable so it can send emails.Some more context, the font also doesn’t get picked up if I do a Ctrl+F on the back end of the form. It’s as if the text isn’t there. If I copy and paste the text somewhere else online, it keeps the formatting, which makes me think it’s some kind of unicode that is still readable, but obviously not in this email situation. Can I fix this on the back end of AirTable so anytime she

I’m trying to configure a log-style table in Airtable where, when a new record is created, certain fields are automatically populated using values from the most recent existing record.The problem I’m running into:Using Automations → Find records, I can filter and sort records so that the correct prior record is identified However, Automations treat the result of Find records as a list, even when sorted and limited to one record Because of this, I can’t reliably reference a single previous record’s field value when updating the newly created record I’m using the Airtable free tier, so scripting and paid features are not availableWhat I’m trying to understand:Is there a supported way on the free plan to carry values forward from the most recent existing record into a new record using automations? If this isn’t directly possible, what table design or workaround is required to achieve this behavior wit

Hello, I would like to write a script that will move this project from “Active Projects” table to “Completed Projects” table when the status is changed to “Completed”. Can anyone help? Thanks!