Automations

Hi All,I have an automation issue coming from a formula field.The lookup field is coming from Tasks table, and the regions are repetitive, so i created a formula to make it as a text and im hoping the automation will take the Regions Text to a normal editable field 'TASKS - Regions', but it updates it with a blank value in the end (the blue circle in the end). Im not sure why, but if someone can help me with this. the formula im using is:CONCATENATE(IF(FIND("KSA", {Regions (from Task Tracker)}), "KSA, "),IF(FIND("GCC", {Regions (from Task Tracker)}), "GCC, "),IF(FIND("Levant", {Regions (from Task Tracker)}), "Levant, "),IF(FIND("EGY", {Regions (from Task Tracker)}), "EGY, "),IF(FIND("WW", {Regions (from Task Tracker)}), "WW, "),IF(FIND("NA", {Regions (from Task Tracker)}), "NA, ")) Not sure if there is something wrong with the formula or its the automation, which is when the lookup field is updated, take the Regions text and update it in 'TASKS - Regions' field. Thank yo

Hello everybody, I have a weird problem with a gmail automation. When testing the automation works perfectly. The automation looks for a field value that is greater than 4 and then the actions are run. When manually changing the a value in the record that is used for the automation to a value greater than 4 the automation also runs perfectly. But when the automation its run automatically I suddenly get the following error in the logs: It doesn’t make any sense that this automation suddenly throws errors when it is run automatically, but every other way of running it works fine. Also, when this same automation is run again manually it just works… Someone any idea what’s going on?

Hi, I would like to know if there is a maximum number of automation that a base can have or if it can have infinite automations?  Thank you 😊

Hi! I've been trying for two weeks to create some automations with integromat but i can't find a solution, can someone explain me step-by-step the necessary integromato flow (i'm sorry but i haven't knowledge in the field).I have a two tables in Airtable, OR and RA. The two most important fields in OR are: Name and Surname, Machineries and Last Modified (Machineries is a multiple choice field). When i select one or more machineries in OR i would like that every single machine will be automatically saved in RA, each machine in a different row with the associated name and surname, so that i can save in each row the time the machine has started working and the time it stopped, in order to compound the utilization of the machine.Trying to do this process i incurred in many problems, when i deselect a machine from OR it does not delete the record from RA, but it duplicates the record of the remaining machines; when i select an extra machine the new machine is saved but the previous ones are

