Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,188 Topics
  • 16,145 Replies
5188 Topics
V
Vineet11Inspiring
posted in Automations
Uploading Images in an Airtable from desktop application

I want to be able to built a utility (that can work on Windows as well as MAC system), that we can use to upload multiple images in a table. The structure of the table is simple: ---------------------------- | Image Name | Thumbnail | -------------|-------------| | Image01 | Image01.jpg | | Image02 | Image02.jpg | | Image03 | Image03.jpg | ---------------------------- The “Image Name” is simple “Single line of text” field and “Thumbnail” is an “Attachment” field. I searched all over the internet, but couldn’t find a way to do that. Services like integromat can be used to insert images from cloud, but I want to be able to upload images kept on local computer. Any help would be appreciated to get me started. I am fairly experienced in VBA automation or Python, but not in using API. So that will be a learning curve, but I am willing to learn.

244
V
L
Ludovic_MoulardNew Participant
posted in Automations
Pro trial plan - unable to send email through an automation

Hi, I work for a company that specializes in data consulting. I love Airtable and believe it could solve many issues for our business and our clients’, therefore I built a proof of concept to automate dynamic email reminders for my colleagues to showcase the value of the solution. I’m using the temporary Pro plan (trial) on my workspace to set up the related automation. Sadly it seems the email feature is still locked even if I’m using this Pro plan since I got the following message: “Cannot email non-collaborators on the current billing plan.” Could you help me here? I’d really like to show how efficient the platform is but I’m stuck because of this… Best,

158
J
A
Aditya_NaveenNew Participant
asked in Automations
Automation error: "Message" could not be converted to a string

I’m trying to create a simple automation where a slack message is sent when updates are made to a specific record and I get the error “Message could not be converted to a string”. I’m not sure what I’m doing wrong here but I went over the trigger and the message itself but nothing seems to help my cause. For some added context: There is an automation setup already (which works without any issues) that sends a slack message when the record is no longer empty. I am attempting to set an automation that sends a different message when the same record is updated with new values. These fields are synced from an external table within the same workspace. Not sure if this is too many complications or if there is a way to work around it!

182
A
T
Thomas_MackayNew Participant
posted in Automations
Setting an Automation to only trigger during working hours

Hi Everyone, I’m currently trying to set up an automation that only triggers during working hours, and ‘banks’ any non-triggered actions until the next working day. I.e. it only trigger between 9am and 5pm, and anything that would normally trigger it at 6pm is held until 9am the next working day. I think I have a working solution, but would be interested to hear if anyone can think of anything better/simpler? The context is a quality assurance process where an assessor completes an Airtable form, and when the form is submitted the assessee automatically receives an email with the results. Currently I have an email automation set up to just trigger when a new record is created (from the form). My idea for how to limit the automation to working hours is: Create a new formula field (called “hour”) that returns HOUR(NOW()) Create a new text field called “results sent?” Create a view called “automation” that is filtered to only include records where the Hour is between 9 and 16, AND record

261
Justin_Barrett
E
Evan_RothrockNew Participant
posted in Automations
Trigger based on date

Hello, I have an automation that uses a date field as the trigger. When I test it, it runs successfully, but the record it finds is incorrect. Today is 10/7. The Trigger is set to “When [Date Field] [is] [yesterday]”, the test runs successfully, but the record it find has a date field dispositioned as 10/5, not 10/6. Is this because of the time of day it is currently for me? Is there a server time that triggers are based on? Can I change my timezone somewhere so this is resolved? Thanks!

1072
Justin_Barrett
R
Ryan_SilvermanNew Participant
posted in Automations
Cross Populating Bases

I’m an Estate Manager and I have many properties owned by different people. I have them all as separate bases so owners can look and have them all in one workspace. I have todo lists in each one which is great but would like them all to populate in a separate base so I can see and supervise instead of having to go into each base. Ideally to make a shopping list too. Can you help me? Thank you

21
Justin_Barrett
I
Isaac_NewtonNew Participant
posted in Automations
Automate Daily Motivational Quotes

Hi, I have a motivational quote table with 1000 records (3 columns). I want to create a daily quotes api where it only displays one record daily. Is there a way to achieve this so I can access each record daily? Thanks

151
Justin_Barrett
S
Solaiyappan_ShaNew Participant
posted in Automations
Create record with Backfill Possiblity

Hello All, I am pretty new to Airtable and trying to build a no-code app for my personal use, Its a peer to peer lending app where I give loans to users and I need to be reminded about all upcoming payments with dates on a recurring basis I have 3 tables in my base Contacts Loans Transactions In Loans, I have the data of which contact got how much loan, what’s the interest, borrowed date like below What I want is to create an automation that will generate a new record in the transaction table for all the pending dates Example Name - John Loan Amount - 100,000 Interest - 1.5% Payment type - Monthly Amount - 1500 Borrowed date - 01.01.2021 Loan status - active In transaction table I want the records to be generated as Name Payment date Payment Amount John 01.02.2021 1500 John 01.03.2021 1500 John 01.04.2021 1500 John 01.05.2021 1500 John 01.06.2021 1500 John 01.07.2021 1500

