Development & APIs

I have 2 bases (Payments and Ledger)And on Ledger base i have a sync table from Payments baseI'm making a script that runs on a table in the Ledger database. This script will create a record in the Payments base and then link that record to a table in the Ledger base.But I'm having problems because the synchronization table has a different ID and recordID than the original table in the Payments base.If I pass the recordID from the Payments base to link it to the table in the Ledger base, will that work?

We see that from last three days we are frequently getting 502 Error in spite of no changes on the URL and how we retrieve the data from airtable.It's even seen that Api calls are working for some time of the day and failing for some cases.We would like to know from community what and all trouble shooting can be done.Troubleshooting done.1. Called the API locally and it's working fine.2. Checked the number of calls as well its well in limit only of the Teams subscription.

Ever since personal token system came in Airtable, my data is not showing in Kodular. I have tried everything, tried putting personal token instead of api key but got no result, can't understand where is the problem. 

Does anyone know of documentation that has an example of creating each field type using Node.js?There are certain field types I am running into issues with such as date fields and currency fields and I can not find much documentation of when an example for each field completed looks like.

Hi, we are configuring a new OAuth App, and would like to configure multiple redirect URLs.Is that supported? Can we provide multiple URLs? Thanks

The past week or so, we have experienced intermittent issues with the Jotform + Airtable integration.1. Some Jotform submissions indicate they were successfully sent to Airtable, and never showed up in Airtable.2. Fields that contain more than one attached file (like multiple photos) are only sending over the first file.In both cases, the integration log shows success. It is not every submission, just some of them, making it hard for me to troubleshoot the problem.

I'm trying to filter my extract by the bank that the user select, but i'm always getting null.What am i doing wrong?const extract = await Extract.selectRecordsAsync({    fields: ["Name", "Data", "Valor", "Bank"]}).then(query => query.records)let bank = await input.recordAsync("Escolha um banco: ", Banks)const extractByBank = extract.filter(ext => ext.getCellValue("Bank") == [bank])

Hey I just wanted to ask if I can install extensions for free as a developer is there any privilege to those who are extension developer 

Hi,I'd like to insert the error message into a field, so I used try catch with both of them updating a variable, which I then used to update the field. Weird; it only updated on success, not on error. Can anyone help? let config = input.config(); const recordId = config.recordid; let tabletable = config.tabletable; let table = base.getTable(tabletable); let query = await table.selectRecordsAsync({ fields: ["Error"] }); let err; try { await table.updateRecordAsync(recordId, { "Eat": "Cheese" // no such field }) err = "Code executed successfully"; } catch (error) { err = error.message; } finally { console.log(err); await table.updateRecordAsync(recordId, { "Error": err } ); } console.log("Updated a record!");  CONSOLE.LOG "Could not find a field with name or ID "Eat"." ERROR Error: Could not find a field with name or ID "Eat". at main on line 16As you can see, err was properly logged. But the record was not upd

