Automations

I've been creating long automation to add a list of tasks every time we get a new project. I create one automation and then add a step for each new task. I just saw the repeating groups function and I wanted to try this. So I added a table called "Tasks for automation" I need to be able to set the task due date to be a calculation based on the project due date. Each task will have a different due date.Task 1: Due Date = project due date - 28 days. Is there anyway to create a date from a calculation 

Please help -Hi, I am trying to create a webhook in Make that runs based on a status change in Airtable. I am using a script to execute the automation. Unfortunately, I am getting a "recordId: undefined" from the webhook even though my script is returning recordId data. This is causing errors at my Airtable step; screenshots are attached:// Replace this with URL for your own webhookconst webhookUrl = "https://hook.us1.make.com/.............................................";const { recordId } = input.config();try {const response = await fetch(`${webhookUrl}?recordId=${recordId}`);console.log(response.status);} catch (error) {console.error(error);} 

I am using `newTable.createFieldAsync(fieldName, "multipleSelects", {'choices': options}, fieldDescription);` syntax to create a field in table.But i want to change question placeholder or create question with custom placeholder(above marketed section in image) without effecting question main reference value using scripting or automation?

Hi,  I have been trying to iterate only a few itens in a table, with no success. Apparently the filter() method does not work as expected in the example below. I would expect both codes worked the same, but they don't.  let table = base.getTable("My table"); let query = await table.selectRecordsAsync({fields: [ 'Total' ]}); console.log('TEST 1 - uses filter() '); let query = await table.selectRecordsAsync({fields: [ 'Total' ]}); for (let record of query.records.filter((each) => { 0 == each.getCellValue('Total') } )) { console.log('Found a zero!'); } console.log('TEST 2 - without filter() '); for (let record of query.records) { if ( 0 == record.getCellValue('Total') ) console.log('Found a zero!'); }  My table has 4 records, with values 0, 1, 0, 0 for 'Total'. This is the output I get:  TEST 1 - use

Hi all. I'm new to this and looking for some guidance.Spreadsheet 1 has all available items for sale. Let's say they're vehicles. So some columns may be, make, model, year, HP, etc. I'm trying to create another spreadsheet2 to act as a "wanted list" where if certain conditions are met, an alert will trigger. So if a salesperson goes into the wanted list, puts a potential buyer's name, Ford, Mustang, 2010 or newer, the system will alert them when we get a 2012 Ford Mustang that becomes available for sale. When I have Spreadsheet 2 with columns that would match up with those from the first spreadsheet, how do I build the automation for it to check to see if spreadsheet 1 has anything that meets those conditions, or similar conditions and then sends an email to the user who created it?Thank you in advance for any help you may have! 

In constructing an email automation when a record matches conditions, I am unable to select a single select airtable field (located in the same base as the selected record that matches the conditions) to insert into the email body. The desired field is a single select field. This field does not appear on the field selection list. It is not a linked field, a lookup field, nor is it the result of a formula. The automation works correctly. However, without the single select field in the body of the email, the customer will not know with which item there is a question. The base in question is called “QuiltFest2022” The Table in question is “Entries.” The single select field is “Category.” The Automation in question is Automation 2: If Email is not empty and CatStatus=1. I have included two screen shots of the automation,

Hi everyone,I'm learning airtable scripting and what i want to do is this :-When a check a checkbox in my table, it run a script which will fetch a webhook. The webhook's url is concatenate with the webhook's url and the recordID.My script is running well but it concatenate only the recordID from the row 01. Whenever i checked another box from another row...My question is : is there a solution to concatenate with, my webhook's url, the recordID from the row that i checked the box ?Here's my script : (a mix of everything I found on the internet) let url="https://hook.eu1.make.com/XXXXXXXXXXXXXXXXXXXXX"let table = base.getTable("Ligne - Matériel"

Hi there,I'm quite the novice at Airtable at the moment and would love some help with from anyone whom is knowledgable with the SendGrid integration and/or can figure out a solution for this problem. I understand how it works, surface level, by adding {field}s to the HTML however, it is not as dynamic as I want it to be. My goal is to send an email from the SendGrid integration with information from multiple rows - a dynamic list in the email that will shrink of grow depending on how many rows there are.Is there a way to add a repeating group in the HTML-code of a SendGrid email that is pulled from Airtable?Is this possible? If so, how? 😭

Hi there,i have an automation question that I can't get around. Using Airtable as a CRM system, I have a table DEALS, a a table CLIENTS and a table BRANDS. I would like to build an automation that checks on a new DEAL if a CLIENT has placed a DEAL with that BRAND before. The DEAL name contains the name of the brand and all DEALS of the CLIENT are referenced in the CLIENTS table.It needs to be something like:Trigger: New DealIf CLIENT(from DEAL) has already a DEAL that name contains the name of the BRAND (from DEALS) then set „NEW CLIENT“ field to TRUEanyone that might be able to help me out here?thx!!

