Automations

Hello,I am trying to develop a maintenance tracking solution that deals with both dates and hours or miles due. I am attempting to configure airtable automations to send notifications as upcoming inspections become near.  I have figured out how to run a notification automation quite easily for those inspections required by a certain date. However I am still trying to determine how to configure the same type of automation with a trigger when the miles or hours reach a certain time. For example, if the next inspection is due at 1,234 miles, I want the automation to trigger when the current vehicle miles are within 5 miles of that number, or anytime that the current miles have exceeded the next due mileage.Thank you for your help.

Hi Airtable Community, I have the following problem. I have a table with tasks and a table with projects.If a task is delayed by x days, I want to display a timing risk in the project. The tasks are linked to the project. However, the tasks are repeated for each project. Therefore, they always have the same names and are not unique. If a task is now delayed, the automation cannot know which project the task belongs to. Do I really have to assign each task a unique name or can I use the record ID somehow?Thank you and bestMirko 

I am creating template tasks  when a project stage is updated. This part of teh Automation is working perfectly However, I want to bring across the team member I have assigned the task to in "Template task" to in the new " Project Tasks"I seem to be unable to get a dynamic field type for Team member. ( I have tried multiple field types) Does anyone know what I am doing wrong?

Hello to all of you!I am new here.I wanted to ask you the following question:I have to synchronize my 2 databases, I have all the automations created, when a record is created, when a record is updated, but I need to synchronize also the deletion of items.Checking the documentation I have seen the following:https://airtable.com/developers/scripting/api/table#delete-record-asyncI have tested the script, but I need to add trigger a webhook with the record ID so I can deal with Integromat and delete the record from the first DDBB.Can anyone help me?Thanks!

Hi there, someone has already asked this question on this thread: https://community.airtable.com/t5/other-questions/select-multiple-records-and-update/m-p/115586/highlight/true#M36767But I don't think it is active any more. I have duplicated the base to get the automation but I don't have the permissions to do so. Would anybody be able to help me on how to create this automation please?  

please watch video for explanation on issue I am having: Watch to explain issue i am havinghttps://www.loom.com/share/fef849aee57642a7bf9f6c99c9ff3822?sid=6395efd4-5163-4435-9f3d-cb035f780664

HelloWe have 2 phases of work:Phase 1 is working on what we call "First Pages." Job sub-status = NEWPhase 2 is everything after that. Once marketing returns the job to the designer, Job sub-status = CORRECTIONSI'm looking for a way to automate the change of the sub-status field from NEW to CORRECTIONS.My thought is to have a field called "FIRST PAGES COMPLETE?" and an automation runs to fill that field with "yes" when the conditions are met. Then, if field = "yes" change sub-status accordingly.I'm having trouble figuring out how to track the proper conditions because I'm looking to track a change between very specific options in the "Status" field. Not just when the record is updated in general.I need the automation to look at the "Status" field and analyze when it changes from "In Progress - Design" to either "In Progress - Marketing" or "with Client"Best way to do that?

I have two tables I want to update when adding a new productTable A - Inventory Table B - Received ( Products received )Table C - New Item Table : Junction Table I have created a junction table so I can multiple "New" products quickly and that do not exist in Inventory.So in the automation I am doing the following 1. Trigger - If Done Checkbox is True1. Create new record : Inventory - Add all parts of information needed here.2. Copy New Inventory ID ( Run Script)- Paste onto : New Item Table : Field : Inventory ID ( Because of permissions I create an extra field also - New ID) - Took a while but working 3. Create new record : Received Table : Add quanity received / cost etc.. I tried to directly update Inventory ID field ( Linked relationship Field ) Linking Inventory & Received Tables - However worked only 50% of time then stopped altogether : Feel it was a time lag in the software So I created a new second Automation - Update Record 1. Trigger -

Hi everyone !I've encountered difficulties in validating the search for an ID. I believe there must be an error in my formula because, after integrating logs to ensure that I was correctly comparing the searched ID with the ID present in the table and the relevant column, I noticed that we have a match, but the formula generates a 'false' instead of a 'true'. Does anyone see my mistake?Thank you

I am using Make.com - Airtable - Update records. I have 5 different modules all returning the same 404 response,  using the outh accessIt locates the base and the table, searching for the primary IDContacted support, sent links and images. No response yet.After some search, 404 errors apparently show up. Airtable did an update in make.comAnyone else having this problem? How do I base my business on this happing?Thanks in advance   

Airtable Newbie here!  I have an email automation that sends me a reminder when an item in my airtable is approaching the due date.  I want to have a field (due date) appear in the email to be in red, so that it i see it clearly.  Can I do that in Airtable?  If so, how do I write it or where do I write that? Is it surrounding the field name in the body of the email?It should look like this:The records are due to the requester on August 5, 2024.

Hello, I am working on integrating my google calendar with my airtable base so that I can include all of the meetings that I have with members of my contact list on their contact profile as a linked record to the calendar table. I created an automation to do this for me (see below). The issue that I have found is that when more than 1 of the contacts that are added to the calendar invite for the meeting is found within my big "Contacts" table, it will grab the unique IDs for both of the contacts and it goes to add my calculated field (the first one in the image below, my primary field, and the only field that I want to add), to my synced calendar "Contacts" field within my calendar table. The problem is the automation tries to update the linked contacts (eg. "Arjin Claire, Evolution") in this "Contacts" tab, but it throws an error when more than 1 are being added. I believe it reads each of these contacts as being concatenated together and since the value is calculated v

