Automations

Hello! I am hoping to send weekly staff wide emails detailing a list of upcoming programs and events at my Foundation. I set up the Automation and it works well. However, the dates are ordered by when a record was created and not based on the actual date of a program. I've seen others with this issue in the past and I tried ungrouping the data but nothing has worked. Is there a feasible workaround for this yet? It would also be great if when sending the date / time for an event it sent it in EST time instead of UTC. I have it formulated in the data layer to so that is recognizes an EST time zone but in the weekly email it still is presented as UTC. Please help! I have an example below with the out of order dates and UTC time zone. Thanks, Praise  

Is it possible to use an Automation and a looping function to create the scenario in the subject line?I have a form to create a new record in table A, one of the fields is a manually selected number (X) from 1-20 (single select). Can an Automation generate X number of linked records in table B? If so, how is this configured please?

Hi, Airtable communityRecently I wrote a script for one of my automations in Airtable, however it's taking so much time so it's going over the limit of 30 seconds. I would high appreciate if you could review and tell me what I could optimize or improve in order for it to work faster.Here's the code: let emailSendersTable = base.getTable("Emails to clients"); let listingsTable = base.getTable("Listings"); let emailSendersQuery = await emailSendersTable.selectRecordsAsync(); let listingsQuery = await listingsTable.selectRecordsAsync({ view: "NEVER TOUCH THIS VIEW! 2", fields: [ "Monthly rent", "Size in m²", "Area (ku and district)", "Layout filter", "Features", "Created date", "Clients (Send emails)", ], }); let updateBatchSize = 50; let recordsToUpdate = []; for (let emailSender of emailSendersQuery.records) { if (!emailSender.getCellValue("Budget") || !emailSender.getCellValue("Size") || !emailSender.getCel

Hello everyone,I come again to ask for your help on the automation for integrating Airtable records into a Google Calendar. This automation only works when I duplicate my event in Airtable. I attach the capture of my automation. Do you have a trick to solve this problem?Thank you so much.

Hello, I am looking for a way to create a workflow where when a new job(task) is created, it will send an email to a group of people who are qualified to do the job, and then the first person to accept that job will be the one assigned to it. Can you guys please help me think of a way to do this?I imagine it would kind of be like doordash where a job is sent out to someone and they can accept it or decline it, and then another workflow could happen where it will send them an email if they accepted the job in time or if they did not. Please let me know your thought! Thanks,Samuel

I'm trying to create an automated email that will list data from found records from airtable, but look like I actually wrote & formatted it. The goal is to generate an email that looks like this: People who are considering: Person's Name at CompanyPerson's Name at CompanyPerson's Name at Company People who have declined: Person's Name at CompanyThis person's comment about why they declined appears below their name.Person's Name at CompanyThis person's comment about why they declined appears below their name.  I figured out how to use the concatenate formula to combine fields and add line breaks etc. to create the above result for each look-up. And I also discovered how to have airtable create a list in an email with only the data from the concatenate fields, and not list the field title each time. (Which didn't look natural, and so won't work for my purposes here.)To do this, instead of clicking the usual "Insert all records as.. list" option next

Hi all, Brief: I am trying to use the Google API to run a script on Google Apps Script (GAS) from a scripting block. Has anyone accomplished this? I read through this thread and decided to pull data into GAS from the Google side, but my client wants me to handle it from Airtable. Full Explanation: I am new to Airtable and am developing a script that will scrape a website for video metrics. I saw in Airtable’s docs that direct DOM manipulations allowed in vanilla JS are excluded, so I decided to stick with a script I already had in GAS to perform the task. I saw Bill’s in-depth response at the link above and decided to run the processes from Google for simplicity, as the Airtable API is a lot nicer to work with (i.e. pulling data into GAS) than pushing data to GAS from Airtable using the Google API, which requires Oauth2. The group I am building the project for, however, wants me to make an API call to GAS from Airtable, call Urlfetchapp in GAS, and send the data back to Airtable to fin