Hi! I have 2 tables from which I am making some matches with scores. There results need to be put in the third table. I am trying to create new records like this:for (let i = 0; i < 5; i++) {let mentor_index = ranked_mentors_indexes[i];let new_matching = {"Unique IO Mentee": mentees.records[mentee_index].getCellValue(field_mentee_index),"Unique ID Mentor": mentors.records[

Hi Airtable community,My script is taking too much time to complete and going over 30 seconds limit. I would appreciate if you could review it and give me some tips. Here's the code:let emailSendersTable = base.getTable("Emails to clients"); let listingsTable = base.getTable("Listings"); let emailSendersQuery = await emailSendersTable.selectRecordsAsync(); let updateBatchSize = 50; let recordsToUpdate = []; for (let emailSender of emailSendersQuery.records) { if (!emailSender.getCellValue("Budget") || !emailSender.getCellValue("Size") || !emailSender.getCellValue("Area") || !emailSender.getCellValue("Layout") || !emailSender.getCellValue("Features")) { continue; } // Access client requirements directly from the "Emails to clients" table let budgetValue = emailSender.getCellValueAsString("Budget"); let budgetRange = budgetValue.match(/(?:~\s*)?￥(\d+,\d+)(?:\s*-\s*￥(\d+,\d+))?(?:\s*~)?/); let minBudget = 0; let maxBudget = Inf

this is probably the dumbest question.i have a table with a list of organizations (Members table) and a single-select field that tells me whether they are members or not.i have another table with a list of organizations that have sent someone to a training (All Orgs table).i made an automation triggered by when a new organization is added to the All Orgs table to search for that org by name in the Members table and update a field in the All Orgs table to indicate if the org is a member.when i test the automation, it finds zero records, even where i can see that the orgs are in both tables. the condition i am using is:Where 'trim org name' contains 'trim org name''trim org name' are formula fields i made in both tables, just in case there are extra spaces in the org name fields that would make the find fail.what am i missing?? i'm guessing it's something so obvious. thank you!

 Hi there,  Really hoping someone smart can help! Here is the situation: I have one field with the title of a movie (example: "The Lego Movie") and another field that is an attachment field for adding a movie poster image. Currently, I can manually search the web and have air table attach that image, but is there a way to create a formula/automation or script that: 1. takes the text in the "movie title" field > searches google for that > and attaches the first image it finds to the corresponding attachment field.Anyone that has a solution, you're amazing in advance! 

Needing some info on Updating a Dropdown Dynamically as the conditions change,ATM Placed (0) is Green StatusATM Not Placed & Number of Days In Program is Less or Equal to 29 Days is Green StatusATM Not Placed & Number of Days In Program is Greater or Equal to 30 Days & Less or Equal to 59 Days is Yellow StatusATM Not Placed & Number of Days In Program is Greater or Equal to 60 Days is Red StatusCurrently have the automations set up the way in which I think it should be working over some previous forum support and still doesn't look to be updating in real time.More details in video.

I set up schedule automation to find records under certain condition and delete those records.however, using script to delete the found records doesn't seem to work.the script I'm using here is the following:---------------------------------------------------------let table = base.getTable("각종주문서수집");let inputConfig = input.config();let recordId = inputConfig['recordID'];await table.deleteRecordAsync(recor

What I want to do is to collect some data from an Interface, and then pass that data to an Automation script. I do not understand how to do this. My current state is as follows:- I have written the Automation script. For testing purposes, I have created some inputs under Configuration, and this is all working correctly. The script gets those inputs via input.config()- I have created the Interface, with two record pickers and a button.I would like to connect the Interface and the Automation script by running the script, passing as inputs, the values from the Interface's record pickers. How do I do this?

Checking for a completed 'checkbox' field seems pretty straight forward but for my purposes I have multiple tasks per individual entry (via rich text formatting in a long text field). Can I create a formula to automate checking individual checkboxes within a single cell, and then update the record accordingly? 

I am having issues with my task base. Right now I have one table with all the tasks and then separate tables with each individual employee. This way they can look at their tasks separately not through separate views. I am having the issue right now that the information won't transfer every time a record is updated. With the different views it's hard to get an automation right that all the information transfers. Please let me know an easier solution or if I need to fix my automations. I've attached photos.

I have created URL for the prefilled form via formula. As described I used prefill_ where the underscore is used. The URL works fine from the base. The problem is when I use this URL in automation via GMAIL the “" underscore is removed. Only the last "” is there. Why? Any help? Here is the link after email received (sorry i removed part of the link): https://airtable.com/xxxxxxxxxxxxxx?prefill Januar=21.8&prefill Februar=-3.2&prefill ROK=2020-oproti-2019&prefill HOTEL=Hotel-SET&prefill Marec=-63.9&prefill DATA-TYP=Obsadenost&prefill April=0&prefill Maj=-59.8&prefill Jun=-69.8&prefill Jul=-42.7&prefill August=-55.8&prefill September=-46.1&prefill Oktober=&prefill November=&prefill_December=

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

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 h