Automations

There must be a bug in the recent update. Last week I noticed a change in the interface when I attach files. Since then every single email automation with attachments fails to run due to "attachment url disallowed". Everything worked fine for the past few years, no changes have been made to automation. Therefore, they messed up something in the recent update. The automation test runs fine with no errors. So, nothing wrong on my side. Airtable support chat bot offered to clear the cache to solve the issue, which I did. It seemed to work temporarily. However, I have to clear cache each time for the automation to run, which is unacceptable. Also, clearing the cache is not helpful when the email automation with attachments runs from the forms (i.e. someone submits the form and uploads an attachment, which triggers the email automation). It worked perfectly fine for many years. It looks like there have been multiple reports of this issue in the Airtable community forum, but the issue remain

I've seen some posts regarding this same issue, but no recent workable solutions so I'm posting again. This automation hasn't run for a few weeks (since June 😎 and no changes were made but it's no longer working. The step failing is sending an email. I get a message: "An attachment url is disallowed". The entire automation goes like this:1. When X form is submitted (including Z attachment)2. Find record (where record ID matches record ID)3. Send an email to Y email address with Z attachment (from X form submission). File format is pdf if that mattersSteps 1 and 2 run just fine...it's step 3 that throws the "An attachment URL is disallowed" message.Nothing has changed to the automation or the file format.What I do notice is a change in the URL of the attachment.This is the URL (incomplete) of an attachment when it was working on June 8. The root of the URL was cdn.filestackcontent.comThis is the URL of the attachment uploaded in the failed attempt. The URL room is airtable-attac

Hi,I have two tables:A table with 'Registrations', 'Courses' and a table with 'Sessions'.If a registration (for a course) is being added, After pressing a inline button, I want to prefill the field 'sessions' with the sessions from the sessions table where the  'Course' field matches the 'Course' field of the new Registration. It happens sometimes that people choose afterwards other sessions then the preselection of sessions. (absence, holiday etc)when button.pressedassign the value of field sessions to the linkedRecords where Sessions.Course is matching Registration.Course.Any suggestions?I'm quiet new into the field of Airtable Scripting... 

Hi! I am trying to create an automation that would allow be to block a "single select" option on a form when this option is booked somewhere else. To explain it better, I want to say: When a room (single select on form) is booked (single select on form), cross out this option on the room list (single select on form). I would love if someone could help me out with the formulas I need to use?Thank you 🙂

We have an automation to send an email when a record is not empty.It works well when we set it for the first time in a new record, but when the attachment is deleted to place a new attachment, the automation generates a wrong URL for the new file and it causes a fail when sending the email in the automation.Can anyone help me with the issue as it is causing big trouble to our company workflow?Many thanks,Nacho

I have created an automation to add a record to a table called "Client View" when a checkbox is ticked in the record in the table called "Project Schedule".  I want to control which fields show in the "Client View" record.  But, my first struggle is I can't get almost any of the fields to show!  In each record in the Project Schedule table, there are 13 regular fields, 3 linked fields from another table called "Project Catalog" and 10 lookup fields from those Project Catalog records.  I don't need all of those fields to show in the new record, but I do need information from many of the linked and lookup fields to show as well as the record name and regular fields.Trigger: when a box is checked in a record in Project Schedule...Action: create a new record in Client ViewBut when I select the fields I want to show in the new Client View record, I can only see 3 fields, not all of them.  Am I misunderstanding the purpose of the "Configuration: Action will run..." s

Hi, we are trying to create an automation to send an email to a company with multiple linked records, but are unable to use a List view to do this.Is there any way for us to send eg. ABC Logistics one email with multiple linked Allocations in a Grid format?I have attached a few screenshots - of our List view and the email we are currently able to send (email is formatted how we want)How would we go about setting up the automation - preferably don't want to have a separate automation for each Company name.Thanks

