Automations

Hi everyone. Recently, one of Airtable users shared their Workspace with me. There is a base in the workspace with a lot of automations, and sometimes they fail to run.The workspace (and the database) owner receives emails saying, "Something went wrong with an automation..." but I receive nothing. Is there a way to fix this and allow me as a collaborator receive those notifications?

Hello! I don't understand why the linked field won't accept the value. What am I missing?  //Setup Startlet tableName = "🎵 Tracks"let linkedField1Name = "Composer(s)"let linkedField2Name = "Producer(s)"let compiledLinkedFieldName = "Contributors (-mix)"//Setup Endlet {linkedField1Values, linkedField2Values, recordId} = input.config()let table = base.getTable(tableName)let compiledObject = new Object;for (let record of linkedField1Values){compiledObject[record] = recordIdconsole.log(record)}for (let record of linkedField2Values){compiledObject[record] = recordId}let compiledArray = new Array;for (let record in compiledObject){compiledArray.push({i

We very recently hit the limit to the number of automations you can have in a base, but we still have a laundry list of automations we would like to create.How do you all handle the limit put in place on a base? Is there any creative solutions out there? I was thinking of maybe moving some tables off into another base, but then I would probably hit the 10 table sync limit in our base too.Use the API? But how would triggers work? 

We need to create individual customer forms that they fill out that populates their specific products. ( A filtered view that only displays their products.) I got the form to properly populate responses in our base to the respective customer.The problem is that Fillout requires a unique record id that gets pasted in their grid view to populate that data correctly.  Because its connected to a base with all the customers, pasting a specific fillout.com customer link will populate in the entire base, causing the form to override the last customers data. We have one base containing all of the customers, with individual grid views for specific customers. Pasting this link into a specific grid view will of course appear in the master grid view as well. What are my options? Does every customer need its own tab for fillout to link to? Or is there a way to paste Fillout record links to individual customer grid views without overriding the entire base?

