Automations

I have 2 automations that takes ~2500 new records. The first one clears the link field and links them to their matching records in another table. The second takes all of the ones that failed in the first automation(these failures are due to the imported list having items that dont match up cleanly and need to check another field) and ADDs them to the link field.These work >95% of the time. My issue occurs because so many automations run at the same time and some of these records need to link to the same record in the second table. This causes them to overwrite each other. I would like to find a way to slow this automation down and have it run in chunks or even 1by1 since it doesn't take too long per record. Does anyone have any ideas on how to trickle this automation or break it up into chunks?

Hey guys,I'm totally new to Airtable and just trying to find my way around. I am or was a private Notion user for a long time, but was looking for a DSGVO-safe alternative with end-to-end encryption for a simple database or customer overview. Currently, however, I can not yet implement the idea, which I have in mind. I imagine the following scenario:I have a "customer database" where I can store all customers with name, address and contact details. The respective customers I can assign a "tour", that would be either tour 1,2 or tour 3. Tours because I drive out food and have 3 different tours, on which different customers are waiting for me.It also happens that a customer appears several times a week in the same tour. I would like now that I have created in addition to the "customer database" 3 times the respective tour as a calendar view. In the calendar view I would then like to assign the customers from the customer database to the respective delivery date.

Table A is a list of customers and each item they bought. I have a Table B where every time a new customer is added to Table A the customer name and a few other columns are added to Table B. If a customer buys something but the customer name already exists in Table B then nothing happens. Feel like this should be easy but can't figure it out...    

I run a research lab. I'm setting up Airtable to manage purchase requests and inventory. I have two tables:1. Purchase Catalog, with fields 'Item' and 'Current Stock'2. Order Line Items, with relevant fields fields "Quantity' and 'Status'. 'Order Line Items' is a table that represent specific instances of wanting to puchase something. Purchase Catalog represents different items one would purchase. The two tables are linked. When we received an item, I will change the status in 'Order Line Items' to 'Received', at which point, I want the field 'Quantity' (from Order Line Items) to add to the value in field 'Current Stock' (from Purchase Catalog). I asked ChatGPT to make me a script and it looks like it would work but it's not doing anything to change 'Current Stock'. Could someone help me figure out how to do what I'm seeking?

Hi,I set up an automation to create some events in an Airtable table in my Google Calendar (Google Calendar action). This was easy. But I can't figure out how to use the Google Calendar Update action to delete an entry.Since it in the automation says "Leaving selected fields blank will unset them", I tried to update the start/end times with empty fields, but that was impossible. After manually deleting any setting in the automation field, Airtable "repaired" them when I exited from the view.What is the trick?Rgds,Björn

I'm using an Airtable form for leads to fill in and want to count a form completion as a conversion in Google Ads.Is there a way to do this?I could use the action of someone landing on the 'thank you' page to trigger a conversion except the redirect to the thank you page after the Airtable form has been completed does not always seem to happen. Possibly because it takes too long and people have left the site whilst waiting for the thank you page to load.Anyone else tracking Airtable form completions as a lead or conversion and worked out a way to do this?

What is your process for troubleshooting automations in complex bases that have information changing regularly?I have an error occurring with an automation that I am struggling to troubleshoot. I can't seem to replicate the error in my testing, which means I am not accounting for/considering an action happening when the base and relevant records are interacted with. I am struggling to identify the issue, as:1) Airtable doesn't instantly notify you of the issue (notifications take 5-45 minutes) - which is bizarre. In a base where there are likely many more interactions with the record in question by the time I realise the automation has failed, this makes it hard to walk back and figure out what conditions are creating the error.2) Record revision histories don't seem to be overly thorough:a) the log doesn't show where an automation fails,b) the revision history timestamps are recorded unhelpfully as "17 hours ago" etc - which make

Hey everyone.I am trying to use the script made by No Code Collab that is made to run as an extension with a button trigger and turn it into an automation that runs a script.I cannot figure how to pass the record to the script. I have set up my input variable but cannot find a way for the script to take it into account.in the screen shot you can see what I have tried without any successAny ideas ?Thanks !T

Hello,I have 3 tables which are linked to each other Customers Invoices https://airtable.com/app0jw4sAdW5VRy68/shrRhehmziVBIfiAG Budget vs. Costs https://airtable.com/app0jw4sAdW5VRy68/shrTYer8pWxDAuat6 The Invoices table is my catalyst. I have created an automation to update the linked record field in the Invoices as follows created a new formula field that generates the right text to go into that linked record field. an automation that triggers whenever a specific field in the Invoices table is updated &

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 t

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. 

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.