Hi all! I’m in desperate need of a way to get the data I have in a table into Google Sheets. I would prefer not to use Integromat, but a script. I’m not a developer… I found a script (https://www.optimi.co.nz/blog/2019/05/11/you-too-can-make-dashboards-how-to-visualise-your-airtable-data-in-google-data-studio) but it pulls all the columns of the table and I would like it to pull only the ones that are not hidden in a specific view. Also, since I will be referring to those columns in other sheets, I need their order not to chance when it updates. Any suggestions? @Bill.French? Thank you!!

Hello everyone ‌🙂‌I have a large number of automation scripts, some of which are quite complex. However, developing the scripts is relatively tedious because the script editor gives a limited view of the code (and it lags behind a “real” IDE, e.g. no copilot etc). There is also no version control.I currently develop our scripts this way:I write the script in Visual StudioI also maintain the GIT repo thereWhen I'm done, I copy the script into the Airtable script editorHowever, copying back and forth is error-prone and tedious.My questions to the community:What are your best practices for writing automation scripts and managing the scripts?Is it really not possible to make the code view in the editor full screen (Safari, see image)?Thank you very much!

OpenAI's API for GPT-4 constantly has an over 30sec delay in responding to larger token prompts. This makes automation in AirTable rather useless unless you go to the trouble of building cloud functions. I have multiple working automation steps to categories data, create short email replies etc. But if you want to do anything real with GPT-4 it's limited by the response time. Question - how can I get around this? Any thoughts? 

When I 'get' look-up or select fields using Pyairtable, they're now coming in as list type objects:  'red' is now ['red']'5/11/24' is now ['5/11/24']The previous behavior was WYSIWYG.  This is unexpected and strange and breaks years worth of ETL scripts that I've built.  Anyone else having this problem?     

Output:Code:   // 7. Extract and Return *Only* Desired Fields const productData = recordsData.records[0].fields; const desiredFields = { "Collection": (productData.Collection && productData.Collection.length > 0) ? productData.Collection[0].fields.Name : null, "Color": (productData.Color && productData.Color.length > 0) ? productData.Color[0] : null, "Font": (productData.Font && productData.Font.length > 0) ? productData.Font[0] : null, "Product": (productData.Product && productData.Product.length > 0) ? productData.Product[0] : null, "Registration Status": productData["Registration Status"] || null, "Registration Date": productData["Registration Date"] || null, "Release Date": productData["Release Date"] || null   

I'm trying to update a Google Sheets script that syncs an Airtable Base to Google Sheets. The script uses an API Key and I need to update it to use the Access Token.Anyone know how to update this code to use the Access Token instead of the API Key? Thanks! var api_key = "API KEY";var baseID = "BASE ID"; var tablesToSync_fromSheetRange = "A14:B16";////////// 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 names from the control panel of the spreadsheet  var ss = SpreadsheetApp.getActiveSpreadsheet();  var tablesToSync = ss.getSheetByName("Control panel").getRange(tablesToSync_fromSheetRange).getValues();      //sync e

I have a problem, everytime when I creating new base, I need to manually set up all tables. I have the main base that I would like copy(tables, extensions, automations) to others, can I archive that by API or code ?

Hello,To manage a catalog of goodies for a company, I've started building a database, forms and an interface.The goodies catalog has about 30 items in 3 categories. Some items are textiles with 7 different sizes.The 30 items are common to different entities of the company, but the stocks are different from one entity to another. (1 entity by city)I built the following tables:Entitie,Sizes,Categories,Objects,Received items,Distributed items.The last two have a form for entering what has been received or distributed.Finally, the interface displays the catalog with all the items and quantities for an agency.After this long intro, I share you my problem:To display the stock by size for a given item (textile) and for an agency, I can't find any other solution than to calculate stock for each agency by creating a column per item per size per agency.For each size, I calculate quantity received, quantity distributed and finally stock, i.e. 21 columns per agency ...I think there's a more optima

Hello,I have a Database that includes a table of Users and a Table of inventory (Computers , Monitors, Docking stations and so on).All of our inventory is mapped by serial number.When I give the user a device I assign it to the Air table.I want to have the option to see the assigned history by user or by device.That means if I have a user name Tom, and I gave him on 01/12/2023 a laptop: Lenovo Thinkpad , S/N:ABCD123, and I took it back on 15/01/2024.Let's say I have the record of this computer.Through that record I want to be able to view the computer assigned History- that means when it was assigned and when it was unassigned.  I couldnt find any automatic way to do so, so i want to check how can i develop this module myself.The main result should be an automated change log for every record modified, instead of writing it manually on the comment section. how can this be achieved? would love to receive any ideas or any SDK or developer documentation regarding this. &nbsp

Hello! I'm using the Airtable API and I'm encountering an error.I'm making API requests in Node.js with OAuth authentication to retrieve records with applied filters. However, I'm receiving an error message that says 'You should provide a valid API key to perform this operation,' and I couldn't find any information about this error no matter how hard I looked. Is there any way to resolve this?I was able to successfully retrieve the list of bases and tables with the same access token.Thank you.Scope: data.records:read data.records:write data.recordComments:read data.recordComments:write schema.bases:read schema.bases:write webhook:manage

React devtools used to be found in the "Advanced" tab while developing a custom extension.  They no longer are and I heard that they got removed for maintenance difficulties.Can you please bring them back or somehow give us a workaround for using the standalone version?If you want developers to make extensions for the Airtable community that are good, this will help us do that better/faster 🙂

This is sorted when we're using Airtable API to build our own product.Free access linkHope it will also be useful to you😄  

Hello everyone, does anyone know if it is possible to use the Gemini API Generative Language to create an automation in Airtable? I would like to use 1 column to receive data input from my users app and serve as a kind of prompt. And then use 2 more columns for output with AI responses.Additional notes:

Any tips on how to make React DevTools work when developing locally?

I’ve added Multiple Select field to my base. In the Fields section on the API page it displays all the Possible Values this Multiple Select field as an array. Is there a way to grab this Possible Values array upfront or do I have to loop through the records and build this array based on each record’s selected value(s)?

Hi, when building our product iOS Shortcuts Library for Airtable users, it's all based on the Airtable API. In recent days, we've gained a lot of experience using the current Airtable API. Here is an overview and sharing of our knowledge that you can use as a quick reference before diving into the lengthy API documentation.Key Concept: BaseID, TableID, RecordIDWhen using the Airtable API, you need to specify which base and table you want to interact with. Unlike the Graph UI, you need to specify their IDs. The easiest approach is to open a record in your browser, and you will find the ID in the URL path.What Are the Major Capabilities of the Current Airtable API?Although there are more than 30 different APIs, here are the 4 most important ones, ranked objectively: 1. Read records in a table using one of these two APIs:List Records: Returns all records in the given table. You can apply filters in the API parameters.Get Record: Returns detailed information about one specific record.2. Cr