Automations

Hi everyone, I have a table with created date column and some data, as soon as new record is created I have created a automation script the extracts the newly created record by sorting this column in descending order and getting the getting the first record by using query.records[0](which is the last record created, because it is in descending order). My question is, is there any way other than this to extract the latest record created? I also have a column that is auto increment id, I was thinking of extracting the highest value from this column as the latest record, but could not find how to find max value of column by writing in automation script. Thank you

Hey, I would like to be able to review who is visiting a specific workflow. Can I do this to that level of detail? Our ultimate goal is to see who from the sales teams visit AirTable. Thanks,

Hello Community! I’m having a small problem with one of my automations. When a new user registers to my app, it creates a record with their user ID, that triggers the automation that runs a JS script that checks an API with the user’s ID. It runs just as I want when only one record is created at a time. However, when two or more records are created at the same time, multiple automations are created and get their IDs inputs mixed and ultimately all of them end up crushing. Is there any solution to this? Should I try something different?

So I have a sheet in Google Sheets that works exactly as I need it to, but I’d prefer to bring it over into Airtable if I can. I have a master sheet of contacts (~2500) with roughly 20+ fields. I’d like to be able to drop in a new tab of data into Airtable and have the master tab be populated with any new data that matches up with a specific field in my master table (i.e. URL field). So for example, if I add a new sheet that has contact names and emails as a new tab, my master sheet will update with any new contact name/email info based on the URLs matching between the two sheets. In Google Sheets, adding a Vlookup formula will accomplish this, but I’ve not figured it out between automations and formulas so far in Airtable. Any help is much appreciated! Here is a quick Loom video to describe what I’m looking to accomplish: Loom | Free Screen & Video Reco

Hello, I’m trying to create an automation that sends Slack messages to people when they are tagged for a task, but only if someone else is tagging them (I don’t want them to be notified every time they assign a task to themselves). How do I tell Airtable to send a Slack message to this person only if someone else tagged them? Field in question is a Linked Record field (“Lead”) that is connected to a table with names. This field is used by us to assign tasks to ourselves and other people. I’ve tried the following so far: Creating a Last Modified By field and setting up an automation that is triggered when a record matches conditions (Last Modified By isn’t [Name] and Lead is [same name]). I tested this with a coworker but it didn’t work. Creating a view for the person and adjusting the trigger for the automation to only run if a record enters their view. This didn’t work because the person would be notified o

Hey, guys. I’m trying to create a management solution for Telegram groups for our company. We are currently using Airtable for an employee directory, and I would like to incorporate messaging group management into it. We have several Telegram groups at our company, and each employee is granted membership to the groups based on their role at the company (sales, engineering, etc.) I would like to use an automation to: Send an email to new users added to a group that includes a static invite link Ban/block employees from group(s) if they quit or are terminated I’m planning to use Airtable automations to invite the new users, and a chat bot to kick/ban members that have changed roles or are terminated. (probably this one: Telegram Bot Integrations | Integromat) I’m struggling with coming up with a “clean” way to make this work. Id

Hello, I’m having an issue with all of the automations I have running with Jira Cloud integration. The automations have all been functioning properly for the last couple of months, then today at a certain time they all of a sudden started throwing failures for unknown errors. Below is a recording of a couple of the automation’s setups and the errors and run history. One important note is that it IS creating the tickets (even though it says fail) but then it stops the proceeding steps and fails the automation. Recording of automations Important notes: no one made any changes to any automation that could have caused this (I am the only person who can do this and I wasn’t on the Airtable). I did a snapshot of the last time the one automation worked, and it still threw a fail. I have tried to reconnect the Jira Cloud with the automation, hasn’t changed anything… You’ll also se

Hello, I’m trying to limit my teams input on record creation. on my records I have two fields one is called “LinerType” and is single select and the other is called “Liner” and is also single select. I want to make an automation or something so that when “LinerType’s” selection is “N/A” it automatically makes the field “Liner” to be selected as “N/A” as well. Basically I believe this amounts to being a conditional statement maybe? when LinerType = "N/A" then Liner = "N/A"

