Automations

Hello all! In our line of work, we interview and hire candidates for our clients. Each record is a potential candidate. If we change the status from “interested” to “hired”, I would like the automation to request that the field “date hired” and “negociated salary” be updated. Is there a way to create an automation where if a field in a specific record changes status, it triggers an “alert” to remind the user to update another field in that same record? However, the information in that field varies, therefore I cannot use the ‘update record’ automation. Thank you for your help!!

Hello community! I am using an automation that triggers when an Airtable field is updated. The action is to update attendees field in an Outlook calendar but testing returns an error of ‘Cannot read property “timeZone” of undefined’. See image for what this looks like. Am I about to fall down the rabbit hole that is time zones in Airtable? Or am I just missing something obvious? Thanks in advance :slightly_smiling_face:

Hello all Im setting up a euipment register off all the companies trucks, trailer, etc. the first table will be have all assests/equp with rego, next service etc the second table is used as form for staff to fill in every month or as isssues arise, with a comments field for staff to fill in any issues etc we wanted to display on the first table the latest comment entered by staff is this possible any help would be appreciated Cheers David

Hi Guys, im hiving somebody can help me if possible, im looking to add a date of birth to a form, I have done this however its quite clunky to be able to scroll backwards multiple years starting from the current date, im looking for a formal to be able to chose the year firstly then month and day. I hope that makes sense and any help would be hugely appreciated. Andy This is the form in question. Airtable

Hi, I have a issue: A form in my table provide: Name - Instruction 1 (from customer) - Instruction 2 … Instruction 10 => I Would like to create a new table from this entry (automatically), with one rom per Instruction. Line 1: Name - Instruction 1 Line 2: Name - Instruction 2 … etc Someone could help me please ? If a tool is easy to create such a process. Thank you so much.

I have a table with four columns: Email address, Thing 1, Thing 2, and Thing 3. The possible values for the “Thing” fields are “YES” and NULL (empty / no data). Is there a way to automate a periodic (say, weekly) scan of the table that looks for NULL values and generate an email to the corresponding email address on the row saying which things are NULL?

Hi Everyone, :wave: Maybe someone can shed a bit of light :flashlight: about how to do this, if possible. :speech_balloon: Actual Scenario: When a member of the team (there are 5 members) makes a question about a certain proyect (we have many at the same time, around 100) the related client receives the question automatically in its email. But in order to answer he has to go into our portal (we use miniextensions.com) log in, find the question and answer it. Which is quite a slow process. :star_struck: Desired Scensario: When a client receives a question he can directly reply the email, and his answer will be updated to the related record. Any Ideas where to start? I guess integromat would be needed for this, or webhook to trigger an airtable automation?

I have an automated email going out to notify people what day/time the Round of edits are due. The date and time look fine in my record but the email says “Please complete your edits by 2021-04-09T09:52:00.000Z”. This is not easily readable. I’ve learned about adding a formula to the table that corrects this but it’s specific to only one field. DATETIME_FORMAT({RD1 Comments Due}, ‘M/DD/YYYY \at h:mma’). That works in the body of the email when I select this formula record to get RD1 Comments Due. Now I want to have an automated email for RD2 Comments Due. Do I have to make a 2nd Time Formula for that field?