Hi there,I have a Zap running that asks chatGPT to choose from a list of 8 commitments and put them in the field 'commitments' in airtable. My problem is that sometimes ChatGPT returns the commitments with a capital letter or a full stop. This then creates a new multiple select and messes up my reporting. Is there a way to ensure that airtable disregards the full stop or capitalisation? Thanks! 

Hello! I'm wondering if an automation can be built to send an email alert whenever an email sync takes place.What I am trying to accomplish is this1. Team A sends a csv file that is sync to an Airtable table2. Within that csv will be a list of records3. I wish to alert Team B via email whenever Team A sends a csv file to Airtable emailed data syncMy conundrum - If I were to use Automations to trigger when a record is created, it will fire off 1 notification for every record which isn't good.How can I build an automation to fire off 1 single email notification whenever a sync takes place? Thanks!

I want to set the value of a Rich Text Field with formatting through automations. However the formatting doesn't work when updating through Automations. Is there a way to do this? Or maybe through a script? How do I ensure that the formatting stays?

I was following the directions found here: https://support.airtable.com/docs/use-automations-to-timestamp-status-updatesHowever, when it came time to select the "Last Modified" field, per the directions, I saw an error stating that "this field cannot be used because it if computed".  What struck me as odd was that this was in contradiction to the exact steps to take in the link.  Now i can't complete this automation.

Is it possible to have an ‘Update Record’ action add to a field instead of overwriting whatever is in there? IE: We have a request base. If the department is Training then Jane Doe needs to be tagged in the Collaborator field on the record. But if the department is Report a Bug, John Doe needs to be tagged in the Collaborator field on the record. The problem: If a record is tagged with Training and Report a Bug, it’ll overwrite Jane with John, instead of adding John.

Hi there!I have set up a masterlist of advocates that is pulling all of our advocates from different bases, using synced tables. Now I want to have a field that will tell us when the person was last reached out to so we have a good overview. I have set up an automation that says 'When this date field is not empty in this table, please update the date field in the masterlist table with the same data" However, it works only the first time. Afterwards, when the original date field is updated to a new date, it's not updating the field in the masterlist table. Is there any way to make the automation triggers every time there is a new value in the original field? Thank you!

Hello community. I'm wondering about comparing dates in automations. It seems this isn't a thing that airtable can do, maybe you can help me find an elegant way to set myself up. Our company changed the date of their fiscal year (FY) and I need to calculate which FY a member joined, renewed or cancelled. I can do it with a formula for each date, for example like this for the subscription date: (and let me know if it could be improved) IF({Subscription date}, IF( IS_BEFORE( {Subscription date}, "07/01/2019" ), DATETIME_FORMAT( {Subscription date}, 'YYYY' ), IF( VALUE( DATETIME_FORMAT( {Subscription date},'M' ) ) >=7, DATETIME_FORMAT( DATEADD( {Subscription date}, 1, 'year' ), 'YYYY' ), DATETIME_FORMAT( {Subscription date}, 'YYYY' ) ) ) ) but I'm trying to make this

Is there a way to confirm if I bbc group of emails which emails actually got the email?Also is there a way for the original email (sent from) to see who all of  people the emails went to. (Like when you send something out of outlook you can see all the emails that the email went to including bbc if you are the sender)  

I've created an Automation that should help me automatically update Records in another table when x happens. So I have two tables: One table with a whole bunch of records (new ones will appear every week) and then I have a table where some of these records appears IF my colleague hasn't accepted them as valid. When they appear in the second table, I'll have to edit one of two fields and give them back to him. Therefore I wanted to make an Automation that automatically makes this update for me. What I have done so far is this: 1. When record matches conditions (field has x value)2. Find records from Table A, view A - Find records based on: Condition: Where ID contains ID (from Table B)3. Update record (Table A)- Record ID: List of Record ID from step 2. - Fields: Field A and B from Table B (so that the record in Table A will get the same values from the record in Table B) When I run this Automation I get an error in Step 3. Why is that?&

