Automations

We are getting close to determining of going with Zapier or Make. I know very well the feedback about Make vs Zapier. However, the decision is more than just me. Either way, our team has a question on how to best judge how many actions or operations is enough?At minimum we’re quoted around 300k-500k runs. I can understand there is a number of variables at play.Some considerations:From an Airtable perspective on an Enterprise account with over 20 apps used across the organization for about 150 editors Considerations to connect Airtable with ServiceNow, MS products, and other financial tools Starting out with about 5 developers using the API solution Definitely be capitalizing on the AI offerings either hasIf anyone has insights on how to determine what is needed love to hear about it.

Okay, so it's 2023. Is it possible to update information in a record via a form and not delete data if the form field is left blank yet? I wish to allow users to update database information via a form, but I do not want the existing data in a field to be deleted if the user leaves a form field blank.Is there a way to achieve this in the Airtable UI and not third-party apps?Is it possible to add to the photos via this form submission instead of replacing all the photos with the update form? For example, photos 1, 2, and 3 already exist in the data. A user used the update form and uploads image 4. So it would update the data to have photos 1, 2, 3, and 4. As it is not, it replaces photos 1, 2, and 3 with just photo 4.Thanks for reading!

I have a table where there are potentially multiple images available:Two columns linking to other records, then One Lookup column for each of those to look up the image attachment, and then finally, One more column where I paste a screenshot, used for cases where neither of the other links are present.So there are potentially 3 columns which could contain an image attachment. If I were to try to build a sensible gallery or an app, I’d only want one image for many of the views, so I’d like to make a Best Image column.The rules are more or less:Does Source 1 exist? If so, use Source 1 If not, does Source 2 exist? If so, use Source 2 If not, use Screenshot  If I try to do this using a Formula column, I end up with what looks like a URL to the image on dl.airtable.com, instead of it displaying the image. The docs do say that attachme

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?