Hello, I am starting with Airtable Scripting.I need to use the content of two cells as input text for a function that formats the text in a specific way.Using this way I only get the value of the first row [0], but this needs to work for every row. It is triggered once a row is added and/or modified.   if (record && record.records.length > 0) { const inputText1 = record.records[0].getCellValueAsString("Index"); // Replace with the actual field name const inputText2 = record.records[0].getCellValueAsString("Script"); // Replace with the actual field name // Combine the content of the two cells const inputText = inputText1 + "\n" + inputText2; const jsonOutput = convertToJSON(inputText, sentencesPerSection);​ 

Hi, Currently I use Airtable to send emails. Is there a way to track if Email has been opened? Also, is it possible to update row field if email was opened? E.g. adding :white_check_mark: if was opened to field Thanks for the suggestions!

HiIn my base I have a very simple table, the records primary field is a number, each new record is the previous number plus one. All the other fields are formulas or links to other tables that fill in automatically. Each week I need to create a new record in this table at a given time, I want to do this with an automation. I want to find the most recently created record (not recently updated as other fields will update at different times) find the name of the record +1 to it and name the new record that value. Is this possible? Maybe with a script, which is a bit beyond me. I can't seem to figure out a way to do it. Thanks for the help.

There are two tables and two automations involved in a workflow.1. When a record enters a view in the first table(the sync table), it will be updated in the second table (1st image)2. When a record is updated in first table(the sync table), it will be updated in the second table (2nd image)Both automations find a record where Ticket No. contains IDAn issue is there is an error from both automations (see an image below). The record is found by mapping Ticket No. with ID, but not updating.However, many of records are run successfully with the automations (meaning most of the records are found and update to the second table). Only few records can be found but not updating (failed to run). They continue to fail even the first table keep updating.I would like to know what causes 'Received invalid inputs' in these fail cases, so I can find solution to fix with the fail one.    

Is there a way to automate the following scenario using any of the automation tools (like Make, Zapier)A change in a field in airtable triggers a 'create a campaign' on mailchimpThe campaign is reviewed and sent manually.The sent campaign triggers a 'change in status column' in the airtable.Is this kind of two-way sync possible?Thanks!

I have a base with two tables: the first is a basic table with a list of records that change somewhat frequently. The second table has a multi-select field whose options should be whatever records are in the first table-view.I'd love to have a script that goes to the multi-select field in table 2, deletes all of the options in it currently, and then replaces the options with the records in table 1. The idea would be to put that script in an automation that runs once a day at midnight, ensuring the options in the multi-select field are always up-to-date.Any idea how to write this script?

I am going crazy trying to narrow down this error. I'm trying to automate payment creation based a date, number of payments, amount, and a linked record. I will eventually layer in frequency as well. Below is the code that I currently have but I keep getting ReferenceError: table is not defined at main on line 12.   let settlementPaymentsTable = base.getTable("Settlement Payments"); let config = input.config(); let numRecords = config.numRecords; let dueDate = config.dueDate; let paymentAmount = config.paymentAmount; let matter = config.matter; // Function to create a new record function createRecord(settlementPaymentsTable, dueDate, amount, matter) { // Create a new record with the due date, payment amount, and matter ID let record = settlementPaymentsTable.createRecordAsync({ 'Due Date': dueDate, 'Payment Amount': amount, 'Matter ID': [matter] }); } let i = 1; while (i <= numRecords) { // Create a new record with the due date, payment amo

let table = base.getTable("Customer Survey Prod");let field = table.getField("Aged Days");let query = await table.selectRecordsAsync({fields: [field]});let recordsToDelete = query.records.filter(record => record.getCellValue(field) > 7)console.log(recordsToDelete);for (let deleteRecord of recordsToDelete) {await table.deleteRecordAsync(deleteRecord.id);}I am running into a 30 minute error when running this is there a way to fix it?

I have an automation set up and the test is sucessful, when its running I can see in the logs that emails are sent as expected but we are not receiving any of the emails.I saw another post which referenced some bounced emails and AirTable blovking their domain as a result, this was removed and the problem was solved. Another said maybe account had not been verified, I can't see this as the issue from following the instructions too.Checked Junk, Spam etc. but no luck, happening for me and all users who are shown as being sent emails on the logs.Any help would be appreciated, as appears I can't speak to support, which is odd!

Hi everyone, please help 😣I have a table set up in a base that automatically updates (via typeform and MAKE) with job applicants name, email and scores on an MCQ that is delivered at a later stage of the application process. I have another table in the same base that lists all the applicants along with many other fields of interest, and I have created a field called 'MCQ score'.I need to find a way to have the 'MCQ score' field (in the applicants table) automatically update every time a new entry appears in 'MCQ score' field in the second table.Essentially, I need it to recognise the email address the applicants add to the MCQ questionnaire, match it up with the correct applicant (based on the matched email addresses) and then automatically enter the score into the 'MCQ score' field. This way I would have all the relevant info to hand in one place.I cant seem to find a way to have it imported straight into the correct table via MAKE, so I need to do it on airtable.Any idea

Hello, I am attempting to create an automation which will take compare records from two separate pages and then input values from one page into another based. I have the system working for finding and inputting the data from one page to another, but the issue is that the source page has repeated entries for the same conditions (example: there are 3 entries for the name daniel, where the name is being used as a condition).Is there a way to have the "Find record" action remove repeated values from its list before outputting?If not, is it possible to do so with coding it?Thank you in advance.

Bonjour, Je suis en train d'essayer de créer une table pour créer une note de frais. Je voudrais à l'aide d'un script "fusionner" plusieurs enregistrement en fonction du mail d'une personne. C'est à dire que j'aurais plusieurs champs comme "Nom", "Prénom", "Description des frais","Montant" et "Facture". J'arrive à fusionner tous les enregistrement pour créer une seule ligne et toutes les données se séparent avec un "/" . Toutefois, le champs "Facture" qui est de type "pièce jointe" et possède une pdf ou un image n'arrive pas à regrouper toutes les factures. Voici le script utilisé actuellement: // Nom de la table sourceconst sourceTableName = "Facture de frais";const table = base.getTable(sourceTableName);// Sélectionner les enregistrementslet records = await table.selectRecordsAsync();// Objet pour stocker les données groupéesconst groupedData = {};// Parcourir les enregistrementsfor (const record of records.records) {const email = record.getCellValue("Mail"); // Assure

Is it possible to embed a jotform into a website that uses url parameters from airtable? I use automations in airtable to send emails and with links to jotforms, but I want to be able to embed these forms into a webpage, but keep the url parameters from airtbale. Is this possible?

I want to use the “send an email once a record is created” automation tool, yet I want it to from an alias account connected to my g-suit account. For example- once a user is registered to my website I create a record containing all his info. then I want to automate an email welcoming him to our service, yet I want the mail to be sent from an alias account (info@…com) and not my personal address (for example- david@…com). Airtable allows me to connect my g-suite account (david@…com), but the alias account (info@…com) cannot be connected (because there is no actual account). Any suggestions on how to set an auto-reply from my alias account?

Hey y’all, Starting to dip my toes into Airtable Automations which are pretty neat, but worried about long term maintainability if I am to lean on them more heavily. Do you all know of any ways to report errors within Airtable itself? Or is it better to wrap all scripts in a try catch & report to an external error service like Sentry?

Is it possible to set a table to sync from an Excel Sheet?  I know I can import data, and I know I can setup Bases to sync, but I'm looking to set up a Table to pull data from an Excel sheet and keep up to date with those changes.

Hi all, I've been a fly on the wall in the community for a while now, today I need some help. I reviewed this post to help me with my problem, however I'm still running into issues I can't seem to get around with my current ability. For reference, I'm getting comfortable with formulas, but have no scripting/coding experience. https://community.airtable.com/t5/other-questions/create-tasks-from-templates-table-via-button-automatically/m-p/47873#M9641 I need a template of tasks, like in the above post; but I need to be able to repeat these tasks for several projects. I've managed to get this above suggestion to work, but it turns out that I need to be able to make NEW tasks that aren't linked to each other, every time I trigger my automations.E.g. My base is built of three significant tables. A 'To Do list"  table; a Projects table; and now a task template table.The To Do list table consists of tasks, linked to the Projects table. So that table has a list of proje

An automation is failing with the following error:"field "ID" cannot accept the provided value: cannot modify a computed field" The automation is supposed to create a new record in table "grants", when the "proposal" form is filled in. However, the automation fails to create an ID in the "ID" field in the "grants" table.  What is strange about this error is that sometimes it works and sometimes it doesn't. I don't know why. Looking forward to your response.

We have two bases, a UAT and a Prod base.  Changes are made to the UAT base, and once approved, we sync to the Prod base.  We notice that the records themselves sync over, but they are not in the same order.  Are we missing something or is this a limitation of sync?

Hello, has anyone experienced this issue as of now on October 6, 2023?I usually copy and paste leads from our sheets to Airtable to directly upload leads for our campaign. However, at 5am ET, I couldn't even copy and paste a single row into our database.Is there a solution for this? I noticed announcements stating that Airtable is performing database upgrades today, so I suspect that might be the reason. However, I'm not sure if this is happening only on my end.I would appreciate hearing from others as well.

Hello everyody,I have 2 tables with date column.When record is created in Table 1, I want to find all the records in Table 2 where the date is the same.For this case i need to use a condtion with dynamic date field, I found out I can do it with a string field using the gear icon and choosing 'dynamic' instead of 'static', though I couldnt find this icon when conditioning date field.Is this function unavailable, or am I missing anything? is there a different way to do so?