Automations

What can cause an Automation to trigger that is not shown in the revision history,  the automation does not use a view, just watches 3 fields that as far as I can see are not changing.Any pointers on what to look for appreciated.Note that the revision history on the left is for the record that triggered the Automation on the right.Paul  

I have a new automation that is supposed to send an email every week to show the status of each persons projects. In my test "run as configured" the emails send successfully with no issues. But in practice when they try to fire at the scheduled time it fails with the error message "The email was rejected by the mail provider". We have several Airtable automations running daily and Gmail doesn't "reject" any of those. I cant understand whats different about this one or why it works in the test run but not in reality.

So, I have created a booking system exactly like this How to make a simple booking system with Airtable! - YouTube , but I want to make an automation whenever the form is submitted, it will create a new event on Outlook. The problem is, the video doesn't show how can I automatically get the meeting end date & time, so I have a trouble at the automation configuration, since I have tried many several ways like doing formula to add on the date but it keeps giving me error, I have done various things as well but the automation does not show the meeting end date and time, instead they give me the options for length, value or record ID which does not make sense at all.Any idea on how I can approach this to work? I need it asap... if it's possible 😞 

Hi, My script below functions to auto generate meeting time slot dates for my team. However, the time generated does not reflect the time zone I hoped for, i.e., Australia/Perth, UTC+8. In my data view, my "Time Slot" column is a "Date" set up as below.Could anyone help me to identify what needs to be amended in my script?Greatly appreciate any help here.Thanks,Eve

Hello! Is there a way to create a notification (using the color function) highlighting an expiration date in my Airtable to alert me five months before an asset expires?

