Automations

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 t

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

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.Duplic

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

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 H

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://zap

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 Compone

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.

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_Link1A1B2B2C2

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!

I am trying to setup an automation for the following:1) At a scheduled time (eg. 10am)2) Send an email to records in Table 1 3) Condition: IF the record has been 'ticked' (A field in the table is a check box that must be ticked, for the email to be sent at 10am).I can setup an email to be sent at a schedule time OR I can send an email if a record is ticked - but I can't seem to do all 3 of these steps. Any ideas? Thank you!

Hi there,I have this script I am working on to update all records in a table based on their currency. Except for records that are in stage 4. I am using this statement to filter through the recordsfilterByFormula: "AND(NOT({Currency} = ''), {Exchange} != '', NOT({Stage} = 'Stage 4'))"The problem is that it ignores this parameter and rus it for all the records. I will be grateful for any help on how I can successfully filter out stage four records. Here is the full script.const dealsTable = base.getTable('deals - test copy'); const currencyTable = base.getTable('test-currency exchange DB'); const deals = await dealsTable.selectRecordsAsync({ filterByFormula: "AND(NOT({Currency} = ''), {Exchange} != '', NOT({Stage} = 'Stage 4'))" }); console.log(deals); const updates = deals.records.map(async (deal) => { const currencyType = deal.getCellValueAsString('Currency'); const currencyField = currencyType.toLowerCase(); const currency

Are you able to have a check box in one base that will trigger the creation of a line of data in another base? I have two bases where I want to combine some of the data into third base, but because the primary fields are not the same I cannot simply sync the data.