Automations

Airtable automations have stopped working altogether for me. The Automations worked perfectly fine uptil 27th of this month(Screenshot-1 attached) but all the of sudden it stopped working(Screenshot-2 attached). I have checked all the conditional formatting and also ran a test for automations and it works fine during test but it gives error in real time automations.  I have not changed anything in the automations and I have also checked that I have not ran over the automations run per month count but it stopped working for me. Is anyone else facing the same problem. Will be grateful if someone helps me sort it out 

Hello everyone,I did a trigger "When record is created" and script action where i want to get the record id to be able to update the record and all stuff. To do it, I'm using input.config() but not doing well in input variables. As shown in the picture, I've created an input variable named recordId and the value should let me choose something like "Record (from step 1)" that should be the record id of the trigger. I've never used this before and I'm a bit lost. Thank you all in advance.  

I can't understand....All my automations dont work automatically.Here is an example:Trigger:When an entry matches the condition.Completed search fieldsIf everything is valid, then update the field of another table.All the tests work, manually it updates the fields, but never automatically.I tried to change the trigger by:When an record is createdAt a certain timeNothing happens. It never fires.I have no errors in the tests, and I point out again, I have no errors, the entries were intentionally created in order to match to obtain a result.I deleted all the automations I had, completely recreated the tables to start from 0 in order to find why, well it's still the same. And the reslut of the test : Same result for all triggers. I didn't forget to update the automation... I don't understand anymore. Especially since it worked 15 days ago when I created this same automation.If you have a suggestion, I'm interested

