Development & APIs

I read the documentation and discovered that Airtable has a request limit for its API. We expect about 50+ people to use our mobile app on the first week of release and the number of users is probably going to increase after a month so this “5 requests per second” seems very limiting for the app. The chances of users sending requests simultaneously is pretty high and this will make the app unusable. Is there a way (maybe a premium plan) to exceed that limit without the 30 second wait penalty? Thanks!

Hi Airtable community. Since yesterday i’m facing an issue with the app I’ve been developping. I haven’t made any modification to my code and it seems to only happen since i upgraded my computer to a faster CPU (I think it’s unrelated but still mention it just in case) I have a method responsible for retrieving all the records from a table. async function getTableAsArray(baseId, tableName, view, maxRecord) { let table = [] let jsonTable = {} jsonTable['name'] = tableName jsonTable['records'] = {} base = new Airtable({ apiKey: 'API-KEY' }).base(baseId); await base(tableName).select({ maxRecords: maxRecord, view: view }).eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. console.log(tableName) console.log(records) records.forEach(function (record, i) { if (i == 0){ console.log('1000ms') } Object.entries(record.fields)

When you are building on Airtable using Javascript - two things can help you build faster with less errors: :globe_with_meridians: GraphQL :closed_lock_with_key: . Type-safety Prisma is an amazing next generation ORM the brings type-safety and GraphQL to the table. So we wanted to see how Prisma would work with Airtable and wrote up a step-by-step tutoria: Sync Inc Docs Prisma - Sync Inc Docs Sync Inc replicates Airtable to a Postgres database, giving you the

Hi there, I am working on creating a user cms for our web app. My goal is gather a record’s information from a button click. I am currently getting the record based upon the click but I am only getting the ‘id’ and ‘name’ as part of the returned record object. Here is the code so far let table = base.getTable("Users"); let fieldsToInclude = table.fields.filter(field => field.name !== "Update User"); let record = await input.recordAsync('Update user', table, {fields: fieldsToInclude}); console.log(record, fieldsToInclude); The console output is: {id: "recmKNtwayYQNFu0K", name: "Kelly"} ▶(9) [Object, Object, Object, Object, Object, Object, Object, Object, Object] 0: Object id: "fldMqI2JmcuRkwOru" name: "First Name" description: "" type: "singleLineText" options: null isComputed: false ▶1: Object ▶2: Object ▶3: Object ▶4: Object ▶5: Object ▶6: Object 7: Object id: "fldVQSI2xjMjdunEi" name: "Initiative" description: "

Hey, Wanted to know if there should be support for it. I just tried to use them but style is not what it should be I think. See attached screenshot of a block with the most recent version of the blocks package (v0.0.47): Thanks, Ronen Babayoff Superblocks.at

Hi all, I realized that for Join Field (previously called Foreign Key field), regardless of whether it is defined as only allowing single or multiple records, is plainly exposed through the Block API as a ‘Multi-Record-Join’ FieldType and there’s no meta data available from the FieldOption as well. That creates many problems trying to handle the join field correctly. Ideally the field type should expose that difference (just like you wouldn’t call Single-Select field Multi-Select). But at least, is there anywhere we get some meta data exposed in the fieldOption or fieldConfig? Great if anyone knows what to do. Or if one of the API team member stumble upon this and take the feedback. Thanks.

Hi, how to integrate & connect APIs of Airtable & Mangopay (PSP) ? what are the steps ? thks !

Hi! I need access to the metadata API ASAP to integrate with Airtable - anyone know approximate wait times / if people are still getting access to the metadata API? Thanks!

Looking for a script to automatically record a Postman response in an Airtable base. Please help :pleading_face: From a non-tech background so will need an elaborate answer :see_no_evil:

I would like to ask if there is a script that will open a specific browser when clicking the button field. My workplace has web portal sites that only work with Internet Explorer, but I don’t want my team to have it as their default browser. I have set up the button to run script, but would appreciate some assistance with the code.

I’m wondering if there is a tool, like the API encoder codepen, which helps build filterByFormula to send to the API via getTableAsync. The API encoder accepts a filterByFormula, but it doesn’t help you formulate one. I have a large Vue site with checkboxes (imagine a furniture store where you can choose size, color, dimensions, name, etc.) and I want to build the filterByFormula on-the-fly as people check and uncheck boxes, but I’m not sure the syntax for a long, complex filterByFormula.

Hi, I decided to use Airtable today to store a spreadsheet-like set of data because it seemed easier than setting up a database (I would usually use POSTGRES locally). I’m getting the data from various sources - online services, web page scraping, and so I create the data records and then need to update them later with data from different sources. My “primary field” is ISBN, and it’s unique for each record, each one representing a book. Why does my record need an additional “id” that I have to query for? Is it possible to make my ISBN the id so that I don’t have to query for the “id” that Airtable is generating? It’s so much overhead to make the additional query each time for the record “id” when the ID that I’m using is ISBN and it would work fine for me to make that the primary key for the table(base). Thanks for any pointers! alexis

I’m running a scripting app that loops through all the records in my Airtable using await table.updateRecordAsync() in a few fields, including a single-select field. Every once in a while, through human error or something else, we’ll wind up passing something to the script that makes it try to update the single-select field with some value that isn’t one of the options for that field. Right now what that does is cause the script to throw an error and abort entirely. What I’d like to do is have it throw an error message and continue on to the next record in the table. What’s the best way to go about this? Excerpt of the script in question below (for context, we’re a nonprofit helping folks in the criminal justice system): if (parsedNewDate.valueOf() != parsedOldDate.valueOf() || postSentencePrison != newPrison|| inmate.releaseCode) { if (parsedNewDate.valueOf() != parsedOldDate.valueOf(

I’ve built a custom app which has functionality to both use it in the sidebar or have it triggered when you press a button field. I’d like to force the app to reload any time the useRecordActionData hook detects a change. How would I go about pinning that kind of functionality to the hook? I’m trying to reset all the various React states whenever there’s new info from the hook.

I’m running issues when running block release to deploy my Airtable app. I’m using npm workspaces as I develop my Custom Airtable App since I’m using a monorepo to make code management and sharing convenient. Here’s the basic folder structure for my project: project_root/ packages/ - houses workspaces common/ contains code shared by airtable_app and server workspaces package name: @shoptable/common airtable_app/ - contains the airtable block app server/ - another workspace Here are the steps I take before running block release: npm i from project_root

In the process of building an Airtable AUTOMATION that will update multiple records at once on a daily schedule, I discovered that’s not currently supported. That leads me down the path of trying to run a script that will run on said daily schedule within the AUTOMATION. However, I have a very novice understanding of JavaScript and I’m struggling to apply Airtable’s specifics when it comes to writing a script. Is there anyone willing to help me out? I tend to learn a TON every time I have the opportunity to modify a script. But I need some help getting there. HERE’S WHAT I NEED A SOLUTION FOR: On a daily basis, I’d like to change the {Status Field} —which is a “single select” type— of a list of records (when the status is “Option 2”) to have a status of “Option 1”). My knowledge falls short on syntax. So I don’t know if it’s easier to comb through the entire table using a “for loop” or calling a view that does that work for me. But I’m

Hi there - I am trying to configure an automation but when I put in output.text and recordAsync, I am told these are not functions and receive an error. What can I do to fix this?

Hello. I am trying to create a script that updates the color of an option within the selection field. Is there a way to do that? I want to keep the same text but only change the color because when I create new options via API they are all created with the same color.

boy, where do I start. so after two weeks of trying to get Airtable to bend the knee to more than 100 outputs per rest API call i have given up. to get to know my environment i have a document with 150 rows and 12 columns that i would genuinely love to import to BI too do some visualization magic to but i’m stuck. I have at the moment connected Via rest api the data from the air-table “database” with the https://api.airtable.com/v0/XXXXX/XXXXX?api_key=XXXXX call. Yet of course that only return 100 values and in the advanced editor it retrieves as so. from the wonderful community that surrounds this awesome Database i’ve found many sources that prompt me to deal with the Pagination that has tormented people in the past so I decided give it a shot and after a lot

I’m looking to connect a number plate (license plate) recognition camera with an Airtable database so that I can have people book into a car park and open an automatic car park gate when the camera sees them arrive. Then in Airtable I’d like to be able to see the arrival time and the exit time of cars in the Airtable database. Has anyone come across a way of doing this?

is there a way to filter a table based on first world in a column. (like search in sql) i have a table and it has products, i want to get all products starts with ‘television’

Despite i set to false flag “Allow linking to multiple records” for multipleRecordLinks field options of this field is exactly the same as this flag will be set to true. How can i know in script that this flag is disabled? Thanks

Okay so I’ve got a list of pretty standard tasks every time I host an event, so I’d like to automatically add them to my task list for each new event I add to my table. Below I have my template of tasks. Using the scripting block, I’m able to choose which event I want to apply this template to. Take a peek at the script below (which borrows heavily from the Record Template example), and example base here! Would love to know you how use this, and if it’s helpful. // pick tables & views from your base here let checklistTable = base.getTable("Planning Check List"); let templateView = checklistTable.getView("Template View"); let projectsTable = base.getTable("Projects"); let projectsWithNoC

I have a list >700 of customer IDs that I want to know more about. How can I query them in bulk rather doing it one by one?

Hi all, We’re excited to release an open beta of a new Blocks Testing package! This new npm package will make it much easier to write tests for the apps that you build - crucially, without having to rely on the Airtable backend to run your block in a testing environment. With the Blocks Testing package, you’re able to create a new test driver instance: import TestDriver from '@airtable/blocks-testing'; import MyApp from '../frontend/my-app'; const testDriver = new TestDriver({ /* test fixture data here */ }); render( <testDriver.Container> <MyApp /> </testDriver.Container>, ); Add input to the app: await testDriver.base.createTableAsync('a new table', [ {name: 'address', type: FieldType.EMAIL}, ]); And verify that the app works as expected: const checkbox = screen.getByRole('checkbox');