Automations

Hi!, which billing do I need in order for this feature to run?Thank you

Hello,I'm seeing conflicting info floating around and nothing within my account settings that indicates when my automation limit/usage resets.And I hear 50 total unique automations triggers per Base is the limit, but there is a way to purchase/add more to our account?Reset Usage:My billing cycle appears to be on the 22nd and we are currently at 37,000/50,000 which seems unusually high in just a week, so it makes sense that it is the 1st of the month.We are on the PRO planI've seen info saying it resets on the 1st and some on your billing date.Can someone help?I have a 40,000 run I need to do on my data base and am worried about using them all up today (13,000) and then being out of automations until my next billing cycle of 22nd.  That would be a problem, esp since we can't purchase more.Total Unique Automation TriggersI've hit my limit of 50 several timesHad to combine some, make them more efficientDelete someI read there is a way to purchase additional automations.  Anyone

Hi there, My Goal (Image 1)I am trying to automate an email newsletter to send job postings stored in an Airtable base using the SendGrid extension. Context:In a Jobs table I auto generate the HTML for this list item in a field. (Image 2)In a Newsletter table, I lookup the HTML list items, of the jobs that are included in the issue and put it into an unordered list (UL). (Image 3)The Problem: When I parse the UL {listings} into the Sendgrid extension, it only displays the raw HTML. (Image 4+5)When I paste the raw HTML directly into the SendGrid extension, it renders it correctly. (Image 6+7)The same is true when I use this in conjunction with an HTML template from SendGrid. How can I fix this?Many thanksThe problem: When I parse the 

This question summarizes the issue: https://community.airtable.com/t5/automations/find-record-invalid-filter-error/td-p/100768I am running into this issue where the FIND RECORDS step doesnt work. The frustrating part is that it sometimes works... I added a script to delay 20 seconds thinking that was the issue. Email (duplicate) and email in the other table definitely match... there is not multiple matching emails.Totally confused why I'm getting errors. Everything seems to work:    

Hi,I'm struggling a bit with a slack automation. the idea: we have a list where all new customer appointments go in. Every day at a certain time the automation pushes the total number of appointments into a slack message. Now we have customers that make more than one appointment and we would like to also understand the number of customers. It would need something like: length of records unique but I cannot find anything like this.thanks a lot for your support!

I have "table A" that holds clients. "table B" holds items. I want to see if there is a match for a field value. If "value 1A" from table A is < than "value 1B" from table B its considered a match and i like to receive the recordID for both.

Hi, I have a track table and an album table. When an album status changes to “ready for release”, I have an automation that finds tracks that belong to that album, then feeds those IDs to a script. The script should do the following: Based on the track info, populate an “internal number” (works fine) Do another query on those same ids, but sort by this newly added “internal number” and another existing field, then update track numbers in sequence. It appears that the new search does not return results sorted according to what is specified in my script. Any ideas why? I also have this script separately from automations, where I go and pick an album manually, and that one works 100%. I’m not sure why the same thing in automations isn’t behaving correctly. // Sort by: // - album (fieldToRank1), // - the newly added main track number (fieldToRank2), and // - nesting sort position (fieldToRank3) // to create and inject Harvest track number in each track. var harvestTrackNumber = 0; sa

I'm stuck on how to create this automation so any help is appreciated! I have two tables:Table 1: Each record corresponds to a purchase, with the following fields:"Transaction Date" for the exact date the purchase was made"Cardholder Name" for the purchaser's name displayed on their credit card.Table 2: Each record corresponds to a purchaser, with the following fields:"Full Name" is the purchasers name (exact same name as the "Cardholder Name" from Table 1)."Status" is a single-select dropdown that has the three options: New, Inactive, Active.I have created a working automation that does the following: When a record matches conditions: "Transaction Date" is on or after one month ago, find records in Table 2 where "Full Name" matches "Cardholder Name" in Table 1 AND update "Status" to Active. Essentially, If a purchase was made in the last 30 days in Table 1, this finds the record of the purchaser in Table 2, then changes their status to Active. I also want the follo

