Development & APIs

We use Airtable as a back-end for many of our major systems. A big part of these systems is the use of scripting apps in order to streamline many of our processes. We have one system to track shipments. We get data in at the end of our day and someone will upload that data into one of our bases. From here, we run a series of scripts that scrubs and processes the shipping data since much of it can come in very raw. I was in the process of working on one of these script today when all the sudden I was thrown the error “You can only send 15 mutations every 1000ms”. Now, I haven’t made any changes to these scripts today and have never seen this error prior to today. The issue is that we process large amounts of data and while putting an ‘await’, which we don’t normally do, in front of an ‘updateRecordsAsync’ function will allow the script to work, it takes us from a process that used to take 5 minutes to one that takes ~30 and potentially ruins our entire decision to move this process into

I’ve successfully applied both those conditions distinctly: filterByFormula: {customerOwnerRef} = '' filterByFormula: {customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}') But I don’t understand how to make a logical OR between both conditions, I tried the following but it fails with INVALID_FILTER_BY_FORMULA error: filterByFormula: {customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}' OR({customerOwnerRef} = '')

I know there has been lots of discussion about Airtable Apps regarding API keys and the best way to store them—I believe the current recommendation is still in globalConfig. My request is about Airtable’s own API keys in particular. It would be great if a Custom App was able to access the current user’s Airtable API key via a new readonly field in their CollaboratorData. When accessed via the App’s Session, this could really help with customizing the app per user and ensure any API calls they make are tied to their Airtable account. I don’t think this is currently possible, but I’d be curious to see if others would find this helpful as well?

Hi! I understand that the API has a rate limit of 5 requests/second per base, and I’m open to creating a database to cache the retrieved data to account for a potentially higher read volume, as recommended in the API documentation, but I just wanted to ask whether there are any other limits/caps on the number of total requests per, say, day. Thank you!

The following request works as expected: https://api.airtable.com/v0/appD1JKW7PlQhRMrF/Docentes?fields=Email&fields=Status But this one fails with status 422 Unprocessable Entity: https://api.airtable.com/v0/appD1JKW7PlQhRMrF/Docentes?fields=Email The response is: {"error":{"type":"INVALID_REQUEST_UNKNOWN","message":"Invalid request: parameter validation failed. Check your request data."}}

Hi Airtable, I would like to automatically retrieve historical exchange rate data from this website secure.mas.gov.sg Monetary Authority of Singapore Any kind folks can help me?

I have an app in G Suite that uses a trigger script from a spreadsheet to create a set of record-associated Google Docs, and retain their URLs within spreadsheet cells. This is done in the background, as a trigger. Can I access the Google Docs API to enable such a function, and how would I enable it as a trigger, similar to a trigger from a Google Sheet? Sorry if this sounds basic, I am just starting with Air Table. Much tighter and somewhat more intuitive than G Suite.

Hi all Is there a way to retrieve or update a record’s activity/comments using the API? I’d be keen to hear about any attempts at doing this. Thanks! Alex

Hi, I have a formula field that has long SWITCH statement and I want to modify this formula dynamically in backend. Is there a way to achieve this?

Hey AirTable Family, Is there a way to pivot columns to rows in AirTable? For example when I import an excel csv with contact name and 10 phone numbers on each row, is it possible to create a view / table from that table (in AirTable) which will pivot the 10 phone numbers to rows while repeating the contact name? I want my assistant to record dispositions for each phone call. Thanks!

Hello, I am using airtable.js javascript SDK to displaying records. I am trying to figure out, is there any way to duplicate a record in same table by just passing airtable record id to api SDK?? Thanks, Chirag

When I use the API to create, update, or delete multiple records in a single API request, is it possible for the request to partially succeed? Meaning, for example: the API successfully creates (or updates or deletes) some of the records but fails to create one or more other records. To ask this another way: if the API returns an error when I’ve sent multiple records, am I guaranteed that none of the records were successfully created/updated/deleted? Thanks.

I’m having trouble finding any info about how to retrieve the records contained in a linked record field. In the custom apps there’s a function called .selectLinkedRecordsFromCell, but I’m not seeing something similar in the scripting app documentation nor anything else about how one might do it. Thanks

Hi all, I have 5000 records and there is one deleted that I need to find. I loop over the the records IDs 100 at a time to see if I get all 100 returned. On this forum I found 2 approaches using filterByFormula to get multiple records for multiple IDs filterByFormula = 'SEARCH(RECORD_ID(), "'.implode($ids, ',').'") != ""' filterByFormula: "OR(RECORD_ID() = 'reca9IDlX0gvu32ml', RECORD_ID() = 'recgh3XeMcdmX8uPj', ...)" some questions is this the best way to find deleted records should I use filterByFormula, and if so, which formula is “lighter” for airtable to process should I use a different kind of filter (AFAIK the batch API is only meant for create / update / delete and not for reading) Greetings, PJ

