Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,191 Topics
  • 16,172 Replies
5191 Topics
L
leone_rochaNew Participant
posted in Automations
Sync with Google Spreadsheets (Update) creating multiple rows

Hi All, I'm new on using Airtable Automations and have been trying to sync content with a Google Spreadsheets file.Once using the "When record update" trigger type, I've observed that each "enter" command made by the user when typing on a specific cell/field in Airtable creates a new row in the GSheet tab.My question is: how to assure that the GSheets will reflect and store only the final status, i.e., the most up-to-date content in Airtable?Rks in advance for your thoughts! 

853
matthew_b
P
p_finder25New Participant
posted in Automations
Segmenting a base into a master email list.

Hey there - What I'm Trying to Accomplish:I'm building an Airtable automation that extracts email addresses from multiple fields in my Contacts table and creates individual records in a Master Email List table. Each email should be stored as a separate record, along with the corresponding Contact Name and an "Email Type" field (Primary, Partner, Referral, or Connection).This will allow me to export clean, deduplicated email data into HubSpot for email campaigns.My Setup:Table: Contacts (source table)Fields:Contact NameFirst NameLast NameEmail (Primary Email)Partner EmailReferral EmailConnection EmailTable: Master Email List (destination table)Fields:EmailContact NameEmail Type (Primary, Partner, Referral, Connection)Automation Steps (Attempted):1️⃣ Trigger: "When a Record Matches Conditions"If any of the email fields (Primary, Partner, Referral, or Connection) is not empty, trigger the automation.2️⃣ Find Records Action:Find all records in Contacts where

307
Mike_AutomaticN
Country_Pigeon
Country_PigeonParticipating Frequently
asked in Automations
Date and task dependencies

Hi All,I'm migrating from Smartsheet to Airtable for Project Management and one thing that I am struggling with, that we rely heavily on for project management, is date / task dependencies. Setting this up in Smartsheet is easy and intuitive, requiring no formulas.Desired workflow:I want to set the Start Date, the Duration and task Dependency so that, if the Duration or Date(s) of a task change, the downstream tasks, as denoted in the Dependency field, will auto-magically update. I have reviewed this video several times and it makes sense and seems easy, but when I configure my fields following the instructions in the video, it does not work as expected.Set up:Table has a Duration, Start Date, End Date and Dependency fields.Dependencies are enabled and set up like the following:The table looks like the following:Expectation:In the Table image above, I would expect that, since the 'Get PB' task is dependent on the 'Get Bread' task, Start Date for 'Get PB' will begin  on 12/28/

1632
Country_Pigeon
J
jmevans90New Participant
posted in Automations
Help creating automation for a dog trainer

