Automations

I have a tab within a table, the tab is called PTO. the PTO tab has two different views I am working between for this automation. The PTO tab as a whole is populated from forms that are submitted containing requests for time off from employees. This form contains fields for [start date] and [end date] and is intended to capture both single and mult-day requests off. The first automation sends an actionable slack message for approval, which is working correctly. The second automation I am trying to set-up is intended to send a message to a slack channel each day that there is an employee out of office, listing which employee is out of office. (Bonus points for this only running Monday-Friday, even if the dates fall on the weekend).My first attempt at the automation was setting up the second view of the same tab, which would be filtered to only show records based on conditions, but I wasn't able to find a way for the records to populate if the request required more dyn

Hello,I have a Database that includes a table of Users and a Table of inventory (Computers , Monitors, Docking stations and so on).All of our inventory is mapped by serial number.When I give the user a device I assign it to the Air table.I want to have the option to see the assigned history by user or by device.That means if I have a user name Tom, and I gave him on 01/12/2023 a laptop: Lenovo Thinkpad , S/N:ABCD123, and I took it back on 15/01/2024.Let's say I have the record of this computer. Through that record I want to be able to view the computer assigned History- that means when it was assigned and when it was unassigned. And also the opposite way, through the user record to be able to see which devices were assigned or unassigned to the user.

Hello and thanks in advance.  I have form submissions coming into Airtable via a Zap from Gravity Forms.  The problematic field is Location which contains lat, lng, and address. I need lat and lng in separate fields in airtable.  This is an example of the imported data: {"location":{"lng":-122.38418565202375,"lat":47.653449368341484},"address":"Magnolia Connector Trail, Seattle, WA 98199, United States"}I need to wind up with 122.38418565202375 and 47.653449368341484 in separate fields. I've created 2 new columns in my table with the names lng and lat and installed the scripting extension. What do I do next?  Also I would like to process all the existing records at once and then process all new entries one by one manually when they come in.Thank you so much! 

Hi,I am trying to set a date field value to today's date, when another value for that record is updated. e.g. when status changes to X, set date field to today's date. I am simply looking for UK date format e.g. 23/01/2024 Does anyone have any ideas? Thank you in advance. Thanks,O

I have a base full of contractor information (Name, contact info, addresses, etc.) these fields are concatenated into one field.I sync this contractor info base across our project bases so that the information is readily available. When I select a contractor from a dropdown list on a project base I want it to use the corresponding concatenated contractor info field from the sync'd contractor information base into a 'contractor info' field on the project base so my users don't have to copy and paste the info in every time. I've been trying to use automation? Is this possible? What is the best way to achieve this? Shouldn't be too hard to select an option then autofill info based on that selection right? What am I missing? 

Hi! I am teaching myself through online videos, and I stumbled across one that showed me how to create a form and automate an alert in a Team Channel. I did that and it is working great. Next, I wanted to see if I could insert a link so anyone that sees that alert, can be taken directly into the table/grid. I found a video that shows me how to do a custom message, and I can get the name added, but when I add the Base URL, it will not work. At first, it was adding a long ugly code but now nothing. I am not sure what I am doing wrong, and appreciate any assistance. 

Hi all, I'm trying to set up an automation using a trigger using a linked record field. What I want is to trigger an email whenever a record has two or more linked records in a field (but not one). Is this possible to set up?For example, let's say the records are individual baseball players, and the field "Teams played for" links to a "teams" table. In Babe Ruth's record, the field would link to "Red Sox", "Yankees", and "Braves". In Mickey Mantle's record, the field would only link to "Yankees". In Jackie Robinson's record, the field would only link to "Dodgers". How can I set the trigger to email for Babe Ruth's record and not Mickey Mantle or Jackie Robinson?

