Automations

I have a simple automation set up where once I move a record to a new column on a Kanban view, it sends an email letting us know that we need to review. However, it fails at the action step and says “Google reported an error while processing this action: Insufficient Permission”. Does anyone know how to fix this?

Goal:  Recreate many-to-many table links on synced records in the destination base based on csv text field of original source record idsContext:Have synced multiple related tables to another base (for reasons of access control, division of unrelated data. Overall syncing 6 of 25 tables to another base)Several of the links are many to manyI have added record_ID to the source tables, and created formula fields that arrayjoin the linked records into a csv (comma separated) text fieldI cannot use the primary name field because they are not uniqueI cannot use the update records directly because I do not have the new destination record IDs for that csv list of source record idsI cannot use the find records because it's not letting my search by each item.  This means that this problem would be trivial if I only had a 1 to many relationship and worked from the "1" side.Potential Solution areas:create "an array" accepted format of items in a formula fieldconvert csv text into an array

Hey-I will spell this out as simply as I can!I've got 2 tables.Event RequestsHostsTable 1 has a linked field titled Possible HostsThe Possible Hosts field contains records that are automatically linked via automation. [the automation basically finds potential hosts for the event request based on certain criteria such as guest count, amenities, etc and the automation will then add those records as linked records] SO FAR SO GOOD! My question is: I'd like to now sort the linked records so that the records [aka Hosts] with the highest number of 5 star reviews show up first. We have that data point in the linked table of Hosts.  The reason why I need this is because we want to then automatically send the top five Possible Hosts [based on number of 5 star reviews located in the field titled Host Score] to the guest via automation so that they can choose from the best hosts. There will be times when there are dozens of linked records from the 

Dear community,This is my first time posting here but I would like a script that allows me to find > 100 records. Automations has a limit of 100. All the script needs to do is find all the records in my 'user' and update them as linked records in a column in the 'retention' table.Reason for this is that I want to calculate the retention of the user base, unfortunately I have 1300 records/users that I need to include all of them in this calculation. Does anyone have any experience with this?

Hello all.I have an order table with a status column and a dropdown list.When the status column has no defined values, it launches an automation that needs to run a script every 15 minutes that queries the status via API from a remote server.I need to properly parse the response from the server and write it to the status column.At the moment I can't figure out how to pull the json status from the response where the status of the request is and update the desired row.I will be very grateful for help. const shopid = 'b6e1835a-85a8-4f34-b445-d9d0934ffcec';let inputConfig = input.config();let orders = inputConfig.order; let table = base.getTable('Orders'); let id = inputConfig.record;const options = {    method: 'POST',    headers: {    'Accept': 'application/json',    'User-Agent': 'Airt

Hello,I'm looking to see if it's possible to pull data FROM Power BI into Airtable. A lot of info about Airtable data going into Power BI but not the other way around. Census seems to have an integration that would accomplish this. Any thoughts or other recommendations? -Bryan 

Hi I recently noticed that Airtable to Power BI link is not working effectively. Some of the columns are not visible. Has anyone else faced this problem before? Any ideas / thoughts / suggestions? @Bill_French 

I have an automation that finds matching records for me and I, in the next step, need to update these records by checking a checkbox (true). As there are two or more records found each time I presume that I need to run a script to achieve this. I'm a complete newbie to scripts; I have used readymade scripts, but never altered (other than to change name of table, view and/or field) or written one myself.  I have searched for an answer and even tested to modify found scripts with no luck. Could anyone help me with a script for this?Table name: PeopleCheckbox field name: Sync

Hi there,I am building a use case for airtable for my company, and this involves linking data collected via an airtable form to membership data which is held externally to airtable. I need to match the records from the form entries to those in the membership data and import the relevant membership number for each individual into a column in my airtable base. Is this possible? Do you have any advice on how best to implement this? Thank you! 

I think this may be a bug, but searching didn't reveal anything.When I have an existing description for an automation and want to edit it, the description field clears out, necessitating starting over again. Screenshots:That screenshot shows there is a description on this automation. Below you can see what happens when I click "Edit Description."Why it matters: It's very hard to view the complete automation title. We have many automations that do various versions of the same thing, so the description is very important.You can't select and highlight the description, so you basically have to start over when editing. The "Edit description" field also seems to be a single line text field, so it's almost impossible to see the full thing.Duplicating automations is extremely helpful, but if you can't easily edit the description, it loses some utility.

Hi there, I'm getting started with automations from my team.What I want to do :TRIGGER: when a record enters a view/table (let's say table A)ACTION: Find record: check if the record exists already in another table (table B)Conditional actions: - if it does, update the existing record in the table B- if it doesn't, create a new record in the table BFor now I have the following on my testing base: My issue lies on how to set up the conditional logic (basically to say "If the record is found, update this specific record).I have a testing error here and I'm not sure what is wrong.I've tried looking at this knowledge base article but when I click on the different set up actions it doesn't do anything, even with another browser My goal is to create a masterlist of advocates from different programs (different teams using different tables), and some of these advocates can be in multiple programs, which is why I want to avoid duplicates in the masterlistThank you for any help!!

I have a table filled with applicants. I am trying to automate the process of sending rejection emails. My triggers are set to when a record matches a condition (particular stage and a checkbox is blank). I receive no errors while testing and can see all the matching records. Despite the automation being "on" it has not sent any emails. One thing to note is I had all the relevant applicants set to this stage before creating the automation but not sure if that makes a difference

