Automations

I’m trying to set a Collaborator field to the current user when they change the status of a row. It seems automations do not know who the current user is… :thinking: :confused: So I read about a workaround where you use the session object in a scripting step to set the current user to a variable and pull that out a step later. output.set(‘current_username’, ${session.currentUser.name}); Thing is… I keep getting ReferenceError: session is not defined So… obviously I’m missing something, chasing a solution that is not possible, or just don’t understand how scripts work. Any help?

Hello all!I am currently trying to make an automation that inputs the date into a cell of the time that is updated. Right now I can only see two options - static and dynamic. The first does not work since the input will not change with every update, and the second can only be based off of different cells. Is there an option I'm missing?Thanks!

Hi, I'm a newbie in scripting, but enthusiastic learner 🙂A little background to the request:I have an automation that runs over a list of volunteers, some of them need training for their roles.the list contains the dates of those who need training and uses OOTB actions to find which have training today: the automation checks each record, and if the date of the training is today, the automation sends a mail with the invitation link to the video training.the problem: sometime, the automation doesn't succeed in sending the mail to specific volunteers.the requirement: using script action, if sending the mail wasn't successful, to put the error message of current volunteer's into current volunteer's record, into "error" field.Will appreciate the help on:Thanks!Nitai

Hello, I'd like to know how to create new records using automaitons in B table as many as the quantity of number column(ex. 5) in A table when the status column in A table has a specific value(ex. realease).See the example below.1. Input 2. OutputI'd appreciate it if you could let me know.

Hi! I would like to make a copy of my Database, automatically, daily. Can not find the solution with automations. Thannks 🙂

