Automations

I want to send an automated email that includes a formula field/token (it is called "6-month historical average"), formatted to 0.1 decimal place (this formula calculates an avg of the numeric values in 6 other fields, all of which are to 0.1 decimal place).Although the "6-month historical average" field is formatted to 0.1 decimal place, when I test the automation, this value always appears with a long string of decimal places e.g. instead of 4.6 it will show as 4.6437449559. Why is this happening?! I want the historical average to show with only 0.1 decimal place.  Thanks for your advice!

Hello everyone,I would like to run an automation to keep track of the previous values of a cell so that I can see how inventory is being withdrawn from the database and have a correct running tally of inventory items.Currently my airtable is set up like this.The quantity removed field is constantly updated as product is removed. I would like to have the sum or some record of all the values ever written into this field in the previously removed field. I have tried formulas but I keep running into circular references. Therefore I am trying to create an automation which will add the new the new value entered to the quantity removed field to the previously removed field value.For example: on the first day Quantity removed is entered from softr and now has the value 15 for a particular product. Therefore previously removed should be 15. On the second day another entry is made to the Quantity removed (value 20). Now the previously removed value should be 35.This must all happen to the s

I am trying to create an automation that updates all records in a table at a specific interval. The automation needs to look a single select field and based on what it is set to update another single select field.The automation works when the trigger is update or create, but the time interval trigger is eluding me.The automation is set to run every 15 minutes, and it looks for specific records. But How do we tell it to update individual records from the list it found?

Hi there. I have a event table full of info for scheduling a bunch of different types of "events."One of the pieces of data is the frequency these events need to occur in weeks. So some happen every week, some happen every 2, some every 4 weeks, etc.In a planning table, that assigns specific information to each instance of the event (primarily location), there is look up fields for the event table info, and look up field to a location table. Since all the events have different frequencies, I would like to automate the creating of the next events somewhat. Is that possible? So if I create "Event 1" assigned to "location 1" on the 1st of July 2023, and "event 1" repeats every week, can I have it automatically create "event 2" on 8th of July 2023? This could ideally be handled 2 ways - a field that has a "no more events after this date" info (so that it doesn't create infinite records), or the Planning Table is grouped by "event" and whenever I click the "new reco

I want to send an email every day at 12:00 p.m. to each record that matches a specific criteria. Trigger: At a scheduled time Actions 1: Find Records Actions 2: Send Gmail When I run the application with the above settings, the email addresses of the target users are included in the cc and the email is sent all at once. How can I send each email individually?

I am currently using the "when a record is updated" trigger paired with 10 separate condition groups, each with its own "update record" action to change the status of records that meet specific criteria. The problem is that it relies on the record to be updated in order to trigger. I'd like to do this same thing using the "at a scheduled time" trigger so I can run this automation daily whether a record was updated or not. I've tried using "find records" to get a list of records to update followed by an "update record" action but I get a "received invalid inputs" error.  

I have an automation set up that is supposed to send an email each Monday at 8am letting people know the status of upcoming items that are due and a list of what is needed to complete them. The automation pulls the information from 3 different tables (using a particular view in each one) and inserts it into the email.One of the fields it's supposed to pull is the 'Needed to Complete' field (long text field with rich formatting enabled). The automated email pulls all of the other fields fine, but will not pull in this one. And it's not just that the values are empty - the column isn't showing at all in the email.I've tried retesting a few different times and it still will not pull that field in. Here's what the structure of the automation looks like: Any idea why it won't pull in that one field?

I'm building a base that users can copy, and I notice all my tables, records, fields, and extensions copy over when I create a template of that base. However, I'd like the templated base to include the automations I built, plus the interfaces if possible. (Honestly, the automations are more important.) I've poked around the Community and even asked ChatGPT (which swears this built-in functionality is possible in Airtable, but I can't find it!).I see other topics in the Community related to duplicating bases (and thereby duplicating automations) but this base template will be set up for other users to use as a starting point, and they wouldn't have access to the backend of my Airtable system.Thanks for any guidance!

I have more than 35-40 filter options available. Example: Founder, CEO, CMO, CFO, Manager etc. How can I reuse filters in multiple tables and bases?Currently I have to manually select each of them one by one for each table and base. 

Hi, I've searched for an answer but haven't found anything posted recently. Thanks for any help.Simple question. I'm looking for records daily at 3 p.m. that meet certain conditions. If I find them, I send an email with the records. But is there a way to do nothing if I don't find anything that matches the conditions? Will the automation automatically abort if conditions are not met? I don't want to send blank emails. Thank you.

I have 2 tables each have one common column i.e website. How can I generate 3rd table which will be intersection of table 1 and table 2?Note: I am using airtable free plan

All of our integrations with Microsoft Teams have stopped working. We have an automation to automatically send a message to a Teams Channel when a new person applies to the company (by sending an airtable form). I can connect the Microsoft Teams account, but I can’t select any channels or teams in the automation settings. Anyone else?

I'm having problems with inputConfig. I'm running a script to check if there are fields with missing data in the columns, this script sends me a notification with which data is missing and generates a report, but I came across this error:The script I want to run in this automation is this:const table = base.getTable('NOME_DA_TABELA');const columns = table.fields;// Função para verificar se um valor está vaziofunction isEmpty(value) {return value === undefined || value === null || value === '';}// Variável para armazenar os nomes das colunas com dados faltandolet missingColumns = [];// Verificar se há dados faltando nas colunasfor (const column of columns) {const value = inputConfig.newRecord.getCellValue(column);if (isEmpty(value)) {missingColumns.push(column.name);}}// Enviar uma notificação e gerar um relatório se houver colunas com dados faltandoif (missingColumns.length > 0) {const recordUrl = inputConfig.newRecord.getRecordUrl();const reportText = `Novo registro com dados falta

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