Development & APIs

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 Modified" let checklistSentLastModifiedFieldName = "Checklist Sent Last Modified" let checklistReceiv

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 projects table), (+/- that record’s value in the Task Template Table), days).

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("Are you sure you want to update th

I’m using the following to capture an email address: email = await input.textAsync(‘Please enter email’); I want the input to be optional, but the “Next” button only becomes enabled when you type something in -the field. Is there a way to make the field non-mandatory or is this a bug?

I am a complete noob and know next to nothing about coding, so bear with me please. I download order reports on ebay and upload them into my airtable base for a partner to gather the data from. They are downloaded automatically in .csv format, with no option to omit any data beforehand. The automatic csv import tool that airtable provides doesn’t work for these because they contain 63 columns. I only use 29 columns, and I reorganize them a little as well. I am trying to find a way to make this automatic. I thought I would try and use the scripting extension to do this. I chose the example “spreadsheet importer” to use as a template. My knowledge of scripting is about 1 html website I made in grade 7 computer class 13 years ago above the average persons level of knowledge, aka slim to none. Here is how far I got before getting confused: // Ask the user to import a CSV file containing a header row let csvFileResult = await input.fileAsync( ‘Upload a CSV file’, {allowedFileTypes: [‘.csv’]

Hi, I’m currently developing a WhatsApp chatbot using Node.js. I’m implementing a functionality where the bot stores the specific responses from the users in airtable columns. But when I was going through the community I found out that it’s not yet possible to create columns programmatically. So for time being, I wrote a program that updates the field say Responses The problem I’m facing is when I call the update function it overwrites the existing record. Is there a way I can append the new value to the existing record without overwriting the old value?

Hi guys, Need your help in scripting. I want to concatenate month and templateName to another table using scripts as individual records. My desired output is e.g. templateMonth; templateName 2022-01; HD-HD1460, TR144 | 1 x RM-HD 2022-01; HD-WHITE | 5 x RM-HD, 1 x RM-WHITE How do I achieve this using a button? Thanks.

The entire error is; TypeError: Cannot read property ‘length’ of undefined at main on line 40. Line 40 reads; let recToCreate = s.delivField.options?.choices.length; OK, so “s” was defined at the top of the script as input config, and “delivField” is defined as an input field of “s” So AFAICS this should NOT be undefined. Any ideas? Anyone else used this script?

I keep getting error: SyntaxError: Unexpected end of JSON input at main on line 32 Is this something to do with my return JSON string from my endpoint or something to do with my code? Here is the code let WPtable = base.getTable("New WP"); // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', WPtable); let blogTitle = record.getCellValue("Title"); let wpContent = record.getCellValue("Content"); let c_name = record.getCellValue("Name"); // had to change to c_name because Visual Studio code was saying name is deprecated just in case I'm using a namespace let bannerhead = record.getCellValue("Bannerhead"); let headline = record.getCellValue("Headline"); let subheadline = record.getCellValue("Subheadline"); let cta_text = record.getCellValue("CTA Text"); let cta_link = record.getCellValue("CTA Link"); let short_path = record.getCellValue("Short Path"); //

If I have a webhook / cURL function (below) - how do I create a script that will run it through timed automation in Airtable? curl -X POST https://app.powerimporter.com/v1/api/workflows/XXXXXXXXXXXXXXXXX/XXXXXXXXX/sync

When deploying my website on Vercel, I always receive the error 429 due to Airtable rate limitation, which I’ve never seen on the local server. I guess this problem is due to the server execute the page build much faster. In that case, is there some way to handle this limitation?

I’d written a simple script for some field Supervisors to be able to pull and generate a report of who’s signed in to their jobs on a given day. It was working fine until the beginning of this week, when all the times got adjusted by 4 hours from when they actually happened. A crewman will sign in at 9:04am, but the report will show them signing in at 1:04pm. This is new and unexpected behavior. GMT for all is turned off on all fields, they should all be localized, and were for the previous month since release. All team members are in EST. After some testing, it seems that Airtable is now dropping the ISO 8601 time zone adjustments. I am uploading them, but they are not being retained when the base is referenced. I am sending (and have been in the same format since the beginning of June) “2022-06-22T09:40:01-04:00”, and I am receiving back in the same API call as a response: “2022-06-22T13:40:01000Z” (Which I haven’t been until 6-20-22) If someone at Airtable can confirm that this is “

Hello. I have problems with automation, I ask you for help. I have table 1 and table 2. When I create some record in table 2, automation is triggered and all data is created in table 1. But when I want to make some changes in table 1, then these changes are not reflected in table 2. Tell me how can this be done?

let table = base.getTable(“Cuentas Ads”); let view = table.getView(“check grupal”); let query = await view.selectRecordsAsync({fields: }) let updates = query.records.map(r => { return {id: r.id, fields: {“Check Grupal”: false}} }) while (updates.length > 0) { await table.updateRecordsAsync(updates.slice(0, 50)) updates = updates.slice(50) }

Currently in REST API - Airtable for my base, I see this in description for creating a record: Your request body should include an array of up to 10 record objects. Each of these objects should have one key whose value is an inner object containing your record's cell values, keyed by either field name or field id. But when I use this code: table.create([{ "key": { "id": "45673157744282"}, "fields": { "purchase_date": "2022-01-08T01:49:22Z", "orderID": "155-5041239-4465010", "order_status": "Shipped", "sales_channel": "Amazon.com", // ..... } },]).then(result => { console.log("Result=", result); }).catch(err => console.log("Error=", err)); I get this error: AirtableError { error: 'INVALID_REQUEST_UNKNOWN', message: 'Invalid request: parameter validation failed. Check your request data.', statusCode: 422 So all I need to do is to be able to pass the key (id of the record to be created) while calling the .create(). How do I do it?

I’ve written this little script and it runs very well as an app. But if I run it as an automation run script, it runs successfully but does nothing, no update and no error. I’d like to understand why the automation mode is not effective ? Thanks for your help. const tEssai = base.getTable(‘Essai’); let rec = await tEssai.selectRecordsAsync(); const dte=new Date(); await tEssai.updateRecordAsync(rec.records[0].id, { “Nom” : “Foo”+dte.getMinutes(), “date1” : dte })

I am sorry for my poor English. I want to write a script and get the information on a specific table. Using the EXAMPLE code of Loading records, I can only get an ID and a name. The records I want are the information I brought from other records. Is there a way to get all the information?

Hi there - We are trying to filter records based on multiple IDs but it is doing so in a loop so we can’t use the || or && as we don’t always know if there are multiple and often times there are 5 or more variables. We want something like this: var these= tabale_await.records.filter(f_record => f_record.getCellValueAsString(“Term_at_id”) == [any of these]) Is it possible?

This is a real noob question, so forgive me… I want to call a script that will include user inputs. Whenever I try and do this from the automation interface, the code declaration errors. I have found the script app in marketplace and can successfully run this fragment within the editor: output.markdown(’# Hello, world!’); let name = await input.textAsync(‘What is your name?’); output.text(Welcome to the scripting app, ${name}.); My question is how do I call this from an automation or a button anywhere else?

Trying to take Object returns from my PHP endpoint and populate the rows of a table - only the first row is being populated (aka cell fields in first row only) - here is my code: // query for every record in "People" let table = base.getTable("SMS"); let view = table.getView("All"); let query = await view.selectRecordsAsync({fields: ["Contact","URL"]}); var json_payload = []; let individual_injection = {}; for (let record of query.records) { let name = record.getCellValueAsString("Contact"); let URL = record.getCellValueAsString("URL"); individual_injection = { 'ID': record.id, 'Name': name, 'URL': URL }; json_payload.push(individual_injection); } console.log(JSON.stringify(json_payload)); let response = await remoteFetchAsync('http://147.182.192.192/speech.php', { method: 'POST', body: JSON.stringify(json_payload), headers: { 'Content-Type': 'application/json', 'Authorization' : 'Basic d2h5d29udHlvdWNvbm5

I’m trying to delete a record if my function fails to find a match with the query. //The Record ID I want to find a match for in the sourceTable let recordIDsource = inputConfig.recordIDsource // Find records in sourceTable let query = await sourceTable.selectRecordsAsync({fields: ["Record ID"]}); //Select the records from the query with matching Record ID's let recordTOupdate = query.getRecord(recordIDsource); If there is a matching ID this works great and gives me the record ID of the record containing my matching “Record ID” in a field. (I know, confusing) The problem is when there is not a matching “Record ID”, rather then giving me a value of null or undefined or 0. I launches an ERROR and breaks my script. What I want to do is, if there are no matching record ID’s, I want to delete theRecord that triggered the automation in the first place. if ( query.getRecord(recordIDsource) === Error ) { await table.deleteRecordAsync(theRecord); } I know that code above "

Hey, It takes a long long time to await table.selectRecordsAsync only to get a single record by id. Is there a way to get a single record by ID from a table? Or multiple records by array of record IDs? Use case is a very common one - once I get record ids from a linked record field I need to get the respective records from the linked table. Thanks, Ronen