Hello. I am a dog trainer with multiple board and train dogs that stay with me for various programs I offer. I teach the dogs in phases, and would like to keep track of where each dog is in their progress. Can I have an automation where if a record is marked as "done", the notes field is updated with new text with the next steps? The dogs are always in different places in training, and my brain feels so torn trying to mentally keep up with who has mastered what skill. I just want a way to visually see things as well as help hold me accountable to follow steps without skipping any, as the dogs start to blur together and sometimes I go too fast/slow (I'm on limited time, the dogs need to be ready in 2, 3, or 4 weeks depending on program!) 

145
TheTimeSavingCo
J
jkdNew Participant
posted in Automations
Creating a script for a Picklist from assembly numbers and a material list

Hello, First time post so apologies in advance...I have a Deliveries table, The idea is when I select a "ship package" [eg.Floor: Sheathing] it pulls up the Assemble numbers with a lookup field - that correlate to a material list on another table. I then have a script which converts that lookup field into a multiple select field. This all functions correctly.Now my issue is that i want to select a series of boxes ["Ship" "Ready" Delivered"]. The idea being that i have a script [i have zero programing knowledge and have ai write my scripts], That when "ship" is checked the script hunts through the "Materials Table" using data from  the "# Reformat" field and with each record that is found in "Assembly #" to match one of the many possible numbers it checks the "Picklist" box. My script below says it works but it does not check the any boxes.    let deliveryTable = base.getTable("Delivery"); let materialsTable = base.getTable("Materials"); // Fetch all records fr

62
TheTimeSavingCo
A
alfa12New Participant
posted in Automations
let recordId = input.config().recordId...

Hello again - I'm having trouble getting an Interface button to call a recordId when it is pressed. I created an interface view of a Record List for an Attendance table and even though the button is in the Record Detail view (Pic #1), I can't get it to send a RecordID to the automation. I've rebuilt the interface multiple times and the automation.But, when I run the automation within the table and click the button in the column, it works. But not entirely: I created a webhook>docupilot>gmail workflow to make a PDF and send an email. I have the Immediately as data arrives switch ON in Make, but, it doesn't do that. I have to click Run once - Wait for new data, then, go in Table view and hit the button and then it works. Automation json attached too.My whole goal is to have it so I can at least just click the button of all the rows on by one in Table view (Pic #2) and the automation through Make processes the pdfs (I'm making pdf certificates for rows that

482
TheTimeSavingCo
V
Viky88New Participant
posted in Automations
Cell value as Email subject

Hi there!I have made a regular airtable automation to send an e-mail when certain conditions are met. I was wondering, is there a way to have a value (not a list of values) of a certain cell in a certain row as an e-mail subject?To put it more directly, when status of an order (field order status) is "finished", an e-mail is sent where the name of the client (field client) from the same record is a part of the e-mail subject.Any help is very much appreciated!

3110
ScottWorld
J
jwagInspiring
posted in Automations
Create record in table B and link to multiple imported records in table A on import

Hi guys,We'd like to be able to import a list of around 30 items (BoM) at a time to a Cost Estimates table, create a single record in a Cost Centres table and link all the items in the BoM import to this Cost Centres record. The name of the Cost Centre record won't be known on import, so can't be specified in the importing csv. Each import should create a new Cost Centres record.I have tried playing around with automations but hit the issue of automations running in parallel and creating several Cost Centre records before the BoM records find them and start linking to them.I'm sure this can be done with a script but I'm hoping there's a way I can avoid that. If not, I'm happy to pursue that avenue and am open to some advice on how best to implement that.Thanks in advance for any suggestions!Josh

1710
J
R
rrusminNew Participant
posted in Automations
Update field in one secondary table with info from another secondary table

Hello helpful community,I have a primary table of People with PersonID as the key. I have 2 secondary tables, Notes and Assignments, where PersonID is a linked field. A user reads the Note, creates an Assignment, then marks the Note complete. I'm trying to create an automation where:Once a Note is marked complete,Find the Assignment with the corresponding Person, and Copy the content from a field in Notes to a field in Assignments.All goes well, I think, until the 3rd step. Here is Step 2, it yields the results I expect.Here is Step 3 where I get the "Invalid input" error message. How do I select the RecordID of the row we're iterating through in the Assignments table? I'm not sure what to select here:Added complication: Some people have 2 Assignments, and I'd like to copy the Notes field to both Assignments. Any help or guidance would be appreciated, thanks!

41
Mike_AutomaticN
K
katetowseyNew Participant
posted in Automations
Horrors. My beautiful Gmail automation HTML signatures have broken

Hello.Until today, I managed to insert a tidy parcel of HTML into my Gmail automation templates resulting in beautifully branded emails. But that hack has suddenly broken across two bases. Does anyone have any idea why and how to fix it? Thanks.Kate

256
K
O
OMSNew Participant
posted in Automations
Automating Data Population to Various Tables

Apologies if I don't use any of the correct terminology when explaining this problem. I have a form set up and I want the information in each field in that table (Table A) to populate fields in other tables. I have managed to make some of this work using a trigger that watches for new records being created in Table A and creating a new record in Table B with linked fields that end up creating records in Tables C through E. I was able to set up an automation in using a trigger that watches for new records being created in Table C which happens automatically because of the linked records in Table B that then finds records in Table D and updates records with empty fields with information from a field in Table C. That's as far as I got but I am two automations short from having all of this work as intended. I created another similar automation to populate an email address field in Table C with information from Table A using the same record creation trigger from the first automation I made

151
Mike_AutomaticN
K
k0k0netijiNew Participant
posted in Automations
Need Help with an Automation (Please)

Hi Everyone!I would just like some help or insight on the problem I'm having with an automation I'm currently trying to make.The automation is supposed to send an email to the user after creating 10 new individuals (like networks) on a table. I'm stuck on how to do it and I cannot fully grasp the resources on airtable help-center so i'm here to ask for additional help or advice 🙂any thing that can help me understand better  would be much appreciated!Thankyou!

132
Sachin_191
T
tsallisInspiring
asked in Automations
I am trying to set an automation but it's not working

Hi 🙂I am trying to set an automation that will update a specific field based on the information that is on another table. The field I want to update is called Relatorio as shown bellow.I want to bring a field from another table that has the same number as the fiel (Item LV) from this table.Here is the picture from the table I want to retrieve the content from.I want to compare the ITEM LV from the first table and compare it to the ITEM from the last table and update the field RELATORIO from the first table with the content found on RESSALVA from the second. So every time ITEM = ITEM LV it should the update.The first table should be completed with aaaa on the first line, ddddd on the second and eeee on the third line.I setup the automation like this but it finds no records.Tks for the help

155
T
L
LimiKnown Participant
asked in Automations
Automations with attachments

I have an automation that once an attachment field is not empty, it creates a new record in a different base with that attachment and a few other fields.Is there a way, that if the attachment field has more than 1 file, it will create a new record for each one of those files?

315
ScottWorld
T
ThomasoNew Participant
posted in Automations
Creating tables through the API / webhooks / scripts

So I just purchased Airtable for our business use case. I am devastated to understand there is no support for creating new tables automatically. The only way to do this is to have a custom app script, however this would need to be triggered manually and will not run in the background… Why does the automation scripting not contain the required functionality that the blocks SDK does? Why is this feature limited to only reading table metadata, if blocks SDK can do it - why can’t the automation scripts? This is so disappointing… I CANNOT BELIEVE the standard API does not have a create table endpoint, where you can define the fields automatically. How are we supposed to develop an automated solution if we constantly have to manually press buttons to create new tables… And upon searching the community pages - there is not one response from the airtables team that shows they will work on this feature or when. What a waste of money upgrading to the pro plan to see inside the automation script

1086
D
JimmyD
JimmyDNew Participant
asked in Automations
Slack integration shortcoming

It would be incredibly useful if the Slack integration could send a message to a person pulled from a field in a table.As it stands, when using the Slack integration in an automation you have to choose (hardcode) the person(s) or channel(s) you want to send the message to.Use case: I have a table that syncs issues from a ticketing system. Each record has an "assignee" field. When a new record enters a view I want a Slack message sent to the person in the assignee field.

262
JimmyD
O
oakleyNew Participant
asked in Automations
Auto filling a linked record from a date field

I have a table with a date field, an I want to link these dates to another table, but group them by month. This is so I can create rollups for monthly financial figures. I have tried to create an automation to auto fill in another field, using the date as its source and then converting the format to mmmm yyyy, from the usual dd/mm/yy. I then linked this field to the other table, but now the automation does not update it even if it runs successfully.Can anyone help solve this issue?

245
O
jfevurly
jfevurlyParticipating Frequently
posted in Automations
Public Outlook Calendar Event Creation via Automation

Hello! I am attempting to assign employees to presentation times and have the automation create the event and invite them to it via Outlook. I've established everything necessary but cannot assign the public calendar in the Outlook: Create Event automation. I also cannot adjust the "From" email. I need to do so because we want the invites to come from a shell email address and not from an individual, and utilizing the Public Folder Calendar in outlook instead of a personal outlook calendar that is shared so that we don't have any interruptions if the owner leaves the company. Can anyone advise a workaround or if this is a feature that Airtable is working on?Thanks!

207
E
J
jzellerNew Participant
posted in Automations
Look Up

I want to create look up field for only apartment details in a row that I have in a table called lease tracker in a base The row has 50 columns and lets say I just want 20 columns data to atomically go to the other tables in my base when updated to the specific unit number of a rental building. My current tables in my base are called, listings, building, apartment rented, calendly interaction,  and lease tracker.I want the tables to look up the data in my lease tracker table and put only the apartment details in the other bases.  I have multiple buildings and multiple apartment number listed in two different columns of the table with the other columns so not sure how to look only the specific unit number of a specific building. I already have look up on these other tables to look up the building table and put it on the other tables automatically What is the best option to do this so I can share the individual apartment details with a building with the other tables. 

73
ibayub
T
thelusInspiring
posted in Automations
Automation to update form configuration?

I know this is impossible as far as basic automation behavior, so I'm mostly looking for ideas on what I could do.I have a form for requesting time slots. Because of the way my department works, only a certain time frame should be open at any given time for these requests, and it's in six month chunks. I'm using the range limit on my Event Start/End fields to do this, and it works as expected.At this present moment, let's say we're only able to select a time slot from January - June. But in June, I'd need to change the range limit for both fields on the form to reflect that selections can be made from July - December. While I could do this manually, I won't be an admin on this once it's live, so I'd like to make the range limit change automatic if possible.Any chance I can alter form configuration on an automatic schedule? Code-heavy solutions are very welcome.

155
ScottWorld
W
Warehouse12New Participant
posted in Automations
Data Auto Populates with Previous value

Hello! Ive been looking all over youtube and the forums to find something that matches the automation I have in mind but to no avail unfortunately. Im attempting to create an inventory list that pulls from an item master list.Currently every detail of items being stored on shelves is being manually typed out, I would like to improve the process but typing in the details once into the item master and whenever a part is being put away the PN is typed in, the remaining data would be pulled from a separate table and auto populate in their respective fields. With the possibility in the future integrating into an RFID system

104
TheTimeSavingCo
I
itiNew Participant
posted in Automations
notifications about a new task

Hi all,I'm new to airtable and I'm trying to take first steps using automations.I'm setting up notifications about a new tasks: an email is sent every time a task with to-do status is assigned to a user. The emails are sent fine, this part works like a charm. But here is the difficult part: I'd like to include in the email the link for the new task and I cannot find the variable I can use in the email text. Like "if task x is assigned to a user send an email to the users email address with the link to x in the email text".I've checked the resources here and couldn't find anything.Can anyone help me with this link/variable?Thank you in advace!

213
I
A
ademicheleNew Participant
posted in Automations
Matching Previous Selections

Hello, I am looking to get help automatically updating records. I have an airtable setup that pulls in companies that visit our website from a lead tracking system. I manually select an option to tag the company as "Sales Target, Client, Employee". There are instances where the same company/person will come to the website and show up as a new line item in my airtable.Is there an automation that I can setup that will automatically update the record to match the previous line where I tagged them? Said differently, If I manually tag Apple as a "sales target" in row 7, I'd like to have airtag automatically mark them as a "sales target" when they show up again in row 101.Thank you

63
S
A
alfa12New Participant
posted in Automations
Update record automation issue

I'm having trouble getting past the Update record in an automation:I was able to:- get the trigger to catch a new email in a table (pic #1)- filter out the matching email and corresponding row (pic #2)In the Update action, I used the Airtable record ID from the first step (pic #3). The field of interest I want to import from the donor table, for example, is What year and school did you graduate from (pic #4) but it doesn't work (pic #5) and I also dont see where in the receiving table I can choose where the donor information I want to collect to insert. Thanks so much!

62
TheTimeSavingCo
H
Hugo02New Participant
posted in Automations
Received invalid inputs - Repeating Group for an update Records

I'm trying to set up an Airtable automation that's not working as expected.Here are the details:Current Setup1. Trigger: When a record matches conditions- Quote_Date_String is not empty- Axonaut_Status is "accepted"2. Action: Find records- Where Quote_ID matches Quote_ID from trigger3. Action: Update record (in a "Repeat for each" loop)- Table: Landing_Table- Update Quote_Date_String fieldError:Getting "Received invalid inputs" when testing the automation, even though the test step shows valid data in the trigger record.Screenshots of the automation and test results are attached.Any help identifying why the update action is failing would be greatly appreciated.Regards,Hugo

242
TheTimeSavingCo

Badge winners

Show all badges
Terms & Conditions