I have two tables that share a linked field. Example data:Table 1:FRUITSTATUS (single dropdown)REVIEWS (linked)ApplesIncomplete[1] [2] [3] [4]OrangesIncomplete BananasIncomplete AvocadosIncomplete Table 2: REVIEWDATEFRUIT (linked)OUTCOME11-JulApplesFail22-JulOrangesFail33-JulApplesFail44-JulApplesPassThe data in Table 2 is created using form.I'm trying to update the STATUS field in Table 1 to "Complete" when a form is submitted with a passing outcome for a FRUIT. So in this case, the STATUS for the "Apples" record should have been updated to "Complete" on 4-Jul.I've been trying this using an automation with the following settings:Trigger: When a record is created. Table 2 is selected.Conditional Logic group == If OUTCOME is "Pass". Within that logic group, I have an Update Record action item. Table = Table 1, Record ID = REVIEWS (the linked record), Fields = STATUS > Complete.The trigger is able to find a record and the conditional logic is able to pass the

Trying to use this to create records based on a template and everything looks correct, but when we ran, it returns an error.I'm assisting another user with their Airtable project and just looking for possible solutions.User downloaded the script from Airtable Marketplace.Here is the tutorial we followed. We used the same fields as a test and received the error.https://www.youtube.com/watch?v=Ujd88TADDvY&feature=youtu.beI believe its the scripting extensionAny insight would be appreciated. Thanks!

Hello community!I am working in a non profit and I am trying to figure out the best way to track my budget. The issue is that I have income from multiple donors, all of which will give funds for specific expenses. This means that a donor might cover a percentage of my yearly expense. I also use a "transactions" sheet wherein i input all of the financial transactions. My questions is if I am about to pay an expense (for example rent) that is in total 1000euro and 200euro is covered by donor A and 800euro is covered by donor B is there a way to:1. input one transaction line that splits the total cost according to the allocation mentioned above?2. at the end of the year I will have to provide all my donors with reports that show the transactions above and they need all this information: total amount paid, total amount covered by donor, line by line transactions relevant to this donor? I am not sure if this information is enough, in my head it is but if feel free to ask clarifying que

I want to have my date of payment updated automatically to the next month whenever it is reached but I am having some issues with having it to work. I already have a trigger that executes emails once the date of payment is a week to or has been reached.

Hi I cannot figure out how to, if it is even possible, to update a specific field ( which is currently blank ), with specified text, which is appended on to the back of another fields data, within the same record, when a third field matches a certain condition. A bit of a tongue twister, apologies. For example :I have 3 fields, namely status, name and surname.First field :  Status Second field : surname Third field : left blank The first field ( status ) is populated with Awaiting order completion. The second field ( surname ), is populated with deer.  Every time I change the status to order complete, I would like the third field ( which is blank ), to be auto populated with the second fields data ( surname ), deer in this instance, and have specified text appended. Therefore the third field should look like this : deer specified text. Can anyone offer any guidance on this please ? Hopefully this is not too confusing. Trying to use arbitrary

Hi Everyone. I'm interested in learning how to create a form in Airtable to trigger automation. We set up automations that work when we add records to a specific table in Airtable. But when we use a form created by the Form feature in the view to add records to the table, the field created by that automation does not work in this case. I'm keen to seek recommendations/solutions from you here. Thank you.     

New to airtables, so hoping someone could help with an automation i am trying to make.I have a grid containing all the purchases of products i am selling. Multiple of the same product are grouped on each line as i purchase them. However when i get a return from a customer, I want this to pull through to another table so i can properly track it. I have a tickbox column titled return. I would like it to work that when a customer returns a product, I can click the checkbox and it will pull through the product information into another grid so that all the returns are in one place. As i can have multiple returns of the same product from different customers, i would like to be able to pull through the information multiple times at the click of a button.Hopefully the above makes sense. 

Title pretty much says it all.  I found the article covering how to create a GCal automation in general.  I don't see anywhere in here where you can specify that, for instance, all invited attendees should be able to edit the event or add more attendees.  From what I can see playing around in GCal's native web client, you can set a default property for the client that when creating events in any calendar you have access to, it should use a particular setting for attendee access level:This is a "General" setting, not a setting belonging to any of your individual calendars.So I'm pretty sure if you wanted to have events get created with any setting other than making attendees read-only, that change needs to come from the client side, i.e. AirTable needs to enable choosing this setting in the Automation.

