Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,188 Topics
  • 16,145 Replies
5188 Topics
A
Amy_CusackNew Participant
posted in Automations
Can I maximize an automation to get around the 25 automation limit per base?

One of the bases we have created is to gather feedback from course participants. I have a form designed but the issue is that participants can submit feedback for one of a list of many facilitators. The hope was to be able to create an automation per facilitator so that their feedback can populate a Google Sheet row and then email them to let them know that they have received new feedback. We will definitely have in excess of the 25 automation limit though. The automation I created is intended to search for the specific facilitators name when the form is submitted and then populates their individual Google Sheet. Is there any way that I can create an automation that where I could combine and add in multiple facilitators? Would it work if I just added additional steps for Find Records with one each for each facilitator? As is stands, with the way I have built the automation, when the feedback form is submitted it doesn’t only populate that persons Google Sheet but actually puts the data

62
kuovonne
A
Amaury_HALLENew Participant
asked in Automations
Trigger Built-in Airtable automation with a button?

Hi community! Is it possible to trigger a built-in Airtable automation (example: Create a custom automation) when a button is clicked? Thanks!

154
A
1
11195New Participant
posted in Automations
Unique event calendar for each worker

Hi! There is event witn N amount of workers. I need to create a individual event calendar (or smth like that) for each worker form 1 grid or excel table. Is it possible? Note: all calendars need to be created automatically as there are 100+ workers

21
P
V
Valdemar_TKnown Participant
posted in Automations
Confirmation on automation execution

Is there a way to get some sort of confirmation when automation is executed without going to automation section and checking history? E.g. I have set automation that on trigger it fires email. I want table to show a checkbox confirm, when email is sent.

93
Alexey_Gusev
P
Prod_CeloNew Participant
posted in Automations
Automation - import a file to another table

Hi all, I’m working on an automation : 2 tables : A and B Trigger : when an option is selected in a single select field in table A Running action : create a new record in Table B with all information of the record in table A => it works perfectly for all fields type except for one : attachement I’ve got pictures in an attachement field in table A, and I’d like this pictures to appear in an attachement field of the created record in table B but when I choose the attachement field in table B, i’m being asked to “choose a property” : I tried it all but I’m not getting my picture in table B. I’m I missing something ? Léo

114
P
S
Sarah_RoachNew Participant
posted in Automations
Creating 1 record in a new table and linking matching records

Hi, I have a base that in table 1 has records created with Zapier. The records are applicants that have compete 1 or 3 onboarding forms Application Handbook Exam W4/I9 The primary field is the subject from the email that was forwarded to zapier For Example: “Fw: Application/John Smith” I have a formated column to extract the name “John Smith” This is what I want the primary field to be in Table 2 Complicated problem part When the first “John Smith” record is created in Table 1 I want it to be created in table 2 Normally this would be the record that has the application attached I do not want multiple “John Smith” records made in Table 2 When a 2nd record is created for “John Smith” I want it to be linked to the “John Smith” in Table 2 This part Ive mostly figured out with a linked field and automation Basically Table 1 is the raw table from Zapier and Table 2 needs to be the pretty formated table. The other problem my formated name cell isnt displaying the applicant’s name in the

101
Kamille_Parks11
J
Josh_CykParticipating Frequently
posted in Automations
Find or create record in Airtable Automations

There doesn’t appear to be an action step in Airtable Automations that allows for finding records by a search criteria and creating the record if it doesn’t exist. This can be done with Zapier, but I would love to be able to accomplish automations requiring this to be done with Airtable Automations. Is there a workaround that would allow for this? Perhaps using a script?

45
kuovonne
C
Chen_ProKnown Participant
posted in Automations
Auto fill a column with data from the same row

Hi there, I’m very new to js, Is there a way to fill a column with data from a row with a script linked to a button? Thanks!

41
Kamille_Parks11
S
SunLynxKnown Participant
posted in Automations
Last Changed Date not populated in email

This seems to easy to not have been answered somewhere; I must be asking the wrong questions. If I send an automated email which includes a column for “Last Modified Date” my column is empty, even when there is a date on the actual table. What do I need to do to fix that? Assuming that’s just one of the quirks of Airtable, will a formula field repeating the data solve the problem? Thanks everyone.

86
Justin_Barrett
P
Philip_Eoute1New Participant
posted in Automations
Hidden character issue using Airtable with Zapier

I have an integer from Airtable going to Zapier to use as a filename for a PDF, but the file that comes back to Airtable is named “20201140719%EF%BB%BF.pdf” instead of “20201140719.pdf” It’s some kind of UTF-8 Byte Order Mark or something. I thought it might be a hidden character in the text field in Airtable, so I converted to an integer, but that didn’t fix it.