Hi all,  I would like to create an automation that triggers when a new record is created. This record contains a field "date" without time. After the trigger, the action is to create multiple records with a field "date" with time. I would like to use the date from the record in the trigger and add a time afterwards.Exple:- Trigger = new record created with a field Date equal to "22-05-2023"- Action = Create 5 records, taking the date of the trigger, and adding time -> "22-05-2023 14:00" ; "22-05-2023 15:00", etc. I have tried to achieve this using a script in the automation but it doesn't work. Somehow the output in the script testing is correct, but the value displayed in the created records are wrong.. Any idea? Many thanks 

Hi,I have been cracking my head for hours trying to find something in Airtable documentation for this.We are trying to upload Airtable attachments to our website (so we don't have to rely on Airtable). Is there a way to:1. display the Expiring Download URL in a field (using some formula) and2. change the the Expiring Download URL's filename (because they look absolutely horrible) using an Airtable automation script prior to sending it to our website?

Building a simple library management system in AT.  Would like to send an automated email reminder to folks with books overdue.  Because AT doesn't allow sending emails to non-collaborators, I have to use the Gmail email action.  I'm running into this error causing repeated failed runs:  Precondition check failed.I'm attaching screenshots of my automation overview and detailed shots of the Gmail portion.  Thanks for any help!    

I have a formula field in one of my bases that is designed to show us how much work is left to be done before a project's start date.So we have the start date and the number of outstanding tasks.  The formula field looks at those two fields and lets us know how many tasks per day are due.What I would like to do is drive an automation flow in the event that formula field spits out a number that is higher than it was before.  In other words, if we've been at 2 tasks per day but it jumps to 3 tasks per day, I'd want to know that.But I don't see any straightforward way to monitor a formula in this manner.  Anyone have any creative ideas?

Hello everyone,I am currently trying to set up an automated workflow using Tally.so and Airtable and need some help.Here's the process I'm looking to automate:A user fills out a form on Tally.so, providing their email, name,The form submission is collected in an Airtable base. - Table usersUpon the new record creation in Airtable, I want to automatically assign a code to the person. - I have list of all coupons in second table named CouponsAfter the code is assigned, an automated email should be sent to the user with their assigned code.I believe I need to use Airtable's Automations feature to achieve this, but I'm struggling with updating the record with the assigned code.The problem I'm encountering is that when I'm trying to update a record, I'm getting the whole list of records in one cell, which is not what I want.Has anyone implemented a similar workflow or can provide guidance on how to achieve this? Any advice or detailed instructions would be greatly appreciated!

Hello,I would like to create a job board with webflow and use Airtable as a backend when an application is submitted and send an automatic email summarizing the application (for the applicant and for me)First question :- Does an airtable form can be dynamic depending on the job page ? I don't want to create a new form for each job

Good day to all,I am currently using both Airtable and Softr for my endorsement platform. Here, our internal team uploads more than 2 pdf reports via Softr with a sample file name convention: trinidad_franco_luis_cruz_CIBI_negrec_)511_h7tezeubi.pdfHowever, once client has downloaded the PDF file in Softr, this is what will appear. The client can’t download the file in PDF.Then these are the steps currently being done: Our internal team uploads several reports in the Softr page.Once uploaded, there is a script developed and placed in Airtable (please see screenshot) wherein the attachments uploaded are readable in the backend.Once an attachment has been extracted and read, it will automatically go through another table in Airtable for matching with the name endorsed by client.Once matched, the report will be viewed already by the client via Softr.I believe that there might be an error when it comes to the script developed as I observed when I checked Step 1 in Softr, the reports ar

^ Sorry about that subject ... I don't know what I'm doing.So ... I have Table Vendor, and Table Transactions... the Name field in the Transactions table sometimes contains the same text as in the Vendor field (which is called 'Who' [i know ... awful field name]), but not always, so I want to search for the text in the Transations:Name to find a the name of the vendor in the Vendors:Who field.I'm trying to find a way to search the Vendors so that it'll populate the LookUp field or linked Field automatically.I made a view that has all the empty vendors fields.. and I am starting an automation that triggers when it's entered this view, then I wanted to search the vendors list for the text that is in the Name field ... but ... i can't do that ... it'll only find the entire line, cause it's taken from a bank statement, and you know how weird those are.For instance if the Transaction name would be "RECURRING PYMNT 6MAR2023AIRTABLE.COM/BILL CA 716.76X1.397259891" I want to search and find Ai

