Automations

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 i

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!

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

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

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 Paym

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.

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

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

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?

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 (

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 i

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.

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.

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.

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

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?

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#/", ) )

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.

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

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

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:

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!

There are serious bugs/limitation in Automation formatting. First date formatting, in Europe we use DD/MM/YY unfortunately AUTOMATION disregard fields date formatting and put them always in ISO format: YYYY-MM-DD. Then numbers, I don’t know why but calculated number fields are never with the desired decimal. It could be cool to have an option for the numbers of digits we want to display or just keep the field formatting (ex. Decimal (1.000) if it’s calculated automation puts 15 digits after the comma (see image) and when not computed it just uses 2 digits even if 3 are selected! Thank you for fixing this.

Hello, I have about 5 tables containing different information but with one Column being consistent throughout the 5 tables (Let’s say Column A in all these tables are Name). How do I make it so that I only need to update the first table’s Column A and the other 4 will automatically reflect this update? For example, right now I have 40 items in Column A and would like to add 5 more without having to add it to all 5 tables manually. Pretty much like an importrange function in Excel. Thanks!

Hello, Any Zapier users out there? I am building a fairly simple automation bouncing data from one table to another within the same base and get this error message: With the following script I can get the field’s name: let field1 = base.getTable("Interest Topic Queue").getField("fldLXMiq8BuPkCJXJ"); output.inspect(field1); …and it is indeed on the table being written to - a single select field called “Source table.” As you can see in the picture, Zapier sees it is there. I’ve used this receiving field the same way in several other Zaps (essentially I am making a junction table to collate data from several other tables and I use the single select field to denote either the table name or if there was an update processed from the source.) Any suggestions? Thanks!