Automations

Hi folks! I'm trying to create a Base that tracks all the calendar entries in a shared Google Calendar, and then every week (or so), archives all the new entries in the Calendar Sync table into a separate "Archive Table". The first part is easy, I have our AT Base syncing with the correct Google Calendar we need and pulling all the info down into AT. The second part is where I'm running into problems. Because our Google Calendar policy deletes everything older than several (I believe 3) years - I need to find a way to archive that information separate from the sync table (since when things delete in Google Calendar, they'll also delete in the synced table).I also don't want to have it automatically pull new entries anytime a change is made to the Synced Calendar table - as we're likely to adjust the entries multiple times and/or delete and add new versions based on our needs - so if I have it automate pulling every entry

Hello, I have an automation where it creates a record if certain parameters are made. However, I do not want it to create a record if it's already there. Here's a video for more context: https://komododecks.com/recordings/fOQVUaV5AMpx41gc149W

Hello AT community, I create a trigger to email relevant parties when a record’s date is overdue but can’t seem to find how I can make the trigger repeat daily - that is, as long as the overdue date is unchanged and remains before today, I’d like to continue receiving email notifications on a daily basis. Your help would be greatly appreciated. Big thanks, Roy

Hi, I am looking to build a script that will allow me to run a large find and replace on Airtable en masse so I do not need to do each one individually. I have a list of around 137 words, they are sectors, that I would like to replace with broader sector categories or something along those lines.For example, Film > Entertainment or Media & Healthcare Products > Healthcare. The sector on the left is what I would like to find and the category on the left is what I would like to replace. Does anyone have a script like this to hand where i can replace the find and replace words, or please could someone help me in creating this code. Thanks

How can I add a “like no like” button to an Airtable automations mail, so I get feed back in an Airtable table? Something like this:

Hi Airtable Folks!I've created an automation to create a weekly agenda for our marketing team using the Airtable automation feature to create a new Google Docs when triggered. My question - Is there anyway to format this to look a bit nicer? Currently the tables/record headings display as thick black bars, and the font size is all 11 - I'd prefer it smaller! Also is there a way to change the column sizes? Kind Regards,Nicola

Hello!First time using this forum so really looking forward to your expertise to help with our calendar management. Our goal is to create an automation/approval process as I we 2 date fields, one as date we input, another as proposed date that a user can enter if the first date doesn't work. When someone types in the proposed date field, I want that to trigger that to go to specific team to then review, click approve/deny.If approved, that proposed date would then replace the date field.  If deny, we can have a comment box for reasons or perhaps other suggested dates.Please let me know if you can help with this and have alternate route to achieve the goal as above is just some thoughts. Thank you so much! 

Hello Thank you in advance for your help! I am trying to create separate records from a lookup field (the input variable) which in this example include the name Tom, Rose. The goal is to write these to new records however keep them linked to the "People" table by using the "Person" field. I am receiving a "cannot receive the provided value" error. I know it is an issue with the way I am writing to the linked record but I am pretty new to this so any help would be appreciated. Thank you! Checking the documentation it states that record links need to be in the following format, ive played around with this but do not quite understand how this would work in my case. What would the string be ? TYPEDEFArray<{ id: string }

Hello Community!I have a form to submit records to "Table 1". Two of the fields from this form are Long-Text fields called "Anchors1" and "Links1" where I input multiple lines of text. In example, "Anchors1" cell content is:"Anchor 1Anchor 2Anchor 3"And "Links1" cell content is:"link1.comlink2.comlink3.com"Example of the form: https://airtable.com/shrSx7xeaXqXIfGByExample of Table1: https://airtable.com/shrXWKgXuwV0sx2cw I want to run an automation, that every time the form is submitted ( and a new record is created on "Table 1") I can get the data from the last record created in "Table 1" and split the records from  fields "Anchors1" and "Link

Please how do I loop through a data like this and create a records in airtable I got this from an external API and parsed it to json format

HelloI have a question about if cell contains "value", then multiply by # formula.  Is it possible to achieve the result I intended in column C?Column A, single select = High, medium, lowColumn B, numerical value = 5Column C, formula, = If column A is high, column B with 0.7, If column A is medium, multiply Column B by 1, if column C is low, multiply by 2. I am hoping I am able to multiply by a specific number under certain conditions.  Without manually typing in a value in the columns.  Just being able to select a value in the single select column makes the task and viewing easier. Thanks in advance!Annie

Hi! Does anyone know if there is a way to do a sum of each status?For instance I have 5 statusStatus 1 - 14Status 2 - 29I am trying to get a view or a script to be able to automate an email that shows how many items are in each status. thank you!!!

Hello, is there a way to run an automation for every linked item within a record? I am either short a few brain cells or this may be a setup issue.I have a business table and a member table. The business can have many members, and the member can have many businesses. However, I want to send a specific text message (via twilio beta) from each business to only their linked members. Is there a way to do this? Twilio throws an error (blank value) when I pick values from the linked member list. I almost think I need a third helper table with single member to single business links. For consideration, the member list would ideally be unique values. Additionally, I would be looking to build this out only to send a message on a member's birthday. Thank you!

This is the first time I have written a script myself as I have been self-learning over the past couple months. I am trying to build a script that will run when a record is created that creates repeated events. I have users who submit events through a form on the interface and added 3 fields focused on the workflow. The flow I am hoping for is if someone checks off Repeating Event it will look at the Frequency field (single select) and the End On field (date) the workflow script will then create events with the same field values at the same times through the date specified in End On field. I know i could probably remove some of the script and use the conditions in the workflow but I have confused myself to the point of not knowing how to move forward without breaking anything more than it already is. Any hints or assistance would be greatly appreciated.// Declare variables let table = base.getTable("Table 1"); let currentRecord = //cannot figure out how to make

Hi everyone,Thank you so much for looking into this and helping me out on this.We need to set up an automation that triggers alerts based on a particular due date and a single select, I have created this quick Loom video showcasing the base we have set up and I tried to clarify the automation as well.Here is the video: https://www.loom.com/share/8015ae2596a64b7aa04c0343d55309cfI would really appreciate any help in this regard. Thank you so very much and I will be looking forward to further responses.Cheers!

Does anyone know how to simply program an automation that would allow for clients to be assigned to employees based on first letter of last name.So if clients with last names starting with:A - G --> Employee 1H - M --> Employee 2N - S -->  Employee 3T - Z --> Employee 4i figured this might be a combination of a formula field that just isolated the first letter of last name. But i think there should be a quick second step that would maybe group letters in alphabetical divisions easier than just manually input a condition automation for each letter.  

I have a table of products that includes a linked record field to a “tags” table. Each product can have multiple tags. I want to create an automation that auto applies one of the tags, called “New Product”, to the product and auto removes the same tag at a later date but does not remove all the other tags in the field. I was able to get the first part to work wonderfully – I have a field that is the last modified date and I setup an automation to apply the “New Product” tag to the the product if the item enters a view and the last modified date was within the last 30 days. But, I can’t figure out how to remove the tag without also removing every other tag in the field. Any thoughts or threads of wisdom? Thanks, Justin

Hi good people. I'm building a base to track my handstand progress. I'd like the base to go to Pexels (or another free source for images) each morning, grab a picture of someone doing a handstand, and add it to "today's" record. Can anyone head me in the right direction to build this automation? Or have some advice/insight on how to make this happen? Appreciated in advance. 😁

Hi, i am just getting to know about airtable and I set up automation and connected my gmail. i want it to send emails to email addresses in my record when a condition is met. but it is telling me I cannot send an email to non-collaborators on my current plan. my question is1. If I upgrade to plus plan will I be able to send emails to everyone including non collaborators?2. Is there a way to send emails to non-collaborators on the free plan?

We had Twilio automation running perfectly sending sms to a phone field on every new record added to a base.Today the automation started failing noting "Twilio reported an error while processing this action: An unexpected error occurred, please retry or contact Airtable support."When looking in the Twilio console I don't see related errors in the error log.Attached is a screenshot from the automations run history.I am new to airtable, and not sure if there's some better way to report such cases. Would highly appreciate your help! 🙂

Hi all – I’m building a workflow using Power Automate to create forwarded emails as “activity” records in Airtable. I’m having issues understanding the Airtable Connector in Power Automate and wondering if anyone has successfully used the “create a record” action before. I’m a little stuck with the required field “body”, and weirdly this required field isn’t mentioned in the documentation here: Airtable (Independent Publisher) - Connectors | Microsoft Docs. What exactly is “body” associated with in airtable, and how should I think about what content should go there? For more context, I’m creating a flow that pushes emails into airtable as a new record. I thought “body” might just be the name of the new record, so I tried pulling “subject” from the email, but the string type is not accepted. Thanks!

Want to have a button that creates a new note field which is Triggered by an automation, although I want the Created By field to have the tag of whoever created instead of; Created By: Automation. Is there any way to do this without a script and if I had to use a script, any suggestions?

Hi all,CaseI've been working in Airtable for a few months now, preparing to launch a platform for our production planning (replacing our current Excel workflow). Each item that enters our production queue is scheduled for a specific week (2023-03 for example) and should get a unique serial number. The serial number consists of a prefix + an incrementing index number, as follows:Prefix = Producer code + Year + Month letter. E.g. A23A for an item with Producer code 'A', planned for week 2023-03.Incrementing index number = 3 digitsFinal result e.g. = A23A501ProgressI've currently set it up so that the calculated prefix for each record links to a table ('SN prefix') containing all prefixes used and the next available index number (rolling up the existing index numbers and adding 1).When a new record is added, an automation fires a webhook, sending the record ID and prefix part to Make.com. Make then r

First things first, for all you airtable users, all the best for 2023!Context:I've got a newspaper that appaers 6 days of the week: monday, tuesday, wednesday, thursday, friday and saturday.Every day i have in this newspaper 2 free spaces that needs to be filled up with an advertisement.I would like to use airtable to make a kind of reservation tool so i can follow up when the correct advertisement must appear in the newspaper.Through a form the user must be able to input:the name of the advertisementa start date of the apparitions (date selection from a linked table to exclude double bookings)a frequency of apparitions (1 = one day / 2 = two days / 3 = three days / ...)ProblemI really don't have a clue how i can automate that airtable assigns the dates to the record when the frequency is more then 1.And then for the icing on the cake... the frequency sh

Hello everyone!I've created an Automation that fires when a Record enters a certain View (date). However, if a colleague of mine creates a Record, sets the date till today which triggers the Automation, the Automation will start firing which will end up in an empty e-mail sent.So I want to add some sort of a delay to this Automation in order for my colleague to have a chance inserting the data to the different fields.I've read back and forth on different forums. The closest I've come is this solution:"I’ve used LAST_MODIFIED_TIME() comparisons on multiple occasions to build automation triggers, and have never run into issues. My trigger formulas typically look like this:AND({Field To Watch}, NOW() > DATEADD(LAST_MODIFIED_TIME({Field To Watch}), 5, "minutes"))This ensures that the field actually contains data, and that data was last updated more than five