Development & APIs

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!

Hi all - my IT team has some technical questions about Airtable that I don't know the answers to (or even really understand!). Can anyone shed light on any of the following questions?Is there AD integration for employee users?Is there 2-Factor Authentication for all users?Is the data backed up? For how long?Are the backups encrypted?Is all the technology patched and current?Is the vendor solution patched on a scheduled basis?Are critical patches applied as soon as their identified, both to the solution and to related technology?Is storage provided, and how much?Is it a Cloud/Saas solution (non on-premise-managed by vendor)?What other security measures are taken?Please provide details on the SOS verification.Thank you,Kelsey Deusterman

Hi, I'm creating an attachment via API and it shows the attachment but then gets deleted a few seconds later. Any tip on why this may be happening? Is it a bug in Airtable or the third party I'm using?  

i write this simple script, and get an error:await table.createRecordAsync({"Singal Select":"1"});Error: Field "fldVrE9PBN0HBkpRn" cannot accept the provided value.tried allsow this script:await table.createRecordAsync({"Singal Select":{name: "1"}});and same error all the premission are open...TY!

Has anyone created an API between Workfront and Airtable? We currently use Airtable for project management/planning and sharing of projects, but creative requests/approvals go through Workfront… would be looking for one-way communication from Workfront to Airtable (specifically relaying dates from Workfront tasks and moving final assets/creative files from Workfront to Airtable once they are approved in the Workfront system). I’m only familiar with Zapier to connect platforms and unfortunately Workfront is not available there, so wondering if anyone has had success connecting these two with a custom API? TIA!

I have written several Scripts and an Extension. Both of these use the Base, Table, View, Record, Field classes provided by Airtable. I would now like to create a node service running in the cloud that needs to get and set information stored in Airtable. Is it possible to use the same JavaScript classes as with a Script or an Extension to access Airtable data from node? Cheers  David

Hi there,I am creating a simple extension that creates a record with an attachment. I am using createRecordAsync  from the blocks API for the record creation and the the native URL interface from the Web API to create an URL from the file loaded in by user via an `<input type="file"/>`.URL objects const handleFileChange = (e) => { (...) const newFiles = Array.from(e.target.files) const fileData = newFiles.map((file) => ({ filename: file.name, size: file.size, type: file.type, status: FILE_STATUS.LOADED, url: URL.createObjectURL(file), })) setFiles(fileData) } then (...) table.createRecordAsync([{attachment: {filename: file.filename, url: file.url}}]) A record is created successfully and I get no error or warnings, however, the file is never attached to the record. I wanted to avoid having to go through the Airtable API.  Is it possible to create an attachment directly from an extension?   Thanks,Pedro

Hey everyone! Im using a script (that I found here in the community, thanks btw!) to pull data from Airtable to Google Sheets in order to make some weekly reports for employees in a company. Problem is, it seems each time the script runs it retrieves the Fields in a random-ish order, which is a problem because those fields are referred to in the reports. Using Zapier is not an easy option since we have more than 400 fields. Here is the script var api_key = "XXXXXX"; //ADD YOUR API KEY FROM AIRTABLE HERE var baseID = "XXXXXX"; //ADD YOUR BASE ID HERE var tablesToSync_fromSheetRange = "A14:B15"; //UPDATE CELL RANGE HERE (for tables that you want to sync) ////////// add items to UI menu /////////// function onOpen(e) { SpreadsheetApp.getUi() .createMenu('Airtable to google sheets sync') .addItem('Manually sync all data', 'syncData') .addToUi(); } ////////// function to trigger the entire data syncing operation /////////// function syncData(){ //fetch table na

I'm doing an extension and I need to get some data from the table. Specifically all the records from the table or selected records, but when I go and select records it only  shows me the ids or names of the first field or "primary field". Is there a way to get all of the other ones? 

Hi All,I'm juste trying to write a small script in node js to get a list of a db I have here in Airtable.As the documentation said, I've used https://www.npmjs.com/package/airtableand my code is as follow :  import Airtable from 'airtable'; const baseId = '****'; const tableIdOrName = '****'; Airtable.configure({ apiKey: **** }) const airtable = new Airtable({endpointUrl: `https://api.airtable.com/v0/${baseId}`}); console.log("airtable",airtable); ==>>> {} console.log("airtable",airtable.getTable("tableIdOrName")); ==> "TypeError: airtable.getTable is not a function" Thank you for your help!

I prepared an api script (with the baseId, tableId and the token). I tried to run it on a console and I get error massage. We should I run it?

Does anyone know whether the Webhook API contributes to the new API limits on the Free/Team plans?