Automations

Hi guys, I am looking how to capture the information from a record before it is going to be updated. Scenario: I have two columns 1) {Current location} 2) {Last time location}. Column {Current location} is 3 times per week updated by CSV import. I’m looking how to capture in {Last time location} the values from {Current location} before those are updated so by this to analyze difference between {Current location} and {Last time location}. Real case: Today {current location} is Monaco so {Last time, location} should become empty. Tomorrow {current location} is going to be Paris so {Last time, location} should became Monaco. I saw before on the forum that there is a solution for that and it was used to record Notes like: Column {Comments} and {Global comments} for each line. So the script was working like: When values as text are inserted in {Comments} - those are automatically moved in {Global comments} and merge {Comments} values with existing {Global comments}. In my case I’m l

Hey so i’m quite new to Airtable (and love it so far!) Hoping someone can help! I want to check if a field has a certain value 24 hours after the created time then send an email if it is that value. I have a formula field with CREATED_TIME() And a Single Select field called “Message Status” with two options: Sent , Received If 24 hours after the created time the Message Status = Sent I want to send an email (to myself as a notification) Is there some kind of automation or script I can use for this?

I have an automation with multiple actions and it’s failing, presumably as action 2 needs to wait a little until action 1 has competed. Is that possible? Here is what I have: Trigger: on ticked checkbox Action 1: copying date and single-select fields to text fields with the same value/name Action 2: find records using the text fields in Action 1 Action 3: update records When I test the automation, it’s successful. When I split this autoamtion into two automations, it works fine. But when I have them sequencially in the same automation, with single trigger, Action 2 fails. It says the fieds in Find Records have invalid filters. I’m guessing the text fields in Action 1 are not yet filled before Action 2 has started to find records. Is that possible? Rgrds, Khuned

Hi, I was wondering if there is a way to auto populate a field with hyperlinks to the the Airtable record for that field. This would be super helpful for synced bases, so you have quick and easy access to the editable record from the synced base.

Hi, What I want to achieve is this: In Select field I select one of the available values - e.g. (Tom, Ben, John) Based on what I selected, it preloads a text template to another field (Description) E.g. I selected Tom, so it preloads premade text about tom in the description field. Also I want this field to be editable further if I wish to. How to do that? Thank you for your help!

First, here’s what I’m trying to do: I’m working on an inventory for my video game collection. I have some games that are collections of other games. For example, ‘Metal Slug Anthology’ is a collection of 7 different Metal Slug Games. I have a record for the anthology, and 7 other records for the games that it collects. I have one field to show which games the anthology collects, and another field to show which collection the games are a part of. So the anthology shows the 7 games it collects in the ‘Collects’ field, and the 7 games each show that they are collected in ‘Metal Slug Anthology’ in the ‘Collected In’ field. Here is what it’s supposed to look like: I’m trying to use an automation so that when a game is shown to be collected in another game, that game automatically shows that it collects the first game. That is, if I were to update the ‘Collected In’ field for Metal Slug 3, then Metal Slug 3 would automatically show in the ‘Collects’ field for Metal Slug Anthology. Here is

Greetings! I would love to anybody’s help with solving some not-trivial task for Airtable automation. I have long-text field with many words ( I do not know exact number of words, but all of them separated by " "). Is there any possibility to split this field to different words? This script for automation. When the form is submitted with long-text field, the script will create as much records as words in long-text field. Thank you so much

Scripting within an automation, I’ve tried a couple of ways but I can’t get the console log to output across multiple lines. As a work around I can use a table, but it’s kind of annoying that it’s collapsed, and I just want a few lines of console to appear; Any suggestions?

Hey all. I am trying to use Airtable to manage farming schedules. I’m trying to figure out an automation that would create an entry in one of four other tables, whenever I update a status on a primary table. Specifically, I have a primary table with all the seeds I am using, and one of the field types is a single-select with labels [Seeded, Transplant, Finish, Harvest]. I also have several scheduling tables that correspond to each of those labels. The idea then, is that when I set a seed status to “Seeded”, an entry for that seed would be created in the Seeded table, and so on for the other tables. Would a REGEX_MATCH formula work for this? I have zero experience writing up complicated formulas.

Hey, I’m new in Airtable and I’m trying to build a dating candidates data table. I store my record as (part of the data): full name, photo, age, height, phone, email, gender, pref_min_height,pref_max_height, pref_maxAge (the pref_ is what the candidate’s preferences) what I’m looking to do and I want your help if it can be done with Airtable + automation schedule + integration with Whatsapp / Slack: once a week it checks each record and checks his/her preferences looking in the table other candidates that match preferences. send automatically all the offers to Whatsapp(by phone)/slack message(by email) write all the candidates offers to new Airtable record called “candidates offers” if the candidate wants any offer, he needs to write the id of the candidate offered by Whatsapp (it should be chatbot) then it will write the new record in Airtable and send the user the offer phone number back to his Whatsapp. it a complicated app, so I’m trying to understand if I can do someth

Hello Airtable community! I would like to have an easier work with my tabs and no to think or miss something in future when its go bigger and im thinking about linking my data. I know ho to link some of cells collumns from one table to another and automate these two. But im not sure about this how to do that thibg I have database for my networking and different tables. Examples: general contact customers pre-orders, potentional customers in every table i have “last contact” to track when we spoke last time to to follow up. I wanted to link up this “last contact” which is created in #1 general contact with #2 customers and #3 pre-orders. If i change last contact in #1 general so it switch on #2 or #3 (depends who im communicating with) and also want to switch from potencional customers to customers after sale. so example. I have Michaela in generas. I started to talk with her about my product and but her in #3 like potential customers. (she is in #1 + #3). When i meet her later i chan

