Development & APIs

Hi! I’m working on a script to batch update linked fields and it seems to work for the most part but eventually throws this error: I have checked for duplicates in the tables I’m working with but there are none. Any ideas what might be causing this? Here’s the script for reference: //Define the company table and query let cmpTbl = base.getTable("Companies"); let cmpQuery = await cmpTbl.selectRecordsAsync(); //Define people table and query let pplTbl = base.getTable("People"); let pplQuery = await pplTbl.selectRecordsAsync(); let updates = []; // Search for matching records and batch update for (let allPeople of pplQuery.records){ let cmp = allPeople.getCellValue("Company") for (let allCompanies of cmpQuery.records){ if (cmp === allCompanies.getCellValueAsString("Company")) { let cmpID = allCompa

Hello, I’m able to successfully make post requests to my Airtable base via the api using a netlify function. My POST request body contains four values (we can call them w, x, y, z). What my function currently does is create a new record and adds each value to their respective field. What I’d like to do, before creating a new record, is to first check if any records in my base have all 4 identical values for each field provided in the post request. If a record does, I’ll return a success response, if not I’ll create a new record with the POST values. I see that the select() function may be a good start but am having trouble understanding how to check if a record matches each value in a post request. For reference I’m using node.js to send this request here’s my create function that is working correctly: let fields = JSON.parse(event.body) const { w, x, y, z} = fields // This is where I'd like to check if my table already has a record //

