Automations

Question: Say that I have 100 records (mined by PR miners) and it would be divided into 5 for the NR miners (NR-A to NR-E), each having 20 records each. 3 hours later, the 100 records are finished and we have more coming from the PR miners, Regardless of which PR miner it came from, I want it to auto populate or to be assigned to an NR miner such that it's even throughout.Here's what the ideal table should look like:As you can see, the records could've just been mined by PR miner A, but is still evenly distributed into the five NR miners. I apologize for any confusions relating this post. I need your help.

Hey Community,  Thanks for reading my post.  I am trying to update records in Table A (sales estimates) with a number from Table B (sales invoices) when a new record comes into Table B.  I could also do this on a regular interval instead of having a new record entry in Table B kick the automation.  Whatever is easiest. Essentially, I'm trying to get around the autolinking problem.  Sales estimate numbers are unique and when they convert to an invoice the invoice has the same number.  However, I'd still have to go in every day and link all the new invoices generated to their estimates to make the reporting work correctly.  I REALLY don't want to do that.  Any suggestions?  I imagine there are several ways to get around this, but I'm really hitting a wall.

Hello!I am somewhat new to AirTable and LOVE it! I'm currently working with the Pro subscription.I have a base where the first 2 columns (Primary Field and column immediately after) on a grid view carry through on all 7 tabs of the dataset. Each tab is recording a subset data analysis of the overall project so the records themselves are separate - to a degree.Essentially, I have the Organization name and Project Title as the first 2 columns on each tab and they will be the same name on each tab so it would be easier if I could enter it once instead of having to enter it on each tab.I'm pretty sure that I need to create an automation but I am not at all familiar with JavaScript. Would anyone have an easy hack or for running this kind of automation?  I hope this makes sense. TIA!

I have 4 separate sheets in one Airtable base. Each of those sheets form a separate calendar. I want for each of those sheets to autopopulate into a 5th sheet that creates a master calendar of everything using linked fields.I currently have built an automation for each of the 4 sheets that has "Trigger: when a record is created" and is triggered by a record being created in the individual sheet. Then the automation is "Action: Create record" that creates a linked record in the 5th master calendar sheet. The only field it is set to populate in the master calendar is the linked field with the name and record ID of the record from the individual sheet.This seems to be working fine except when new individual records are manually created in each of the individual calendar sheets. However, if I try to duplicate a record in the individual calendar sheets or create records in the individual sheets from other automations, the automation gets into a loop where it keeps endlessly creating new rec

Hey, I am trying to create an automation to update records. For example, I have a table that has a master list of contacts. I have a second table (in the same base) for a specific event - let's call the second tab, Events. When someone from the master list registers for the event, they automated get added to the Events tab. I now want to create an automation so that if the contacts name, email, title, or any other information about them gets updated in the master list, it also automatically gets updated in the Events tab. Is this possible? I have tried to set up the When record is updated automation for hours and its still telling me something is wrong.  Thank you in advance!!

I'm a new Airtable user and I'm trying to replicate some functionality I had in my previous spreadsheets integrated with Looker. I have two tables: Categories (with fields ID, Histórico, Categoria, subcategoria, and Centro de Custo) and Transactions (with fields ID, Data, and Histórico).I'm trying to automate the creation of a new field in the Transactions table called "Categoria", which should work as follows: when the value in the Histórico field of a transaction matches a value in the Histórico field of the Categories table, the corresponding Categoria value should be returned.I tried creating a formula field in the Transactions table with the following formula: =ARRAYJOIN(IF(FIND(Histórico, Histórico(from table Categories), Categorias(from table Categories))However, it didn't work as expected.Can anyone suggest a solution or a different approach to achieve this? I'm struggling with what seems to be a basic task and I'm close to giving up and going back to my confusing spreadsheets

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 - uses filter() TEST 2 - without filter() Found a zero! Found a zero! Found a zero!  Any thoughts? 

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");let queryResult = await table.selectRecordsAsync({fields: ["recordID"]});let record = queryResult.records[];let request= url.concat('?ref=', record.getCellValueAsString("recordID"))await fetch(request); Thanks a lot !

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[mentor_index].getCellValue(field_mentor_index),"procentage": similarity_matrix[mentee_index][mentor_index],};await table_matchings.createRecordAsync(new_matching);}  I am getting this error that I do not know how to resolve:No overload matches this call.Overload 1 of 2, '(fields: { "Unique ID Mentee"?: readonly { id: string; }[] | undefined; fldBBVDi3w6mPEQHI?: readonly { id: string; }[] | undefined; "Unique ID Mentor"?: readonly { id: string; }[] | undefined; fldb2AlrU2AJShSc3?: readonly { id: string; }[] | undefined; procentage?: number | undefined; fldgTMwV2nFs4Uv26?: number | undefined; }): Promise<...&

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 = Infinity; if (budgetRange) {

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(recordId);--------------------------------------------------------- when I test, this script kept throwing fail notice showing the 'recordID' of the input variable I made is an array not a record.How can I change this to scipt to work with array of recordID ? or is there any way that I can select every record ID values instead of 'list of record ID'? I don't get any other options at the 'value' box an I assign the input. 

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=