I made the code below to read a row in my Teste3 table, and from that row, generate new rows according to the code. Row generation is correct, but the script is unable to record new rows in the table. Can you help me?    let table = base.getTable('Teste3'); let queryResult = await table.selectRecordsAsync({ fields: ['Valor', 'Vencimento', 'periodo_real', 'parcela_real'], }); let records = queryResult.records; for (let record of records) { let valor = record.getCellValue('Valor'); let vencimento = record.getCellValue('Vencimento'); let periodo = record.getCellValue('periodo_real'); let parcela = record.getCellValue('parcela_real'); if (valor && vencimento && periodo && parcela) { let [currentParcel, totalParcels] = parcela.split('/').map(Number); if (currentParcel < totalParcels) { let newParcels = []; for (let i = currentParcel + 1; i <= totalParcels; i++) {

When I run my following code within the Scripting App, it returns an overly useful object that I can easily sort and use to update my record with.  let sortedResults = membersRecords.records .filter( member => member.getCellValue("Result Date") !== null) .forEach( member => ( console.log(JSON.stringify(member.getCellValue("Result Date").valuesByLinkedRecordId)), console.log(member.getCellValue("Result Date")) ));  Note how valuesByLinkedRecordId, which is a lookup field set to return the date, returns the below object - and how in this object the records are incorrectly ordered by date.This returned valuesByLinkedRecordId object is fantastic, as it can be processed into an object that's sorted by date and then stamped back into the associated Linked Field so that the records are then in the date sorted order. However, when I attempt to adapt my Script App code (which cycles through all records in the table) into an Automation script that's n

In advance, thanks for this help. I work at a small company, and I'm a marketer by trade, so please be kind 😛Anyways:I have a base that's for an artist on our team. It currently has three sheetsProjectAsset TypeIndividual AssetAnd are nested together (Project is the main umbrella of any, well, project. Asset Type is [product] Screenshots, [product] videos, etc which serve as the organizational packets of deliverables, and then individual delivered assets live under that). We have very strict content approvals, so I need to get very granular with approval and content revision chains, down to the individual asset. Currently, it's working, but it's a bear with manual data entry when a new record is created. I have two (and a half) goals I'm trying to accomplish:1) If the artist were to open up a Project, and then select "Add Asset Type" (from a linked records to the other sheet), upon clicking this, I'd like to have it auto-pop the records that would nest down well: Due date,

Howdy AT Community! Hoping a kind soul can provide some assistance with an automation query. I'm trying to track subscription activations for a University cohort, pulling from a large Uni Cohorts table to update a specific cohort tracker table.  Desired automation flow is as follows:Student submits subscription activation request form > record is auto populated in main Uni cohorts table (first name, last name, email, Uni name) > record 'Status' field is set to 'activated' if approved in main table > student record status field is updated/reflected in cohort activation tracker tableThe list of student names and emails is already populated in the tracker table, purely need to track them in for external onboarding reporting purposes. Struggling to get the update record automation to work between the two tables (unless there's a formula trick I'm missing?)Any assistance greatly appreciated. 

I think I'm really close to figuring this out.  Here's the ideal  scenario:My accounting department hits a "Reminder" button on their interface which triggers an automation to send my Project Managers a reminder email to approve their invoices.  The email contains a grid of that specific project manager's open invoices.My current situation:- My interface button works great.  Best button ever.- My "repeating group" action is where i'm getting twisted up.  I've got a "repeat for every one in the project managers" list going. I've got a "Find Records" action that finds ALL the invoices where the "PM Approved" field is not checked. I want to send Project Manager 'A', a grid of ONLY his invoices that haven't been approved yet.  How do I add a condition in the "Find Records" action that find records for the next project manager on the list?   Edit:  I think I understand now.  The "list" can only be generated from a multiple sel

I’m using a base to conduct performance reviews and record records. On a set date, I’d like to send the relevant records to the relevant employees. While I understand how to find records and trigger emails (see below), I’ll need to use dynamic recipients, which conditionally match only to their rows in the table. I’m struggling to set this up. With 50+ employees, I’d like to be able to do this dynamically, without manually coding each recipient. Specifically, I want to send Manager A all of the records about Employee A. I want to send Manager B all of the records of Employee B. Any ideas how to execute this? Thanks!

I've searched and read related posts, but I'm still not seeing the exact same behavior.I'm using webhooks to both create records and update records. The create records automation functions as expected and creates a record with invoice number, and other order data.Now, as that order is updated (ex: ships, is delivered), it sends a second webhook, for which I have a second automation. I have a webhook triggering a "find records", but am unable to have it find records that match the condition of invoice number. If i try to select the matching record, it says, "no nested values available".I have also tried to just skip the find records step and use the invoice number (which is the primary field) in the update records step, but that also doesn't work.Error message in either instance is "received invalid inputs"This doesn't seem like the proper functionality. Any advice?

HI All--- I have several automations set up and would like to create this one below. I am trying to set up what feels like a relatively simple automation, but cant figure this out. Can anyone help? Short explanation I want that....1. when a specific form that I use, is submitted...2. containing 1 of any 3 options in the dropdown,3. to update a different record in the base.---- More detailsI am trying to eliminate a manual step that I have to do each time this form is submitted. After a form is submitted, I have to find the record and update a field to "N/A" whenever a form is submitted as Paid. N/A tells other team members that the invoice does not need payment. Basically what I want is that any time a form is submitted as "paid" it should also have "N/A" applied automatically. But I can't figure this out?! We have 3 different credit cards that we use so, really, any time the form has been submitted with any of the three cards (Paid Visa, Paid MC, Paid Amex)...

Just curious, are there currently issues with Hootsuite & automations because of Twitter?I have some Airtable automations that allow me to send unique scheduled posts to Hootsuite for multiple platforms & accounts. I have seperate automations for each platform or have one for the option to send to all.Seems like Twitter has broken the API between Airtable & Hootsuite.I am getting an error from Twitter when trying to connect to Hootsuite. Seems like Twitter is even preventing the connection to the other platforms.Twitter returned an error. Error hashes: rm18c109a07cc4fc8a, ufm18c109a07cc4fc8aCannot use the automation for any of them now. p.s. Screenshot shows the ones I am speaking of as turned off. That is intentional so I can do things manually.Just curious if anyone is dealing with the same issue. I have sent this to support also. Figured I would give it a shot here also.

Good morning team,I’m trying to run this automation script that works on a base with 82,000 records but now throws this error since May 3, 2023. This is the first time that it happened on my base.Just a bit of a background, my Airtable base is connected to Softr as well. This is the code developed:// Converts settings selections to variableslet sourceTable = base.getTable("Bulk Upload");let selectedField = sourceTable.getField("Attachments");let destinationTable = base.getTable("Bulk Upload Extract");let nameField = destinationTable.getField("File name");let attachmentField = destinationTable.getField("Attachments");let recordinput = input.config();let bulkrecords = await sourceTable.selectRecordsAsync();let chosenrecord = bulkrecords.records.filter(test => test.id === recordinput.record_id)

I have a master table Invoice with a fiels Invoice_Number and a detail table Lines.Each Line belongs to a single Invoice.In the table Lines I want to setup a field Line_Number and I want to automatically populate its value.Line_Number must simply contain the line number of its Invoice.For example : Invoice A has 3 lines numbered 1, 2, 3 and Invoice B has 2 lines numbered 1 and 2.Does someone knows how to setup this field ?.Thanks by advance.

Hello everyone,I'm asking for your help on a subject that seems simple to me, but which I've been struggling with since this morning.In my company, airtable is used in particular for the subscription to our newsletter. To date, we have nearly 18,000 subscribers. I would like to create an automation that would allow me to send a slack push, every Monday at 8am, with the number of subscribers to the newsletter and the evolution of the number of subscribers since the last week.Do you have any idea how to do this? pleaseThanks in advance   

Hi All,I am a Recruiter and I stored my candidate details in Airtable like Name/Contact No./Current Company.Now I want to share an automated email to my candidates to update their respective record. Note: My candidates don't have edit permission. Please suggest is there any way for this.

Has anyone found a way of keeping a table in AirTable fully up to date with new users when a new person is added to the G Suite Directory (GAL)? Zapier does it with personal contact but I haven’t seen anything with the global directory.

Hello, I would like to integrate an Airtable workspace to QuickBooks Desktop (2021), not online. I need automate the creation of multiple sales receipts. Does anyone know how to set up this integration?

Hi,we had a fairly simple automation - on a checkbox, send an email and put a simple value in one of the cells. We ran that for 1200 cells, the automation executions got queued, but only some of them went through to the email phase and only a couple of them got to the last step of updating the records. We are on a PRO plan, so we should have enough of quota (50 000). The automation has been working fine when testing (and apparently another couple hundreds of executions - as we know that cca at least 500 emails went through).What's going on?

Hi! I have the following problem I'm trying to solve:I have one Trip table which lists a series of trips, which each have a start and end date and a list of 4 potential locations.I have another Crew table which lists crew members start and end dates, and their location during those dates.I'm trying to figure out how I can auto-populate a field in the Trip table with the crew who are available from that building during the trip dates, depending on their availability.Is an automation the best way to try handle this?I've made some attempts but am struggling without having dynamic date entries in the automation filter conditions for finding records. There are dynamic entries for Text, but not date fields.Any help would be greatly appreciated!

I have an automation that generates an email.In some cases the fields I want to include in the email are not set yet.I want to add a conditional statement to the email composition, something like "If {name} is set, include {name} followed by a comma, otherwise skip straight to the text." I can't see a way to do this in the automations interface.I know that I can add fields to the table to do this but I'm trying to figure out whether there is a way to handle this logic temporarily within the automation.  

This is my first post so please bear with me. I have a base that I am using to track content and for project management of a newsletter. Table 1 Newsletter shows the newsletter project and has fields for Month, Year, Content (which is a linked record field), Content Attachment, and a checkbox for completed. Table 2 is where I am tracking content based on 8 common sections, month, year, content attachment, point person, notes, and content created checkbox.  I have an automation set up that when Content Created in Table 2 Content is checked it updates the Table 1 Content multilinked records. When I update more than one Content Created in Table 2 Content it only overwrites the other content in Table 1 Newsletter instead of just adding the subsequent linked record. Once all 8 Content Areas are in that field, an email is triggered to several people saying all the content is complete and is ready to go in the template for the newsletter. Is there a way to have the automation u

Hello to the community ! I'm coming to you because I'm stuck on my project.  I have a table that contains different columns and the last one is a "Button" that triggers a script. I would like to get the content of the cell "dossier" in the row of the triggered button. Row NumberFIRSTNAMELASTNAMEDOSSIERBUTTON1JOHNDOE49BUTTON2MARIADOE21BUTTONFor instance here, how can I make sure that the script is using the value 49 if I trigger the button of the row 1 ?I would like to automate this, I don't want the enduser to pick a record manually. Big thanks for you help,Maël