Automations

I use a lot of linked records.Occasionally I have an issue where a [Record from table A] is deleted (by a user or automation with script) which triggers the deletion of a [Record from table B] it is linked to (by a user or an automation). Because changes to from [Record from table A] look up fields in Table B trigger other automations, these automations start running before Record from table B is deleted. However Record from Table B has finished deleting before the other automations have finished. This isn’t really a maj

I’m trying to create a field that automatically tallies up the number of times each record has been modified. Does anyone know of a way to automate this? Thanks!

We have a variety of projects and ask teams to log their cumulative monthly hours worked for each project. We have an "Hours" table where each row is associated with a project, a month, and a year. Then the team goes into the table to enter # of hours worked for each project. I have the table grouped by month. For example, the grouped field for January 2023 group has a list of 8 projects:TeamMonthYearProject# Hours WorkedOperationsJanuary2023Project A 

I’ve managed to get Markup URLs {[Text](URL)} working when sending emails by automating a field to be written with an automation. However, I’ve lost the ability to separate lines in the email. So, this automation:Gives me this (one is grid and one is line):Any thoughts on how I might be able to throw a line break between these items?

I set up automations for my team so that the next person in the workflow gets notified when the previous step in the process has been completed. However, since I set up the automations, they all come from my Teams account. Is there a way to change this so that the person who enables the automation “sends” the message? 

This automation is designed to automatically update two fields of a newly created record submitted via form. Neither of the fields being updated by the automation is "Formula Name", which is the field that appears to be causing the failure. Anyone have any idea what is going on here?

I have several automations set up to send emails through gmail based on certain conditions (dates coming up, status changes, etc.). They have been working like a charm until yesterday! 2 different gmail accounts should have automatically sent 200 or so emails each. 1 gmail address seems to have worked fine. The other sent maybe 5 or 6 of the emails but not the rest. However, the automation log shows all 200 were successful. I know they didn’t actually send because I have the emails BCC myself, to ensure they show up in my gmail account. Now when I am testing the automations, no emails are sending, even from the address that worked yesterday. I tried relinking the google accounts to airtable. No dice! Any ideas??

Example Of URL/Link in email thats broken, and I need help fixing: Image 2021-02-11 at 10.40.0... Use Case: This email gets sent from an air table automation. The URL is from a field in my table that I’m using CONCATENATE to dynamically add an email to the URL. DT HR: General Phase 1&2 - ... When I click on the URL in the cell in airtable it works. Example: docs.google.com

We utilize Airtable to keep record of barcoded assets located at 10 different locations. When we do a physical inventory we have to manually search the item by barcode number and use the checkbox field to check that it has been inventoried.  I'm looking for a way to set an automation to simply scan a barcode the item being inventoried and using automation Airtable will find the record and update the checkbox field.

I have automation where if number in employee table is above 6 trigger automation, If I manually select record and run automation it works as it should.. Just not sure why its not being triggered.So employee was at 7, I created another entry using interface, It moved to 8. Automation did not run.  

Hi everybody, as you can see I try to connect my airtable with my ghost CMS and I click “yes” on the field where it says “include file content, because it seems an existing problemn with Airtable. But whatever I do in zapier, it still an outdated URL. Is there any workaroudn to fix this?

Does anyone have a current script that is parsing any emails beiing received in the new “trigger when email received”. I am trying to parse the body, but I cannot figure out the inputs from the email received.I get errors on all of the inputs. My reason for the inputs, is that the receivedDate didn’t work.// Get inputs from the automationlet inputConfig = input.config();let subject = inputConfig.subject;let body = inputConfig.body;let receivedDateRaw = inputConfig.receivedDate;// Optional: log inputs (for testing)console.log("Raw receivedDate:", receivedDateRaw);console.log("Subject:", subject);console.log("Body:", body);// Parse date string into Date objectlet receivedDate = new Date(receivedDateRaw);// ✅ Function to get the next Tuesdayfunction getNextTuesday(date) { let day = date.getDay(); // Sunday = 0, Monday = 1, ..., Saturday =

