Automations

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.

I have an integer from Airtable going to Zapier to use as a filename for a PDF, but the file that comes back to Airtable is named “20201140719%EF%BB%BF.pdf” instead of “20201140719.pdf” It’s some kind of UTF-8 Byte Order Mark or something. I thought it might be a hidden character in the text field in Airtable, so I converted to an integer, but that didn’t fix it.

I am having trouble getting this automation to work. It’s almost there! I have a monthly task list, and after I complete the task for the month, I want it to re-appear with the new due date. Example: “Give dog her medicine on 10/1/2021”. Frequency = 30 days. Once task is complete, add new task for “Give dog her medicine on 11/1/2021”. I have everything working except the date. Can anyone help? I’ve recorded what I’m doing so you can see. It says “Could not convert string to date.” but I cannot get it to work. Thank you!

I have some formula column fields with the following syntax: column_1: checkbox type column_2: formula type with IF statement Everything is working as expect and I see as table results the desired emoticon if is checked or unchecked. The problem occurs when I add those records as grid in the Airtable email automations. I get empty grid values in the email where these formula column fields with the emoticons result don’t show anything. Can anyone help me out to understand why and how to fix this weird behaviour?

Hi So I’d like to create an automation that sends me a list of items off of my airtable but in a pre-formatted way. Currently, I can send an automated email but I have only two options which is list or grid. This is ok for displaying items but it’s not ideal. For context I’m recording coverage from media websites. I can collect this in a grid format but I want to display it in a much more intuitive way. i.e. the end result should be something like News Headline (News Source - xxx UVM’s) - Article Summary Is this something I can do directly in airtable or via a script?

Hello Everyone, I have tried watching some videos to no avail… I have a CRM base with many tables. One is [Leads] which I populate with as many different fields as possible to qualify the company. Since I take the time to populate many fields, I then dig into the company and decide if I want to pass them along to sales but I do not want to loose the history of companies I have researched. So I have a pass/fail check box field that is filtered so only the pass appear in that view. I have this table linked with [Sales] so they can enter into the linked field and simply “pull in” leads from the [Leads] table from the + POP Up window. What I would like to have happen is when the sales team brings that record into the [Sales] table it “disappears” from the [Leads] table so it is no longer available. I would prefer an updated field action in the leads record so it can be filtered out of view! I have run a successful TRIGGER in the [Sales] table view by using (when record enters view) or (whe