Hello Community,I've made a script in an automation and some part of it doesn't execute and I can't figure out why.In the script below, the "if" test is pulled so I can't find "11-OK" in log but directly "13-END" (I've put an always true condition only for testing purpose). Could somebody tell me why ?Thanks in advancelet clientTarget = "";let salonTarget = "";let totalCommandes = 0;let inputConfig = input.config();let subtotal = inputConfig["subtotal"];console.log("1-subtotal: " + subtotal);let total = inputConfig["total"];console.log("2-total: " + total);let client = String(inputConfig["client"]);console.log("3-client: " + client);let salon = String(inputConfig["salon"]);console.log("4-salon: " + salon);let table = base.getTable('Client-Salon');let query = await table.selectRecordsAsync({fields: ['Client', 'Salon', 'Total Commandes']});

Hi. Im having two issues with automations. Thanks in advance for any help - Michael1. My automations only run when a new or matching record is submitted through a form. If I do so on the table itself which the trigger is set up to monitor for either matching or new records, the automation doesn't run. Am unclear why?2. My automations for matching records will only run on new matching records (submitted through a form) and not on all the matching records on the table. What do I need to adjust? Thanks again!

I'm not exactly sure on the best way to go about doing this or if I am posting this in the correct location. I want to send a text message to a group of employees about upcoming open shifts. I have the employees in a table and i have the upcoming shifts in another. I am able to text individual employees a standard message now. I am not sure how i can add the open shift date to the message and then pick which employees i want to send the message to and have the date added into it as well. The employee table and the shifts tables are linked. Right now i am able to send the message with an automation that is sent by a button in an interface I created. maybe it isn't possible or maybe its super easy and i am overthinking it. Thanks for any help in advance!

Hi everyone,I'm very new to Airtable and I'm trying to get an automation to check a column called "Vehicle Registration" and a column called "VIN No" and if either of these two columns match with an older record, both the new record and the old record are either highlighted as duplicates, or a column with a checkbox is automatically ticked to show it's a duplicate record.What would be the best way to go about this?Thanks in advance.

I have set up an automation to send client creatives for approval, which allows them to update the database with either an 'approved' or 'denied' status. However, it appears that they need to create an account to do so. Is there a way for them to approve without having to create an account? Thank you. 

Help please! I cannot figure this out. (I thought I'd posted this earlier but it doesn't look like it went through....)I have about 5000 people in a base and I need to send individual emails to them, so 5000 email messages total. The emails will contain a link to a form prepopulated with a couple pieces of their individual info, and I need them to update their info using the form. I had everything working but apparently overlooked the possibility that somebody would limit the number of these emails that I can send. I don't know whether the problem is with Airtable, or Gmail. The Gmail account being used is a Workspace account (not a free Gmail.com account). What are the limits for this sort of thing and who are they imposed by? Is this something I just can't do? If so, what's my alternative? I need this ASAP so be grateful for any help. William

Hi, im trying to create an automation that will move data from a field with a formula to another tab whenever a trigger is activated, but for some reason, i get this error - “Fields” could not be converted to a string. can somebody help solve the mystery? Thanks, Liran

I am attempting transfer checkbox data from Webflow form using checkbox fields for multiple selects it returns a value of TrueTrueTrueFalseFalseFalseFalseFalseFalse via webhook what is the best approach to convert the true false value to multiselect - Thank you 

Hey All, I'm getting an error message about the Record ID when the IDs are the exact same. All automations are failing with the note "Record does not exist," yet the trigger is succeeding with the same Record Id. Photos below show the failing automation message and matching record Id from the trigger.   The Automation itself is based on formula fields which are populating correctly- photos below. If the Created Time (field) is within a certain Quarter (formula)- then update a single select field in the same record. I have this in 3 tables and for 1 everything is running correctly but for the other 2 everything is failing. Any advice before I submit to Airtable as a bug/glitch? 

I'm working with a Kanban view where we drag action items into Today/Tomorrow (single select) options. I'm currently assigning dates manually, but I'd like to automate this - so that when someone drags an item into the "today" pile, it automatically gets today's date. I don't think it should be a formula (because that would automatically change dates on items that have been done in the past), but I can't find a way to automatically assign a date dynamically (today's date) with an automation. (but there must be a way, right?)

I have created a script to delete  a record but it is giving me an error. Here is the code: console.log(`Hello, ${"300 Replens"}!`);let table = base.getTable("300 Replens")await table.deleteRecordAsync(input.config()['reckUma1c1NLjQADd']); Here is the log:CONSOLE.LOG"Hello, 300 Replens!"ERROR

Hi, I have a Make scenario setup, but it is not pulling through any data to Airtable. The Make scenario is attached and is very simple; it Watches for items in Podio and then Creates Records in Airtable. I have set up the link between accounts a few times to double-check that everything is working. I've continued to run the scenario, and it comes back with no errors or warnings, but when I refresh the Airtable page, no data is being pulled through. Any help would be greatly appreciated. 

I have two automations in question.  The last time they both ran successfully was September 26, 2023 at 4:43pm CDT, and now neither work as of today.I'm not sure if its some strange permissions thing or an internal limit? Or was there some sort of update that may have nullified some function that I was using?Both Automations concern making records, both revolve around the same main trigger (one actually waits to verify the first record is made before the second record is made).The first record automation just does not want to run it seems. as per the screen shot, it was working 2 days ago with no issues.When testing, first it said it lacked permissions, so I changed the receiving table's permissions to open.  Then it said it couldn't enter information into certain fields because it was a computed field (the table it would be making the reco

Hello, We are struggling to extract the first image of a column called "photos" then re-upload it in another column. We tried to do it by having a formula to extract the first attachment url (which is working) : (IF(BLANK(photos), "", MID(photos, FIND("(", photos) + 1, (FIND(")", photos) - 1) - (FIND("(", photos)))) Then, using the following automation to upload it in our target column "1st_photo" :=> WHEN a record match conditions "photos" isn't empty THEN update the column "1st_photo" using the url from the formula column as input. However, this automation isn't workingI guess the issue come from the attachment url. Do you have any idea to handle it ? Does it require a script ? Thank you very much ! 

Is it possible to create an Automation so an email send 2 days after record updated?

We're a real estate company looking to have Airtable Automations help us get client feedback on properties we present. Ideally, the process would look as follows: We add properties to an airtable base Once status is changed to "pending client feedback", an automated email sends the property information to the client. I'd love for that email to be able to solicit client feedback via button/checkbox/text field, for instance client received 123 Main St and did't like it they could have the option to "reject" (via button or form?) which would update the record in AirtableIf they liked the property, opt to "like" or "shortlist" the property which would update the record and trigger additional notifications to our team that the client wants to tour this site. 

I've seen great docs and help for this for MS Excel on Windows.. but MS has not released the Power Query Editor for Excel on Mac.  Has anyone successfully done this, using any hack or workaround? TIAGary Wong

Hello,I am stuck at automation and would highly appreciate help with the issue.I have the tables:Projects (linked to operations),Operations (linked to projects, stakeholders, products, accounts),Stakeholdersand Accounts. What I am trying to do:If you create a project, I want to create several rows in Operations table (with template) - one for revenue, several for fixed costs.But I want to input the Stakeholder and preferably product, when adding a new project.Scenario:1. Add project (project name, stakeholder)Projects Table:Project NameStakeholderTEST1X2. Template created one row for Revenue and several rows for fixed costs in Operations. What I want is to fill in the same stakeholder for Revenue ent

I am new to Airtable.  I have a base of speaking engagements.  I want to send an automated reminder to my boss when the engagement is 5, 3, and 1 day away.  I am able to get it to work the first time but I can't get it to know that the time is getting closer.   From what I read, DATETIME_DIFF used with NOW() doesn't update daily.  How to get this to work?

I have a base that I use for onboarding new users. New records are created via a fillout form. I want to create a linked record in my Agents & Staff table, as well as my phone directory table when a new record is created in onboarding. I know how to link to an existing record, but I am stuck on creating a new record and linking.

Hello you wonderful people! Small roadblock I've encountered that I am hoping someone can help with. I would like to use Airtable for our team to record meeting notes. When a new record is created in that table, it would be great to have some text pre-fill, much like in the manner default values can be assigned to some Field types. Since the default option (as far as I can tell) doesn't exist for Long Text Field type, I figured I would use an automation. I tried a simple test. I tried to get the automation to produce rich text entry, or even multiple linesEven using markdown, I was not able to get more than a single string of text to appear... ie it looks like this on my best efforts: **Action Items:** <br> * 1 <br> * 2 <br> * 3 The Goal is to have a