I have looked through a couple of the other posts about this and they didn't answer my question 😕😕I have a forms to airtable automation that I am trying have send an email summary of the form responses. All of the steps of the automation are running successfully except the email message and I am getting the error "message could not be converted to a string." I tried having the data pulled into the email from both the google form and the second lookup function and both are giving the same error. Can someone help me out? 

how can i match ‘exactly word’ in Automation trigger condition using contains? look at the image below

I am trying to automate emails through my plus plan on one of my tables, but I keep getting this message when I try and set it up. "On your billing plan, you may only email collaborators with verified emails." Does anyone know what type of plan you need in order to automate these emails? I can't seem to get a hold of customer support. 

Howdy AT community!Hoping an AT wizard can assist with the below forms automation conundrum:I have a subscription activation request form for a particular subscription product whereby customer organisations/managers can submit up to 10 nominated subscribers.  Form record fields are minimal, just nominated subscriber emails and organisation are required (with subscription product name hidden on the backend). I have set up an automation that creates records in a Product Slices table as submissions are received. However, the automation creates 10 records in the table regardless of nominated subscribers submitted (resulting in a lot of blank records!) Furthermore, the Organisation name does not populate for the first record created for some reason (see attached images). Can anyone advise on a way to tweak the automation to only create records against submitted nominated subscriber emails? 

No answers.  3+ support requests over the past couple days at a 'business critical' support request level.  Is this isolated?  Any ideas?  We have only used half of our automation runs.  This is going on with all of our automations.Can someone at AT at least let us know what is going on?  All of our operations our totally screwed up. 

Is there a way to use the automation to create a table based on tags? For example, if I had a table with entries that were tagged "A" and/or "B", would there be a way to create a new table with just the entries tagged "B"? Cheers!

Hi everyone!USE CASEI work a lot from the phone, talking with many clients and handling many projects. I talk with them with WECHAT, not with whatsapp. Any time a new task arises, I take a screenshot, and later when I arrive home I check them all and add them to my to do listOBJECTIVEI would like this process to be done automatically. I know I can use a form in my phone for it, but I just want it faster because is a process that we do it all the time with my team.MY ATTEMPSI tried sending the screenshot to Slack and then to airtable but I couldn’t manage to send an image, the text inputs where ok, but I couldn’t do it with the image (I tried with zapier and make). The same thing happened when trying with Telegram.Also I tried using iphone's shortcuts app, but same thing happened, text strings can be sent, images no. Any ideas out there? 🤖Thanks! 

Hi all, I’d appreciate some guidance on how can I change the filenames of my attachments. I have a table with 500 records. Every record has a name and multiple images (attachments). The attachments have identical file names in multiple records, e.g I might have a file called 1.jpg in one record, then a different attachment in a different record with the same name of1.jpg. I managed to find a script that does that, but it changes the name only for one attachment. Ideally, would be to create a rule that adds to the current filename, the name from another field. e.g: Gorge 1 + current filename.jpg // Setup const mainTable = base.getTable("Test") const mainQuery = await mainTable.selectRecordsAsync() // Build new attachment data let updates = [] for (let record of mainQuery.records) { let attachments = record.getCellValue("images") if (attachments.length) { updates.push({ id: record.id, fields: { "images": [{

I just want to comment that the 25 automation limit per base even at pro and above level is pretty weak. I was initially excited to roll some glue factory (Zapier) automations to Airtable, but quickly realized how limited this could be. With a pro account with Zapier, automations are unlimited. This helps when you just want to do little things like you might in Airtable (simply updating field or sending confirmation emails. I think @Bill.French had some good points about this in another string. Pricing and usage limits for automations I know automations are new so maybe you want to tweak first and that is great, but we need this lifted soon if you want more adoption. @Evan_Purcell