Why I cant reply to actionable messages on Slack?  When clicking in slack I always keep receiving the same reply."You do not have access to this Airtable record, or it has been deleted" Thats impossible as Im the owner of the base and workspace. How may I fix this? Thanks

I’m trying to auto-create a record when an interface button is clicked. This can be done by linking a button to an automation. In the new record I want to store the user who clicked the button. Is this possible?

I have two tables with the same fieldsTable 1. Current Data (Read-only)Table 2. Proposed Draft (Read/Write)I want users to be able to edit records in the second table. Table 2 can then be submitted to a workflow. If approved, data from Table 2 will be joined to Table 1.Essentially, is it possible to join (concatenate) one table to another with the same fields? 

Hello,I was hoping that somebody could tell me what I have set up wrong in this update record automation. Every time it runs I get an error message emailed to me. I have included three screenshots, one for the trigger, one for the find records action and one for the record update action. Any help I could get would be most appreciated.

Hello! I have an idea for an automation and I'm not sure how to go about it. I have an automation (in zapier) currently where when the referral source is left blank when an employee schedules a client in our scheduling software, the client name and email is added to an Airtable base so that we have a running list of who to reach out to and ask for the info. I wonder if it's possible to send an email to the employee asking for the referral source. I was thinking it'd be great to just send an airtable form but I don't know if I can send a form that would update an existing record? The referral field is not always applicable so making it required isn't an option. The existing automation filters whether the referral source is needed. The process in my head goes like this:-New record is added to Airtable base that includes name and email. The record also has a single choice field that is left blank with the possible options.-An email is sent with an airtable form asking the employee to

It won’t find the slack channel I need and when I use the “Find channel” option I can’t search for it either because when I type it into the search field it doesn’t do anything. If I hit return, it just picks whatever channel is at the top of the list and doesn’t search for what I entered.

Hello,I am looking for some help on an automation I am trying to run.  I am trying to use a make.com webhook with airtable so that when a new record shows up in airtable it sends the webhook to make.com.  I have the script that I am using and the connection and everything works but the webhook does not send the correct bundle of information.  It sends the record ID and then just generic information like 'header 'recipient', etc.  I am a school teacher and not a coder so I have been trying to get Chatgpt to help me with the script and I feel I am really close but don't know the scripting language enough to diagnose the problem.  Any help would be appreciated.let table = base.getTable("Injury Report Form");let recordId = input.config().recordId;// Fetch the specific recordlet record = await table.selectRecordAsync(recordId);// Check if the record is fetch

Hi everyone,I have a table for customers, a table for assets and a table for faults.Each client can have several assets and each asset can have several faults.When a fault is closed, an email is sent to the customer with a request for payment for that fault.I have clients who are divorced and they are paying for the same property.Their email column is a lookup field from the asset table (which connect to the client table) in the faults table and it looks like this now - "email 1, email 2"And the same for the column with their first name it a lookup field from the asset table (which connect to the client table) and it show - "first name 1, first name 2"I can send each client seperate email with the "repeating group" automation.the problem is that i cant seperate their first name in the email body text.how can I send each client private email with his first name?

Hi 😊 I'm trying to create an inventory system that works a bit like a CMS. I want to be able to create an automation when if I add a new item in Table 1, another table is created (duplicating fields from existing tables) and then if possible, linking the new table in a column by the new item in table 1. To make it easier to visualise, Table 1 is like a directory, and then Table 2 is a like a log of that item. Currently I have to: 1 - add a new item in table 1, create a SKU number for it, then duplicate table 2 (which has different field values) to create a new table for the new item. I then copy and paste this new table into a cell on table 1 that coincides with that same item.Screenshots attached that show Table 1 with item catalogue, and then Table 2 with item 1 listed. You'll also see the duplicate tables of table 2 along the top, and the links to these in table1. Thanks in advance!

Hi everyone,I have a table for customers, a table for assets and a table for faults.Each client can have several assets and each asset can have several faults.When a fault is closed, an email is sent to the customer with a request for payment for that fault.I have clients who are divorced and they are paying for the same property.Their email column in the faults table looks like this now - email 1, email 2And the same for the column with their first name - first name 1, first name 2Is it possible to send an email to each of them separately when a fault is closed?

I need to have the master table unmodified and only its duplicate to register my changes so I can compare the two. How can I do it?

I am trying to set a simple automation but for some reason It does not work and I cannot make anything out of what the error is giving by Airtable: Updating the record failed.For more context, I have a formula field that is concatenate from multiple text fields and I want to have a multi-select field that is pasted from the aforemention formula field. The purpose of this is to have tags type as well as remove the duplicated tags.Let me know if you have any suggestion. Thanks!

Wonder if anyone has something that works for this... I'm creating discrete events in a base, and I want to automate the process of turning the data points into a .ics file and attaching it to the record in an attachment field. It's a bit like this walkthrough  but instead of using Make to attach the .ics into an email, I want to return the file to the Airtable record's attachment field. Then anyone who has access to the record can download and save the calendar entry to their own calendar. Per that walkthrough I was trying to get Make.com to do this but I keep running into Bundle Validation Errors, and I'm wondering if there's a way for Airtable to handle this inside the base via scripting.