Development & APIs

I'm fairly new to JS and I'd love feedback if this script is the most effective. I'm trying to link records between tables, and I know it's not a simple copy-paste.I have two tables: enrollments (students) and courses.Enrollments has the fields:Course ID: integerCourse ID Link: link field to the Courses tableThe integers directly correspond to a 'Canvas Course ID' in the Courses table. Manually, I can copy from one column to the next to make the link.From what I've pieced together, you need to query to find the AT recordID for that matching integer. Here is how I'm approaching this:let enrollTable = base.getTable('Enrollments'); let enrollList = await enrollTable.selectRecordsAsync({fields: ['Course ID']}) for (let student of enrollList.records) { //find the matching Course from Courses table let coursesTable = base.getTable('Courses'); let courseQuery = await coursesTable.selectRecordsAsync({fields: ['Canvas Course ID']}); let filteredTerms = courseQuery.records.filte

Hey folks,We recently received an email that Zapier's users' Airtable API keys will be automatically switching to OAuth tokens. How would this be possible? And how can we do the same for Softr users? Who would be the right person from the Airtable side to support this? Zapier Email: Your Airtable Zaps are switching to OAuth on Sept. 25

Hello, I am trying to reduce the number of clicks that need to be used print a page designer record. I have set up the new button functionality to connect to the page designer to print, but once you click on it you have to click at least on 4 different windows before sending the item to print. Is there a way to use the scripting block to automate this process for you? I don’t know much about scripting so I might need to outsource the service but ideally when clicking on the button it would automatically send to print without needing to reset the dimensions of the page designer.

I'm running an API POST script and I'm trying to utilize the id that is returned in the response.This is the key piece of the script. var postOptions = { method: 'POST', headers: myHeaders, body: formdata, redirect: 'follow' }; let response = await remoteFetchAsync("https://xyz.com/...", postOptions) .then(response => response.text()) .then(result => console.log(result)) .catch(error => console.log('error', error));I get this response. I'd like to then reference that id returned.CONSOLE.LOG "{"id":29644,"progress":0,"current_line":null,"status":"created","created_at":"2023-09-12T09:30:39-07:00","started_at":null,"ended_at":null,"file_url":null}"I've tried this, but I get an undefined error.console.log(response.result.id) 

Hey EveryoneI have a problem when collecting data thru API, in this example records of a foodmeny in Airtable. Every dish and the different infos (ID, Day & Date, Swedish, English, Allergens) is formated in a formula field in Airtable. One per dish. In this example its 6 different dishes and I want the output in the API to look one of the examples in Picture 1, but I can't get it like that I only get like Picture 2, were its different strings.Any advice how to set this up in Airtable and the Api call?Regards Jesper

Does anyone know if I can use filterByFormula with selectRecordsAsync in a script? ChatGPT tells me I can but I'm doutful. The script editor gives me a red squiggly line, and the script doesn't work. Completes okay but does not apply the filter. e.g in the following code (assuming the syntax in variable filterFormula is correct). Also, if this really does work, does it mean I can get around the Airtable selectRecords return limit? Or can I only do this by calling the API direct. Grateful for any help. let customerBookingsRecords = await customerBookingsTable.selectRecordsAsync({ fields: ["Day"], filterByFormula: filterFormula }); 

Hello there, I've developed a workflow that follows these steps:1) When a record is updated, all the product's fields are watched2) With these watched fields, a new script will run. The main goal with this script is taking the product's information, then making a PUT request to an external JSON API by taking the product's SKU.When I test the script, it runs successfully, but the response logs: {status: 400, message: "Invalid data provided"} status: 400 message: "Invalid data provided"Does anyone knows why this is happening? Is it an error in Airtable or in the external API server? Thanks in advance!The code goes like this: //input of modified product let inputConfig = input.config(); //Fetch for external API and JSON creation let response = await fetch(`http://.../${inputConfig.sku[0]}`, { method: 'PUT', body: JSON.stringify({ "product": { "ean": inputConfig.ean[0], "sku": inputConfig.sku[0],