Hi community,I'm struggling to understand why this whatsoever perfectly working tiny piece of script stops doing so when (seemingly) the 'start' date and the 'end' date are not in the same month.I am rather new to Airtable script editor so I couldn't find a step-by-step run mode, or a variable value watcher, but it seems that the 'days' variable is not computed correctly when 'start' and 'end' belong to a different month (for instance, 2024-07-15 and 2024-08-07 - however works perfectly with 2024-07-15 and 2024-07-31, and then 2024-08-01 and 2024-08-07)... leading to not entering the 'for' loop at all.Any clue anyone? Many thanks in advance!  let table = base.getTable('Man.days'); let inputConfig = input.config(); const start = new Date(inputConfig.StartDate); const end = new Date(inputConfig.EndDate); const days = end.getDate() - start.getDate(); var date = start; for (let i = 0; i <= days; i++) { let record = await table.createRecordAsync({ [

Dear All,Newbie here! To simplify our current workspace, we would like to duplicate our main base (let's call it A) and delete any entries in the duplicated version (B) with a deadline after June 2023. B will be used as archive for our past work.Then we would like to run an automation in A to remove any content with the deadline set till June 2023 (so we are only using what is for use " current content")This is a one-time automation; we do not need it to run multiple times. How can I set up the script for each scenario? Thank you in advance for your support and guidance, Best regards,Catherine 

Use case: Within an table (called ‘Meetings’) user creates a new record (i.e. a meeting) User adds date/time, text description, attendees (collaborator field), videoconference link (link field), etc. Automation sends a invite to each attendees email address (from collaborator field) as an email with .ics attached or alternatively as an MS Outlook Invite. NB. this is not the same as much of the functionality which just creates a record in a user’s calendar - as this doesn’t provide sufficient notification/visibility to the attendee that they’ve been added to a meeting. They need to receive an email - which can then create an event in their calendar. I can send an email from a record easily, but making this an invite/event or adding an ics had eluded me. Any suggestions welcome?

Hi all,I've followed the advice, and every other ticket on this subject that I can, specifically disconnecting and deleting previous Gmail, integration, connections, and re-adding them, including adding three different accounts in case that's the problem. I've also created a new automation to see if that's the issue, although the air table processing seems to be okay. I've also waited a few days and tried it all again to see if it was a temporary problem somewhere on the stack, still no luck.I just keep getting Gmail related errors like those below. What can I do? Any help appreciated."Google reported an error while processing this action:Request had insufficient authentication scopes."   

Hi there!I need to send calendar invites by email automation to people I book for events. I'm using Make to create the calendar invite and upload it as a file in Airtable.Then, I'm using automations to send the .ics file as an email attachment to people I book for my events. They can then download it from their email and it creates a calendar invite for them. Everything seem to work just fine when I test things.However, I have two types of emails to send via automations : Initial invitation when I'm booking someone to an event :Triggered when the entry matches conditionsSends email with .ics attachmentThis one doesn't work and the error is 'An attachment url is disallowed' Updates (for when something changes such as the event duration) : Triggered when the entry is updatedSends emails with .ics attachmentWorks fine! Any idea why my initial email won't send? My guess is that it's because the trigger is too fast and the file hasn't completely uploaded to Airtable

In airtable I have created an automation 'send email'. I 'insert value from field', the field being a number. The number comes from an Airtable field which is a formula that is formatted to $123,456. The 'insert value from field' is not formatted and comes out in the email as 123456.123456789. How can I pass the field format to the inserted value?

Hello!I have a formula field set to format as a percent in the table. That field is then part of a linked record lookup field in a table that will trigger automation to send emails. I want to share that percentage in the email. However, when I use the lookup field in the body of the email, it only allows me to include the number as a decimal.  Is there a way to get this to show the percentage?The original formula field formatted as a percent:The lookup field settings:The automation's email token:The result in the email:Thanks in advance for any help you can provide! 

Hey all, I have a table which is a  synced report from Salesforce that shows me opportunities coming up for renewal. I also created a different table with the same fields but is populated from the Salesforce report "SFDC Renewals Report" via automation: When condition is met (opportunity ID is not empty) - then create record in the second table "AE<>RAE Worksheet". My issue is that we moved accounts around in Salesforce and now some accounts have a different Renewal Account Executive or Sales Person. I cannot figure out how to automate the update of that Renewal Account Executive field in the "AE<>RAE Worksheet" to match the one in the synced salesforce report.  Any help is greatly appreciated

Hello,I have a Table that captures customer orders information through an Airtable form. Each order can contain anywhere between 1 to 20 products. Gist of problem and my data below with just 2 products: Ref #1: Name1: Size1: Color2: Name2: Size2: ColorOrder 001Product XSBlueProduct OXXLRedOrder 002Product KMBlackProduct CSBlackI have an email automation that gets triggered when a form is submitted. I somehow want the information in email in following format.Order 001 summary: NameSizeColorProduct XSBlueProduct OXXLRed What I have tried:Add records as List - too long vertically, not useful at all.Add records as Grid - too long horizontally, same issue as above.Try to manually format as table with HTML/Markdown: didn't workCurrent workaround: Add 20 separate grids (attached pic), but if order has only 3 products, 17 empty grids are in the email. Excerpt from automation below.Tried using helper grid views and scripts, but couldn't approach problem in a meaningful way. 

I'm calling in a script more than once input.config, to show input variables, but the error say that I can.. so, how can I display 2 or more variable within a script?  

Hi!Has anyone come across a way to bulk / auto reduce image size for uploaded attachments to Airtable? I also use Zapier and I am looking for a way to do it without taking on another monthly subscription only for this task. Thank you!

Is there anyone that could assist me for a 5min video call to see why my syncing of pages are not working please or do airtable have a support team that can help?Thanks all

I’m looking to streamline data entry in my Airtable base by implementing real-time auto-suggestions for the 'Company' and 'Company Address' fields within the Interface Designer. Specifically, I want users to be able to start typing a company name or address, and have Airtable suggest existing entries based on what’s already in the table, similar to how Excel auto-suggests based on previous entries.I’ve explored options like linked records and single select fields, but these either require extra steps or don’t provide the seamless experience I’m looking for. Ideally, I’d like this functionality to be constantly available while users are working within the Interface, without needing to run scripts manually.Has anyone successfully implemented something like this, or is there a recommended approach or workaround that could achieve this within Airtable’s current capabilities?Thanks in advance for your help!

Hello community,I have a table called attendance where each record is the date of the event, the participant, the payment.I want to automate the fact that each time a record is created from this table, it updates the list of participant from the table Event.Thanks for your help,Marine

Hello,I'm trying to perform duplicate check in a table and have only unique records maintained in the table.For Example: ID Name0000 ABC0000 ABCThis should return one unique row and update the table.Can it be done via automations? Looking for the steps here. Thanks.

HelloI would like to know if it is possible to build an automation --> if Column B (Actual timeframe) changes and does not match with Column A (Initial timeframe), then the Column C (On time?) would change to YES or NO (single select option YES/NO)? Additionally, the actual timeframe value comes from Miro board. Thank you in advance! 

Hi, I'm using an automation to Find Records on a quote and then to Sort this list before duplicating these records onto a Purchase Order.  I'm using the Sort list function and the the Looping function to go through each record, referencing the sorted list instead of the original set of records from the Find Records step.  Unfortunatley I'm using Manual Sort, and Airtable doesn't recognize its own Manual Sort means of using lowercase and upper case letters to sort this list properly.  Has anyone else run into this?For example, in this list: c1KWVc1KYc1KZc1Kbc1Kdc1Kec1Kgc1Ki The sort results put C1Kb as the first result, while Manual Sort puts C1KWV as the first record... Thanks in advance for any tips or suggestions.  

Hello,  My facebook automation dont't work.I need to reconnect all the time. When I relogin to account it work idk for 5min ? and  then i need to connect one more time...;/How to solve that issue? 

Hi folks!I recently received an Airtable email that allowed me to download a calendar invite using a button inside the email. I was wondering if there was any way to do this using email automations? I've included the email I'm talking about as an attachment. 🙂 Thanks a lot!

Hi everyone. I am trying to set up an automation where when a diagnosis field for a trip in one table is updated it finds the corresponding person (that is connected) in another table and updates a diagnosis field in that table where only different diagnosis is entered. Attached is what I have started. It doesn't run. I tried adding a find records step but couldn't configure the condition (screen grab also attached). Suggestions please!

Hoping someone here has the missing piece. Goal: In an Airtable form when selecting the Other option to a pre-defined list of options, and entering a single line text for that option, that text then presents in the original table with the other pre-defined options for future selecting. I have:Table 1 that populates via a form built in Form View. The form asks for the submitters State.Multiple tables that are predefined lists of Group names based on State. For example one table is all CA group names, another all MA group names, etc. Each table has an Other option.In the form when someone selects a state, the respective table of their state's Group options presents. If they select Other a single line text field presents to add in their required response. That  is working correctly. What is not working correctly is the automation that adds this Other single line text field entry to that State's Group list of options moving forward. I

Hi,Our process includes creating hundreds of Google Drive folders for client sharing during a year. This is now done manually, and I am looking at automating it if possible. Ideally a trigger in Airtable would the use some information identifying the client, create a Google Drive folder, make the access "Anyone with the link", fetch that link back to Airtable, and send out an email to the client.Alternatively, Airtable would be watching a specified Google Drive directory for creation of new directories, then initiate the process of changing access and pushing the link to Airtable.Any ideas?Rgds,BjörnPS. We use Zapier, so that is a viable option for us. For cost and maintenance reasons I'd like to avoid other 3rd party systems.