I have a multi-select status field that I would like automated but not sure where to start. I have a ‘Due Date’ field and a ‘Status’ field. I want the ‘Status’ field to automatically show either On-Time or Late depending on the ‘Due Date’ field. I tried writing a formula for it and it worked but I wanted to make the ‘Status’ field a multiple select field. Is there a way I can automate this so depending on the ‘Due Date’ and the current date, the ‘Status’ field will automatically populate with the options of On-Time or Late?

Hey everyone, For a software project we are importing data from an existing erp to airtable. We wrote a script linked to a button that gets the data from various endpoints and uses it to calculate some fields and fill in or update records. Now we would like to automaticly synchronize projects that change in the erp. So every hour we look at the ones that changed in the last hours and update “sync” field with a date. When that date changes it triggers an automation with the earlier mentioned script (small change in how it gets the id from record). However it is impossible to make requests to external api’s using automations at this time => always get the error “TypeError: Requests that follow redirects are not supported currently”. I was wondering if there is a way to let a script/automation press a button-field from a record? Or a way around the type-error but it is mentioned

I have some AT automatons that are not reliably happening when they should be. Here’s my setup, can anyone help me improve it? I want to update a single-select drop-down column according to a formula. The formula will output a value in the single-select choices. So I have a filtered view that only shows records where the string equivalents of the drop-down and formula columns are not the same. On this, I have an automation that watches for records to enter this view, and then sets the single-select to the value of the formula. Since the view is filtered by unmatching values, it should always be emptied by the automation which matches them. It works most of the time but I continuously check the view, and find updates missed. If your curious about the background, we’ve found that given the lack of mobile support for interfaces, the kanban view actually works best on phones, to populate shuttle driver’s job list. But we want the cards to be locked to a formula, not

Hey everyone, Hoping that this is a simple fix, but can’t find any documentation on this problem so far. Problem: The output of a script is not being accepted as inputs to downstream steps in an automation I am trying to create. Use Case: I am trying to create an automation that does the following: //trigger There’s an update to a Google Calendar Event //actions Look up corresponding Airtable Record //run script Compare the Start/End Times between the Airtable record and the updated Google Event, output whether the times match or not. //Conditional Actions IF: Start/End Times DO match → Do Nothing, end the automtation IF: Start Times DO NOT match → Update Airtable record with new Start Time value from Google Calendar IF: End Times DO NOT match → Update Airtable record with new End Time value from Google Calendar Below are some screenshots of t

Hey everyone Having problem with an automation when a record is checked, a copy of the record is made in another table. The problem is that it works ok when doing it slow and one record at the time, but I want to take all the checked records at the same time or to speed up the automation, its very easy that a copy is not made because of the slow automation. Any ideas? Regards Jesper