I have a script to import a CSV from a URL. The URL is provided by an API JSON file. let csvFile = await remoteFetchAsync(reportData.attachment.url) At this line, I get the error:j: Error: Response status was 302 'Found' but redirect mode was set to 'error'I'm able to open and generate the CSV using incognito mode in my browser. The code has a verifier in the URL., like this:https://xyz.com/files/#####/download?download_frd=1&verifier=ABC123Is Airtable able to access this sort of file?

Hi, I’m writing a program that sends Airtable content to WhatsApp in Node.js. I’m facing a problem while sending the image file, I can only find a way that sends the image URL and not the image itself. How can I convert the URL to the image file? Code for sending the image URL. const img = record.get('Image'); imgurl = img[0].url console.log(imgurl) Help is appreciated, Thank you!

I created a new token and tried to use it to replace my API key in a Zapier app connection for Airtable. Thought I was doing the right thing in preparation for the deprecation in 2024. It didn't work. Zapier doesn't seem to recognise the token and wouldn't accept it.Likewise tried to use tokens in direct connections with other subscriber apps. They didn't accept them either.I'm missing something fundamental here right? Grateful for any help.

I'm writing a script to create records from an API call. One of the fields is a single select option. At the start of the script, I want to use the input option for the user to pick an option from the single select, which will be used for all the records. I don't see any option to pick from a single-select list. Is this possible?https://airtable.com/developers/scripting/api/input 

i can t create an api key I don't even see the option  

hai my name basi , from india in my airtable i trying to make summary table for purpose of make an interphase, Our airtable  have a two table name as, 'JOB NO' and 'SUMMERY copy'and in 'JOB NO' have 3 fieldwhich has ,'EMPLOYEE' - employee name'DATE2' - it formula field with like this '9/8/2023 12:00am' in date phrame'DUTY TIME' - duration fiedso i am try  convert the 'JOB NO' data in to another table like thisif  TABLE 'JOB NO' DATA LIKE THIS :-BASI--11/07/2023--2:0SKIL--12/07/2023--5:0BASI--11/07/2023--1:0BASI--12/07/2023--2:0SKIL--13/07/2023--5:0'SUMMERY copy' need BE like this :-BASI--11/07/2023--3:0SKIL--12/07/2023--5:0BASI--12/07/2023--2:0SKIL--13/07/2023--5:0employee name need in 'EMPLOYEE' in table 'SUMMERY copy'date need be in 'DATE' ( date field ) in table 'SUMMERY copy'sum of duty time from JOB NO in 'SUM'( duration field) in table 'SUMMERY copy'this script made by chatgpt   let jobsTable = base.getTable("JOB NO copy"); let summaryTable = ba

Hi,I would like to know is it possible to have a roll up or look up for a field that is is multiply tables lets say 3 to 15 the is a number value and have it show up in a primary table that all other tables a linking to?I am hoping to make separate bills of materials (tables) that link to my primary table witch is a list of stocked items and used item that need to be ordered.any help of info would be greatly helpfull. 

Hello, I am struggling to connect Matlab to Airtable's API. All calls that I make to post are returned with 422: Unprocessable Entity, no matter how I configure the data structure. I can successfully make get calls with Matlab's webread(), but fail with all webwrite() posts. I have also performed posts with python using the same authorization key. This tells me that my link, authorization, and write access are all working and it is a problem with webwrite(). I have tried formatting the data in many ways as shown by the screenshot, primarily attempting using structs or nested structs as the data entry. Even using a key value pair directly in webwrite() all gives the same 422 error. Following the Matlab documentation on these functions explicitly yields these same results so any further insight would be greatly appreciated. Thank you. 

Hi, I'm struggling to figure out how to get product support and wondering if anyone has faced a similar issue. We use Airtable to sync information into a database within our software. There is a unique ID we use in Airtable and our database to match the records. Frequently, but not always, our product renders an error message saying that ID is not found in Airtable and thus can't sync. However, the ID number is always present - it's somehow not being read or sent correctly. We've investigated from our end and there is nothing wrong that we can identify. So I'm trying to figure out if there are issues from Airtable's end that could be causing this or other ways we can troubleshoot. 