Hi there, I’m trying to create an airtable automation script whereby it takes in the Full name of a record and changes only the first letter into uppercase (upper caps). This is my code, I can’t seem to get it to work, can anyone help me with this? let table = base.getTable("Training Masterlist"); // Use the correct field name that maps to the automation's Record IDlet recordId = input.config().AirtableRecordID;  // Correct this if it's named differently // Ensure that the recordId exists, if not, log an errorif (!recordId) {    throw new Error("Record ID is undefined.");} // Field namelet fullNameField = "Full Name (As in NRIC)"; // Fetch the record that triggered the automationlet record = await table.selectRecordAsync(recordId); // Get the current value of the "Full Name (As in NRIC)" fieldlet fullName = record.getCellValue(fullNameField); 

Have automation to run when record is created, When record is created, It will set added_date, add_by(person email) and set record as active. It does 2 of 3… It doesnt add person email address. What could I be doing wrong?   

Scheduled trigger not working as expected 

OK someone please help! About 2 months ago the automation I had set up from Airtable to Google sheets simply stopped working. I have reconnected everything but get the follwing error message.Error message "This automation is no longer authorized to use the configured Google Sheets account. Please select a new Google Sheets account for this step. Please select a new Google Sheets account for this step."I have a similar automation working fine. Why not this one?

I need to rig up a button that can export a row of data and download it as en Excel file to a local computer.I assume I'll be able to use Make and Webhook for this. However, the Excel file should have a certain layout. Fx an image placed in a certain place as an image, and certain fields should be placed in different places in the Excel file. So a bit like the page designer, but instead of a printout or .pdf it should be an Excel file.Is this at all possible, and/or has anyone experience with something similar?

I'm working on a small Airtable automation to track monthly utility expenses by pulling data from a regional electricity provider’s site — the fesco online bill system. The challenge is that the site often loads slowly or becomes unresponsive, especially in the evenings.Has anyone dealt with similar issues when pulling data from sites that don’t have public APIs and aren't always stable? I’ve tried simple fetch scripts and automation tools, but they tend to fail unpredictably.Would appreciate suggestions on how to handle unreliable external sources in automations, or even alternative approaches like manual syncing that aren’t too time-consuming.Thanks in advance!

Hi! I wanted to ask, if there is an automation for following up on unanswered e-mails? We are tracking our leads with airtable, and if someone doesn’t respond to our first mail, that we send out an automatic follow up E-Mail? Looking forward to your help!

Hello, I would like to know if there is any option to schedule email in the Automations area. My idea is to schedule a follow up for a lead 2 days after I change it’s status to “In Negotiations”.

I am trying to run a script through a button triggered automation, but I am running into an error for exceeding the time limit of 30 seconds for execution. Is there a way that I can get around this so I can run the script?I have heard that people have been running the scripts in batches, however, I am not too sure how people are doing this as I cannot find an tutorials on how to work it into the automation. Any ideas?

I’m trying to identify where a record has an expiration date and send an email identifying that record.I can automate an email that recognizes the expired date but can’t find a way to attach/send the identity of that record. I have a log (record from a table) and the entries have a field “expiration date”.  My automation finds that record and sends an email that a record has expired.  I need a way for it to not only do that but identify what record that expired (separate field).  Is there a way to do that? 

I ran into Airtable’s row limits and pricing walls, so I built a free browser-based tool that lets you export full bases — including tables, links, and attachments — into a clean ZIP file.No data ever leaves your browser.No account required.You can try it here if you're curious: https://ar.konanx.comWould love any feedback or ideas for what to add next — especially if you’ve had similar Airtable pains.

I am trying to set up specific filters after a user clicks a button to visit an interface page. It seems that there is no native way to do this given the options airtable gives you,. It also seems like there is no way to add url parameters to an http address  but I thought it might be possible to just do this using url parameters and a http page.Maybe there is a way to do this with a script? I’d have to figure out what the parameter values for the filter are, and then also have some way to redirect to a new page which might not be possible in the airtable scripting environment. 

I have a script that is using a repeating group to batch process a couple of records sent through output.set() If one of the scripts fails it doesn’t seem to register that error in the overall automation. See image below, individual script failed, overall automation is giving me the green light. I noticed that the script wasn’t behaving correctly on some records but having the script not throw errors is potentially dangerous as problems stay hidden.