Hey Guys, I have a base which has 50 Automations. I need more automations in the same base, Is there a pro feature or something I can buy to get more automations @Stephen_Orr1  @TheTimeSavingCo  @kuovonne Basically something that allows me to put in ore automatons in the same base. Thank you guys for the wonderful help you guys provide. Always appreciate it. Regards,Dilip

Hi _ I am using automations to turn on an IOT device. When I enter the javascript in the automation and test it. It works. When I actually add a record and have it trigger the automation, it runs (or says it does) but the webhook doesnt seem to run (the light doesnt go on/off) like it does in the Test Environment. Any Ideas?

HelloI am new to airtable. I'm sure this is simple, but I can't seem to solve the problem.I have a table with a multiple select column. I want to save in a field or in another table all the options that are generated in the multiple selection column.For example:The multiple select column includes: math, sports or geography selected along the rows.If I include a new option (new row) as "physics" it should be reflected in the new field that collects all available or selected options.The goal is to then be able to send a list of available options to webflow.I hope the explanation is correct.Thanks

Hi,I have a multi-select column that occurs in several different tables on my Airtable project. Is there a way to sync the options that populate for these columns? For example, if I added "Clinical" as an option in Table A for that column then "Clinical" would also be added as an option in Table B & C for that recurring column. I would greatly appreciate any help with this!Best,Collin 

Hi,I have a requirement where I need a trigger when new Spreadsheet with the term containing Brand created. I need automation/script/Zap to read the spread sheet created and create these records present in the google sheet into airtable. I did a lot of searching on Zapier, There seems to be no automation which reads google sheets drive link from airtable and creates those records in airtable  Can someone help me if they have worked on something similar? Appreciate all the help ill receive @kuovonne @ScottWorld @Justin_Barrett 

Hello, I have a problem with an automation that works intermittently. I tried to follow the errors one by one to try to understand why sometimes it works and sometimes not! First records are created in a table (A) from a “Typeform” form which also fills in a “Parent record ID”. Then the automation must update records on another table (B) found from the “parent ID”. There is no problem to create the records on Table (A). But the automatism which is supposed to update the table (B) does not always work… it drives me crazy! An automation that is incorrectly configured never works! An automation may occasionally fail for x reasons. But when it only works 2 out of 3 times… it’s weird. Note that these issues arose after the new “conditional actions” were implemented last week…not sure if it’s related. Have any of you had issues like this? Thank you for your help.

This seems like a pretty basic operation and I'm sure it's been discussed however I haven't really found anything that looks "canonical", as it were. I simply want to add an event to a Google Calendar when a date is chosen in a field. I played around with Zapier a bit but it didn't allow me to select any of the relevant fields from the table, namely the date and address. I don't mind digging in and making an effort to get something to work but hopefully someone can point me in the right direction. 

Hi,I am looking for help with an interface button. It used to (before me), create a new task for the user to edit with data linked to the data in the interface. I cannot find how to do this at all. Please can you help. Thanks 🙂

Hi AT Community,I'm creating an automation email within Airtable that uses percentage field data from my table.  I have set the precision to one decimal place (1.0) in the field column. However, when testing the automation, the preview shows that the token data percentage with 10 decimals (1.000000000), which looks ridiculous. Anyone know why this is happening? I know the workaround is a single-line entry, but I'd prefer to be able to enter the data as the percentage number, as that's how the information comes to us.Appreciate your help!

Hi there,I'm trying to set up an automation that either goes to an email group that we've set up in Outlook, e.g. info@test.com should arrive in the inbox of admin@test.com and office@test.com,  etcOR just list a number of email addresses entered manually in Airtable automations as text, but neither seems to be working.I've tried just entering the group email address but nothing comes through to anyone's inbox when I test it. I've also tried just adding multiple email addresses manually, using a comma (,) without spaces in between them. In the second instance, only the last person on the list is receiving the email.I'm not sure whether I'm doing something weird or whether it's a bug.