Hello I am looking for a solution to the following problem. we have an internal Order pipeline of equipment orders coming in and we need to consolidate these Orders on a "Hub Code" which are our branches. We will then proceed with the data for picking and shipping purposesAn example of the task would look like the following: Case 1: different Items ordered for same HubInput Table "Input Rider Gear Orders"View "Pending"Order 1Column: "Order Number" Value: "17884"Column: "Hub Code" Value: "nl_til_west"Column: "Full Name (from Master Data combinations)" Value: "Winterset - Male - M"Column "Quantity Pick" Value: "1"Order 2Column: "Order Number" Value: "17984"Column: "Hub Code" Value: "nl_til_west"Column: "Full Name (from Master Data combinations)" Value: "Winterset - Male - L"Column "Quantity Pick" Value: "1"Output Table "Rider Gear Output"Column: "Hub Cod

I have a base that acts as a sales pipe line of sorts with each stage having its own table (Bid Board, Pre-Approval, Live, Shipping, and Completion). I have it set up through multiple If-status > Create record automations to move a job along the tables once it reaches a specific stage. This has been working great for me but there is one issue. If I notice there is a mistake or I need to update some information on an existing record (for example "client name") I would need to manually do it across each table.I tried to set up an automation using the following -Trigger - When Record is UpdatedActions - Find Records > Update RecordWith the intention of having it detect that a record was updated, and then reflect that update on the second table. For example if I updated a Customers name on "Bid Board," then the automation also correct it on "Pre-Approval."Testing the automation returns all check marks but actually trying it in live nothing happen

Hello, I have the following problem of not beeing able to merge Orders in our internal pipeline. We are getting Orders from our Hubs for Equipment, which need to be packed and shipped in batches. The Script should be able to merge same items ordered for the same Hub multiple times or split if different items ordered. I created the following 2 cases to make the request visible. Case 1: different itemsInput Table "Input Rider Gear Orders"View "Pending"Order 1Column: "Order Number" Value: "17884"Column: "Hub Code" Value: "nl_til_west"Column: "Full Name (from Master Data combinations)" Value: "Winterset - Male - M"Column "Quantity Pick" Value: "1"Order 2Column: "Order Number" Value: "17984"Column: "Hub Code" Value: "nl_til_west"Column: "Full Name (from Master Data combinations)" Value: "Winterset - Male - L"Column "Quantity Pick" Value: "1"

I'm new to Airtable and looking to see if this will be a good platform to use.I created an Excel file that has a lot of information, so, based on the rows selected by a user, I want it to export out separate word documents based on those rows only and the word document would include the information from each column and that word document would be company branded. Hopefully, my question makes sense,Is that possible?

Hi there, I’m trying to set up an automation that sends an email every day at 12:15am notifying security about who wants to come onto site today, and if they are “not approved”. The email includes a grid of all records that match the conditions “date of entry is today” and approval status is “not approved” I would like to include that day’s date in the subject line and the body of the email. I’ve set up a formula field to give me today’s date, and another field to format how I want it to look in the email, purely for the purposes of this automation. My automation is set up as follows: Send email at 12:15am every day Find records where date of entry is today, and approval status is not approved Send email To insert today’s date into the email subject and body, I was inserting the field ‘todays date formatted’ from the find record step. But if I have say 3 records, it gives me the date 3 times. Is there any