Hi, I’ve been using the “Find Records” aspect of automations and super helpful. It doesn’t seem to be well documented anywhere though, and where I am very confused is that often there will a value from a previous step that I want to use (dynamic), but it is not available, only <>length. Unhelpfully rather than being greyed out, or not visible, I always end up clicking through to find it’s not available! From what I can tell, you can not use any of the following as a dynamic variable in the Find Records automation: Formula value Linked record Roll-up Considering those make up a large percentage of my tables, it’s a little frustrating! Indeed it seems that the only values you can actually use dynamically, are ones that have been manually populated. But that means either having to actually populate those fields manually, or using an automation to print the value int he field (so it looks like it has been cre

Hello all, I have an automation that is looking for a record with specific values. Sometimes it does not find the matching and it is normal (it is a use case.) I would like to know if there is a way to catch the error of the find function ? If not I was thinking of doing it with a script but I found it strange that in automatisation it is not possible to catch error or even do conditional branch. thanks for your help Alex

I have 2 tables, Customers and Requests. Requests a made with a form view with the typical customer details (Name, email, etc). I would like the send an email to new customers. The automation flow would be: Trigger: New record created in Requests Action: Check the Email column in Customers to see if there is a match. If the email from the Request is not found, send an email to the Customer to complete the new Customer form. I have tried with the inbuilt automations. Once the records is created, I can find a record, but I wan’t to run the send email step if there is 0 records returned, but the Automations only allow you to run the next action if something is found. I also tried to write a script for it. With scripting, once you implement the input variable you can no longer test the script. It also won’t let me return a boolean value. I wan’t nothing to happen if the email is found in Customers, and to only run when a new Request record is created.

A few questions if anyone could answer my queries that would be great, Can we email a link to the form of an existing data update using mini extensions automated? (By this I mean, I have a table with existing data inside it and the few columns have to be filled out by the respondent, I need to send the link of each form to different email ids, which is in the order of 60 people each with different mail id. Can I enter the mail id’s into each row and somehow make the link send to the corresponding mail?) 2.When I use miniExtensions to update the existing data, if I share my link with someone who does not have an account can he be able to enter the data and save it in the forms? Is there any way to export to Microsoft word from airtable? Any help is appreciated. Thanks

Hello! Is there a way to increase the limit of automation per base or are we really limited to 25? We’re currently working on a base that needs 10 tables and each table requires to have 5 automations (for email reminders). The first table (lets call it the General Phase) triggers the automation in other tables so I’m concerned that if we are really limited to 25 per base, I would have to create another base (Base 2) so I can complete the rest of the automation per table. This will conflict with the integration that we have for General Phase. There must only be 1 General Phase table. I hope you can help me out. Thanks in advance.

I created automation like this: trigger: when a record matches conditions - Has started (column name) = N action: send a slack message I tested the automation, it works. But when the automation will run?

I have an automated email set up, using Gmail, for informing someone when their video is scheduled to be published. This is trigged once the publish date date field is set. I have changed the publish date date format from ISO to friendly format, but it still publishes the scheduled date as ISO format in the automated email. Does anyone know how I generate an automatic email with the friendly date format? Thank you!

Hi, is already 4 days that I’m experiencing that my automation is reporting a fail on Facebook; I’m receiving an email from Airtable advising about that, but seems everything’s ok with my automation, also because it worked for some weeks without any problem. What’s wrong? Tks Antonio

Dear community. I need to set up an automation, which should be simple, but i’m new with automations in Airtable. I have a table of orders. Sometimes, several orders have been made by the same client. I want to be able to send just an email for every client, in which they will be able to see a table of all the orders they made. How can i create this automation? Thanks in advance for your help, Javier

Hello I have a a process automation that when a lead is converted to a customer (single select field), airtable automation create a new record in a client tab and a list of tasks to do accordingly. I have 2 types of tasks, 1 for product 1 and 1 for product 2. Everything works perflecty … however, when i selected 2 products for one customer I have a duplicate customer fields … I checked with the delete duplicate script, but i want it to be automatic. I attached screenshot, so maybe you can help … many thanks in advance ! Maybe there is some workaround with the automation set up. Is there anyway i can update when the client is existing, instead of creating a new line ? thanks !

Hello! I have an automation set up to send emails and I received the message below. Does anyone know why? I thought we could send up to 100 emails a day.

I am trying to figure out an issue where attachments in my Airtable records are being deleted - allegedly by me according to the record history - when I am doing nothing of the sort. I am using Integromat to create an Airtable record from incoming emails - the script includes populating an Attachments field in Airtable with certain email attachments. I then have a native Airtable automation that classifies these incoming email message records based on their content and updates a Message_type field That all works just fine, however in many, but strangely not all cases, the attachment then mysteriously gets deleted… Here’s the record history pane from one of these records (I’ve obscured the data fields) The Activity history shows the initial creation of the record via API, including an attachment, from Integromat, then the classification step u

I am trying to set up an automation such that the following are true: Record A has a field with Step 1 in it (single select). I want the automation to auto-create (based on conditions I’ve defined) a new record that carries over similar information but changes that single select field to Step 2. Is there a way to do this?

Hi all, wondering if anyone can help me out here. I am tracking some data which is time-sensitive and set up a trigger following Airtable’s recommended steps but I would like to customize it further by having the reminders triggered within 30 days before the due date. For example - if the item is due on 1 May, I would like the reminder to be triggered in April. How could I modify the formula? For reference, this is the existing formula as recommended by Airtable: IF( AND( {Due Date}, NOW() >= {Due Date} ), “Trigger Reminder” ) Thank you! Any help would be greatly appreciated.

Hi all, maybe a stupid question but I’m confused about how to format my automated mail. What my Airtable looks like: What my Mail looks like: What should i do that both look the same way?

So we’re managing our project management status on Airtable and we have ‘project management stage’ field(single selection) in the master view. I’ve set up an automation based on this field, using ‘when a record matched conditions’ as a trigger. It worked well, when the ‘project management stage’ field started to meet the condition that I set up. HOWEVER, what’s really frustrating is that the automation keeps getting triggered even though there is no change/update on the data field that I set up as the automation trigger. I checked all the change history of the record, but no change has been made to the field. Why is it happening? Why is it so buggy? This is extremely frustrating especially when we try to use this feature for external-facing purpose. I’ve been an advocate for using Airtable in our team, but I keep losing trust in Airtable whenever I see this kind of sloppy bugs and malfunctions. If the feature is not fully ready and tested, Airtable team SHOULD N

Hi all! I have a table that will have a check box field , which when checked will create a new record in the table (can do this easily). I want that record to be a duplicate of the original. I have 4 steps I would like to happen automatically if possible, but I have not found a way to do these: Is there a way to duplicate the record whole without having to add all the fields (there are a lot) to the action? I then want one field in the created record to have a value auto-populate from a different field in the original? I want to link the two records in a Link field that is present in each record. I want to check a box in a field of the original record to indicate a status change. Any and all assistance is much appreciated! Thank you in advance!