Has anyone used Airscripts to pull data in from Cin7 via API? Also, does anyone have recommendation for best API to use? I think you have to use async and await in Scripts? JavaScript has so many options. Plus, I just started using Airtable yesterday. I was think about using the below but adding Cin7 requirements. They just use HTTP auth so I need to add that piece for accessing still. import fetch from ‘node-fetch’; const getPokemon = async() => { try{ let id = 1; let url = https://pokeapi.co/api/v2/pokemon/${id}; const res = await fetch(url); // Returns a promise so we need await const data = await res.json(); // Returns a promise so we need await console.log(data); }catch(err) { console.log(err); } }; getPokemon();

Hi! I’m working on an airtable script where I’m trying to re-link records that were previously linked in another base. Context: I shared two tables from an OLD base to a NEW base. These tables had records that were linked(in the old base). After sharing them to the NEW base, the links got lost. I’m now trying to re-link these records. I have two tables, “Companies” and “People”. The “Companies” table has fields with the company name and employees. The “People” table has fields with people’s names and their affiliated company. Here’s the script I have written to attempt to solve this issue. //Define the company table and query let cmpTbl = base.getTable("Companies"); let cmpQuery = await cmpTbl.selectRecordsAsync(); console.log(cmpQuery) //Define people table and query let pplTbl = base.getTable("People"); let pplQuery = await pplTbl.selectRecordsAsync(); console.log(pplQuery) for (let allPeople of pplQ

I already reported this on the github javascript library, but I think more core developers might see it here as well. I want to filter the results of the airtable rest api based on the field ID using the filterByFormular parameter. The reason for that is, that the name could always be renamed, using the ID is future proof. A simple filter look like this: Name = "Joe" But instead I want to use the id: fldnwAXj3iM53qu4y = "Joe" After tons of googling it turns out that this is simply not implemented. I also tried it out with the id in brackets, but that still does not work (so it is not undocumented). I think this is a critical feature for the rest api, to build robust apps on airtable. It should be a quite simple feature with a huge impact. Might be worth a look.

Hey everyone, I’m new to using scripts and I’m hoping someone can help me out. I’m running an automation that runs a script which includes the input from the trigger but I have no idea how to add the input to the script. Here is the script, the input is supposed to be sent as the body to the webhook url: let response = await fetch('https://hook.eu1.make.com/o3pnw2043wkr9zs9mcavdrix', {method: 'POST', body: '*Input should go here*'}); console.log(await response.text()); Thank you

Hello, I am a beginner in the API world and I am a little lost in my research. I have a script that sends data with webhook into a google script. I check with webhook site if my data was send correctly and I succeeded to retrieve the data from my airtable (after I choose the right row). My question is, how can I get the data (from the payload) with variables into my google script doPost function ? I want to retrieve data from my airtable to generate a google doc after. I hope it’s clear enough. Best regards

Hi friend, i am new to airtable scripting, i am trying to send a webhook to third party API, let url=“https://connect.pabbly.com/workflow/sendwebhookdata/IjQ0NDI0NiI_3D”; let config=input.config(); await fetch(url+config.recordid); In airtable, it show test run is successful , but on the third party side, no record is received, am i doing anything wrongly?? please kindly help!! thanks

Dear all, I am new to Airtable. I wish to find out how powerful is the Airtable scripting language (is it Javascript?). Is it powerful enough to automate anything within an Airtable base? For examples: to validate a user input on a field and able to undo if it’s invalid; change the colour of a field; hide a button on the fly, etc. Can I attach a script to a button on a form? Airtable is known as a low code platform, does that mean bases are usually developed without writing much scripts? Thank you very much in advance. Martin

Hello. I’m writing a VSC extension, and using the example javascript code provided in the airtable api docs generated for my base. The code gets the records from airtable, but then logs an error. The extension doesn’t crash, but fails in airtable.lib.run_action.js line 70 where it calls callback(base._checkStatusForError(resp.status)); with a rep_status of 200 Is this an airtable problem, or should I be adding reject code, catch code or similar? rejected promise not handled within 1 second: TypeError: Cannot read properties of undefined (reading 'offset') /Applications/Visual Studio Code.app/Contents/Resources/app/out/vs/workbench/api/node/extensionHostProcess.js:102 stack trace: TypeError: Cannot read properties of undefined (reading 'offset') at /Users/dave/Documents/Projects/vsc extensions/airtable-docs-ext/node_modules/airtable/lib/query.js:118:28 at /Users/dave/Documents/Projects/vsc extensions/airtable-docs-ext

I need a script that will run when I push a button that will check to see if a field is “TRUE” or checked and if it is, than will send the webhook out with the recordID. This will help our workflow because we want to make sure that all needed fields for a Zapier automation are present before a webhook is sent.

Hello, maybe someone had a similar issue and can give me a hand After I do Block run on my extension the resulting localhost URL has an expired SSL certificate. It is my understanding this is a self signed certificate created on the fly when I do Block run (but I might be wrong) I searched for the certificate everywhere but it just isn’t there, which makes me believe it is created on each run for the server. Does know if there is a way to specify the certificate I want to use when I do Block run or any other work around to this issue. I am pretty sure I might be doing something wrong since I couldn’t find any other report on the same thing but I have spent 3 days now on this without luck. Any help will be appreciated!

Hi there, we recently saw an increase of interest from our customers using regarding a potential integration with Airtable. Naturally, there has been quite some excitement from customers and ourselves when we decided to kick off the design and technical spike work last week. Given the nature of the product, we were somehow assuming that Airtable would have a great developer experience, including OAuth2, as well as all the necessary REST API endpoints one could wish for to build an amazing integration. Learning that OAuth2 was not a thing yet was a bit of a bummer, but something we felt we could still workaround for the time being. And even though it felt a bit weird to have to manually request access for only the Meta API, it was pretty much the next step we took from there… which, well… brought us to the “thanks, but nah” message many others got here as well… right after applying for it. Oof. Going through previous community posts, it seems like there

Hi, I try to filter airtable using the by the record’s id, for example filterByFormula=OR( {id} = ‘rec1’, {id} = ‘rec2’, … ) and I got the error “unknown field names: id”. That also results in errors even after I remove the brace brackets. Tangent

My “Published URL” column contains URLs of web pages. Through API, I would like to be able to pull only the record containing a URL I supply in the call. I am already successfully making a curl call with this… $base = 'appPtTr2kigmLlCP8'; $table = 'Content'; $view = urlencode('Published (Robert)'); // $fields = urlencode('Published URL'); // Only return these fields, cf. https://community.airtable.com/t/using-fields-filter-in-list-of-records/940 if (!empty($offset)) { $q_offset = '&offset='.$offset; } $airtable_url = 'https://api.airtable.com/v0/' . $base . '/' . $table; // construct the url query $url = 'https://api.airtable.com/v0/' . $base . '/' . $table . '?maxRecords=5&pagesize=1000&view='.$view . $q_offset; But how can I make use of the relevant feature (is it filterByFormula?) to add Elsewhere on the forum, I have seen reference like… filterByFormula=SEARCH(‘riva’%2C+%7BLast+

What does this error mean? j: Error: Failed hyperAssert: rowJson at main on line 24 Here is the code I have: let table = base.getTable("SMS"); let view = table.getView("Kosta"); let json_response = '{"action": "linkcreator", "data": [{"id": "recpuidwtkoxhyylo", "name": "kosta kondratenko", "url": "https: \/\/headstudios. Com. Au\/for_you\/sales-terminator-army-generator\/", "shortlink": "", "linkid": "lnk_1lhi_2rcwr8", "mobile": ["0412 826 569"], "path": "kostas-terminator", "displayname": "kosta", "originalurl": "https: \/\/headstudios. Com. Au\/for_you\/sales-terminator-army-generator\/? Fname=kosta", "secureshorturl": "https: \/\/showme. Headstudios. Com. Au\/kostas-terminator"}, {"id": "rec2nv7qklwu5jmbv", "name": "kostya kondratenko", "url": "https: \/\/headstudios. Com. Au\/for_you\/sales-terminator-army-generator\/", "shortlink": "", "linkid": "lnk_1lhi_2rcwr9", "mobile": ["+61412 826 569"], "path": "kostyas-terminator", "di

It would be great if you could make the default values also work for API created records. Maybe optionally for backwards compatibility. Cheers, Arthur.

Good morning all :coffee: My example base - a score board :joystick: There’s a neat trick that not too many casual Airtable users know about - where by configuring filters within a new view that’s filtered to Single Select column(s), that new records created under that view will default to the filtered value(s). Very handy! Have the Single Select Field (or more) Create the View Filter that View to Single Select colums New records created default to those values. My question - is it possible to POST a record to a targeted View? Obviously the API calls for the Base ID and Table target, but I can’t find anywhere that details the syntax, or even mentions if it’s possible to utilize a view within that table

Hello everyone! This is kind of a stretch, so I am wondering if you anyone knows if this is possible. I am looking for a way to iterate through all records in a table and create a chart based on data linked in another table. I’d like the save a picture of each of these charts in another column in the record. For example, I have a table of people on a roster. Each of the people have certain metrics associated with them over time. I want to chart those metrics on a lineup graph and save it in the persons AirTable record. Is this possible with some script combined with a vega, google charts or image-charts api call? Can the AirTable Script editor handle image files? Thanks!

Hi guys, I’m trying to set up a GET API call with filterByFormula that would return an error instead of empty value. Imagine that I have two fields - {user_id} and {full_name}. {user_id} field always exists, but based on formula it should return: A) 200 OK response if full_name does not exist b) ERROR response if full_name field already has a value Any help would be much appreciated! Thanks!

