Automations

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

All day... no status issue on status.airtable.com.  Failing, pending for like 15-45 minutes on 'Find Records' step and other code steps, etc...  total headache for operations today.Is this isolated, or did anyone else get totally screwed today?   

I have a work date formula in the 'end date' column.IF(AND({Start Date},{SLA (days)}), WORKDAY({Start Date},{SLA (days)}))When someone changes the SLA number, start dates and end dates changed because I setup a dependency automation.However, I'm seeing that some of the end dates are on weekends even though there is a work day formula in the end date column. Any insight? Also including a screenshot of the dependency roll up. Thank you!

Hello friends, I’ve had an automation running correctly in the past. Today, I’m getting the following error" The Automation is simple: When Condition is Met > Send Gmail Email. I tried reconnecting my Gmail Account, but problem still isn’t solved. Clicking on Learn how to fix common issues doesn’t provide a solution. My assumption is that this is an external error to Airtable, but I haven’t changed a thing in Gmail to possibly cause an error to this automation. Any suggestions? Solutions? Thanks

Hi all,Wanted to see if anyone had any ideas why the following isn't working.BackgroundI have a table of issues each with a specific codeI also have a table that takes form submissions for the yes/no output of questions in the form.When the a question is answered "yes" I want to create a link in a lookup field to the issues table to record the specific issue found.IssueUpon the form submission the automation I have set up only works for the first question. After the first question none of the other questions answered yes are linking to the specific record.Any ideas why this is?

Been trying to update a table (Table C for our example) whenever Table A and Table B get information without duplicating pre-existing records. I am hoping that I am able to do so simply through the automations in Airtable but so far im stuck since all my attempts have led to errors because my condition cannot be applied.The my current automation process looks like this:Step 1, Trigger: Whenever a new record is added in Table AStep 2: Finds the data in Table CStep 3, If Condition: Airtable record ID  does not contain Airtable record IDcreate record in Table CI would have used the same process for getting the data in Table B to Table C. The issue here is that there is an error indicating that I "cannot assign list of string to string". Is there a workaround for this? Is there something I can edit or change just so I can get this automation working without the use of a 3rd party interface?  

Hi there,Hoping someone can help with something I hope can be automated. I have multiple fields with numbers in, let's say:Field 1A: 100Field 1B: Field 2A: 250Field 2B:Field 3A: 500Field 3B:I then have a % field, based on which I would like an automation to populate the 'B' fields (as a % of the 'A' fields), when the % field is updated. The reason I would like to do this as an automation rather than formula is that I would like the B fields to be editable to allow for bespoke amounts. Usually, the % will be the same for all B fields (there are around 10), but not always. Therefore, if I enter 10% in the % field, the numbers will populate as follows:'B' columns as % of 'A' columns: 10%Field 1A: 100Field 1B: 10Field 2A: 250Field 2B: 25Field 3A: 500Field 3B: 50The only way I can think to do this would be to have a formula field for each one that sums the % by the 'A' field, then a manual override field, then an if formula that says "if({override field}="",{sum field},{override f

I have an automation set up that I want to bring an attachment that is already in a field, and sent it along with the email message in the automation. Both Test come up successful but when I run the automation, the email does not attach the file from the field that is label correctly. Any advice please?

Good day all.  I have some records where an attendee fills out a form and selects multiple events.  This form populates several things:Calendar Table(which also generates GCal events)Junction TableAttendee's table with all the courses(Array)I want to have another table that is a 1-1 of data, in this case, I'm thinking, Attendee - CourseI'm sure it will have to be an automation that extracts from an array, and creates a single record PER course per Attendee:ben.smith@blah.com - Fun with ABC 051223 9amben.smith@blah.com - Z is the Letter 052023 10ametc, etc.  I will then have it linked to actual records - Calendar, etc to draw data from them, as well as if needed data from this table.However, I'm first looking at the automation to first extract the said data and add to a new table, my 1-1 table.something like above.  First field being the email of the attendee(s),etc 

Hi. I am using the Find Records action to return what is frequently a more than 1 item long list of results.I understand that the results are returned in an array, so when I try and append the results to a Google Sheet, they will all be listed in the same Sheet row.Has someone figured out a way to create a new row for every record in the array? Or is there some completely different way of doing this?Thanks!

Howdy, I am trying to append my airtable records to a google sheet at regular intervals, including my last modified column. How can I get it to append the actual value, and not just the character length of the value. I’m getting results like 29, 30, 29, 29… for my rows instead of 8/18/2021 10:27:31 or whatever

Hello and Good Day again! I'm writing this as I have what sounds like a simple yet complicated automation issue that I can't seem to get right. (For privacy reasons I have changed the name to different authors I hope you understand)Anyways, we had a programmer create a setup where our website updates the tables automatically whenever someone books us. So, table 1 here has customer names and the date they booked our mechanics. (The data in this table is updated from our website)Table 2 (also updated from our website) is basically a contact information about our clients and their vehicles. As you can see in Table 1, it's basically the bookings so any of the clients can re-book us and it will be logged separately (Mary Shelley being in 2 and 4). However, in table 2 she's only registered once and thats what our programmer did.Now on to my issue: Table 3 was supposed to use airtable automations to gather the Clients name and mechanic from table 1 and the vehicle from table 2

