Automations

Hi,Is it possible to trigger and automation task if sum of one column for a group reaches some amount.For example I have columns grouped based on the a parameter, let's say group1 and group2.Then I have another column stake and I want to trigger a task if sum of a group exceeds the sum of stake column by some number Thanks

Hi Y'all!First post. real problem. Have been trying for 2 days(script below text)I have a workplace problem that i am determined to solve using Airtable.In table: Product data i have 1500+ product records with a primary barcode field called 'BRCDP'In table: Scanlist i created there's a field called 'BRCDA' also a primary barcode field. I needed a script that is be able to compare a dataset an match the records primary field, if a new records added to table: Scanlist matches a existing barcode in table: Product data, this new record should be automatically be added to the designated linked record field.  It keeps crashing. Does anyone have a simply script for this?const productDataTable = base.getTable('Product data'); const scanListTable = base.getTable('Scanlist'); async function linkRecords() { const queryResult = await scanListTable.selectRecordsAsync({ maxRecords: 1 }); const scanRecord = queryResult.records[0]; const scanBarcode = scanRecord.getCellValue('BRCDA');

Hi, I would like to add +1 to a #Number column to a dedicated Name line in one table as soon as a record is created in another table including the same name. Is it possible?Thank you very much 🙏Example:Table/tab 1Name.      Surname NumberYohan       Lafon.      5Table/tab 2Name   SurnameYohan   Lafon   When a new record is created in table/tab 2 including this exact Name + Surname, it adds +1 (therefore it gets to 6) in Table/tab 1.Do you know how to do it?

Hi,I have an automation that triggers every day at a specific time.I want to end the automation after a number of days.How can I do that?Thanks,Jacqueline  

Hi community, I have a question related to the taggin proces. I recently uploaded a lot of data in Airtable and I have defined tags. Now I want to create an automation (with script probably) which is able to search in the description and compare with the predifined tags. If there is a match I want that tag to appear in the column "tags".I saw a discussion which somehow was related but not spcifically with matching the description and predefined tags. Is somebody able to help me? I am not a technical spcialist so hopefully it is not too difficult...Thanks!

I have a schedule I am using Airtable for. Each Day of the Week and Associated time has an ID (ex. All Mondays at 4 = 1)I have the ability for people to fill out a form and request a timeslot, but they may want the timeslot for the entirety of the season which I allow them to request. I have an automation that looks at the form request, sees that they are requesting all season and gets the ID and then finds all the other timeslots for the following weeks with that ID. I would then like to update each of those records with the person requesting so it is removed from the list and on the main calendar as booked. Any ideas on how to do this? Also made me think of an amazing feature that would be the ability to dynamically update a Views based on something automated Filter so you can then set automation of anything entering that view. 

Do e-mail automations work on the free plan?Thanks  

Hi thereI want to know if the following scenario is possible:Use an automation script to Find > 100 records, andOutput a list of the found records, andUse the new 'Repeating Group' logic to update each record from the above list.Basically, I need to find more than 100 records based on a condition ("is single select field option A selected?") and then make updates to the found records.If this is possible, am I on the right track using output.set?

Hello everyone 🙂I work for a school and some workshops are made in groups of students.For instance, I need the 6 people from the Thursday, 11am slot to receive the same e-mail, visible e-mails in the "To:" field, and to Cc their trainer.Is there a way to select the e-mail addresses from the group meeting these criterias (day, hour) and send the same e-mail to all of them instead of sending individual e-mails?My idea is to do a concatenate formula to blend all addresses, but I'm not sure how to do it, and I'm afraid it would send multiple times the same e-mail...🤯Thanks a ton for your help!

Hi All,I am currently working through learning the Automations section of AT and it's really cool so far.However when I've come to 'connect' to my Twitter account then it fails or . . . something, not sure exactly what.Here is the dialog that finally returns after I have selected 'Connect New Twitter Account'It appears to be working ok, it goes in and I can see Twitter in the background albeit greyed out, then it comes back to this screen.And of course I press 'Sign In' (several times) and it just returns to this same page.I have tried closing it all starting again, logging into Twitter in advance, not logging in..... none of it seems to have any success...Any tips, solutions or just plain good old advice appreciated.Thanks in advance for taking the time to read my question 🙂  

I have an automation that emails the count of records that match certain criteria. This often results in emails that indicate there are 0 records for consideration. I’d like to only fire this automation (or send the email) if there matched records are >0. Is this possible using the new conditional automations, or via scripting? Thanks, Andy.

Seems like it should be relatively simple, all I want to do is use a button from an interface to add 1 to a number field in my tableI'm using the button linked to an automation and here's what it looks like:And this is using a dynamic update:But here's what happens when I test this:So I guess it's the wrong format, and I can't find any documentation on formatting for this. Seems like I can't even add two fields together.So how would you do this?  

I have 100 records in a table with the same status "ready for publication". How can I use the "Find records" action to only retrieve the first found record?

We at ALS logistic solutions provide robotics pharmaceutical automation technology and innovative pharma stores that aid in increasing quality and efficiency while providing enough flexibility and performance to allow pharmacies to respond to rapidly changing requirements while maintaining a manageable investment cost. 

I may be having a particularly dense day here, however am not understanding how to automate the following situation:I have four workflow records for each project in a table. There are multiple projects in the table. The workflow records are, in order "project name" Define, "project name" Design, "Project Name" Build and "Project Name" Test.  Each has a status of "Not Started", "In Progress" or "Done".  What I want to do is, based on the trigger of the status changing from "In Progress" to "Done" in one task, set the status in the subsequent task to "In Progress".  I can select the trigger record without a problem, but how can I move to the next record in the sequence?

Hello,I am relatively new to Airtable and had a question about Automations. I set up a research table that I want to add records with Name field and URL field. I want the name field to auto-populate the link's page title when I paste the URL in whenever I create or update a record. Any idea how this can be done? 

Hi Folks, I’m having a problem with an automation that I built. Initially it worked but now it doesn’t. Essentially what I’m trying to do is this: the trigger is a new record creation in 'Table C" Then we work to update a field in “Table B” using the linked id of a lookup field from 'Table C". Then in the field area I simply try to create a simple subtraction formula: Current balance - amount But I keep getting this error! (screenshot attached) Any idea what could be happening?

This new Airtable Community Forum SUCKS so much and I cannot type it without harassing the keyboard caps key at the same time. Why on earth did Airtable switch from the old community board. If it ain't broken don't fix it. This is difficult to you, boxy, hard to find things. Is it only me having the incident notification window on the left and doesn't go away, it stays stubbornly there even after try to close. I really miss the old forums, I don't think i will come here very often anymore because this board is user unfriendly.Anyhow...My question was about Selenium. I am looking to populate text from Airtable into another web-form like commercial site and I need to enter text and upload pictures. The main challenges:1) how to get Selenium access data in Airtable and always take the next line (next record) of data2) how to upload image to the 3rd party form (I can't past URL from Airtable documents, it will have to be upload from computer but maybe there is a way to transload the images

I have an automation where an email is triggered when a new record is added. However, the emails are generic and only says: "A new item has been created in the XXX job log"How can I get this email to say what the exact record title is? I have looked everywhere and I cannot figure this one out. Any help is appreciated... I am sure it is something simple. Thank you.

I'm wondering why Airtable is saying that I can't run a script on my current plan when I am on a trial period of the Pro plan. I'm really hoping to see if paying for the pro plan is worth it for my organization. Thanks for any help!

Hey All,I'm trying to create an automation whereby, when a user checks the green "flag" checkbox for a given "Adjustment" in the "All Adjustments" table, it triggers the creation of what you see under the  "Analysis by Division" field in the Analysis Table. That is, for a given checkboxed "Adjustment" (listed in All Adjustments Table) like "Seat Molding," "Touch ID Seat Adjustment," "Heated Massage," "Meal Reheater/Composter" or "Retractable Covid Seat Screen," I'd like Airtable to automate the concatenated formula (as shown under "Analysis by Division,") pairing every one of the 17 "Team Divisions" that I have posted in the list of Team Divisions (which I have rolled up into the "Analysis" table) with the "Item Being Analyzed," which is basically a roll-up of the same checkboxed "Adjustment" from the All Adjustments Table. I was trying to automate this from the click of the checkbox in "All Adjustments" and spit out 17 concatenated records in the "Analysis" ta

I want to automate copying data from one field to another field in a different table.The Assets table has three fields:Asset NameNotesURL (where the asset is saved) Whenever a new asset is created, the user enters information into a form that creates a  new record in the Assets table. So, the data might look like this:Asset Name: BananasNotes: Used in the XYZ projectURL: URL link 001When an existing asset is changed, the user enters that information into a form that creates a new record in the Assets Update table:Asset Name: Bananas (from linked record in Assets)Notes: Second paragraph was revised and corrections made in third paragraph.URL: URL link 002Upon the creation of the new Assets Update record, the new URL value should be copied to (and overwrite) the URL value in the Assets table for that asset (based on its  Record_ID,  I think). No other data needs to be copied to the Assets table.I'm using a form submission as a trigger. Then, the action is Update Recor

Hi All,I'm wondering if there is a way to get an automation's name from within the automation.I'm working on a better error handling system for collaborative bases. When automations fail, they currently only send a notification to a single user - the person who turned the automation on or updated it last. I need multiple people to be informed in a non-arbitrary way should any one of the developers be out. I currently have something that looks like this:  output.set("update_status","success"); let buildErrMsg = function(automationName, description, name ){ let msg = description + " in " + automationName + ".\n\n" + "Failed with error: " + name return(msg) } try{ await table.updateRecordsAsync(recordsToUpdate) }catch(err){ err.description = "Issue with updateRecordsAsync"; err.automationName = "My Automation" let msg = buildErrMsg(err.automationName,err.description, err.name) output.set("update_status",msg); }  The output variable

Hi, I am new to Airtable and have a question. I have two tables, each with the same column (multiple select) for "Technology". Specifically, it is about funding programmes and investment measures. In the table of investment measures I would like to have all funding programmes displayed in one column, which have one of the same technology tags. (e.g. a funding programme has the tags "digitalisation" and "business financing", and the measure (online shop) also has "digitalisation" as a tag, so the funding programme should be displayed there in the column).Can it be done via an IF function or something else?

I have an Expense Reimbursement Form I use in Airtable. It collects things like date of purchase, dollar amount, person to be reimbursed, and an Attachment field for Receipt images. It then sends the form data to me automatically via email, but the email doesn't include Receipt Images (attachments) in the body of the email.Is there a way I can have the Form Response email include attached images (receipts) in the body of the email? Each form could have 1 or more attached images.That would be very helpful because it would give me a complete Expense Reimbursement request, or equivalent Check Request form. Thanks in advance. -M