Automations

I am trying to map this formula field into a date field in an automation. However, the automation cannot display the date, and I cannot add DATETIME_PARSE to this IF formula. How do I automate adding time to a date field?P.S. I cannot just use a lookup field, because I have tasks being created from other tables and they all use the same Due Date field, which is tied to further automation down stream.

Hello!I have an automation set up that when a record enters a view, a script is run to delete the record. Almost every time it runs it throws some failure notices and I get multiple notifications from Airtable. But, it seems to work though. All records are deleted from the view when it runs. Usually there are only 20ish records that enter the view at a single time. And if I watch the view the records will disappear usually in under 10 seconds. Yet, I still receive the failure notices.Here is the script.  //Identify the table you'd like to delete records from let table = base.getTable("🗹 Checklists"); console.log(table) //Identify the view you'd like to delete records from let view = table.getView("⚙️🅰️ Delete Records View"); console.log(view) //Select the records that you wish to delete let recordQuery = await view.selectRecordsAsync(); let recordsToDelete = recordQuery.records; console.log(recordQuery.records) //Delete records for (let deleteReco

I am attempting to create an integration between RingCentral and Airtable by registering a webhook on RingCentral that will be triggered on specific events (such as receiving messages). The endpoint I want to use is hosted on Airtable, and I am using RingCentral's Subscription API to create the webhook subscription.Details: Airtable Webhook URL: The webhook URL I want to register with RingCentral is https://hooks.airtable.com/workflows/v1/genericWebhook/xxxxxxxx [Truncated the URL for privacy reasons].RingCentral Subscription API: I am utilizing RingCentral's Subscription API to create the webhook. I have provided the eventFilters that are relevant to my use-case and specified the transportType as WebHook.Error Encountered: When I attempt to register the webhook, I receive the following error message: "Error status: 400, Error message: {"errorCode":"SUB-522","message":"WebHook responds with incorrect HTTP status. HTTP status is 400","errors":[{"errorCode":"SUB-522","mess

Hi I'm brand new to Airtable.I am building a database for tracking which assets our staff have.I have 2 x tables: People and ComputersThe value in the login.name field in the People table is the same value in the Last User field in table Computers.I have created a Computers1 field in People that links to Computers, but I have to click and find the computer in each record.given I have matching data in both tables, how do I automate getting them Linked?

We interact with multiple Utility Companies (Water, Electric, Gas from different cities and counties).Is it possible that when I select a Utility company, the contact information auto populates in another field (Separate Single Line Text Fields or a Long Text Field)?Thank you.

Hi,I'm trying to find a way to do the following, and I hope someone can help! I am not Airtable savvy, so any help is appreciated.I have a form that our customers fill out if they have damaged product, data goes into tab/table "Damages Info". They input information, two pieces of info being the CPO and SKU.I have a table synced to the base that contains all order and product information (tab/table Tracker).When a form is submitted, I'd like for Airtable to automatically look at the SKU and CPO that was submitted in 'Damages Info" table, find the line item in the synced "Tracker" table with the same SKU and CPO, and then auto populate several fields in the "Damages Info" table with the info from the "Tracker" line item.Is that possible? Loom link here. https://www.loom.com/share/73f641df472346ea8ab59fad20b0b2d5?sid=0976a088-2169-4f5e-ba39-16db16d043c2Thanks! 

I have a field called ID, and it's an autonumber field.  I cannot get it to display in my email.  I've tried creating a formula field with it, too, with some prepended text and tried adding &"", too, which was suggested somewhere.  I can add the Airtable record ID with no problem and other formula fields and have them included in the text of the email.  But anything I do with my ID field will not show up in the email.  The test data does have an ID in the ID field and a value in the ID Text formula field.  Any help will be greatly appreciated!

Hi all,I'm somewhat new to air table automations and I'm trying to figure out a way to complete this task:I have two tablesRevenue Plan (applicable fields: Week Starts [Date], Week Ends [Date], Week [Formula])Promotion Calendar - PM (applicable fields: Date Start [Date], Revenue Week [Reference])When the user fills in a record with a Date Start on the Promotion Calendar table, I'm wanting it to automatically add a reference to the record in the Revenue Plan table whose range of dates encompasses the date entered.For example: if the start date in Promotion Calendar is entered as 8/10/2023, it should link the record in Revenue Plan that contains the Date Start: 8/6/2023 and Date End: 8/12/2023.What would be the simplest way to accomplish this task?

Hello everyone,I am experiencing a problem with my automation that connects a Google Sheets document to an Airtable master table, using the Airtable record ID as the primary key. Typically, this setup functions correctly around 70% of the time. However, occasionally, the automation fails, presenting an error message indicating that it has received "invalid inputs".Upon investigating these errors, I've noticed that the record ID associated with the failure is valid, as I'm able to manually copy it and locate the corresponding record in the Airtable master table. This leads me to believe that the issue may not be with the IDs themselves.I'm unsure about what might be causing these intermittent failures and would greatly appreciate any insights or suggestions that could help me troubleshoot and resolve this issue.Thank you in advance for your help! 

I have an automation that won’t turn on despite working correctly the last few days. It’s set to create a record when a row is added to a google sheet. Both the trigger and action pass their test, yet the automation won’t turn on. What could I possibly be missing?

