Automations

I’ve upgraded my account and I can verify that $12 has already been charged. But I still couldn’t use “Run script” feature inside the Automations tab for a space belonging to the workspace that is in “Plus plan”. And also, I can still see the alert “Over limits” in the page of one space. But since I’m in Plus plan now, it shouldn’t give me this alert.

Here’s how the data looks: { "gatewayMessage":{ "gatewayID":"956995" , "gatewayName":"Ethernet Gateway 4 - 956995" , "accountID":"40029", "networkID":"66417" , "messageType":"0" , "power":"0", "batteryLevel": "101" , "date": "2022-09-16 00:00:30", "count":"3", "signalStrength": "0", "pendingChange": "False" }, "sensorMessages":[ { "sensorID":"701519" , "sensorName":"Cooler 1", "applicationID":"2", "networkID":"66417", "dataMessageGUID":"88e199c6-62a3-4d2c-9a57-7c0a375282d0", "state": "16", "messageDate": "2022-09-16 00:00:03", "rawData":"7.9", "dataType": "TemperatureData", "dataValue": "7.9", "plotValues": "46.22", "plotLabels": "Fahrenheit", "batteryLevel": "13", "signalStrength": "76", "pendingChange": "True

Hi, we run automations on Airtable combined with webhooks and pabbly connect. Since we use our base as inventory system, we would like to know from which order the stock changes comes from. So we decided to at the order numbers in a field, which will be changed every time an order comes in. Today we found out that if there are orders in the same timeframe, the history changes the stock in a correct way but shows only the last ordernumber, which means that the numbers have been combined automatically. In the screenshot you can see that the stock goes from 2 to -1 (3 orders) but only the last ordernumber was taken: Is there any way to show the full history, since we need those numbers for internal adjustments.

As in the title, I’m trying to update multiple records with the results of a Find Records step. I’ve got my ‘When a record is updated’ Trigger and ‘Find Records’ Action step set up correctly, but I’m having trouble with the script Action that comes afterwards. I’ve adapted the code of another forum user (which updated a single-select field when records matched Find conditions): let jobsTable = base.getTable("Jobs") let packagelinkFieldName = "Package Link" let inputConfig = input.config() let recordsToUpdate = inputConfig.recordId let thepackagelink = inputConfig.packageLink let updates = new Array for (let record of recordsToUpdate){ updates.push({ id: record, fields:{ [packagelinkFieldName]: {name: thepackagelink} } }) } while (updates.length > 0) { await jobsTable.updateRecordsAsync(updates.slice(0, 50)); updates = updates.slice(50); } The error I’m getting i

Hey all! So I wanted to create an event, and CLEAR or DELETE the Google Calendar even when a checkbox/flag is clicked. This would be used when we cancel or reschedule but don’t want to delete the original entry. Currently I have three automations: These all work beautifully, but I wanted one more automation, unless the #2 could also update, but figured it’d be better to keep it separated as its own unique automation. Any ideas? I don’t see an option “Delete Google Calendar Event”. Thanks. Sean L

When including a checkbox field in slack message automation unchecked displays as blank instead of false. Could get around with a calculation field but that seems like unnecessary extra work.

Is it possible to select records in scripting with specific conditions? If I wanted to get all the records that have a field value of green, how would I write that query? I don’t want to just get all the records; I want specific records with more than 100 results.

Is there a quick way to switch which record is the test input for a script automation? Can’t seem to figure out how to change it, but makes it hard to build out a new automation on existing data if you don’t want to force modify old data! Currently, I’m trying to write an automation that is triggered when a form is submitted, but it’s testing on a row that wasn’t created by that form, which means nothing works quite like it should (nor should it!)

Hi there community members I’m still new to airtable scripting and really need your help in solving the timeout problem on one of my scripts. I’m getting a script exceeded execution time on the following code. What can I do or how can I change the script to prevent it from happening console.log(“Start Ditribution script”); let inputConfig = input.config(); let leadRecordId = inputConfig.recordID; let tableLeads = base.getTable(“LGA Leads”); let query = await tableLeads.selectRecordsAsync({ fields: tableLeads.fields }); let leadRecord = query.getRecord(leadRecordId); console.log(leadRecord.getCellValue(“Lead Key”)); I see the 1st console.log, but not the 2nd, so I assume it must be happening when I’m opening the table. The table has a lot of records.

I have already done this process on another base, but now it just doesn’t work. convert email address to and I get this error code Same with the ARRAYJOIN Thanks in advance!

Hello, I have a little script in automation, but when we copy the database, we need to test it manually every time. Is it possible to do this automatically? Thanks for your help

Hi there! I am trying to send personal & private reminder messages via Slack to people in my team. For that, I created automation and would now like to add a dynamic (colleague+me) channel ID which is connected to their name and therefore allows me to also put a dynamic (personalized) greeting. However, I am not managing to get the automation working. Is it possible at all? Do you have any tips on hand? Please don’t hesitate to ask questions in case it is not 100% clear, I am conscious that I am having a hard time describing my issue. !

I have created a form that we want to send to our customers with some data prefilled. The form is working correctly when i follow the link from within the Airtable, however, when sending it in an email some of our links get changed. For example “?prefill_Company+Name=rec4C08RaU1jF9SZG” is changing to “?prefill_Company+Name=rec#C##RaU1jF#SZG” It appears that all numbers are being changed to a ‘#’ Any information would be greatly appreciated. Many thanks in advance

Hi! I’m trying to build an automation for a social media tracking table wherein when a user selects a status from a dropdown (ie Facebook, Twitter, Instagram, etc.) that Content Title will automatically have a suffix added (ie /FB, /TW, /IG, etc.). Any suggestions on how to build that? Thanks for the help!

I have an Automation running that copies a record from one table into another one every time we check that a task has been completed. It seems to work well except when there is any attachment attached to the record being copied. In those cases, the automation doesn’t function, and the record isn’t copied over. Has anyone else experienced this problem?

Hello I have 2 fields: Start Date and Time (Calendar filed) & End date & Time ( Formula field based on Startdate+ Duration) I am trying to create an automation for creating events in Google calendar based on the checkmark trigger. But get an error refer the image. Please help

Is there a way to not save scripts while in development and testing or maybe to revert back to a previous version? The script is saved when you “Finish Editing” to go back to the 1st Automation screen to run the “Test Automation”. Which means that if you run into an error, your script is already saved with the error and you can’t go back to the previous version. Maybe my work flow is incorrect. Please help

Hi, If I create an automation with the following configuration: Trigger: a record is created Conditional action: if record meets X, update field A with values (‘in-app’, ‘bespoke’) How do I make sure it doesn’t overwrite any values that already exist in that field? I just want to add the two additional values, if they don’t already exist in the field. I’ve tried the following, where you add the existing values of Content Theme into the updated values but it does something weird to the field configuration and adds a blank field value option if the field is blank before this automation. Is this possible in the automations?

Hi there, What I’m trying to achieve around purchase orders. I’d like to create a new record in PO’s table and on adding the Supplier in the new record, an automation is triggered. This would “find records” in the Products table that have the matching Supplier. Then, in the Purchase Orders Line Items table, new records would be added for each Product that was found and would including the PO# from Orders Table and the Product Name and SOH from Products table. I can have the automation find the records but it seems to only output to a single record with multiple values. I need a way to create the multiple records. If anyone has a basic script for such a thing, or could help in any way, that would be amazing. Thanks in advance! Jason

Hello, I built an automation to fullfill a linked record with some info when another record in not empty. It is working perfectly for new records, but i need to run this with all the records in a table that have been already created. this is my automation. x Might somebody help me with this, pls?

Hello everyone, This all applies within the Google environnement. I am using Airtable to capture my work for reports. I love the automation that creates Airtable records from my Calendar. However, this automation does not encompass Tasks that are given a date (action which shows them automatically within my Calendar). Is it an error on my part that the Tasks in my Calendar are not being captured in the automation? if not Is it possible to tweak this automation to encompass Tasks once they are inserted into the Calendar? if not Is it possible to set up a separate automation for Tasks? (not a preferred option) Hope this makes sense, thank you.

Hello, I have a simple question: I want to insert tags automatically when a cell or multiple cells contain value under, or above a level or contain certain words on a different cell. For example: if value is below 50%, insert tag(multi-select) “Low traffic” or if the “Health Care” word is present in a cell, then insert the same multi-select tag cell “Animation” Basically I want to auto tag my data. Do I have to create an automation for each tag? Thanks!

Hi - I need to be able to do a batch insert into a child table, monthly. I’d like to automate this. If I were doing this in traditional SQL it would look like: INSERT Table2 (UpdateColHere) SELECT ColHere FROM TABLE1 WHERE ConditionField = ‘TRUE’; How would I go about that in Airtable? If by script, does anyone have any examples?

Hello! I have a base - we will call it base 1. It contains visible and non-visible records. I have a view within the base specifically for “visible” records. When a record changes from non-visible to visible, only records in that view are seen. I have synced the “visible” view to Base 2 and set up an automation that when a new record enters the view, it creates a new record in table 1 within Base 2. All is working as expected. When a record is updated in Base 1, it updates, as expected via sync to Base 2 visible view. Working as expected. What is not working. I am attempting to set up an automation that when a record in Base 2 Synced visible view is updated, it updates the fields in the “new” record within table 1. I keep getting an error that the record does not exist. Any tips? Thank you!

Hello! I am trying to create a two-part order/inventory table. I have serial numbers in one table, order received with the orders that the salesperson enters in another table, and order picked in the third (this table is for the fulfilment staff to be able to select the serial numbers desired for that order). All these tables need to be connected and I’d love to have it all automated. But, first step in doing all this is I need to copy order recieved table to the order picked so that there can be two separate forms for my separate departments. I’ve tried doing an automation with the trigger being “when a record is created” and action being “Copy to order picked”. And then once the order has been fulfilled, it all is going back to order received or another table… But for whatever reason this won’t work! Do y’all have anything to help?! (I’ve tried doing two forms in the same table, but I don’t want to create new records each time, I want to do half the record fill