I tried copying a script from the extensions section and using it in a script for an automation.Safe to say it did not work and gave me multiple errors.What would be the easiest way to transfer the code from one to another? @kuovonne Script:let config = input.config({title: '📎 Convert attachments to URLs',description: 'Output comma-separated URLs for all attachments and write to another field for each record. Can be used for sending URLs to third-party integration services.',items: [input.config.table('Links and Tools', {label: 'Links and Tools',description: 'Select a table with records that have attachments you want URLs for',}),input.config.field('Attachment', {label: 'Attachment field from the selected table',parentTable: 'Links and Tools',description: 'Select the attachment field from the table above you want URLs for'}),input.config.view('Grid view', {label: 'View from the selected table',parentTable: 'Links and Tools',}),input.config.field('Attachment URL', {lab

Hello, greetings to all!I am looking for a solution for my table, I hope you can help me.I need to create a button with a Script, and this button should change a single select and in turn fill a text field.It is for an inventory, I need to know the item where it is located, with the single select I have the different warehouses, and the text box is a comment about its location.Do you think this is possible?I am very new to airtable, I started using it a month ago.I try to create a great Workspare to present to my superiors and request an upgrade and thus be able to work the entire company with this wonderful APP.Thank you very much in advance

Hi,I need some help auto creating weekly calendar entries a few weeks in advance.Currently my automation is set to create 8 calendar entries every Sunday, which shows on a Calendar view for one of my tables. For instance, if my automation ran on 9/3, it would create 8 entries on 9/3.Ideally, what I would like for my automation to do is to create the calendar entries 2-4 weeks in advance so if my automation ran on 9/3, it would create the entries for 9/10 and 9/17. Thanks in advance for any help!

HelloI have an automation in grid mode (so I can select records). I want to create a Google Sheet of those records.How do I Find Records based on those selected? The google sheets bit I can do.

TLDR: I'm trying to mark employees as "OOO" if they are OOO for 3 or more days of the week (vs if they are only OOO for 1-2 days of the week they still show up as available). I have a system set up where I have created an "open space" record for every week and previously I had it set up so if the employee was OOO for any part of the week (even if it was just one day) the open space record will show up in red as "unavailable". But I want to adjust that to only showing up as unavailable if they are gone for more than 3 days of the week.I have created fields in my table that shows all the days of each record,  so for the Open Space records it lists out all 5 days of the week vs for any OOO records it lists out all of the OOO days.I'm looking for a formula that compares the two. When the person is only OOO for one day, the formula below works great (as you see for my 12/1/2023 example) IF(FIND({[Prototype] Daily Dates 🧮 🏳️}, {[Prototype] Daily OOO 🧮 &#127987

I am not sure what I am doing wrong. When I use the script I have written on the scripting extension I get the desired output, however when I put that same script into an automation, the output is all wrong.Is there something I am missing?

Hi AT Community,For a project I am doing resesarch on record templates. I was wondering if Airtable has any limitations on how many new records can be created at once when using a task template table to insert new tasks once a project has entered a table with certain column conditions.So, there is a project table where a new record will be created with certain columns. A combination of columns will set of an automation that will trigger the creation of new records in a task table, based on a task template. I currently have 90 tasks related to a certain project label, which need to bo copied from the task template table to the task table (the projects are pretty standardized regarding tasks). Is this possible in Airtable, or are there any limitations on how many records can be created at once through an automation?Looking forward to your reply, thanks in advance.Regards,Arjen

I want an automation to update the linked records. It works when a record only has 1 linked record that the automation should update. But when there is more linked records to update it will not change any of them.   any suggestions?   

My automation has to update the Currency field with the formula field value. The formula field contains a number formatted as currency.When testing automation I receive an error message "Fields" could not be converted to a string that I can not figure out. The updated field is currency (which is basically the number in fact) and the source field is the number as well.I will appreciate any ideas and hints on what's the problem and solution

Hi, I have two use cases to solve: 1. (To simplify) the base is made from experiments (that contain) Sessions (that contain) Observations. Each experiment is matched to multiple codes. I have to create observation in context of session and assign code from experiment sets. 2. A session can contain one or more person. I have to assign a specific person to observation, it will be easier if I can select from persons that are related to the session.I'm quite new in Airtable. Is there a way to solve this two use cases? 

I've created an automation to link the submissions of two forms together based on the email a customer inputs. Presuming that they input the correct email in both forms without typos, it will link them no problem.I've just noticed today that if one email is all lower case and one has an uppercase letter then it won't connect the two even though it's spelt exactly the same.I understand there are formulae that I can use to correct the case, but I want to manage this through the automations. Is there a way to create a find record condition that is "Where *email address* is *email address*" that isn't case sensitive?

I have a base to manage volunteers and volunteer events. There's a Volunteers table to store volunteer information (name, email, phone, etc.). There's an Events table with details about volunteer events. There's a table called Volunteer Signups that shows which volunteers are signed up for which events.I use a form to register new or returning volunteers. The form fills in the details on the Volunteer Signups table. An automation then creates a new record in the Volunteers table if the volunteer's email is not in the system yet. If the email is in the system, a new Volunteers record is not created.Returning volunteers will then have multiple events listed on the Volunteer Signups table, one for each event they have signed up for over time. I want to have a linked record in the Volunteers table that shows only the most recent event they have signed up for. Right now I'm only able to show the first event they signed up for, not any subsequent events. What do I need to change to achieve t

Please helpppI have multiple linked records inside a single record that I would like spread out into seperate rows with all the other information copied over. Something in my automations or my linking isn't right, but after two days of arguing with it, I need some help. Thanks!

Hi Community!I'm setting up an automation to remind users to update their records. So the idea is to send email reminders in 3, 6, 9 and 12 months since the last update.I'm using an automation triggering by a formula field that simply calculates the number of months since the last update was made.All good there!However, some emails are invalid (user likely entered wrongly), so I'd like to avoid trigerring the 6-, 9- and 12-months reminders if the email is invalid.My logic right now works like this:Triggers if months passed = 3 AND email is not checked as invalidChecks email as invalidSends emailUncheck email as invalidThe idea is that if the email fails to send (step 3) then the process stops, step 4 never occurs, and the email invalid is left checked. This works nicely.What doesn't work is if the email is sent! Because step 4 updates the "Invalid email" field, which is also in the trigger, it triggers the automation again and again and again. I had instances of sending 1000s of emails

Hi there - We are setting up automation to find records that meet certain criteria -- either via a view or several 'Find Record' set-ups but the 'Find Records' is stopping at 100 records.  What is the best work around for this?  Thanks! 

Not sure if any of you have received the notification that if you're on the pro plan - your automations will be halved from the aldy restrictive 50,000 per month to 25,000 per month (also No more multisource syncs, API limits of 100,000, halving of attachment storage space to 10gb)? Also the support team seems to be not active since the pricing plan was announced - all my emails get diverted to a cliched auto reply when in the past a warm body will be manning the email and helping to resolve the issue. Isn't it industry practice to pmaintain current users on their own legacy plan? The new pricing and lack of support is making us consider other platforms instead 

Hello everyone, I am looking for a script to find values of over 100 and sum the total. I have looked on other posts but can't seem to find one to support this. Thanks all,

I have an automation that triggers when a form is filled out. The form collects email addresses and locations from people, putting that info in the signups table, and matches them with captains based on their location; the captains are listed in the captains table and linked to the signups table, with lookup fields in signups for their email address and other key info.The automation sends an email to the new signup connecting them with their captain. Some captains have email addresses, some don't. So the automation looks to see first of all if there is an email address for the captain in the signups table's lookup field. The logic in the automation is: signups: email (from captains) is NOT empty.However, the step is triggered even if the email (from captains) lookup field IS empty. When testing the step, it returns a success and shows the field contains [object Object]The field looks empty in the data table, I have no idea why it is returning "object Object" or

I've had so many frustrations with the automation feature that I literally haven't updated my Airtable in MONTHS because of this.... I migrated from GSheets and manually updating GCal to Airtable for it to automate for me and yet I keep getting this error message despite the test running perfectly fine.... If anyone has some insight on how this can be fixed, it would be greatly appreciated... Screenshots attached.. If there is also any way to contact customer support away from a public community forum and beyond the help articles, that would also be super helpful... 

I'm trying to use a script in an automation to filter specific records from a view and then include those records in the next step of the automation (which would be inserting them into an email to send).I can get the script to successfully find and filter the records needed, and it looks like I need to use output.set to export the info back to the automation, but I'm having issues figuring out how to do so.When I run the script below, I'm getting the following error: TypeError: Invalid arguments passed to output.set(key, value): • value[0] should be a JSON-serializable type, not an object Anyone know how to fix what I have for the output.set part or any guidance at all? Thanks!const table = base.getTable("Sessions");let view = table.getView("Sorted Active Coaching Sessions");let inputConfig = input.config();let CoachingAssignment = inputConfig.CoachingAssignment;const fieldName = "CAMatch"const queryResult = await view.selectRecordsAsync({fields: [fieldName]})const MatchingSe