71
Justin_Barrett
S
Sarah_MerionNew Participant
posted in Automations
Help with automating new date every month after task is done

I am having trouble getting this automation to work. It’s almost there! I have a monthly task list, and after I complete the task for the month, I want it to re-appear with the new due date. Example: “Give dog her medicine on 10/1/2021”. Frequency = 30 days. Once task is complete, add new task for “Give dog her medicine on 11/1/2021”. I have everything working except the date. Can anyone help? I’ve recorded what I’m doing so you can see. It says “Could not convert string to date.” but I cannot get it to work. Thank you!

82
S
G
Giulio_BambiniNew Participant
posted in Automations
Emoticons not showing up in airtable email automation

I have some formula column fields with the following syntax: column_1: checkbox type column_2: formula type with IF statement Everything is working as expect and I see as table results the desired emoticon if is checked or unchecked. The problem occurs when I add those records as grid in the Airtable email automations. I get empty grid values in the email where these formula column fields with the emoticons result don’t show anything. Can anyone help me out to understand why and how to fix this weird behaviour?

171
Justin_Barrett
D
Devon_StantonParticipating Frequently
posted in Automations
Email Automation - Preformatted Lists

Hi So I’d like to create an automation that sends me a list of items off of my airtable but in a pre-formatted way. Currently, I can send an automated email but I have only two options which is list or grid. This is ok for displaying items but it’s not ideal. For context I’m recording coverage from media websites. I can collect this in a grid format but I want to display it in a much more intuitive way. i.e. the end result should be something like News Headline (News Source - xxx UVM’s) - Article Summary Is this something I can do directly in airtable or via a script?

30
D
J
Jonathan_CarpenInspiring
asked in Automations
Automation Frustration

