Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,195 Topics
  • 16,192 Replies
5195 Topics
N
NitaiLSInspiring
posted in Automations
Retrieve error message and insert to record field using automation

Hi, I'm a newbie in scripting, but enthusiastic learner 🙂A little background to the request:I have an automation that runs over a list of volunteers, some of them need training for their roles.the list contains the dates of those who need training and uses OOTB actions to find which have training today: the automation checks each record, and if the date of the training is today, the automation sends a mail with the invitation link to the video training.the problem: sometime, the automation doesn't succeed in sending the mail to specific volunteers.the requirement: using script action, if sending the mail wasn't successful, to put the error message of current volunteer's into current volunteer's record, into "error" field.Will appreciate the help on:Thanks!Nitai

20
N
S
starparkssiNew Participant
posted in Automations
How to create new records as many as the quantity of number column?

Hello, I'd like to know how to create new records using automaitons in B table as many as the quantity of number column(ex. 5) in A table when the status column in A table has a specific value(ex. realease).See the example below.1. Input 2. OutputI'd appreciate it if you could let me know.

212
kuovonne
G
GrimiKnown Participant
posted in Automations
Automations - copy of a Base

Hi! I would like to make a copy of my Database, automatically, daily. Can not find the solution with automations. Thannks 🙂

22
G
W
wfrezzatoNew Participant
asked in Automations
Error: Field "fld3VB0dy42qjaliB" cannot accept the provided value.

