Development & APIs

Hello- I’m new to airtable and new to scripting. wondering if there is anyone who can help guide me: i have a rental company that rents artwork. im trying to write a script so that when i input rental dates i can search “cards” by the ones that are currently out on rental and the ones that are still in stock. im thinking an “if then” script might help… any guidance would be greatly appreciated!

I want to write a small script that updates all status-fields in a given view. Let’s say I have a view with tasks. Tasks have a status-field ( single-select: ‘new’, ‘busy’, ‘done’). My script should update all status-fields for all tasks in a given view. With input.config, I can select the base, view and field (status). But I can’t find a way to select the new value of status for all those tasks. Is there a way to accomplish this? Because I want this script to be as generic as possible, I don’t want to hardcode any values. Idealiter, selecting done should return the id for that field. Something like. let config = input.config({ items: [ input.config.table('selectedTable', { label: 'Table to use', description: 'Pick any table in this base!', }), input.config.view('selectedView', { label: 'View inside the above table', parentTable: 'selectedTable', }), input.config.field('selectedField', {

It seems I can’t use a variable in the method updateRecordAsync(record,{"field": value) In the head of my script, I ask which field needs to be updated. (ps: I use pseudo-code here to keep my question brief. Everything works, except the last line) input.config({ input.config.field('selectedField', { label: 'Which field do you want to update?', parentTable: 'selectedTable', }), }) Let’s say I choose the field status. Then I would like to use something like updateRecordAsync(record,{selectedField: someValue) or updateRecordAsync(record,{selectedField.name: someValue) However, the code above gives an error: j: Field ‘selectedField’ does not exist in table The code only works when I hardcode the field, which kinda defeats the purpose of scripting/automation… updateRecordAsync(record,{"status": someValue}) question: is there some way to use a variable selectedField in updateRecordAsync or do I need to keep the fieldname hardcoded?

I could not find in the API documentation a way to trigger Airtable’s UNDO actions. Is there a way to do this ? It would surely be of a great help for all users. Thanks!

Hi, I’m new to Airtable scripting and figuring this out as I go along. What I’m trying to do is to get a script to count the number of non-empty records for a specific field in one of my tables. This is because this field does have some blank values for some records and I don’t want to simply count all the records in the table. let query = await myTable.selectRecordsAsync({ fields: [myField], }); let recordCount = query.records.length; When I use the script above, I get the total number of records in myTable. How can I add a condition to this so that I’m only getting a count of those records where myField is not empty? Thanks

Hi, I’m testing the script of Airtable and I’m facing the issue with POST request creation. First, I tested my request with Postman and it worked fine. Then I ran the same request with Airtable script and I got failed. let response = await fetch('https://gorest.co.in/public/v2/users', { method: 'POST', body: { "name": "Tenali Ramakrishna", "gender": "male", "email": "tenali.ramakrishna2@15ce.com", "status": "active" }, headers: { 'Content-Type': 'application/json', "Accept": "application/json", "Authorization": "Bearer 84799e2274fa6626356d26d9364fde5320a5d3f1703b6d33a525a1585cbbce65", }, }); console.log(await response.json()); Could anyone help me on this? Thank you!

Hi, I’m trying to make a script to set the single select value when a button is pressed. However, it requires an id. How would I get the id of my single select value? Example of a working script which I’d like to duplicate & set it to another value, the script is fired with a button: let table = base.getTable("©️ Copyright infringements"); let record = await input.recordAsync('',table).catch() await table.updateRecordAsync(record.id, { "Status" : { "id": "sel3MYJB5QL4jKFdg", "name": "Approved internally", "color": "cyanLight2" }, })

Hi, Is it possible find the same rid from array to array2 then push the wordspin values inside the array variable but i can’t use .find as it result to error. let id1 = "recQoA4zwa0xZQVGL"; let id2 = "reckssVy1WsRtWPQs"; let id3 = "recSu7GQqd85dC5go"; let array2 = [ {rid : id1, wordspin : "test1"}, {rid : id2, wordspin : "test2"}, {rid : id3, wordspin : "test3"}, {rid : id1, wordspin : "test11"}, {rid : id2, wordspin : "test22"}, {rid : id3, wordspin : "test33"}, {rid : id1, wordspin : "test111"}, {rid : id2, wordspin : "test222"}, {rid : id3, wordspin : "test333"} ] let result = array2.forEach(function rid(r) { return function (o) { var ref = r.find(p => o.rid === p.rid); if (!ref) { r.push(o); return; } Object .keys(o) .filter(k => Array.isArray(o[k])) .forEach(k => o[k].forEach(rid(ref[k] = ref[k] || []))); }; }); I want my result to look like this [ {ri

So this is what I am using to get my data from airtable import axios from "axios" formSubmitHandler = e => { axios .get( "https://api.airtable.com/v0/" + app_id + "/" + view, { headers: { Authorization: "Bearer " + app_key } }, ) .then(resp => console.log(resp)) .catch(error => console.log(error)) e.preventDefault() } This works very well, however when I try to post something into the same table and now using this: formSubmitHandler = e => { const { name, email } = this.state const data = { "records": [ { "fields": { "Name": name, "Email": email, } } ] } console.log(data) axios .post( "https://api.airtable.com/v0/" + app_id + "/" + view, { headers: { Authorization: "Bearer " + app_key } }, data ) .then(resp => console.log(resp)) .catch(error => console.log(error)) e.preve

I’m trying get all of the records form an api call into an object so I can use the data in other calculations. I can’t, however, get the function to return what I want. I’ve tried lots of combinations of async/await and .then(), but I can’t get it to work. “aTotalRecords” gets filled up with the data, but I can’t get the function to return it. Can someone help me figure this out? Thanks in advance. Here’s the code I have: async function getAirtableData(){ // var Airtable = require('airtable'); var base = new Airtable({apiKey: oConfig.oConfig.airtableAPIKey}).base(oConfig.oConfig.airtableBaseKey); var aTotalRecords = []; // for keeping allthe records base('Polygon Transactions').select({ maxRecords: 500 // view: "Grid view" }).eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. records.forEach(function(record) { aTotalRecords.push(record.get('tx_

Hello, I am trading account and software activation code. I need to improve this system, anyone who can help me please contact Telegram @gamikeystore

Hi. Is there a very simple example of how to consume multiple pages when calling GET on the airtable API? I have a simple API Call class, much of which I got from this forum, but there are multiple pages in my data. Here’s my code: class AirtableGet{ constructor(inputSheetName, tableName){ this.inputSheetName = inputSheetName; this.tableName = tableName; // text name of the table in Airtable; ex. "Balance Tracking" /** Airtable Variables */ this.ss = SpreadsheetApp.getActiveSpreadsheet(); this.inputsSheet = this.ss.getSheetByName(this.inputSheetName); this.myAPIKey = this.inputsSheet.getRange(9, 2).getValue(); this.baseKey = this.inputsSheet.getRange(10, 2).getValue(); this.cAirtableAPIEndpoint = this.inputsSheet.getRange(11, 2).getValue(); this.url = this.cAirtableAPIEndpoint + this.baseKey + "/" + encodeURIComponent(this.tableName); };// end constructor /** get request */ getFromAirtable (){ var options = { m

Hello, I’m struggling with setting correctly a Date field. Basically I have a field with Date type which I set to Date.now() when something happens. If anything else happens I want to blank out the field and leave it emtpy. If I try… myDate = null; I get an error reading “Type ‘null’ is not assignable to type ‘number’”, and it seems the only way I can get rid of the error is by using… myDate = 0; Now, when I run the script and my “else” is executed I can’t seem to assign 0 to the field, and I’m getting an error reading “j: Can’t set cell values: invalid cell value for field ‘myDate’. Cell value has invalid format: .0 must be a string, .1 must be a string, .2 must be an object” So, the question: how can I manually assign null/empty to a Date field so that no value is displayed? Thanks in advance for your help.

Cross-posted, but updated I’m using the popular script for downloading attachments from a url to an attachment field, but I’m running into issues. The url I’m using is a direct download link to an mp3 file in Box, and this script is working properly half the time, but in some cases rather than downloading the mp3 file, it’s scraping the html of the download page instead and loading it into AT as (what looks like) a text file with an mp3 extension. I’ve opened the file preview for one of the incorrectly downloaded files in Box and it looks like it’s asking for Box credentials, but I’ve double-checked the urls in Box pre-download and they’re all set to be downloadable with just access to the link, so it isn’t (or shouldn’t be) a permissions issue. I’ve been able to open them even when not logged in to Box. When I download one of the files it is unsurprisingly corrupt. Has anybody run into this before?

When I block run, I get an error when trying to open the app in Airtable: Can‘t connect to your local app, did you block run ? It works in Safari and I suspect it’s a CORS issue. Does anyone else have the same?

I need to get all the ids and names of my bases. I know I could do this using a simple call to Metadata API → Sign in - Airtable. However, airtable stopped creating new X-Airtable-Client-Secret's. Is there another way?

Hi there - Does anyone know how to push information from airtable to Instacart? For instance, choosing a recipe using a form and then pushing the ingredients. I am not sure what the best way to do this would be… Suggestions are welcome! docs.instacart.com Instacart Connect - The Instacart APIs | Instacart Connect Documentation Use Instacart APIs to add Instacart capabilities to your branded ecommerce site. You and your customers benefit from Instacart scheduling, full-service shopping, delivery, pickup, and order tracking. Your developers can integrate the selected... Thanks in advance!

Hi, I have this table in Airtable which has for about 10k data. I try to display it with datatable and it takes quite a long time to fully load the table. Is there a way to lazy load the airtable and display it on datatable?

Hi, I am trying to adapt/modify scripts that i have found within these forums in order to update a linked field with a recordID defined as an input variable. I am very limited in knowledge with scripting, through trial and error i have been able to modify and update a single line text field and a single select. I have also managed to clear the cell through a previous failed attempt. Can anyone help me understand where im going wrong? Full Script Here. let config =input.config() let records = config.step2Records let drop = config.drops console.log(drop) let table = base.getTable(“All Drops”); for (let record of records) { await table.updateRecordAsync(record, { "Collection From": [{id: drop}], }) } I have read through all posts similar looking but i am at a loss. I would like the answer but also any reference to learning material would be great. Many thanks,

I’ve been trying to modify a script I’ve found on the airtable community that would allow me to click a button and trigger a script to move a record to another table. But it seems that in the process, it moves every record in the table. Is there a way to make it only move ONE record? let table1 = base.getTable(“New Leads”); let table2 = base.getTable(“Following-Up With”); let result = await table1.selectRecordsAsync(); for (let record of result.records) { if (record.getCellValue(“Move To Following-Up”)) { await table2.createRecordsAsync([ { fields: { ‘Name’: record.getCellValue(“Name”), ‘Email’:record.getCellValue(“Email”), ‘Phone’:record.getCellValue(‘Phone’), }, } ]); await table1.deleteRecordAsync(record.id); } } This is the script I have currently, any help is appreciated

Hello, I’m new to airtable and I want a build a form that allows users to search for their places using google maps. So my question is how to add javascript to a specific field

Hello, I’m trying to delete a massive duplicate records in my table about 10,000 to 20,000 records exist in my table. As i don’t know where to insert the proper condition if the records is duplicate by knowing they are older dates or not up-to-date/current date And I can’t delete them in one go due to script execute time. // Read our table var table = base.getTable("Weekly Metrics"); var query = await table.selectRecordsAsync (); // Check whether any record in that table // match the input let duplicate = query.records.filter((record)=>{ return query.records.find((potentialDuplicate) => { return record.getCellValue("Pages") === potentialDuplicate.getCellValue("Pages") && record.id !== potentialDuplicate.id; //&& record.id !== potentialDuplicate.Id }) }); // console.log(duplicate); let updates = duplicate.map(update => { return { "id":update.id, fields:{ "Duplicate?":true } } }); while(updates.length &

Hi everyone, I’m performing a vlookup essentially at a spesific time each day. It worked the first couple of times, but now keeps giving me an error, any advice/guidance would be greatly appreciated! //"Time Sheet" contains values on which you want to run the vlookup let mainTable = base.getTable("Time Sheet"); let mainTableRecords = await mainTable.selectRecordsAsync({fields:["Title Name"]}); //"Volunteers" contains range to search in let lookupTable = base.getTable("Volunteers"); let lookupRangeRecords = await lookupTable.selectRecordsAsync({fields:["Name"]}); //"Title Name" has the values you want to look up for (let record of mainTableRecords.records) { let lookupValue = record.getCellValue("Title Name"); //"Name" is the range to search in for (let rangeRecord of lookupRangeRecords.records) { if (rangeRecord.getCellValue("Name") === lookupValue) { let linkID = rangeRecord.id;

Hi all, This forum has been a huge help in getting me unstuck in many instances. I haven’t found an explicit answer for this one, so posting here. I have an API call to the Airtable API in which I am looking to retrieve a record that matches on a specific field value (not the record id) and I am looking to identify that field by it’s field id rather than it’s field name. Is this possible? If so, what would be the proper syntax? For clarity here a sample syntax with field name as the identifier. NOT({Field Name} = ‘data’) ergo appending option of filterByFormula=NOT%28%7BField%20Name%7D%20%3D%20%27data%27%29

I have not been able to address tables in a base other than the first table (the one that shows up in the API documentation for a base). I have tried substituting a different table name, but that gives me an error. For example, I have a base called “Bug Tracker”. The first table is called “Bugs and Issues”. I can get at it with curl https://api.airtable.com/v0/BASE_ID/Bugs%20and%20issues?api_key=MY_API_KEY As you can see, I have another table in that base called “Testers”; however curl https://api.airtable.com/v0/BASE_ID/Testers?api_key=MY_API_KEY returns {"error":{"type":"TABLE_NOT_FOUND","message":"Could not find table Testers in application BASE_ID"}} How can I get data from the “Testers” table? Thank you