(Javascript novice) I’ve adapted some code to work with my different field names but it isn’t working and I’m not sure why. This script is supposed to update the fields “Proposal Accepted”, “Checklist Sent”, and “Checklist Received” based on the amount of time that a single select field was set to either “Proposal Accepted”, “Checklist Sent”, or “Checklist Received”. Strangely, the automation runs successfully sometimes. When it doesn’t run successfully, the execution log is as follows: Error: Could not find a field with name or ID “undefined”. at main on line 72 Can anyone see the problem? Here is the code: let table = base.getTable('Jobs') let proposalAcceptedTimeFieldName = "Proposal Accepted Time" let checklistSentTimeFieldName = "Checklist Sent Time" let checklistReceivedTimeFieldName = "Checklist Received Time" let proposalAcceptedLastModifiedFieldName = "Proposal Accepted Last

I’m new to Airtable and have no JavaScript knowledge so I’m hoping someone smarter than me can help! I’ve been trying for weeks to figure out how to write a script to set due dates for each task in a list for a given project. So far I’ve modified this script to generate the tasks. The part that I’m stuck on is that instead of tasks having dependencies based on the completion of another task, my tasks have due dates that are relative to the type of task. I just can’t figure out how to script: use an input of new project, then for each new task created in Tasks Table, use task type from Template Table, get corresponding dependent date for that project from the Projects Table. Use that date, calculate the Due Date in the Tasks Table using something that would function similarly to the formula WORKDAYS((dependent date from projec

Airtable give me a tool to encode my url . but … How to do it ? How to use the API URL encoder tool : https://codepen.io/airtable/ thanks

Hi all, so I wanted to check if there is way to retrieve a specific record based on filter criteria, Based on my Understanding so far i can only use table.selectRecordsAsync() to get the array of all the records . later need to perform filter using linear search on the returned array. i wanted to check if i can get a specific record based on query condition as a response. for example : From table animals … i need record where name == X, is there a better way than getting all the records and then i need to loop through until i find X. kindly help me with this. thanks, Harshith

Hi there :slightly_smiling_face: I have a very simple code involving if statements and buttons but it’s not working. I’ll explain further below my code: let sale = await input.buttonsAsync("Is the vehicle set for another service or will it be sold/scrapped before then?", ["Yes, another service date", "No, will be disposed"]); if (sale = "Yes, another service date") { let plan = await input.buttonsAsync("Is the next service on a date or at a specific mileage?", ["Date", "Mileage"]); if (plan = "Date") { let date1 = await input.textAsync("What is the date of the next service? ( eg: May 1, 2022 )"); let format_date1 = new Date(date1); let format_date2 = new Date(format_date1.setDate(format_date1.getDate()+1)); let final = format_date2.toISOString() let field = table.getField("Next Service (if Date)"); let confirm = await input.buttonsAsync