I am trying to create an app that allows the user to edit/add data through input fields. I have the data binding and working fine. The issue happens when the user wants to edit anywhere in the text. It will allow a few characters input, then the app will refresh and the cursor will be at the end of the text. I simplified the code to just editing a record name for reproduction. Any ideas? Thanks in advance import { cursor } from “@airtable/blocks”; import { useLoadable, useWatchable, initializeBlock, useBase, useRecords, useGlobalConfig, TablePickerSynced, Box, Text, Input, } from “@airtable/blocks/ui”; import React from “react”; function UpdateBlock() { // YOUR CODE GOES HERE const base = useBase(); const globalConfig = useGlobalConfig(); const tableId = globalConfig.get(“selectedTableId”); const table = base.getTableByIdIfExists(tableId); const records = useRecords(table); useLoadable(cursor); // re-render whenever the list of selected records or fields changes useWatchable(cursor, [“

We are using Zapier to integrate an Airtable base onto our website. If we move the Airtable base to another workspace on a different Airtable account, will that affect the Zapier integration?

Is it possible to end a script early? It seems like the process.exit() function isn’t available. I’d like to show an error message and exit if the input meets certain criteria.

Hi, Does anyone know how to get to the REST API documentation? I found a link here https://support.airtable.com/hc/en-us/articles/203313985-Public-REST-API but it appears to be broken. Thanks!

Hi, Thank you for your participation in the Custom Blocks Beta! We have some big updates about Custom Blocks that we’re excited to share with you today. (Airtable has also launched several other new features today—you can check them out in our community announcement and in this blog post. Blocks are now Apps Firstly—Blocks are now called Apps! You can read our announcement here to find out more. This rename doesn’t change anything about how you manage your custom apps - no action is required on your end. The Blocks SDK and CLI are not being renamed and will continue to be published as @airtable/blocks and @airtable/blocks-cli. Publish your apps for anyone to install Secondly—we’ve heard many questions about if it’ll be possible to publish your custom app to the Airtable Marketplace (formerly known as the Blocks Gallery). Today, we’re excited to announce an official pathway for any developer to submit their custom app to the marketplace! With the new block submit command, you can sub

Has there been any thought about enabling the creation of new spreadsheets by typing “airtable.new” or even “table.new” into the address bar? I use it extensively for google sheets, and wondering whether there were any plans to support having the same functionality?

Unfortunately another roadblock. Both Zapier and Integromat do not allow selecting the SINGLE SELECT Field as a Trigger to start workflows. Some other restrictions exist, e.g. Zapier allows Sing line text field to be a Trigger. Integromat does not allow even that, trigger can not be either text or Single Select. I may be mistaken but I tested both and both field types are unavailable as trigger. That’s a disappointment and I’ll reach out to Zapier and Integromat to comment on that. I’ll update here once I get some feedback.

Release: create tables, create fields, and update field options from the Blocks SDK Custom Apps A few months ago, we announced some unstable APIs for creating tables, creating fields, and updating field options using the Custom Blocks SDK. As of last week’s new release of the SDK (v0.0.54), these APIs have been marked as stable. These methods include: base.createTableAsync() Creates a new table in the base with specified name and fields table.createFieldAsync() Creates a new field in the table with specified name, field type, and field options field.updateOptionsAsync() Updates… @Billy_Littlefield wrote: " A few months ago, we announced some unstable APIs for creating tables, creating fields, and updating field options using the Custom Blocks SDK. As of last week’s new release of the SDK (v0.0.54), these APIs have been marked as stable. These methods include: base.createTableAsync() Creates a new table in the base with specified name a

I’m trying to use the Shipping Block - one of the custom block contest winner. For some reason it won’t pull the rates for my UPS account that’s already connected (Shippo allows you to bring your own courier account and your own negotiated rates). I don’t think it’s the format of any of addresses that’s causing the issue as I’m able to retrieve the USPS rates for US based addresses. Might be niche but did anyone successfully used the block with their own carrier?

Hello! From the documentation for the Airtable API, it clearly indicates that there is a rate limit of 5 transactions per second. With the current implementation of our updateRecordAsync for Airtable, we are seeing no (noticible) rate limits. Are Custom Apps not currently subjected to such limits? If not, will it be? Thanks! Sharon

When we read about other products like the recent early experience beta announcement of Google Tables, we often assume such tools are simply a threat to all other near-codeless platforms. I don’t see it that way - here’s why. It’s not unreasonable to ask - Should I be thinking about this new technology? Is it something that could threaten my business activities and commitment to Airtable? Is my service going to improve or suffer as a result? These are rational questions and concerns but luckily, we operate in a free-market economy and because there’s competition, Airtable is likely to improve at a faster pace as a result of any new competitive offerings. Having been on the test team for many Google services in the past and recently the Tables product, I can assure all of you - Airtable has a huge headstart and especially on the UX axis. I can also predict that integration between the two platforms will yield a wholly new crop of business solutions that would be impractical in either