Hi using this formula works… IF({Type of Task}=“CANCEL”,DATEADD({Check In Date},-1,“days”), IF({Type of Task}=“REBOOK”,DATEADD({Check In Date},-60,"days”))) But then I want to add another condition so have copied it the exact same way and it doesn’t work? I’m suspecting its to do with the number of ))) at the end as I have no clue why in the first condition it ended with ) and the second ended with ))) so have tried all number of them but they don’t work. Thanks in advance. IF({Type of Task}=“CANCEL”,DATEADD({Check In Date},-1,“days”), IF({Type of Task}=“REBOOK”,DATEADD({Check In Date},-60,"days”))), IF({Type of Task}=“CHECK PAYMENT”,DATEADD({Check In Date},1,"days”)))

Is there a way to do that with Airtable’s automations? I find that our users don’t usually check their Airtable notifications.

Hi Everyone, I am currently trying to figure out a way to do the following: I have two tables. 1 is for projects and 1 is for project options. Each project option is linked to the proper project and both have single selects for their status. Essentially it is set up like this: (Project Table) Project Name | Status | Project Options | Final Approved Option (Project Options Table) Project Option Name | Linked Project | Status | ~ Various other information The Status fields are single selects with various statuses…i.e. Research Cutting Sent for Approval Final Approved Paid My goal is to do two things. #1 Have the Project Table automatically update status based on the Project Options linked. #2 Have the Final Approved Option link to the record that matches the proper criteria. Given that several options will be made for

Hello! I have an automation setup that when run “successfully” only populates some of the fields specified in the the action. Screenshot included below and highlighted where the errors are occurring. I also after a successful run initially eventually got an error message (seen in a screenshot below that “Could not find matching rows for string”. Was hoping could get some seeds of support on these two issues. Results of Automation From Initial “Successful” Run (The column Tags__ForLinking is the target field that updates as a result of the automation): Automation Setup: Trigger: Action: (1) Properties

I am trying to update multiple records at once using an automation with a script. I received a lot of help by using the script referenced here: Update Multiple Records with Automation. Basically, I am trying to mark records in one table (called “Summer Registrations”) as “paid” AND link those records to the the trigger payment record. The trigger payments can be linked to more than one record, which is why I know I need to use a script. Marking all the found records as “paid” is working fine, but the problem I’m having is pulling in the Record IDs from the trigger step. In the screenshot, I want to put the Airtable record ID from the step1 trigger into the field marked “Receipt”.

Hello! I am trying to automate posting a random record to twitter. I have an automation set up already that whenever i check a box on the record it will send out the tweet - this is working fine. I want to automate that step though so i made a column with “random” values. Now I want to set an automation that each day, it finds a record with the highest value from that “random” value column and updated the record to check the box that will then trigger the twitter automation. How can I set up an automation to find the highest value and then update that record by checking the box? Thanks!

I’m working on a Risk Register. I’d like the Priority single select field to display options ranging from very low to very high, depending on the risk rating number that is returned through a formula field. For example, the formula field may determine the risk rating to be 25. I’d like the Priority single select field to display the words ‘very high’ in red. If the number value is returned as 5, I’d like the Priority field to display ‘very low’ in green.

With Airtable automations I see them in the test output results, but I’m not able to select them as variables to auto fill a field. I know 3th party tools like make/zapier/miniextension are able to do this for me, but I don’t like to use them as it adds complexity to the setup. Thoughts / (native) solutions anyone?

I would like to build an automation script that deletes the record after 14 days of being done. Status = done Table Name = Onboarding Status

I have a base my team uses for resource planning and time tracking. I assign tasks and hours in the Gantt view, tasks sometimes span days and weeks (there is a start date, end date, and duration field). My employees then add their actual hours to the existing records as a time sheet. The problem I’m running into is that when assigning multi day tasks only one assignment record is created for the first day of the task, and all assigned hours are put on that task. I need an automation that will create a new record for every unique date between the start and end date of a task, duplicating all other attribute information and assigning the appropriate daily hours according to a formula. Is this possible within Airtable or do I need to use a different service? Thanks in advance for any thoughts or advice!

Dear community, I have a question regarding the updating of the fields in Airtable. For instance, there are 100 customers and 50 of them have the Increase tag. I want to know how to make this flow: A new record added–>If the customer has Increase tag–>Update field. And this update will be in every 1 minute or less. Thanks,

I’m recording sales orders by scanning barcodes of the products that are being sold. For eg: if I’m selling product A, I’d scan the barcode from my phone using the Airtable app and the barcode field would be populated. Now, my aim is to automatically populate linked records using automation. Check the image below, I have 2 tables - Inventory (test) and Sales Orders (test). I have scanned the barcodes of the actual products to record inventory in Inventory (test). You can see 10 units of each product with unique barcodes. Now, let’s check the Sales Order table in the image below, You can see that the Inventory (test) is linked to the Sales Order (test). So, when I scan the barcode from my phone of an item sold, the automation will be triggered and