Hello all,  I am new to airtable and I started struggling with a few things. For my Base is Financial Data setup and I also use Make integration that collects some financial data via HTTP reqest, parse data and send as update to airtable to existing fields.My table contains different fields some are $, some are Numbers format, some are timestamp and some are text. First problem i encounter is when Maker gets data, and wants to Update record it works fine but only if all is 1:1. It fails if some of the records in HTTP request are Blank, or have "-" or for example "NA".Problem i assume is because airtable field is set for Number and Make is sending update as Value=char/sign.The other field was expecting a timestamp but Make was sending blank value and that failed which is weird why it would. I suppose it should just skip value.2.This problem is regarding same issue but is very weird one.In my HTTP request/api call, i have 3 fields and all of them are timestamps in USA form

Apologies if this is not the right topic category for this. Our Airtable automations have been stuck “in progress” since around 1:00pm today and it’s pretty much halted our business operations. :frowning: However, it says “No incidents reported today” on https://status.airtable.com/. I submitted a bug report via Airtable’s “contact support” chat bot a couple hours ago. Not sure what else to do. Is there a better way to report “incidents” like this? The automatic email response I got for the bug report mentions live chat, but I can’t figure out how to access that on the Airtable interface. Thanks for your help!

I previously had this automation working but has for some reason stopped working. Although the file name is uploaded, the isn't actually anything in the image file. Process is click on the 'Process PSDs' button and this fires a webhook to make, which then uploads to s3.This is the script that runs on button click:// ---------------------------------------------------------------------------- // 🚨 STEP 1. 🚨 // Change 'Test' to the name of your table. let table = base.getTable('Pre Mock Prod (PB)'); // ---------------------------------------------------------------------------- // ---------------------------------------------------------------------------- // 🚨 STEP 2: 🚨 // Change the following url to your Zapier webhook. // To get a Zapier webhook, click the below link, then choose "Catch Hook" as the trigger event // https://zapier.com/app/editor?create=true&template__0__selected_api=WebHookAPI let webhook_url = 'https://hook.eu1.make.com/o2svol1v14

Hello all,I know this looping question has been posed in various forms over the years, but I could use a gentle nudge in the right direction as my research has reached an impasse.I have two tables - the 'primary' table has ~1200 records, and the 2nd table has ~800 records.  I'd like to create a script to compare the two tables and update field XXL2 in the primary table with the string 'XXX' if a matching record in the 2nd table matches a field in the primary table.I have seen that I need to populate an array with the 'found' results and then cycle through updating the results using slices of 50, but I know there is more to it to ensure that the code completes within the 30-second timeout.What I have thus far is: let uncontractedComponentsTable = base.getTable("Uncontracted Components Report"); let vsaCancellationsTable = base.getTable("VSA Cancellations"); let updates = []; // grab the records from the Uncontracted Components Report table let uncontractedComponentsRecor

Is there an easy way to remove the color highlights from an automated report? I want the colors to exist in the base, but when an email goes out in grid form I'd like the color highlights for different categories to not show up.

How can I set up an automation in Airtable that will update records in the status column once a week, but only if they meet a certain status type, such as changing records with the status 'DONE' to 'Archive'?

Hi!We have 7 different “campaign” types we sell to our advertisers, many of which have overlapping items (i.e. and Instagram Story). I want to create automations so that when a new record (Campaign A) is created, all of the line items for that type of campaign are also created, along with their starting point for each cell. The issue I am having is, since Campaign B also has an Instagram story, but has a different starting point, the cells within the Instagram Story line are initially populated correctly and then overridden by the other automation. Is there a way to have them both be live, or will each line item in every type of campaign have to be different, even though they are the same product? I’ve attached two screen shots of the different automations for you to see what I mean…

Hi all,I'm building an advertising database for a publishing/newspaper company. I have an automation that whenever an ad order is placed in one table A, takes Record Name X (Ad order number) and Values Y (Issue #s) and makes a record in table B for each (XY1, XY2, XY3).This is effectively our ad order history.Is there a away to automate so if the ad order in table A is changed, say an issue 3 (y) is removed, I can identify what value was removed and go and find that entry in table B and check a box that says "ad cancelled?"And conversely, if an issue is added to an ad order, could I identify what issue number is added and then generate a new record in table B for it? (Say XYIssue5)?Thanks!

I recently had to update our password on Hootsuite... we have posts automated to post on Hootsuite from Airtable, so I immediately went into Airtable to update this account info... Unfortunately Airtable gives the error "could not authorize this account" repeatedly... If anyone has any ideas on how to fix this I would appreciate it. 

HiI want to define feature status by automation.For example, if all the user stories of the feature are done then the feature is considered as completed.Is it possible without a script ?Thanks for your help.

Hello everyone,In short, I am trying to use an automation to combine multiple single select linked fields into a single multi select linked record.I have two bases: projects and team. Depending on the complexity and size of the project, there may be 5-15 resources assigned. We assign these resources through their own single select linked field so that we can utilize the timeline/utilization function. This makes doing things for the entire team complicated - such as creating a distribution list for the team members -  as we have to create a lookup field for each resource's email, another field to combine them, and another field to format it. I thought a simple automation could address this issue. It is pretty simple: when one of the 15 single select linked records is updated, it updates the multi select "team" field with all the assigned resources. I am running into two issues: 1)If I don't put a separator, then the multi select merges them all together (Instead of the field h

I'm a javascript developer, but all the examples I can come across are either too nuanced or specific for my needs, so I'm hoping to find a simple script to take the following table which has a column of linked records from a third table:Table_1IDLinked1A,B2B,C,DAnd spit out the following table:Table_2IDEach_Link1A1B2B2C2DThanks!

Hello - I'd like to update a date field on a table when an Outlook email is sent. I'm assuming I need to set the "New email is received" trigger and associate the "Sent items" folder in Outlook. Beyond that I'm confused.Fields on the table are:Name: full name of email recipientEmail: email of recipient of sent emailLast Contact: date of most recent sent emailOwner: email of senderThanks for the help!