What's wrong with this script? let tableName = "Table 1";let viewName = "Books (ChatGPT)";let openaiUrl = "https://api.openai.com/v1/completions";let apiKey = "sk-key";let table = base.getTable(tableName);let view = table.getView(viewName);let record = await input.recordAsync('Select a book to summarize', table);if (record) {let recordId = record.id;let bookTitle = record.getCellValue("Name");let bookAuthor = record.getCellValue("Autor");let prompt = "Provide detailed yet concise bullet-point summary of " + bookTitle + " " + bookAuthor + "in exactly this format: Long-Form Summary: Themes: Lessons from Reading the Book: Category Tags: Key Quotes:"// let prompt = "Предоставьте подробное, но лаконичное описание в виде маркированного списка книги " + bookTitle + " " + bookAuthor + " в точно таком же формате: Сводка длинного формата: Уроки из чтения книги: Категории тегов: Ключевые цитаты:" async function sendRequest(prompt) {try {let body = {"prompt": prompt,"temperature": 0.7,"m

Hey, I’m struggling to create an automation that sends an email (to myself) when any record under a field in a specific table is deleted. I thought the ‘When record updated’ trigger would work, but it seems I’d need something more custom. For context, I’m using Airtable as a database for a booking app, and my goal is to receive an email when a user deletes/cancels their booking on the app (this action already deletes the corresponding record in Airtable). Any help is appreciated. Tunmise

Hi,I am needing help with an automation. I am needing to change the status of our guest to moved out when the lease end date has past except for when it status is canceled. 

Hi everyone I have created an automation which sends an email of a list of records from my table at a scheduled time. However there is too many records being shown and would like to change the amount. The number of length is by default at 100 and does not let me edit this number. Can you help me please?

I have this table to track some gym progress.I have a number of updated values for each record, e.g.:for a 1 set of 10 for 245 for b 2 set of 8 for 356and etc.there is also column for tracking the latest update.I need to be able to somehow store the progress/history of this values. So what if i update smth like this:for a 1 set of 10 for 245 => for a 2 sets of 9 for 250i could have bouth record in my baseI'm aware about the Revision history function, although it's not providing acces to the information in the most comfortable wayIs there a way, through some formula/automation/etc. to copy the current record each time i'm updating it? 

Am looking for a developer that can connect our Airtable to DocuMint for automation. Also have additional automation needs that need to be addressed.  Please respond below with email and we will reach out!

I'm new to Air Table and having trouble finding a solution for this. I want to press a button to update a record with some information provided by the user. So on hitting the button I want it to set one field to "Completed" (which is fine), one field to todays date (which the work around seems to be having a formula on the table that this can be grabbed from) and the name of one of our team. Ideally the name of our team member would be selected from a drop down but I would settle for them typing it in somewhere. Is this possible?

TL;DR: what's the difference between 'contains' and 'has any of'?I'm setting up some automations with a 'when a record matches conditions' trigger.When I set my 'find records' trigger to the condition 'has any of' the dynamic value I want to use, I get 'invalid value: when a record matches conditions cannot be converted to an array of string'.When I set the condition to 'contains', it works perfectly.What is the difference between 'has any of' and 'contains'? In natural language the two are synonymous (to my sense of the language, anyway), but I assume there's some important distinction in the underlying code that I don't understand.

I'm intending to create a simple AirTable script to record duration of a single status field. In my use case I'm tracking a large number of issues where the status frequently goes back and forth between the multiple status',For example there are multiple status':  open, in-progress, and resolved status. A normal workflow would be non-linear, so a record could go from open to in-progress, back to open, then to resolved then back to open, and then finally to resolved again.open > in-progress > open > resolved > open > resolved.I'd like to track the duration that each record is in each status as well as the cumulative time each record is in each status. This way I could say this record was open for a period of 3 days, in progress for 1 day and it was  in a resolved status two days. In the first table I have several records with a status field and a time modified field as well as other important data fields to help identify the issue, like name and the primary