Hello,I have a table. In the table there is a column named "Status" (single select field) with different selection possibilities. ("Property1", Property2",...).In the table is another date/time field.I want that when the status in "Property1" is changed, record the time of this change in the date field.How do I do this?Thanks!

I have a pretty basic automation that grabs a few records in a grid and sends them in an email. The issue is that it seems that in between finding the record and sending the email two different fields go blank. I've attached screenshot examples. The first is the result of "Find Records" and the second is the Grid emdedded in the email (with information censored). Note how in the second image, Product Type and 2024 Rate Availability are both empty. This is actually happening on two different automations that are set up to run on different cadences, but I haven't been able to find issue within the automations or within the records themselves.Can anyone help me troubleshoot this issue?

I create 'multiple select' field to store multiple functions of my product. When I do automation to google docs, the information in this field is grouped together into one field. Current format in google docs is value 1, value 2, value 3Any method to present the value each line?value 1value 2value 3Also, the product image can't be automated into google docs through airtable automation. How can I fix it?  Tks. 

I built an automation with a trigger and an action, but when I try to turn on, it doesn't working. The automation turn on and after it, turn off. Everything seems right and I don't know what to do to solve this. Someone know what can I do?

I have an automation that sends out a digest of all overdue tasks to my team on a twice-weekly basis. This has worked out great for the past 6 months or so, but now names are not appearing in the "assigned to" field. I've tested out all steps of this automation and user names appear correctly at the "find records" test phase, but when populating into the grid below w/in the email, it shows up blank (see below screenshot). Anyone have any ideas about what's going on?I guess one work around is that individuals each get an email that only shows tasks assigned to them but that's not great either since we like to have team visibility across tasks. 

We are using a base as template, which has some automations. I’ve noticed that when the base is duplicated all the automations become disabled. Is there a way to enable all automations on base duplication?

Hi everyone,We have many automations that send an email to a member of staff when the automation is triggered.  That member of staff has left and I now want all of those automations to go to another  member of staff.  Is there a way that I can search through all the automations to find every instance of that email address being used so I can then manually (or automatically) update the email address with the new name?I've searched around and I haven't been able to find a way to do this without going into every automation individually... Thanks 😄

Hi Everyone, I currently have 2 tables ("Lesson Tracker" & Student Record").What the lesson tracker does is that each new entry is basically a record of the student's name and the date of the lesson they attended.The student record table is essentially a database of the students, with their name, contact info, as well as a column counting how many lessons they have attended in total.What I would like is:1. Every time there is a new entry on the lesson tracker, an automation runs which first matches the student name on the new entry to the corresponding student row on the student record table.3. Once this matches, a lesson is added to the number of lessons column. Eg. If the student already attended 3 lessons, then this new entry would turn 3 into 4.The ideal scenario is this: "Sam Smith

I am using Airtable as the backend for my app. I have a Table A for registering users and a Table B for registering restaurants. Through the Google Matrix Distance API, I am using longitude and latitude data to calculate the distance between registered restaurants and user data, obtaining the results in the "distance" column of Table B where the restaurants are registered.However, each automation I run through the script only updates for new users registering, causing interference with the distance results for users already registered. I would like each user to have their own distance calculation without interfering with others. I have no idea how to do this! I believe it might involve a filter or something like user ID .

Hello,I'm building an app and would like help solving an issue. I have a Table A where I register my users. Table B contains the restaurants in my app. I use a Google Maps API to calculate the distance between my users and the restaurants. I'm running an automation script block to update the distance calculation each time a new user enters. However, I want an automation where each user has their own calculation from their location to the restaurant. Any ideas on how to achieve this?

Hello Airtable Friends!I really need some help with my automation.I created an automation for when a record is updated for our team. Basically what I did is when an assignee is changed to another assignee, that new assignee would get an Outlook email saying that the record was reassigned to them.When I go to test it, I get an alert from Airtable saying something went wrong with the automation but it doesn't show me what the exact issue is. I am wondering if its Outlook but I am not sure.Can someone help me out? 

Hi,Ive created a project management workflow where we have a project board that filters into a task board, and tasks are assigned to individuals who check a "complete" box when done. We have a dashboard for each individual where their tasks appear. Because the tasks need to be completed in a certain order (ie "edits" need to happen before "production") and we have different people executing on different parts of the project, it can be hard to know when its your turn with the project. The project manager typically assigns all the tasks out at once so all tasks associated with the project appear on the individuals dashboard simultaneously. Ideally we would only want the project to appear on the persons dash if it was their turn with the project. The tasks are already numbered for order so hypothetically it would be easy to automate one following another. Im wondering if theres a way to set automation so the tasks only appear if the previous ta

Hi everyone!I am currently working with two tables (let's refer to them as A and B), wherein table B is synced to table A.My objective is to deduplicate table A, but before doing so, I need to merge the information that is not synced in table B to prevent any data loss (essentially deduping without the deletion part).Is there a method to achieve this?I was contemplating using a script to handle the merge process, but I'm unsure if there's a way to identify whether a field in table B is synced or not.Any insights or suggestions would be greatly appreciated!Thank you in advance.