I'm creating an extension that will create a table and display a response for the user. I want to be able to color some cells depending on the response they get (true/false). Is there a way to do that? Coding? 

Hi,After the great deployment of interfaces for iPhone I have created an interface that I use with my iPhone.I'm finding problems when completing numeric fields, when I want to introduce a number for example 15.25 after I introduce the first number the field autocompletes super fast as 1.00 and I have to be racing agaisnts the time here.Am I the only one having this problem? 

Our client uses Trybooking for their attendees when the purchase promotional material. There is currently no way to export the data CSV to Airtable except for downloading it manually. We have over 500 records that are going to come through - so manually downloading the CSV in Trybooking, and uploading the data into Airtable daily, is too time consuming.I have the API for the Trybooking event and it says it's able to be used to "extract your data to external sources.". Is there any way to get the data to be sent automatically to Airtable? Unfortunately, Zapier isn't an option. I'm a complete programming newbie. Any help would be appreciated.Thank you!

Hey Everyone, Can anyone spot where I'm going wrong here?!I am trying to add multiple values to a multiple-choice field:const YesVotes = ["Adam", "Bob", "Charlie"]; const YesArray = []; for (var i = 0; i < YesVotes.length; i++) { YesArray.push('{name: ' + YesVotes[i] + '}'); } console.log(YesArray);So the console log is giving me what I think I want:["{name: Adam}", "{name: Bob}", "{name: Charlie}"]But the function output.set('YES Votes', YesArray);Is not making the change to the YES Votes column of my table.

Hello, i am trying to create users on Softr solution with their api script, i tried to put in a script on airtable but it show me an error. I need to integrate records data (name, email etc.) here is the code : curl --request POST 'https://studio-api.softr.io/v1/api/users' \ --header 'Softr-Api-Key: F00xq00gpZf8TLCFYsbsSa7CzRO' \ --header 'Softr-Domain: app.softr.app' \ --header 'Content-Type: application/json' \ --data-raw '{ "full_name": "NAME-FIELD", "email": "EMAIL-FIELD", "password": "12345678", "generate_magic_link":true }'```

1. Get webhook link from Zapier2. Add input variables you want to push to Zapier3. Check the code to incorporate variableslet url = "https://hooks.zapier.com/hooks/catch/10801604/3u5d4q0/?projectID="; let config = input.config(); await fetch(url + config.projectID + "&recordID=" + config.recordID + "&lat1=" + config.lat1 + "&lon1=" + config.lon1);​ 

Hi, I was wondering if there was a way to get the statistics on API calls to a base? I’m building a no-code app with Bravo Studio and they’re not integrating analytics for the moment so I was wondering if I could track the Get requests made for specific records.

 I have a table with two columns: Url and QR Code.  I would like to run a script that will modify the QR Code field when the Url field changes.I created an automation that fires a script when the Url changes.  I'm trying to determine how to modify the QR Code in the row that changed.The script: /** * Generate a QR code from text, using QuickChart.io (https://quickchart.io/documentation/qr-codes/) * @param {string} text The text to be converted. * @returns {string} The QR code's URI */ const getQrCodeUri = ( text ) => { const serialize = function(obj) { var str = []; for (var p in obj) if (obj.hasOwnProperty(p)) { str.push(encodeURIComponent(p) + "=" + encodeURIComponent(obj[p])); } return str.join("&"); } const settings = { text: text, size: 150, margin: 4, dark: 'f00', light: '0ff', ecLevel: 'Q', format: 'svg' } const qs = serialize(settings) const baseUri = 'https://quickchart.io/qr'

Hello everyone! So I've run into bit of an issue regarding uploading my .csv-file using the Sync API. I use Insomnia as my API client.So what's done so far: I've created an excel-file, made a bunch of headers and added some fill text to each header. Then I've saved this as a .csv-file. In Insomnia, I've made use of the Binary file body and uploaded the .csv. All good. The file is sent to Airtable. Here is the issue. When importing the file to Airtable, it tells me that only one field exist and this field contains all of the headers I've made in the .csv-file. How come?  Hope that someone can help me figure this out. Thanks!