Automations

I am trying to hava a base or table that keeps track of all of the visible fields in a view, and I want this to be done automatically whenever a fields is added, removed or it's visibility is changing.  We have more than 30 views and more than 30 fields.  I am getting this error, whenever I try to run the following code.   let table = base.getTable("Master Product List");console.log(table)let recordId = input.config().triggerId;let records = await table.selectRecordsAsync();//let updatedRecord = base.getTable('Master Product List')let updatedRecord = records.getRecord(recordId);console.log(updatedRecord)let viewNames = [];let views = await table.views;console.log(views);for (let view of views) {  let queryResult = await view.selectRecordsAsync();  let recordId

Hello everyone! Are there any Automator document users here?I'm trying to create a document that picks up fields from a find record from a view to put into a Google Docs, except the layout is not respected: the \n line break character in Airtable does not seem to be recognized: do you know how to make a line break as in the Airtable view?Line breaks are coming from a ARRAYJOIN({Lookup},"\n")Thanks for all your advice!

Hi, Is there a script that will generate a Unique ID for each image that would ideally be the concatenation of other fields like Initiative Name, Project Name, and then some random value?  While the image has a name, creating Asset ID's automatically would help organize and ensure we are working with the correct creative asset. 

I’m following up on a previous solution ScottWorld provided for another user. I apologize if there’s a better way to link to the old closed post. Anyway, the goal is to Automate the END TIME based on START TIME, and DURATION. The formula Scott suggested was: DATEADD({Start Time}, {Duration}, ‘minutes’) When I put this Formula into the END TIME formula field exactly as is, and the DURATION field empty, the END TIME is automatically set to 5 hrs after the START TIME. When I enter “3:00” (3 hrs) into the DURATION field, the END TIME is automatically set to 7 Days and 20 Hrs later. Obviously, I’m misunderstanding something.

I want to set up various automations with reminders (slack messages) or updates for the team but not spam them with an overload of updates.So far I only found how I can trigger Slack messages for a certain trigger but I want to avoid sending a message for each trigger.How could I "collect" all messages for one user and only send them a slack update e.g. once per day/week, with every update this person was mentioned in or task status changes that are relevant for that person?Thank you very much 🙂 

Hello Airtable Community! I'm working on a special project for a content calendar within Airtable. There are 4 tables in play: The master calendar table and 2-4 tables to individually view the content being planned for each platform. The master calendar is serving as a master view of ALL communications going out, but the individual tables are being used to plan the specific content. I am working on an automation that will create a new record in the corresponding individual platform views from the master calendar. The problem I'm running into is that I would like that new record to be linked to the original record in the master calendar. So that if changes are made to the record while viewing the individual platforms, it will also change within the master calendar table. I hope this makes sense, been struggling for the past few hours. I've attached a screenshot of what the tables look like. 

I am confused with how to set up the Repeating Groups feature and how to make it work the way I want to.My AirTable table is a list of many records that are assigned to different employees.  I created a View for overdue records (each record has a due date). I want to create a repeating automation that sends out an Email to each team member with a grid embedded in the email of their outstanding records at various times around the due date. I am confused as to how to make this work so that each email to a team member shows a list of only their own assigned records.I believe that this structure is definitely not going to work the way I want to because when I put in the grid from the "Find Records" action, it shows the entirety of the list. See this: What exactly am I doing wrong?  I created a table just for the staff and have it linked to the other records. But I don't want to send out an email for each record, only for each team member, and it should ea

I want to change single select field (named "Status") let's say from "status A" to "status B" of a product when the checkbox field (named "Checked") in checked. Both are in the same table.I already try it with automation but the error appears. What am I doing wrong here?  

Hey all,I am stumped and looking for some help. Here's the situation; I have linked record called subgroups (a string with an integer i.e. Pacific 6) that will be occasionally updated when the person is moved to a new subgroup. I want to keep a running record of each group a person has ever been in, so if they are in subgroup X, then moved to subgroup Y, then moved to subgroup Z, the record keeping cell would now contain "subgroup X, subgroup Y, subgroup Z" but I cannot figure out how to append the new information each time a record is updated instead of replacing or concatenating with just one other record. My automations keep failing but I am really green with automations so I'm not sure if it's even being built correctly.So far, I've tried the following:Using a formula with a change trigger in the form of a I/O single select and reference cell with the original group (called orig) - IF( Select ="Changed", Subgroup & ", " & Orig)​This just leads to a record with the orig

