Automations

Hello,Yesterday Automation Script Block had some errors and it failed for multiple automations.Inside the Script Execution log, This error is shown for both of them.There was an unexpected error while executing your script.Just confirm that anyone else has that same issues.@isaiahmiller97  also mention before day.  AUTOMATIONS UNRELIABILITY - Airtable Community  

Hello, I need help figuring out what I am doing wrong. In the main table, I track daily work, and in the other table, I track inventory. There is created a link record from the main table to the inventory table. From the main table, I am selecting the available items for sale. What I would like the automation to do is find the records that I have assigned and copy the quote number from my main table to the inventory table. I know I can do a lookup the problem is that I have too many records that would have to backlog. Here is what I am trying to accomplish with the automation, but it keeps failing. After I update that Quote Number field and select the items from the inventory table, I am triggering the automation from the checkbox field. Main table view: Inventory table (Resale Items) view: It finds the records. Automation fails, even though it finds the Record IDs.

Hi, I'm sure this question has already been asked but still can't find an easy answer. It seems as though it should be quite simple but I can't wrap my head around it.As per the screenshot, I would like to automatically combine Linked Record entries from multiple fields into 1 field. The 1 combined field needs to keep this data as Linked Records, and not as formula text.The  Linked Records are from another Table in the same base.So basically, if this automation or formula was setup properly - the "ALL COMPLETED PROJECTS" field would contain 3 Linked Records: "Pen", "Pal" and "Pol".Is this possible?

Not sure if this would be a roll up field, script, or automation but I am trying to combine multiple linked record fields into one linked record field automatically. For example: One record has multiple linked fields “Assignment 1”, “Assignment 2”, “Assignment 3”, ect. and I want them to all be shown in an “All Assignments” linked field automatically. Is this possible?