Hi everyone, I have a pretty simple base and need some of the records to recur daily. Right now I just change the dates on all of them at the end of each day. Is there a simple way to turn a few records into recurring records in Airtable without having to use another tool (such as Zapier etc.)? I’ve seen some solutions but they all seem a bit complicated and I hope there is a new feature that I am not aware of that could make my life easier now :slightly_smiling_face: . If there isn’t is there a least a way to select a few records and change their dates all at once? Thanks in advance and peace to you all, Keren

Hey there ! I’m struggling to automatically update some records that are in airtable bases. I’ve got a flow into a google sheet with clean url, that I would match to same url into Airtable (but those may not be all clean.) In Google sheet my urls are without “/” at the end In Airtable 80% of urls are with " / " at the end, 20 % not. Do you know how should I write my formula to search both case each time and update the record in question ? thank you in advance ! Will

Is there a way for an automation to grab the attachments from an Outlook email and add them when the automation creates a new record? Thanks.

I’m planning to automatically send an email to our customers if the Paid checkbox is ticked, so my trigger event is when the column for the Paid checkbox is updated but I am worried if I accidentally untick the checkbox and customers will receive multiple emails. Is there a way that I could create a warning pop-up that will ask me “Are you sure you want to proceed?” Thanks!

I’ve encountered this problem a number of times now. I have many automations set up for various projects. Seemingly randomly, some of my automations will rapid fire 10-20 emails to the recipients. These “runs” are not shown in the “run log.” It only shows that automation running one time. However, the email recipients receive multiple emails of the same record. It’s a huge problem for us, as we are using these automations to run projects for our clients and I don’t want to spam their email inboxes. Anyone else have this happen to them? I have tried changes my trigger from a “matching conditions” to “entering a view” with a specific filter. No luck. Again, it doesn’t happen every time, only with certain records. At first, I thought maybe it was if the attachment file was too big, but that doesn’t seem to be the case. Help please!

One of the bases we have created is to gather feedback from course participants. I have a form designed but the issue is that participants can submit feedback for one of a list of many facilitators. The hope was to be able to create an automation per facilitator so that their feedback can populate a Google Sheet row and then email them to let them know that they have received new feedback. We will definitely have in excess of the 25 automation limit though. The automation I created is intended to search for the specific facilitators name when the form is submitted and then populates their individual Google Sheet. Is there any way that I can create an automation that where I could combine and add in multiple facilitators? Would it work if I just added additional steps for Find Records with one each for each facilitator? As is stands, with the way I have built the automation, when the feedback form is submitted it doesn’t only populate that persons Google Sheet but actually puts the data

Hi community! Is it possible to trigger a built-in Airtable automation (example: Create a custom automation) when a button is clicked? Thanks!

Hi! There is event witn N amount of workers. I need to create a individual event calendar (or smth like that) for each worker form 1 grid or excel table. Is it possible? Note: all calendars need to be created automatically as there are 100+ workers

Is there a way to get some sort of confirmation when automation is executed without going to automation section and checking history? E.g. I have set automation that on trigger it fires email. I want table to show a checkbox confirm, when email is sent.

Hi all, I’m working on an automation : 2 tables : A and B Trigger : when an option is selected in a single select field in table A Running action : create a new record in Table B with all information of the record in table A => it works perfectly for all fields type except for one : attachement I’ve got pictures in an attachement field in table A, and I’d like this pictures to appear in an attachement field of the created record in table B but when I choose the attachement field in table B, i’m being asked to “choose a property” : I tried it all but I’m not getting my picture in table B. I’m I missing something ? Léo

Hi, I have a base that in table 1 has records created with Zapier. The records are applicants that have compete 1 or 3 onboarding forms Application Handbook Exam W4/I9 The primary field is the subject from the email that was forwarded to zapier For Example: “Fw: Application/John Smith” I have a formated column to extract the name “John Smith” This is what I want the primary field to be in Table 2 Complicated problem part When the first “John Smith” record is created in Table 1 I want it to be created in table 2 Normally this would be the record that has the application attached I do not want multiple “John Smith” records made in Table 2 When a 2nd record is created for “John Smith” I want it to be linked to the “John Smith” in Table 2 This part Ive mostly figured out with a linked field and automation Basically Table 1 is the raw table from Zapier and Table 2 needs to be the pretty formated table. The other problem my formated name cell isnt displaying the applicant’s name in the

There doesn’t appear to be an action step in Airtable Automations that allows for finding records by a search criteria and creating the record if it doesn’t exist. This can be done with Zapier, but I would love to be able to accomplish automations requiring this to be done with Airtable Automations. Is there a workaround that would allow for this? Perhaps using a script?

Hi there, I’m very new to js, Is there a way to fill a column with data from a row with a script linked to a button? Thanks!

This seems to easy to not have been answered somewhere; I must be asking the wrong questions. If I send an automated email which includes a column for “Last Modified Date” my column is empty, even when there is a date on the actual table. What do I need to do to fix that? Assuming that’s just one of the quirks of Airtable, will a formula field repeating the data solve the problem? Thanks everyone.