Hello Everyone, I have tried watching some videos to no avail… I have a CRM base with many tables. One is [Leads] which I populate with as many different fields as possible to qualify the company. Since I take the time to populate many fields, I then dig into the company and decide if I want to pass them along to sales but I do not want to loose the history of companies I have researched. So I have a pass/fail check box field that is filtered so only the pass appear in that view. I have this table linked with [Sales] so they can enter into the linked field and simply “pull in” leads from the [Leads] table from the + POP Up window. What I would like to have happen is when the sales team brings that record into the [Sales] table it “disappears” from the [Leads] table so it is no longer available. I would prefer an updated field action in the leads record so it can be filtered out of view! I have run a successful TRIGGER in the [Sales] table view by using (when record enters view) or (whe

133
J
Ricardo11
Ricardo11Inspiring
posted in Automations
How to automate relations via a shared column value

Hello community, I’m currently migrating from Google Sheets and Glide to Airtable. Glide’s dynamic filters / automatic relations are missed and I’m struggling to recreate those in Airtable. :-/ Each row in my table represents an item ordered from a vendor, items may be part of an order of multiple items from multiple vendors. How can I automatically relate items within one order that are supplied by the same vendor. The purpose is to create a roll up per vendor, for example to send a single automated email to the vendor per order instead of each single item. In Glide I would simply have a formula field combining the OrderID and VendorID, which creates an automatic relation. How can I achieve similar functionality in Airtable? (I’m wondering if this can be down within Airtable or needs to outsourced to Integromat, Zapier…)

165
Ricardo11
C
Currently_JasonInspiring
posted in Automations
Automation Step Filter

Hi, I have what I suspect is a common issue relating to sending Weekly digest emails using AT Automation. I have an automation that sends a weekly email with a list of this weeks sales.Unfortunately, sometimes the sales are 0 for that week but the email (final step) still sends. What is the best way to get around this? I have a few ideas but I’m sure there are probably better ways. Thanks Jason

42
A
I
Isabella_FantinNew Participant
posted in Automations
Look up a record in another table & link together

Hi all, Is there an automation set up that can compare two tables? I have a list of records in one table (Main List) and a list of records in another table (Startup List) and would like to check if a record in the Startup List alreadt has an entry in the Main List; and if yes, then link the Main List record to the record in the Startup List. I have tried a few automations, but it keeps creating a new entry in the Main list instead of “finding” the entry in the Main List. (added bonus if I could then update the entry in the Main List with data from the Startup List IF there is an entry already.) Thank you !

773
I
D
darren_zouNew Participant
posted in Automations
How to get date of form submitted in automation?

I looked into the options and none of them is the date that the form is submitted. What can I do?

272
D
S
Sam_BeckerParticipating Frequently
asked in Automations
Scripting App Vs. "Run a Script" Automation

Hello All, I have the following script that I use to create links between tables based on the “ID,” which is consistent between the two tables. Typically, I run this script manually every few days or so, but I have recently discovered the “Run a Script” automation, which would completely eliminate the need for manually clicking the “Run Script” button. However, the following script throws an error every time I test the automation (which is when a new record in the “Enrollment” table is created, the script is supposed to run). I’ve gathered that this is an issue with certain functions not being recognized in the automation, however I do not know how to fix this. Any help would be greatly appreciated! //Define the Facilities table and query var facTbl = base.getTable(“Facilities”); var facQuery = await facTbl.selectRecordsAsync(); //Define Enrollment table and query var conTbl = base.getTable(“Enrollment”); var conQuery = await conTbl.selectRecordsAsync(); // Create an updates array let

212
S
C
Colleen_BradyParticipating Frequently
posted in Automations
How do you cancel or undo edits you've made to an automation?

When working with automations, how does one cancel edits? What if I don’t want to update an automation because I made a mistake? And when the pop-up asking about changes appears, is there a way to cancel and not apply updates? Thank you!

732
D
D
deepak_kaleNew Participant
posted in Automations
How to execute script when new base is created

I have requirement when I want to execute the script as soon as a new base is created. I want to create automation & add somefields in every existing & new tables created across existing/new bases. Thanks, Deepak.

72
D
E
Eddy_MaayaInspiring
asked in Automations
Monthly Recurring Tasks

Hi All, Im not sure if this has been asked before. I tried searching for it but could not find a solution. So here it goes. Im trying to do a simple recurring monthly subscription record. For Example: John is billed every 13th of the month. On his record there is a checkbox, bill date and next bill date. The next billdate is a formula that adds 30 days from the bill date. I have created a view called Monthly. When John makes a payment, the check box will be checked and it will appear on the monthly view. I wanted to uncheck this boc 7 days before the next bill date and how do I update the next bill date so it would add 30 days everytime? Any suggestions?

533
E
M
Marc_Justin_RaiKnown Participant
posted in Automations
Problem on my Script Suddenly

I suddenly get an error while executing my script. “There was an unexpected error while executing your script”. It doesn’t say which one causes it. I only change my table name and change immediately the value on the gsctable variable. let gsctable = base.getTable("CBD B2B DE 5"); let query = await gsctable.selectRecordsAsync(); let today = new Date(); let year = new Intl.DateTimeFormat('en', { year: 'numeric' }).format(today); let month = new Intl.DateTimeFormat('en', { month: '2-digit' }).format(today); let day = new Intl.DateTimeFormat('en', { day: '2-digit' }).format(today); let todate = `${year}-${month}-${day}`; let lw = new Date(today.getFullYear(), today.getMonth(),today.getDate()-7); let ly = new Intl.DateTimeFormat('en', { year: 'numeric' }).format(lw); let lm = new Intl.DateTimeFormat('en', { month: '2-digit' }).format(lw); let ld = new Intl.DateTimeFormat('en', { day: '2-digit' }).format(lw); let lastweek = `${ly}-${lm}-${ld}`; for(let dates of query.records){ let toda

195
kuovonne
S
Sarah_FlemingNew Participant
posted in Automations
Automation change a single select field when 14 days have passed since a date field

Hi there, I have a field that shows the date a proposal is sent to a potential client, and I have another field that shows what action needs to be taken as a single select. The idea is that the actionable will show “in progress” in green after the proposal is sent, but once two weeks go by past the date the proposal is sent, I want it to change to “call client”, essentially triggering a follow up action if we haven’t got a signed contract yet. Is there a way to do this? I set up a trigger: when record matches conditions (14 days past date and actionable is in progress) And then when I try to set up the action to update record I can’t seem to select the trigger - it wants me to pick a specific record. But I want this to happen for any record that is past due Any ideas? Is this a custom script thing? for now I am using the free version. I have an automation set up to send weekly emails of records that need a follow up so aside from it changing the drop down I don’t need anything else

154
D
A
Almas_SayyedNew Participant
posted in Automations
In automation feature of sending mail how can we design the next step if confirmation is required form mail

Hi All, Am creating automation wherein the user does the following steps 1)fills the form 2)trigger should be created to send mail 3)Once the mail is approved a confirmation required from the mail Yes/No :heavy_check_mark: or :x: 4)based on the above action the next trigger for the creation of a record should trigger. Also for the following mail has been Approved or replied to by :heavy_check_mark: (Approval status field) then the record is entered in the database. Clueless as to how to proceed further. Thanks in advance Almas

00
A

Badge winners

Show all badges
Terms & Conditions