I made the code below to read a row in my Teste3 table, and from that row, generate new rows according to the code. Row generation is correct, but the script is unable to record new rows in the table. Can you help me?    let table = base.getTable('Teste3'); let queryResult = await table.selectRecordsAsync({ fields: ['Valor', 'Vencimento', 'periodo_real', 'parcela_real'], }); let records = queryResult.records; for (let record of records) { let valor = record.getCellValue('Valor'); let vencimento = record.getCellValue('Vencimento'); let periodo = record.getCellValue('periodo_real'); let parcela = record.getCellValue('parcela_real'); if (valor && vencimento && periodo && parcela) { let [currentParcel, totalParcels] = parcela.split('/').map(Number); if (currentParcel < totalParcels) { let newParcels = []; for (let i = currentParcel + 1; i <= totalParcels; i++) {

532
kuovonne
Karlstens
KarlstensBrainy
posted in Automations
Lookup .valuesByLinkedRecordId doesn't return within Automation Script?

When I run my following code within the Scripting App, it returns an overly useful object that I can easily sort and use to update my record with.  let sortedResults = membersRecords.records .filter( member => member.getCellValue("Result Date") !== null) .forEach( member => ( console.log(JSON.stringify(member.getCellValue("Result Date").valuesByLinkedRecordId)), console.log(member.getCellValue("Result Date")) ));  Note how valuesByLinkedRecordId, which is a lookup field set to return the date, returns the below object - and how in this object the records are incorrectly ordered by date.This returned valuesByLinkedRecordId object is fantastic, as it can be processed into an object that's sorted by date and then stamped back into the associated Linked Field so that the records are then in the date sorted order. However, when I attempt to adapt my Script App code (which cycles through all records in the table) into an Automation script that's n

40
Karlstens
C
CbathelNew Participant
asked in Automations
Help with autopopulation of data when a new entry in a linked sheet is created

In advance, thanks for this help. I work at a small company, and I'm a marketer by trade, so please be kind 😛Anyways:I have a base that's for an artist on our team. It currently has three sheetsProjectAsset TypeIndividual AssetAnd are nested together (Project is the main umbrella of any, well, project. Asset Type is [product] Screenshots, [product] videos, etc which serve as the organizational packets of deliverables, and then individual delivered assets live under that). We have very strict content approvals, so I need to get very granular with approval and content revision chains, down to the individual asset. Currently, it's working, but it's a bear with manual data entry when a new record is created. I have two (and a half) goals I'm trying to accomplish:1) If the artist were to open up a Project, and then select "Add Asset Type" (from a linked records to the other sheet), upon clicking this, I'd like to have it auto-pop the records that would nest down well: Due date,

172
C
G
GrussKnown Participant
asked in Automations
Update Status Field Across Multiple Tables for Specific Records

Howdy AT Community! Hoping a kind soul can provide some assistance with an automation query. I'm trying to track subscription activations for a University cohort, pulling from a large Uni Cohorts table to update a specific cohort tracker table.  Desired automation flow is as follows:Student submits subscription activation request form > record is auto populated in main Uni cohorts table (first name, last name, email, Uni name) > record 'Status' field is set to 'activated' if approved in main table > student record status field is updated/reflected in cohort activation tracker tableThe list of student names and emails is already populated in the tracker table, purely need to track them in for external onboarding reporting purposes. Struggling to get the update record automation to work between the two tables (unless there's a formula trick I'm missing?)Any assistance greatly appreciated. 

196
pressGO_design
Aaron_Hess
Aaron_HessKnown Participant
asked in Automations
Automate sending digest

I think I'm really close to figuring this out.  Here's the ideal  scenario:My accounting department hits a "Reminder" button on their interface which triggers an automation to send my Project Managers a reminder email to approve their invoices.  The email contains a grid of that specific project manager's open invoices.My current situation:- My interface button works great.  Best button ever.- My "repeating group" action is where i'm getting twisted up.  I've got a "repeat for every one in the project managers" list going. I've got a "Find Records" action that finds ALL the invoices where the "PM Approved" field is not checked. I want to send Project Manager 'A', a grid of ONLY his invoices that haven't been approved yet.  How do I add a condition in the "Find Records" action that find records for the next project manager on the list?   Edit:  I think I understand now.  The "list" can only be generated from a multiple sel

170
Aaron_Hess
H
Hallie_BregmanNew Participant
posted in Automations
Conditionally email records to a conditional set of people

I’m using a base to conduct performance reviews and record records. On a set date, I’d like to send the relevant records to the relevant employees. While I understand how to find records and trigger emails (see below), I’ll need to use dynamic recipients, which conditionally match only to their rows in the table. I’m struggling to set this up. With 50+ employees, I’d like to be able to do this dynamically, without manually coding each recipient. Specifically, I want to send Manager A all of the records about Employee A. I want to send Manager B all of the records of Employee B. Any ideas how to execute this? Thanks!

526
Aaron_Hess
A
alex37New Participant
posted in Automations
Update Records Using a Webhook

I've searched and read related posts, but I'm still not seeing the exact same behavior.I'm using webhooks to both create records and update records. The create records automation functions as expected and creates a record with invoice number, and other order data.Now, as that order is updated (ex: ships, is delivered), it sends a second webhook, for which I have a second automation. I have a webhook triggering a "find records", but am unable to have it find records that match the condition of invoice number. If i try to select the matching record, it says, "no nested values available".I have also tried to just skip the find records step and use the invoice number (which is the primary field) in the update records step, but that also doesn't work.Error message in either instance is "received invalid inputs"This doesn't seem like the proper functionality. Any advice?

815
ScottWorld
G
GM-in-ChicagoParticipating Frequently
asked in Automations
Automation Confusion-- Help a Guy Out

HI All--- I have several automations set up and would like to create this one below. I am trying to set up what feels like a relatively simple automation, but cant figure this out. Can anyone help? Short explanation I want that....1. when a specific form that I use, is submitted...2. containing 1 of any 3 options in the dropdown,3. to update a different record in the base.---- More detailsI am trying to eliminate a manual step that I have to do each time this form is submitted. After a form is submitted, I have to find the record and update a field to "N/A" whenever a form is submitted as Paid. N/A tells other team members that the invoice does not need payment. Basically what I want is that any time a form is submitted as "paid" it should also have "N/A" applied automatically. But I can't figure this out?! We have 3 different credit cards that we use so, really, any time the form has been submitted with any of the three cards (Paid Visa, Paid MC, Paid Amex)...

74
G
J
Jarrad_Connor1Inspiring
asked in Automations
Hootsuite

Just curious, are there currently issues with Hootsuite & automations because of Twitter?I have some Airtable automations that allow me to send unique scheduled posts to Hootsuite for multiple platforms & accounts. I have seperate automations for each platform or have one for the option to send to all.Seems like Twitter has broken the API between Airtable & Hootsuite.I am getting an error from Twitter when trying to connect to Hootsuite. Seems like Twitter is even preventing the connection to the other platforms.Twitter returned an error. Error hashes: rm18c109a07cc4fc8a, ufm18c109a07cc4fc8aCannot use the automation for any of them now. p.s. Screenshot shows the ones I am speaking of as turned off. That is intentional so I can do things manually.Just curious if anyone is dealing with the same issue. I have sent this to support also. Figured I would give it a shot here also.

232
J
F
Francoloco23Known Participant
asked in Automations
Script Exceeded Execution Time Limit

Good morning team,I’m trying to run this automation script that works on a base with 82,000 records but now throws this error since May 3, 2023. This is the first time that it happened on my base.Just a bit of a background, my Airtable base is connected to Softr as well. This is the code developed:// Converts settings selections to variableslet sourceTable = base.getTable("Bulk Upload");let selectedField = sourceTable.getField("Attachments");let destinationTable = base.getTable("Bulk Upload Extract");let nameField = destinationTable.getField("File name");let attachmentField = destinationTable.getField("Attachments");let recordinput = input.config();let bulkrecords = await sourceTable.selectRecordsAsync();let chosenrecord = bulkrecords.records.filter(test => test.id === recordinput.record_id)

281
Ben_Young1
J
jb11New Participant
posted in Automations
Create an line number based on The Invoice Number

I have a master table Invoice with a fiels Invoice_Number and a detail table Lines.Each Line belongs to a single Invoice.In the table Lines I want to setup a field Line_Number and I want to automatically populate its value.Line_Number must simply contain the line number of its Invoice.For example : Invoice A has 3 lines numbered 1, 2, 3 and Invoice B has 2 lines numbered 1 and 2.Does someone knows how to setup this field ?.Thanks by advance.

60
J
O
OdysseyNew Participant
posted in Automations
Newsletter subscription count

Hello everyone,I'm asking for your help on a subject that seems simple to me, but which I've been struggling with since this morning.In my company, airtable is used in particular for the subscription to our newsletter. To date, we have nearly 18,000 subscribers. I would like to create an automation that would allow me to send a slack push, every Monday at 8am, with the number of subscribers to the newsletter and the evolution of the number of subscribers since the last week.Do you have any idea how to do this? pleaseThanks in advance   

81
TheTimeSavingCo
J
jainpurtikolaNew Participant
posted in Automations
Record Update

Hi All,I am a Recruiter and I stored my candidate details in Airtable like Name/Contact No./Current Company.Now I want to share an automated email to my candidates to update their respective record. Note: My candidates don't have edit permission. Please suggest is there any way for this.

96
ScottWorld
D
David_BruntNew Participant
posted in Automations
Airtable G Suite/workspace Directory Sync

Has anyone found a way of keeping a table in AirTable fully up to date with new users when a new person is added to the G Suite Directory (GAL)? Zapier does it with personal contact but I haven’t seen anything with the global directory.

322
MichaelTomar
A
Ana_ChairezNew Participant
asked in Automations
Integration for Airtable and QuickBooks Desktop 2021

Hello, I would like to integrate an Airtable workspace to QuickBooks Desktop (2021), not online. I need automate the creation of multiple sales receipts. Does anyone know how to set up this integration?

553
MichaelTomar
K
kotrfaNew Participant
posted in Automations
Automation executions stuck "In progress" for 12+ hours on simple "Update records" or "Send email"

Hi,we had a fairly simple automation - on a checkbox, send an email and put a simple value in one of the cells. We ran that for 1200 cells, the automation executions got queued, but only some of them went through to the email phase and only a couple of them got to the last step of updating the records. We are on a PRO plan, so we should have enough of quota (50 000). The automation has been working fine when testing (and apparently another couple hundreds of executions - as we know that cca at least 500 emails went through).What's going on?

1391
J
M
mrwinter11Participating Frequently
posted in Automations
Automation to auto-populate records based on availability dates between two tables

Hi! I have the following problem I'm trying to solve:I have one Trip table which lists a series of trips, which each have a start and end date and a list of 4 potential locations.I have another Crew table which lists crew members start and end dates, and their location during those dates.I'm trying to figure out how I can auto-populate a field in the Trip table with the crew who are available from that building during the trip dates, depending on their availability.Is an automation the best way to try handle this?I've made some attempts but am struggling without having dynamic date entries in the automation filter conditions for finding records. There are dynamic entries for Text, but not date fields.Any help would be greatly appreciated!

50
M
S
serpentorNew Participant
asked in Automations
Can I use conditional logic in automation emails?

I have an automation that generates an email.In some cases the fields I want to include in the email are not set yet.I want to add a conditional statement to the email composition, something like "If {name} is set, include {name} followed by a comma, otherwise skip straight to the text." I can't see a way to do this in the automations interface.I know that I can add fields to the table to do this but I'm trying to figure out whether there is a way to handle this logic temporarily within the automation.  

1181
kuovonne
DrChrisD
DrChrisDNew Participant
asked in Automations
Updating Field with Multiple Linked Records Using Automations

This is my first post so please bear with me. I have a base that I am using to track content and for project management of a newsletter. Table 1 Newsletter shows the newsletter project and has fields for Month, Year, Content (which is a linked record field), Content Attachment, and a checkbox for completed. Table 2 is where I am tracking content based on 8 common sections, month, year, content attachment, point person, notes, and content created checkbox.  I have an automation set up that when Content Created in Table 2 Content is checked it updates the Table 1 Content multilinked records. When I update more than one Content Created in Table 2 Content it only overwrites the other content in Table 1 Newsletter instead of just adding the subsequent linked record. Once all 8 Content Areas are in that field, an email is triggered to several people saying all the content is complete and is ready to go in the template for the newsletter. Is there a way to have the automation u

51
DrChrisD
M
maelrxNew Participant
posted in Automations
Button + Script : How to retrieve the content of a cell present in the row of the triggered button ?

Hello to the community ! I'm coming to you because I'm stuck on my project.  I have a table that contains different columns and the last one is a "Button" that triggers a script. I would like to get the content of the cell "dossier" in the row of the triggered button. Row NumberFIRSTNAMELASTNAMEDOSSIERBUTTON1JOHNDOE49BUTTON2MARIADOE21BUTTONFor instance here, how can I make sure that the script is using the value 49 if I trigger the button of the row 1 ?I would like to automate this, I don't want the enduser to pick a record manually. Big thanks for you help,Maël 

1293
TheTimeSavingCo
A
Ayushi11New Participant
posted in Automations
Email automation

Hi ,I am trying to send an automated email which contains a table but while i am doing an automation for the same, i am not able to add the table in it.

21
TheTimeSavingCo
J
junekyungNew Participant
posted in Automations
Airtable Slack automaion failed

Hi, I had used the Airtable-Sending Slack automation function well, but since a while ago, the automation keep failing.The error message is 'Received invalid inputs. Could not find Slack conversations for email:'. The 'invalid inputs' message referred to is a 'to' field, which has an input of email. It had worked well for over 2 years, and it suddenly failed to function.Do you know how to fix this problem?(Recently I just became an administrator of the Slack workspace. Does it relate to this problem?The email inputs themselves are all exact and have no problem.)

512
ScottWorld

Badge winners

Show all badges
Terms & Conditions