I have a Purchase Order table and an Expenses table that when records are created and automation pulls the records into the Budgets MASTER LIST using roll up and look up fields. Each Budget is allocated to a department (Autism Liaison, Events, IT & Comms etc etc ) so the Primary field for Budgets MASTER LIST is a forumula using IF to pull in the lookup Budget ID from each entry so I can group the entries by Budget ID. (hope this makes sense so far).I also have another table that lists all Budget Categories (called Annual Budgets) that contains the annual budget amount and on this table I need to show running balance - remaining budget etc etc (don't worry about that I have already set that up), BUT it relys on having the linked field in the Budgets MASTER LIST to do this.So, all I need is each time a new record is created in Budgets MASTER LIST, rather than me having to manually select the linked field 'Annual Budets' and select the budget related to it, is there any way I can say

i have a script step in an automation that i have been using for many weeks. it has been working as expected- with many runs per day. i've been rebuilding some automations, so i've been running them a lot as i test them. just now, the automation stalled out and finally failed:FailAn unexpected error occurred, please contact Airtable support.When i tried to test the script, i received this error:ERRORThere was an unexpected error while executing your script.the script in question is: output.set("date", new Date().toISOString()) I started using this script in December to replace having a "Today" field that used the Today formula. I use the script to update a field that displays when the last automated activity took place. it is used in many automations and all are now failing. Any suggestions on how to resolve this?

We are an Enterprise user and heavily dependent on Airtable Automations working.On Monday, Airtable automations had an unreported outage and performance issue spanning over 12 hours that went unreported on status.airtable.com.Support made us aware of a fix after 12 hours.Now, 2 days later, automations are now failing again and pending.This is unacceptable to Enterprise users and we expect issues like this to be resolved within an hour at the latest.  This is a commercial solution, and our entire business operation is at a standstill due to this.We have used only 20% of our automation runs budget allocation, and these performance issues are unacceptable.

I am trying to send emails using the Gmail automation. The field I am using to route to the "To" field in the automation is an email field. The problem is, some of the emails were inputted with a space before or after them, which I suspect is preventing deliverability.I tried using a formula field to trim the email field, but I route the formula field to the "To" field in the Gmail automation, it shows up blank as though there is no text in the formula field.What is the best way to eliminate spaces in a field you intend to use in the Gmail automation's "To" field?

I have made a stock taking system in airtable. And I have a whole list of items with current stock values. I would like to the end of every financial quarter take a snap shop of the current stock value. Is this possible?I've tried to play around with scheduled time trigger and the repeating group action, but I don't seem to be able to find a way to tally this up. Is there a good way to do this?

Hello,My team and I have many due dates scattered around as we are show managers.I recently built in a formula based off of weeks out from show time that the item needs to be completed, and how long it takes to complete it to in order to find out when we need to start the task.I'm currently trying to send a weekly Monday email at 8am that sends to each assignee informing them on the upcoming start task dates coming up within the next week but have run into an array of issues and I don't know which angle to take it on.Is it possible to automate this or is this too many fields? I have been reading a bunch of community forums but all have one part of what I need, but not completely.Please note:Some tasks have multiple assigneesThis is for a view within a viewAny insight helps as I am fairly new to Airtable's automations and feel like I've done everything.Below are the column fields on my base.Once again, I'm trying to complete the following automation:Email individual Assignees every Mond

This is Conditional Logic that is very simple, one of the conditions is the "has any of" and that is selected from the single select field as  "CTC" and then it just fails and shows the result from that field as [object Object}. What is causing this? See attached screen shot.

Hello,So I am trying to make a column where if a user updates their date of birth it will change their date of birth in a different table. The issue I am running into is that when I change the date of birth for any user it just changes the date of birth of the first person's date of birth in the second table.How do I make it so that if a user puts in their date of birth it will change onto the other table on the line specific to where their name is?

Hi, I would like to add a pop-up for one of my automations. It's triggered by button. Automation creates a record based on input from different table. I'd like to be able to have a communicate lik "created successfully" or "creation failed". Is there a way to do it?

Hi Everybody,I have an Airtable table already populated.There's a field called <<Status>> set as a formula that takes either the value <<OK>> or <<Not OK>>I want to set an automation that calculates the number of rows with the field Status = <<OK>> for each day.Ideally, I want the results to be shown like this  DATE                                                        Number of OKs15/01/2024                                              3216/01/2024                                              28......Thanks in advance for your help.Just for information, I am a beg

Hello. I am encountering a small problem with a Make.com scenario Goal: Scrape info from an API and update a table inside of Air Table API is running smoothly, all data is being pulled. Currently, the scinerio is only running and creating 20 records total inside of air table. I have a paid subscription and am running into this problem It should run continuously. Anyone have any info about this? 

Is anyone seeing their automation freeze after a trigger?

Hello everyone,I'm currently working on an automation project where I'm facing a challenge with embedding images into a Google Slides presentation. I am using Make to lift the images from airtable and replace the placeholders in Google Slides template. I am able to pull in all the text information but have hit a roadblock with the image embedding part.Here is the issue:* I have a Google Slides presentation with placeholders for images.* My Integromat scenario successfully retrieves image URLs from an Airtable base.* The URLs are accessible and lead to a download option for a `.png` image when opened in a browser.* However, these images are not being uploaded or embedded into the Google Slides presentation.Sharing a screenshot of my Make scenario.This is the templateAnd here is the settings of Upload Image module The url that I obtain from the previous module looks like thisIt seems the URLs might not be in a format that Google Slides can embed directly, possibly because they initi

Dear Airtable community,I'm working on an automated email sendout where I would like to let the recipient know which order and delivery dates will be applicable within a holiday week. To make it as easy as possible for the reader, I basically joined one big text field based on the data input, for example "order will be placed on 28-12-2023 for 02-01-2024". Now, I'm looking for a way to aggregate my output - kind of like a pivot before showing all fields. Data format:CityRecipientTextBerlinBerlin1order will be placed on 28-12-2023 for 02-01-2024BerlinBerlin2order will be placed on 28-12-2023 for 02-01-2024HamburgHamburg1order will be placed on 29-12-2023 for 02-01-2024FrankfurtFrankfurt1order will be placed on 28-12-2023 for 03-01-2024How can I aggregate the information so my vendor only receives the following information:CityTextBerlinorder will be placed on 28-12-2023 for 02-01-2024Hamburgorder will be placed on 29-12-2023 for 02-01-2024Frankfurtorder will be placed on 28-12-2023

Hi all, I love the AT community and can often find solutions within articles but can't seem to find anything that helps solve my current situation:I have a multiple-user assignee column and often people from lots of different teams get pulled into one task. We also have a multi-select team column showing which teams are directly involved with the task. I currently have automations set up to add the relevant team into the team column when any of the team members are added to the assignee field. But as conditional automations only run until one condition is satisfied and then stop without making updates for any other satisfied conditions, I have had to create a new automation for each team, to ensure it updates for every assignee. I am currently trying to write a script to combine all of these automations; I have coded the part to input the table and source (assignee) and destination (team) fields, but am stuck as to how to define each team and the relevant team members and then get

 My automation exceeded the run limit 2500 in just a few hours because I don't know how to control it! Can someone help me?  

Hello, I created 2 automations in Airtable: 1- to calculate the distance between two points using the Haversine formula and: 2- for reverse geocoding to convert latitude and longitude into an address. Unfortunately, I'm getting an unexpected result when I execute a new data record; it updates results with numerous rows! Does anyone know how to control this?

I would like to know when a repeating group in Automations is finished. I try to use a number field and update it incrementally but the formula does not seem to work in Automation. Is there any other way?

hi all, i have a parent table that is copying data to a child table on a condition. I've written the script and I can handle all the data types except I'm having trouble with the linked field. I have a User table linked to both tables. I keep getting this error: id has incorrect objectId prefix "sel", expecting one of ["rec"]the linked field I'm copying returns this object:{id: "seleCE7wF1kaofYBd", name: "Lucas", color: "cyanLight2"}but the actual record id of "Lucas" on the user table returns "rec6TmmKCTEiSp3BA".How can I fix this? 

Fetch request is built like this, including these headers: But it returns a CORS error — the webhook isn’t returning Access Control Allow Headers… Oddly enough I can get it to work from Postman: And if I follow the proxy outlined here it works as well. Is there a way to make the webhook return that header? Or another solution? Thanks!

Hello everyone, we created the following script yesterday, which is running and working, but we are facing the 30second timeout issue every time. Is there a way to make this script run smoother or more efficient, or what could be a solution to loop the automation? // Fetch records from TABLE1let table1 = base.getTable('Supplier summary');let result1 = await table1.selectRecordsAsync();// Fetch records from TABLE2let table2 = base.getTable('ERP_suppliers_hub');let result2 = await table2.selectRecordsAsync();// Loop through TABLE2 recordsfor (let record2 of result2.records) {  let SupplierId = record2.getCellValueAsString('supplier_id');  let key = record2.getCellValueAsString('supplier_id_key_formula');    // Check if the key