Hi - I think I need a scripting app to solve my problem, but I’m new to Airtable scripting and so am reaching out for help. I have a table that I’m populating every day, but I want a 2nd grid/view with only the latest record showing. So I wanted to ...
I want to create a very simple script. What I want it to do is to call a URL (the URL being called activates a sync between Airtable > Shopify. What is the code to call a URL?
I’ve done a ton of searching and can’t find any answer to the possibility of using an Array (list) in one field of a base as a search input for another field. I do not want to ARRAYJOIN(values) as I am not searching for the total string, I want to ta...
Hi all! I’ve been working on utilizing scripting within automations for a project. When a record in a table “MPList” is updated, I want to see if that record’s sort name matches any sort names in another table “memList”. If there is a match, I want t...
Hi This relates to this Topic This is the code I have: let repoT = base.getTable('Repo'); let sourceT = base.getTable('Source'); let record = await input.recordAsync('Pick a record', sourceT); // let name = record.getCellValue('Part 1') + '-' + reco...
Hi there, I’ve found a javascript code to convert HEX codes to a name. However, as I am not a javascript coder, I need help to make changes to the code so that it works when i run it as a script in Airtable. Here is the link: https://www.w3schools.co...
I’m still fairly new to scripting, and going through the learning process. I’m assuming the below error means that scripting can’t access the details that it needs to? Error N: Can’t set cell values: Field ‘Button’ is computed and cannot be set My ...
Hi Everyone, I’ve been trying to script from the desktop Mac OS client. I believe it’s an electron app. Unfortunately, any time I try to open the scripting block, it just hangs there and continues showing the loading wheel. I can run scripts, but I c...
Hello, Could someone help me with a script to delete data from a table passing 1 field as a parameter? For example, I want to delete all records that were recorded yesterday, so I would pass yesterday’s date to the parameter and all data would be del...
I’m trying to update a base every 24 hours hitting a public API using remoteFetchAsync(). When I run the automation code below, I get this error: ERROR ReferenceError: remoteFetchAsync is not defined at on line 24 at main on line 9 The automation:...
