Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,196 Topics
  • 16,198 Replies
5196 Topics
R
Ruben_RossvoldInspiring
asked in Automations
How to add to record instead of overwriting?

My record has a field that's named  'Automation history' which is where i want my scripts to keep a log whenever it does some changes, i keep this to identify errors etc. But the issue is that it get's replaced, is there any way to .push that value there instead of overwrite? All the other code i want to keep as is.This is my code:  let createOpportunity = await tableOpportunities.createRecordAsync({    'Opportunity Name': orgName,    'Organization number': orgNumber,    'Company Type': orgType,    'Foretaksregistret': orgRegisterDate,    'Kommune': orgKommune,    'Postnummer': orgPostNummer,    'Automation history': "Record created at " + yyyy + '-' + mm + '-' + dd + " ,&nbsp

312
R
R
RSkInspiring
posted in Automations
Query regarding performing calculation across rows

Hi, My Airtable use case is to maintain Farmer’s finances. We have developed a WhatsApp bot, and by using webhook triggers the information gets stored in Airtable.I have a query regarding calculations.This is my current data structure. Since we cannot create columns dynamically in Airtable using Automations, I am generating dynamic rows for each expense type for each crop.Now in the Current Crop Expense column, I want to calculate the sum of all the Expense Amount for the current crop for that particular user.For eg: For user John CROP B, the total in the Current Crop Expense column will be (200+60+70) = 330 and stored in the corresponding row to the crop name. It can be stored correspondingly to all 3 crop B rows or just one. But I need the calculated value to send back to the users.For Crop A for the same user, the value stored in Current Crop Expense will be 170, and so on.For User 2 - the total Current Crop Expense for Crop A will be 7, Crop B = 410  (240+1

94
TheTimeSavingCo
Kevin_Estavanik
Kevin_EstavanikNew Participant
posted in Automations
Best way to Automate recurring Show and Segment Creation

Hello!I'm helping a TV Station track their various weekly productions and was looking for help on a way to automate the creation of future recurring show and segment records. The main issue I am running into is how do I populate future Date and Time fields for the various productions in an automation based upon each productions schedule/template.For context each of the 8 productions has a base with a table called "Shows" that has a one to many relationship with a "Segments" Table with the following fields.Shows TableSegments TableStatus (Single Select: Pitch, Production, Aired)Placement (Single Select: A, B, C, etc)Air Date & TimeTaping Date and TimeSegments (Linked Records) Two production template/schedule examplesShows TableSegments TableShow 1 - 12-15-22 7pm Air DateSegment A - 12-15-22 4pm Taping Date Segment B - 12-15-22 4:30pm Taping DateShows TableSegments TableShow 2 - 12-15-22 10am Air DateSegment A - 12-15-22 7am Taping Date Segment B - 12-15-22 7:30am Tapi

191
TheTimeSavingCo
T
twmericNew Participant
posted in Automations
Is Automation limited to one time a record?

Dear All, I have got a situation, where I try to have a single update will trigger two records changes (one to many relationship), like below:When I change back to 1 on 1 relationship, the automation works.  Because the two entries are on the same column, so that I can't refer one to another.Any suggestion to me?

11
kuovonne
G
GreidamNew Participant
asked in Automations
Help, can't access fields after Find Records step in an email automation

For some reason I can't insert the fields from the Find Records step as a token in the email body. Am I missing something obvious or is this a bug? I tested the Find Records step and it successfully returns records and shows me the related fields

80
G
B
bstrandahlNew Participant
posted in Automations
Email notification Emails

I want a specific person to receive an email when a record has been added to a view. I have it set up and it runs perfectly BUT most records are added a few hundred at a time. Is there a way to have the email go once after a data dump instead of for each 300+ records?

31
TheTimeSavingCo
J
Jordan_MParticipating Frequently
asked in Automations
"Find Records" Automation in a Script

Hello everyone,I am very new to scripting, so hoping I can get some support here.In short, I am trying to use the "Find Records" automation action to get a list of records, and then pass that list onto the script to delete them. Below is what I have but am getting "TypeError: Invalid arguments passed to table.deleteRecordAsync(recordOrRecordId): • recordOrRecordId → recordOrRecordId should be a Record, not undefined or recordOrRecordId should be a string, not undefined"I believe this is because the list is being passed to the script as a string, not a record, but am not certain that is the issue or how to rectify. Code is below, thanks in advance!let table = base.getTable('Milestones'); let inputConfig = input.config(); let recordsToDelete = inputConfig.RecordList; console.log(recordsToDelete); for (let deleteRecord of recordsToDelete) { await table.deleteRecordAsync(deleteRecord.id); output.text(`Deleted record for ${deleteRecord.name}`) }

2003
kuovonne
N
NamachaNew Participant
asked in Automations
Modify a single select for an entire column

Hello everyone, To begin with, sorry for my writing, I'm French and I'm not used to English yet.I'm looking to change the status of a column with a simple action, like a button or a formula but I don't know how to go about it.As you can see in the photo.I am eager to see your advice to carry out this action, thank you all!

220
Karlstens
J
Joel_Andrews1Inspiring
posted in Automations
Time Converts to UTC in Email Automations

Whenever I include Date & Time fields in email automations, the time gets converted to UTC. Is there a way to prevent this? Thanks!

14210
T
B
Brendon_JohnsonNew Participant
posted in Automations
Automation from two tables, creating single entries in a third table

Hi all, I am trying to create an automation where when I add an activity to a person in the first table (which draws from a second table), in a third table it automatically creates a row with the person and activity each as individual entries, which I can manage in a Kanban with a third drop-down option, as outlined below. I want to be able to match each person individually to each activity for this Kanban option, so I can filter and monitor people's responses to an activity overall one at a time. The problem is, with the automation I've created, instead of creating an individual entry for the latest activity I've added with the person I added it to (see table 3 DESIRED below), it instead creates a row with all of the activities attached to that person (as you see in the last table – table 3 ACTUAL).The automation goes like this: When "activity" is updated in table 1Automatically create new entry in table 3I tried adding a step in between – search for "person" in table 2

01
Karlstens
J
Jordan_MParticipating Frequently
asked in Automations
Conditional Automation Button Based on time it was Last Clicked

Hello,I have an automation based on a button click that creates a number of records in a separate base based on what is selected in a multi select field. The automation itself works well, but I am having an issue with people accidently clicking the button multiple times and creating duplicate records. They do need the functionality to run the automation if the multi select field changes, though.My thought was I could use the now() function in a field to essentially create a "Button last clicked" field, use a formula to compare that to the last time the multi select field was modified, and then use that formula's output as a conditional check for an action within the button automation.The issue I am having with this approach is around the now() function, the field only seems to update every 10-60 minutes. So within those 10-60 minutes, the check doesn't work and the button can be clicked multiple times.Is there a better approach to this? A way to work around the now() function providing

263
J
A
Andrew_DaviesInspiring
posted in Automations
Autonumber - reset each day to 1?

Hello allI have a "maintenance log" and have created an ID field with date / autonumber (ie - 14th December #1)The autonumber I am doing with a simple autonumber field, but I am wondering if there is a way of resetting the number to 1 each day just to keep it clean.  It would also be a good way of seeing how many issues are created each day.I have tried the following with no success :Add a "Next ID" field - which is the current ID plus 1Create an automation which searches records created today onlyIntention was to find the most recent record - then use the "Next ID" field to populate the "Current ID" field - but I can't limit my search to just 1, most recent record.Trying to avoid using Make / Integromat if I can.Any thoughts?Andrew

812
kuovonne
S
SynthetikNew Participant
posted in Automations
Automatically create a title from a YouTube link or website?

I'm wondering how one might go about creating a script or automation that would create a title for YouTube links and possibly for websites as well.For example, when the YouTube link is pasted into the field, the title of the video is read and then inputted into a title field.This is to save time by not having to go through and label all the YouTube links and websites.

162
Databaser
H
Hilla_Michowiz_New Participant
asked in Automations
RTL in mail automation

Hi, I want to send emails to my customers using the Gmail automation and I was wondering if I can somehow change the direction of the text to RTL (the mails are in Hebrew)

440
H
R
REBECCA_ELAM1New Participant
posted in Automations
Find records by condition needs attention

we still dont have grouping or sorting for records found by conditions in automations. and you cant add an additional dynamic filter to the view you choose… this makes this effectively useless for many cases. we keep getting things added to the ‘by view’ option but the ‘by condition’ option you need to use in order to have dynamic lists in emails. we either need view selection to be able to be dynamic or we need to be able to add an additional condition to the view. ‘show me the records from the expiring projects view where sales person is sales person from the triggering record’ or ‘show me the records where the name of the view matches the sales persons name from the triggering record.’

21
Karlstens
P
Paolo_CesareoNew Participant
posted in Automations
Puzzle with the table in a record

Can anyone help me solve this puzzle? I need to insert a simple table into a record. Basically within a record I need to collect the data in rows with headers. Someone has already faced this problem. Thanks in advance to everyone.

51
Karlstens
B
Brandon_VangNew Participant
posted in Automations
How do we access an input variable in a form and assign it upon creation of record?

I have an input variable called “recordId” with value of Domain of website. My question is, when we create a new form from the interface to add a record to a table, how do we access that record? I noticed when we set up input variables, they only access specific values we give it. How do we avoid this and allow variable to be free to capture the data in the form? const config = input.config(); const recordId = config[‘recordId’]; console.log(recordId); For example, let says I have an interface form that allows me to create a record. Let’s assume the form has: Name, Domain. When I click submit to create a new record entry, this input variable should have Name, Domain. For some reason, I’m unable to figure this out.

561
Karlstens
R
Ryan_MizakParticipating Frequently
posted in Automations
Java Automation

I am trying to get a sum total of a column in an automation that will send out an email showing the new total every time an amount is added. I was tasked to create an automation running a script, but I am very new to script writing. Any help would be most appreciated

111
Karlstens
A
Andrew_TsaoNew Participant
posted in Automations
Null check in Airtable Automation Script

Hi 👋I recently decided to take the leap to level up how I use Airtable by taking baby steps to use Airtable script to accomplish more complex tasks, especially in Airtable Automations. I am currently struggling to combine a typical "If conditional statement" with a "for loop."In this example below, I am trying to do a simple null check to check if NOT BLANK then run through the for loop to update those blank fields with an "Undefined" text, but it always seem to replace all records even when a record already have text in it. What am I doing wrong or what am I missing?  let records = input.config().step2Records let table = base.getTable("Playground"); if ("Email") { for (let record of records) { await table.updateRecordAsync(record, { "Email": "Undefined" }) } } For reference,  input variables: I have seen you @kuovonne all around forum posts patiently teaching others about understanding and utilizing Airtable script

897
Karlstens
Y
yahalom_cpaNew Participant
posted in Automations
Sending a different email based on the score

Hello,I wish to create an automation for my students. Trigger: If the column is marked as true: Action: if the SCORE in the scores column is >= 70 Send Email A if the SCORE in the scores column is < 70 Send Email B 

52
Marielle_Gueis1
L
Luis_TamezNew Participant
posted in Automations
Automation: Linking record dynamically based on Date ranges

Hi Airtable community!I need your help... I am working on a personal finance project and have 3 tables: 1) Credit Cards, 2) Statements, 3) Transactions...On the Credit Cards table, I have a list of the Credit Cards available to make transactions (e.g. Amex Platinum, Chase Sapphire, etc...)On the Statements table I have a list of all the monthly statements for the each of the cards (e.g. Amex Platinum - Nov 2022 Statement). Each Statement record has a linked record to a Credit Card (from the Credit Cards table) and also a Start date and Close date, which define the range/period for all the transactions pertaining to a Statement.On the Transactions table, each transaction has a Date, amount, category, vendor, and a Credit Card (linked record to Credit Card table). What I need to achieve is to link each Transaction to a corresponding Statement, based on the Credit Card and the Date information on each Transaction. Today I am creating this link manually, but I would like to automate t

162
TheTimeSavingCo
M
Marika_VallierParticipating Frequently
posted in Automations
Airtable/Google Calendar Integration sharing

Hello !How can I share (=make it visible) the Google calendar I created via linking my Airtable calendar via the URL to anyone from my team? 

50
M
D
Dennis_YuInspiring
asked in Automations
Using Zapier, find a record with the same phone number. If it exists, do nothing

Hey AirTable Community Me again, I am currently using Zapier and WATI. I have a base of all my Leads, sometimes, Leads are created twice intentionally. When a record is created in AirTable, I want Zapier to notice. Then Zapier will tell WATI to create a Contact based on the details. Then Zapier will also tell WATI to send a template message to the person. The above is easy enough. The problem lies thereafter, since I can have Leads with the same Phone number, I don’t really want WATI to create two of the same contact and send the same message twice. So my idea is that after a record is created in AirTable, I want AirTable to look for another Lead that has the exact same phone number, but not the same Lead Unique ID. If the result is TRUE, then do nothing. If the result is FALSE, then proceed with the rest of the steps. I am slightly limited to Zapier as a tool for now since the WATI integration with Integromat/make is a little “wonky” and unintelligent (or maybe I am wonky and unintell

120
D
N
nunesNew Participant
posted in Automations
Hootsuite integration not working to upload video

Hello Community,I can't upload video using airtable to hootsuite, but hootsuite works fine if I don't use airtable.Any suggestions?Thanks

50
N
S
SkidzParticipating Frequently
posted in Automations
Record List Block

Can you incorporate record list block in automations? Since I found this is the only way to limit X number of rows to show. 

82
S

Badge winners

  • Welcome
    jeckelbargerhas earned the badge Welcome
  • First Topic
    ABTChas earned the badge First Topic
  • Welcome
    ABTChas earned the badge Welcome
  • Welcome
    danielahas earned the badge Welcome
  • First Reply
    AlineWhas earned the badge First Reply
Show all badges
Terms & Conditions