Is there a way to run an automation where I can find the next empty cell in a column? I am trying to run an automation where the next empty cell in a column is found and then copy some value from another table over to that empty cell. For example, I have a table with usernames and passwords and another table with names and empty columns for usernames and passwords which will be copied over from the other table. I know there is a FInd Records action where I can look for empty cells, but that action returns all empty cells and not only the first empty cell. I think I can get this to work by creating a third linking table where I can automate creating new rows with values from both tables but I am sure there is a simpler way to just find the first instance of an empty cell on a column. Name Username Password Peter User1 Password1 Joe User2 Password2 Mary User3 Password3 Paul Albert Bob

Javascript baby here. My ultimate goal is that when a record is created and matches conditions, a script will run that will duplicate that record a number of times and update it's status. I've been modifying a duplication script from an extension script, but I'm a bit stuck on how to make it work for an automation, and if I'm even doing the right thing. If you have a moment to take a look, I would really appreciate it!Here is the code as it stands:let table = base.getTable("🏁 Tasks") let fields = table.fields let query = await table.selectRecordsAsync({fields: table.fields}) let records = query.records //I have a set number of records that will need to be duplicated based on information from the base which I think should be inputConfig.numRecords let inputConfig = input.config(); //exluding only one field let exclude = ["Dependent On"] let filteredFields = fields.filter(x => !exclude.includes(x.name) && x.isComputed == false) //I'm not sure if I need this par

Hello all,I am currently trying to send an automated email to a target person once a certain date assigned to them is reached. As of right now, I only see triggers for when a date is an exact date, but it must be the same date for the whole base, and not dynamic per each certain date that is unique to each target person. Simplified: I need to set a trigger for a date that is set for individual rows, is this possible?Thanks!

Hey Airtable community,I hope someone can help me 🙂 I am having a table in airtable with different projectflows in each record. In a collumn of the record the email of the respective POC is entered. Once a month the POC is asked to update different other information in the records. For this I would like to send a monthly reminder to all POCs who have not updated their records yet. I have managed to create an automation which filters which records are updated and which not and then sends out an email to the list of email adresses of the records which need a reminder. My problem is, that some POCs are responsible for multiple records and would get multiple reminders. But I would only like ONE email to be send to each POC. So if an email duplicates (or more) I would like it to be used only once. Does somebody know, who I can do that ? 🙂 Thanks in advance. 

what is the email send limit using outlook? i can't tell if there is a daily limit of sending emails only if using the regular airtable email function, or if it applies also to emails sent by outlook.also, is this daily limit per user? or daily per workspace?we've been thinking about expanding our use of airtable to manage projects. but it would involve assigning many tasks to non-users, and it would also mean sending reminders for overdue tasks. i'm concerned that we would potentially hit that limit quickly. thanks!

Hi there,As the title says, I'm trying to send a POST request using Fetch to a Zapier webhook. This works fine, except when the Fetch is placed inside a function, it is never sent.Checking the network log, the request seems to be stalled indefinitely.I tried sending the request using the same code outside of Airtable, and it's working. The request is sent to Zapier.I've scoured Google looking for similar issues but couldn't find anything relevant. I tried async and not, try/catch, and adding headers, but nothing so far. Has anybody encountered this issue before?Appreciate any help and suggestions 🙏 let table = base.getTable("Testable");let record = await input.recordAsync('Select a record to use', table);let bugID = record.getCellValueAsString("Bug ID");let kustomerLink = record.getCellValueAsString("Convo Link");if (kustomerLink) {    send

Hi,I currently have several dashboards for client fleets using Interfaces. On these I use the Field Summary to calculate the percentages of a fleet based on whether they are 'active' and within a servicing window. What I would like to do is automate a function to grab that Field Summary data and at the end of the day input it into a new table to historically graph this data for analysing trends. This is already graphed and I simply enter the data manually. I know how to automate the trigger but after extensive reseach I think the only way to grab and record this would be a script.Thank you,

Hey friendsI want to build a content plan for social media according to dates.So:I have several tables for each platform:1. Facebook2. Instagram3. Tik Tok4. Email marketing.In each such table I have the topic (story, post, etc.), the upload date, the content itself and status.I also have a master table that contain date, status, comments and also contain a Facebook, Instagram, Tiktok and email marketing column (linked columns).I want the main column in the master to be the date and actually when I write a certain date it knew to pull me to my linked columns what needs to be uploaded each day according to each platform.For example, I will choose the date 05/18/2023 - it will automatically fill in the Facebook column what needs to be uploaded that day, in the Instagram column what needs to be uploaded that day, etc.I tried to automate it but I'm completely lost 😞I really appreciate the help!  thank you!