Hello,I try to import and upset data from BigQuery to an airtable table.I use Skyvia or Make and the first import works fine....My problem is the Upsert case !When I run a new import, the record are duplicated and not updated.First, is there a method to compare the two base and write only the new record in airtable?Second, is there a method to compare the two base and update in airtable only the modified record from bigquery ? May be do i have to script that in an automation ?Thanks for your help !

Hello,I don't know how to perform the following query in a Script code:1. I have a table A of records with field short URLhttps://my.url/path1https://my.url/path2/path32. I have a table B of records with field long URL (like https://my.url/path2/path3/path5?x=y )Given a record from table B, how can I find all records from table A that have a short URL starting like the long URL ?Should I iterate on all records of Table B and check if shortURL indexOf my longURLI can't short/cut my longURL then query Table B (because I don't know where to cut)May be there is an AirTable formula? that check if record's field is part of my longURL ?Thanks

I have 2 tables in my base . Table 1 have multiple records while table 2 only has single record . Table 2 has a field (lets say voucher)  with data type number. Whenever a new record is added in Table 1 ,I would like to Increment the value of a field (voucher ) with 1.

Hi there, I have been searching heavily for some help on what I'm trying to achieve but haven't had any luck. What I am looking to do on Airtable is have an autogenerated number for each line item I add but it needs to have a prefix of 6700. It also needs to start at a specific number, lets say 67006789. Is there anyway to do this? 

Hi everyone, I am not sure if what I'm trying to do is even possible, but hopefully it is!I am improving my office's Airtable and I have two sheets, for simplicity we will call them "Places Sheet" and "People Sheet" (these are what the records under each are). Under the People sheet, I have a column where one or more Places are linked when relevant. Now, I would like a column in the Places Sheet that shows me which People (ideally through a Linked Record) have that Place as a linked record on the People Sheet. So, in effect, when Record A from the People Sheet links to Record B from the Places Sheet in a specific field, Record B also links back to Record A.I could go through and do this for each individual, but some People have more than one Place linked to them, and there's well over 1000 records under the People Sheet and over 300 records under the Places Sheet, so I'm really hoping I can automate this process.

I have an automation where I first create a list of records and sort them by priority, then I put them into a repeating group to run scripts on them one at a time. But, it seems as though the repeating group will run those functions with multiple items being processed at a time, not one at a time.  Is there a workaround so that I can process the items within a list one at a time in the repeating group? Thanks! 

I would like to use automation, to look for a matching bank statement, related to a payout. In english terms, the automation would be something like this:When Payout with Payout Date is at least 14 days agoThen, Find Record in Bank Transactions where Date is after Payout.Payout DateFor number fields or text fields, there is the little gear icon on the right which allows you to set dynamic variables. It seems this is not available for dates.See screenshot below. Am i missing something? Why would this not be available for dates?     

Hy, friends! I was trying to create dependent dropdowns using the “If a record matches the conditions” then “Find Records” automation. I can’t do it, maybe I’m doing something wrong? Can anyone help me or explain the essence of automation?

I'm doing a read-only base to give to others as a template and I noticed my automations don't transfer when they copy the read-only base. Is this right? Is there a way to make sure they cross over?

Hi,I have a table where people insert new records through an Interface, one of these columns needs to be unique.My issue is that i cannot stop people from inputting the same data by mistake through Airtable's Interfaces (so for example they need to fill the form  with "12345", but they write "21345" by mistake, and "21345" is already there in the database), so i want to catch this duplicate's existence afterwards by sending an email and performing other operations when it happens.Do you know if this can be done?

Hi,I created a base linked to a form that insert records. When a record is inserted or updated in my base, some automations are linked to perform actions. Everything worked fine till two days ago, now the trigger of the automations does not activate and actions are not performed, but they work fine when I do manual tests.Can someone help me? I have a free plan but all the things I use are included in that plan

Hi. I couldn't find any specific information related to this. We are currently looking into possible options to conver a Google-Sheets based system to something more thorough.  We want to make sure we do not hit any walls later on in the future, once the system starts to grow. For the Pro plan, there is a 100k automations limit per month.  If you perform automations outside of AirTable, using Make or Zapier, for example watching rows and then updating rows based on certain conditions - would these count towards AirTable automation limit? My intuition would tell me no, but I would prefer to be certain about this - as that way I know we always have a plan B if we hit the limit.

Hey, Is it possible to rate one record multiple times (1 collaborator to rate same recordmultiple times), and later on to show an average rating? And to do that with multiple collaborators? For example, restaurant review, Can I rate the same restaurant multiple times, and calculate the average rating for that particular restaurant? And that average rating to be a combination of multiple different ratings from multiple collaborators. I’m not quite sure how to do that… Thanks

I'd like to set up an automation to send an alert when two records have the same value in a date field.For example, Record A has a date of August 6.  Record B has a date of August 7.  Then the date of Record B changes to August 6 (same as Record A).Can someone please tell me if this is possible, and if so, how?

Hey guys,I have a lot of blog posts that I am trying to showcase on my website but I don't have the room to store them in the webflow CMS since I use CMS for a lot. I would like to avoid upgrading the website plan as my blog posts will eventually out grow the limited amount of CMS items webflow offers anyways. Is there anyway to view my airtable CMS items to my website WITHOUT storing them in the webflow CMS?Thanks!