Automations

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 

Hi ,I am trying to send an automated email which contains a table but while i am doing an automation for the same, i am not able to add the table in it.

Hi, I had used the Airtable-Sending Slack automation function well, but since a while ago, the automation keep failing.The error message is 'Received invalid inputs. Could not find Slack conversations for email:'. The 'invalid inputs' message referred to is a 'to' field, which has an input of email. It had worked well for over 2 years, and it suddenly failed to function.Do you know how to fix this problem?(Recently I just became an administrator of the Slack workspace. Does it relate to this problem?The email inputs themselves are all exact and have no problem.)

Hi, non-dev hereI have been an avid user of Airtable and I'm enjoying it but there's some things like proper pivot tables and reports I wish were available.So anyway, I am currently trying to build a report that uses live data from one table to another.When we're using excel, this was how it looked, as you can see, we would manually input a lot of the fields, and check them manually, use formulae to help us calculate some of the metrics we wanted. But we want live data and data that can be captured weekly on Airtable I've come up with a relatively.. tedious solution do let me know if there's a better way.Here's what I didI created a new table to host the live data, link all enrolled students into this record, created a column for each cell in that table that is not calculated/formulae (about 200 columns)set up an automation to make sure every new enrolled student is linked to this table. Now I have live data that is extremely hard to view, I can build an interface and be done with this

I need help in linking four tables in Airtable with automation. Our art group publishes monthly shows where our members showcase their works. To streamline the process, I have created four tables in Airtable, namely Venues, Shows, Members, and Exhibitions.The Venues table contains information on the places where members have previously exhibited their works. The Shows table tracks the shows entered by the members, with each show tied to a particular venue. We also have a Members table that includes all the members who can enter data into Airtable. Lastly, the Exhibitions table allows members to enter their current shows.I have created a form under the Exhibition table. If a member enters a show that is already in Airtable, they only need to enter their name and find the show in list. If the show is new but in an existing venue, they can enter show information. And if the show is in a new venue, they need to enter both show and venue information.I have not been able to link the Shows ta

Hello, I have one table for inventory with several different items. By column, there are items, quantity, category, and program. Category and program are selectable from a drop-down list.I also have a form for checking these items in and out. On the form, the category, program, and who checked out the item are selectable. However, the item and quantity are not. How do I get the quantity to update on the table when someone fills out the form? Thank you!

HiI have a CSV file with about 250 Dropbox share links. I would like to upload the media from these links (images, PDF's and h.264 video files) to an Attachment field in Airtable.Does anybody have some pointers on what would be the best approach to achieve this? Can't find any info on this particular problem when searching.