Hello, Quite new to Airtable, I have an issue with an automation.We are a non-profit that coaches People, who create Projects. We have a directory table called "Annuaire" where all the People are, a Projects table where we list the Projects and a Prospect Projets table for people who may be interested in our courses. The prospect table has a form, so people can enter their info by themselves. To keep things simple, the Prospect table has info related to the person (which would go in the Directory table) and the project (which will stay in the Prospect Projets table for now). The automation I have in mind is the following : 1. When a record is created, the personal information create a new record in the Directory table2. It updates the category (but that part is not a problem3. Then, the created record in "1" is updated to link the Prospect Projets to the "Annuaire" field in the tableI've tried the following automation : But as you can see, I

Hi everyone!I'm trying to create a simple automation to send notifications on a specific Slack channel once action X occurs. PROBLEM: when I try to connect my work Slack account, Airtable tells me that "the selected account is not valid or no longer works.". ⚠️It doesn't work with my company's Slack workspace but it works with my personal Slack Workspaces.Has anyone faced the same problem at any point in time? Or does anyone know how to fix this issue/ a workaround?⚠️It works if I use a 3rd party tool, such as Zapier or Make/Integromat but I can't use this type of tools for the project I'm working on. It must be a direct integration between Airtable and Slack OR a workaround that doesn't require 3rd party tools like the ones mentioned above - for instance, webhooks or writing a script?Thanks a lot for any advice and help.

I know this has been asked many times in march/april this year, but I’d like to know where we stand on this. I want to send a weekly digest of upcoming events, using a grid or list view. However, these events are always sorted from “newest” to “oldest” (i.e. the event I created last is on top). The same goes for the order of the columns in the grid by the way… Would it be so hard to add a sorting option to the “find records” flow block? Or at least keep the sorting that is used in the “view” that is selected for the “find records”??

(Thank you in advance! I swear I've tried everything I could find here and no luck)I'm running a (successful) Create New Record automation from a Synced table, so my teammates can use the source data to develop their own additional work (but not adjust the source data itself). Yes, it duplicates a record -- but it's the only way I can deliver the starter content and let them build on.Next step is to run an Update Record automation, so when:Source data record is updated, thenMatching created record is also updatedTrigger (successfully finding the updated records in Source data) & Actions ("received invalid inputs") screenshots attached.

I have an automation that triggers at midnight every night. It runs a Find Records on a table with a date field, looking for dates that match "Yesterday." Below is a screen cap of the trigger going off at the right time/day (7/15). It should have pulled a record made on 7/14 (which I have confirmed exists and matches all of the other requirements for the lookup). I'm worried that the record "created time" is in PDT but that the lookup automation is in GMT, and therefore is puling the wrong date? Timezones always feel hazardous to automate around, so any insight or best practices advice would be so helpful! Thank you! 

Hi all,This is my first time in the community so I am learning as I go forward 🙂I have 9 bases for 9 different countries that have their own data and interfaces. However, I want to have these 9 bases synced into one base which I did using the import from airtable and sync function. The problem is joining these 9 synced bases in one table. I tried scripts, I tried automation based on time to create new records (still facing major issues with this) and the main problem is when it comes to updating the info in the main table with the 9 synced bases. Since airtable creates its own records ID, I am not able to do the updates because whenever airtable creates an ID and then you copy it to another table the ID changes.Regarding the scripts, since we have info linked between tables, drop-down and check boxes in the tables the script is not able to do the required copy or update.Any idea how to work around this?Thank you for your help

We've been using the following script for about a year now with no issues // Get Input - Gets record ID of updated record can then get info like rid.uei let rid = input.config(); let apiKey = 'XXXXXXXXXXXXX'; // Make the request let ueiData = await fetch(`https://api.sam.gov/entity-information/v3/entities?api_key=${apiKey}&ueiSAM=${rid.uei}`); let ueiResults = await ueiData.json(); // Output the data for the next action output.set('ueiResults',ueiResults); For whatever reason it stopped working this week. When I put the URL directly into the browser it still returns the correct information. It's only when we try to pull the information from the script that we received the following error: Error: request to https://34.199.241.198/entity-information/v3/entities?api_key=XXXXXXXXXXXXX failed, reason: write EPROTO 80DCB8B1417F0000:error:0A000152:SSL routines:final_renegotiate:unsafe legacy renegotiation disabled:ssl/statem/extensions.c:893: at main on line 7 Any id

Thank you for considering to help me! Here's the process I'm trying to create:A new record is created via a form which will have a start and end date (i.e. 7/3-7/28)Based on the timeframe (above), I would like to set up an automation where additional new records are created (within the same table) for each week within that timeframe. (i.e. a new record with the dates 7/3-7/7; another record with the dates 7/10-7/14; another one for 7/17-7/21 and the last one for 7/24-7/28). There will be other fields that I'd like to copy from the original record as well. I'd like to avoid a script and just use formulas and automations, but am open to a script (although will need help writing one!) if that's the best/only option.Thank you!  

Hello guys,I'm trying to create an automation that:When a new record is created -> Compare "E-mail" field with existing records -> If true, do something.The issue I'm facing is that: The automation is comparing the email to the contact being created instead contacts already created and always return "True" obviously.I'm I doing something wrong? Or is there any way other way to achieve this? Thanks in advanced

I have a problem using Automation to create a link between records in two tables.I have Table A and Table B.  Table A has a link field (’Link-A-B’) to Table B.  Table A also has a Form to create a new record in its table.  The form requires user to choose an entry into the Link-A-B field.  If the user selects a particular choice for the value, then the Form exposes another field in A (‘New Option’) that the user is required to type a value into.  Upon submission of the Form in this case—with a non-empty value in the’ New Option’ field—  an automation is triggered to create a new record in table B, and to enter the value of ‘New Option’ in A into the primary field in the new record in B. All the above I have working just fine in my Automation so far.  But the next action that I want to subsequently have happen in my automation is to change the link value in the Link-A-B field in the new A record: From what the Form user had selected, To a link to

Hi, I have a list of people with different positions and locations. I would like to create groups of these records like: * All the people who work in Sales * All the people who are located in EuropeAnd I can give it different parameters and it will sort by the different groups. >> I don't want to create all the groups beforehand. Meaning, I don't want to give it a defined list in case there are job titles or cities that aren't in my list. << Can anyone suggest an automation tool to do this? 

I have one table "Companies" it is related to "Campaigns". When I send a Campaign to a Company I want to batch or else automatically link the Campaign to the company.I see that linked records are not part of the batch Update extension. Example:I create a view of Companies that's 100 records.I have a Campaign that's "Direct Mail Piece 1"I export that list and send mail to those companiesI want to show link these 100 Companies to the Direct Mail Piece 1 Campaign so I know which companies have received which marketing.How can I accomplish this?Thanks!

I have an automation that will email a specific person when a record enters a view. The view is looking for a status change. Once the status has been changed a field is populated with the user that changed the status. As part of my automation, I’d like the person who changed the status to be CC’d on the email that will be sent. How do I get the email of the AirTable user to auto-populate into an email field?

I need a field named START to gather data from other domains, including dates.Why is the game development date being removed?SWITCH("Stage," IF ("Stage"="READY FOR GAME DEVELOPMENT,"DATEADD("GAME DEVELOPMENT,"'', "DAYS,"If the stage is "READY FOR CREATIVE DESIGN," the date add is "READY FOR CREATIVE DESIGN," the date add is "READY FOR PRODUCTION," and the day is "DAYS."

I am trying to delete some records from a child table when the parent record is removed. To do so, I have created a view on the child table showing records where the parent link field is empty. On my automation, the trigger is set to be when a record enters that view, the automation fires.  The automation is firing but I get an unexpected permission related error I have not seen before. I am the workspace owner. I can manually delete rows in the UI. This seems simple....what am I doing wrong? I have other delete automations that are still working fine. Error: You are not permitted to perform this operation at main on line   Code is below let table = base.getTable("tablename")let inputConfig = input.config();let recordId = inputConfig['recordId']await table.deleteRecordAsync(recordId);

Is it possible to get the previous value of a field to compare to when you have an automation trigger because of an update? I am thinking the only way to do this is to hold the old value in a hidden field and then update the hidden field after you take care of whatever you needed to take care of. I think the only issue is a person can make multiple updates to a field before you ever finish the automation so your previous value will be out of date if an update occurs before your first script finishes.