21
kuovonne
D
Dhaval_GorasiaParticipating Frequently
posted in Automations
Triggering Automation

Hi, I have an inventory list of a few items. I have mentioned the total number of units of each item in the Product Inventory table which is my main table to track the remaining inventory (refer to Image 1). Now, sales orders are updated by my warehouse executive, and the inventory gets deducted in the Product Inventory table as all the tables are linked. I want to trigger E-mail automation based on the condition that when the remaining units turn 0, Airtable will send me an e-mail notification that says “Please update the stock”. I’m trying to create automation using these conditions (refer to Image 2) but I’m getting error “Test fail”, “There is no such record”. Can anyone help how to resolve this.

01
J
Alexey_Gusev
Alexey_GusevBrainy
asked in Automations
(maybe bug) "When record matches condition" trigger works wrong

Hi, (TL;DR "it triggered on all new records, no matter if conditions are met, when they include formula field) I have following issue: table1 (near 1500 records) has button field “Confirm match”. when a key pressed, the record partly copied to table2 (by my script, ~500 records), linked to it’s “parent” in table1 table2 contains formula field “Control”, relying on some data including lookup from linked record in table1, result is “OK” or “_error” “_error” records supposed to be removed, from time to time. I can’t filter at this step, because sometimes “OK” record in table2 may become “_error” after table1 update. it’s usual process, and it worked as expected. Now I decided to automate cleanup for table2 and setup new automation “When record matches condition”, second step is Remove record, where Control contains “error” (by way, I was surprised that Remove action is not available, i did that by scripting) The problem is that trigger works on records, which supposed to be “OK”, while my

112
Alexey_Gusev
E
EM_CHNew Participant
posted in Automations
Automated email does not pick up last updated data

Hi there, Can someone help me please ? I set up an automated email to send a grid view every week in a list view. The email is well sent and received the first time, but afterwards it does not pick up the updates that I make in my grid. So if I bring a change to my grid, it is not reflected in the email that is sent out ! it has last week data… Would someone be able to help please ? Emmanuel

64
E
E
EinkaufNew Participant
posted in Automations
Automated Reveals

Hey, I am trying to import an excel questionare into airtable. Since the questionare is pretty long, i wanted to shrink it a bit. I was wondering if it’s possible to hide certain parts of the questionare until the condition in the previous field is set to a specific status. For example: a question in the questionare is answered with no and as a result, more of the questionare is revealed with more fields to fill in. Is that possible and if so, how?

21
kuovonne
A
Albert11New Participant
posted in Automations
Automations are acting on their own

Hello everyone, We have a pretty urgent/critical issue affecting our day-to-day operations, and I was wondering if any of you faced a similar issue before. We have a few automations that are copying some fields from one table to another. In our specific case - it’s attachments. Since today, we have started seeing very odd issues - when the file gets copied from one table to another (Via an automation), another Automation that has no name (see screenshot attached) delets the file attached. A few facts This is happening with attachment columns that are used in different automations (so it’s not specific automation related) I created new automation from scratch - same behavior I created new column fields (as if thinking maybe some other automation was added as a trigger for that field) - same behavior Manually adding files into the column (not via automation) is working fine. Other automations that copy text (not attachments) - working fine Before today - everything was working fine The

93
Justin_Barrett
G
GN_FMPNew Participant
posted in Automations
'Date added' field not triggering time based automation

Hello. I’ve built an automation that is supposed to automatically send an email to people in a base (called ‘Tester panel’) once they’ve been in it for 365 days or more. The date they were added to the base is recorded in the ‘Date added’ field, which is automatically filled in by Airtable: To set the automation, I picked the ‘When record matches conditions’ trigger, and build it around the ‘Date added’ field in my base: I tested the automation with mock up records and it works fine. The problem is that when I actually switch it on, it doesn’t send the emails to the database. After a few experiments, I realised that it gets triggered when a new record is added to the base and matches the criteria, but it doesn’t get triggered by the existing records in the base that match the criteria. It seems like either the automation doesn’t work retroactively, or that there’s a problem with the old data in the Date Added field, but I’m not sure what that can be? I know I could create a view and

02
G
Y
Yash_Verma1New Participant
posted in Automations
If-Else logic for CRM automation

Hello everyone, I am building a CRM with 2 tables: customer table (name, email, total purchase) and order table (order id, customer name, customer email, purchase value) I want to implement an automation which triggers when new record on order table comes in and does action on customer table: If (customer exists in customer table): find that customer on customer ledger via email and update their total purchase as per the current order by adding to their total purchase If (customer does not exist in customer table): create new customer record saving customer name, email and their current order’s purchase value as total purchase. I tried building this in Airtable automation but it doesn’t allow if-else conditional in formulas How can I build this functionality? Please advise.

143
kuovonne
C
Clement_GuibaudNew Participant
posted in Automations
Received invalid inputs

Hello, I would like to populate automatically my airtable calendar/grid. But I’m testing it’s failing because the inputs is invalid but I don’t know why. There are no explanations. Does anyone already faced this problem ? Thanks by advance.

22
Benito_Abraham
A
Alex_RedfernNew Participant
posted in Automations
How to format emails in the SendGrid block without html

I’ve just set up the Sendgrid integration so we can quickly bulk email our team of tutors. I can see there is an HTML option, but I don’t want to spend time writing the whole email in HTML as it’s time consuming and my coding skills are basic. I tried adding links in the email using markdown but it does not appear to work. Is it really the case that you cannot add links in these emails without styling the emails entirely in html? If so, this prevents the integration from being useful for saving time. One workaround I thought of is creating the links as fields, then inserting the fields in the email, but this would be somewhat of a pain.

30
A
E
Emma11New Participant
asked in Automations
Automation Candidate X Job

Hello! I’m trying to create an automation on Zapier or Airtable: Table 1 View 1 : All my Candidate Onboarded Table 2 View 3 : Job description Published I’d like to create an automation when a job description is published (table 2), send an email to the candidate who matches with “Expertise 1” or “Expertise 2” or “Expertise 3” of the Job description (table 2) is the same as “Expertise 1”(main expertise) or “Expertise 2” or “Expertise 3” of the candidate (table 1). Thanks

230
Dimitris_Goudis
C
Colin_RathbunKnown Participant
posted in Automations
Calculated update

Hello. If one of my automated actions is to update a number field, can I make it Calculate the update? IE (Current Field Value) minus (some other value) and put that newly calculated value in the field?

52
U
B
Bill_GrinsteadKnown Participant
posted in Automations
Automation not working correctly with formula field

I have a formula that returns a url like the one below. I’m trying to send the URL to a Slack channel when a condition is met, however, Airtable doesnt give me the option to choose the URL string, it only gives me the option to insert the LENGTH. How can I simply get it to send the string? IF( SEARCH("NJOnlineGambling", {Website}), "https://www.njonlinegambling.com/wp-admin/admin.php?page=easyaffiliatelinks#/", IF( SEARCH("PennBets", {Website}), "https://www.pennbets.com/wp-admin/admin.php?page=easyaffiliatelinks#/", ) )

227
D
M
Marty_McCoyKnown Participant
posted in Automations
Creating / Editing Airtable Records Based on Outlook Event Series

I have set up AT automations to create and edit AT records based on Outlook events. But I cannot figure out how to create one AT record for each instance of a meeting series; instead, the first instance of a meeting series creates one AT record and the rest of the instances are not created. Any help here is greatly appreciated! I also have a Zapier account if that’s a better tool.

21
M
A
Adam_RekerNew Participant
posted in Automations
Automation or script to change a date

I’m looking for an automation that can change a date field. Basically I want any dates before today to update to today’s date (in a date field). Trigger: if Status Due is before today Action: Update Status Due date to today’s date

81
WilliamPorter
I
ismail_crcNew Participant
posted in Automations
Automation help: "sleep" a few minutes before sending a Slack notification

We’re using Airtable as a CRM on my team. One use case is to send a notification to our team’s Slack channel when a record is updated. The automation looks for recently modified records in a table that stores check-in records (one record per call or outreach activity). The trouble is that we often get multiple notifications when one would have been just fine; the extras are just noise. Here’s what I mean: SLACK MESSAGE 1 [12:01 PM] Person A updated record B “lorem ipsum dolor sit amet” SLACK MESSAGE 2 [12:02 PM] Person A updated record B "Lorem ipsum dolor sit amet qua." (All that changed here was a couple characters and a new word). Can the Airtable automation wait for 5-10 minutes before sending these update messages? Or, as a complementary solution, is there a way for the Slack notification to highlight only the parts of a record’s field that have changed? Here is our current configuration:

215
A
K
kxr1mNew Participant
posted in Automations
Qr code maker app automisation possibility

Dear airtable community, currently I’m using the “QR Code Maker” app in Airtable, which works great for me at this point. Now I want to take the next step and fully automate my process, by letting the app generate a qr code, without me manually having to confirm that procedure. As soon as a certain field is filled the qr code should be added to the chosen line. Since I couldn’t find this option straight in the app, I had a look into the automation category and noticed the custom script option. As far as I can assess this, I think that this is the best option. If there is another great solution to tackle my automated qr code creation, please be so kind and let me know, any help is highly appreciated! Thanks in advance guys, take care and stay safe! Kind regards, Karim :slightly_smiling_face:

00
K
L
Lameez_AlexandeNew Participant
posted in Automations
SurveyCTO Webhooks Rate Exceeded

Hi, I’m using a webhook to import data collected in SurveyCTO (mobile data collection platform) into Airtable. I’ve recently received error message “Rate limit exceeded”. I’ve tried deleting any inactive webhooks in my base and SurveyCTO but error persists. Anyone else experience this and what could be the cause? Much appreciated!

11
Justin_Barrett

Badge winners

Show all badges
Terms & Conditions