Development & APIs

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 cd packages/airtable_app block release I run into the following error: building copying package.json file copying package-lock.json file ❌ Error: package-lock.json does not exist! Failed to build the block code! There’s only a package-lock.json generated at the project_root level. How can I get around this issue with my development environment? Current Workaround The only way I’ve found that works is to run npm pack

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 lost when it comes to much more than identif

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 of shuffling around the internet i’ve come to believe the solution is to do this and replace the above code with this. yet all i gat is one column table with error and no data. is this the right direction? in newish to air tab

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 projectsWithNoChecklistView = projectsTable.getView("No Checklist"); // select an event to create a checklist for let selectedEventRecord = await input.recordAsync( "Choose event to create checklist for", projectsWithNoChecklistView ); if (selectedEventRecord) { // load in all of of the tasks that our

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'); expect(checkbox.checked).toBe(true); The Blocks Testing package is compatible with many popular testing frameworks, so you can choose your favorite way to write your t

I have a table in which I am using a start date+time. The end time needs to be formatted as a date if I want it to work in my Calendar view (which is shared to various departmental users). I have ‘Class 1 Start’ [2/6/2021 8:00AM], I also have a field where this class has a defined meeting time [105 minutes]. I attempted to use a simple {dateadd} formula to define the ending time of Class 1. Hoping to use the start and end times together in the Calendar View (Airtable - Shared Calendar). Other fields have unique end times so I hard enter them, but we have 5 classes per course so I’m trying to build out a script that would remove the opportunity for data entry errors/oversight. Currently I use it where Classes have no end time, so they populate the calendar as a default 1 hour block. The ical feed thus is incorrect when I share this for use. I have no experience with Scripts and my cursory search didn’t get me very far. Any guidance where I can piece together a script would be welcomed.

I want to log my Exceptions from my .Net Application to the Airtable using the NLog After configuring the nlog.config file. getting the following error in the Nlog internal logs: Error WebServiceTarget(Name=ws): Error sending request Exception: System.Net.WebException: The remote server returned an error: (422) Unprocessable Entity. at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult) at NLog.Targets.WebServiceTarget.<>c__DisplayClass67_0.<CreateSendContinuation>b__1(IAsyncResult r) Here is my nlog.config file <?xml version="1.0" encoding="utf-8" ?> <nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" autoReload="true" throwConfigExceptions="true" internalLogLevel="info" internalLogFile="c:\temp\internal-nlog-AspNetCore3.txt" > <extensions> <add assembly="NLog.Targets.Http" /> </extensions> <targets> <target

Hi ! I created a rollup field I want to access via the API. Aggregation formula is AVERAGE(values)*1.20 values are integer. Custom json decoder (written in Elm) fail at parsing this field. I checked the api documentation and field’s type is number or string. I expect it to be a number since it’s formatted as an integer and all input values are also integer. What does it mean ? How to coerce the type to be only a number ? I tried to consume the aggregated value in another field formula but it inherits this number or string type. Thanks for your help!

I have a very minimal understanding of JavaScript and cannot write anything from scratch (yet). But I believe I could modify something pre-built. Elements I already have: Base 1: A base with all of my Slack Workspace members and their Slack ID(s) as well as their DM Links Base 2: Another base of incoming inquiries (that populate from an Airtable form) that also has “Lookup” fields that pull the user’s Slack ID and Direct Message (hyperlink) from Base 1. Request Using Airtable Automations I’d like to trigger a scripting block to send a Direct Message to a Slack user in my Slack Workspace (using their <{Slack ID}—Lookup field> in Base 2) when the status of an incoming inquiry is “XYZ”. NOTE: I am aware that Automations has a Slack notification feature, but you can only post to a channel or (the same) Slack ID each time the automation runs. I’d like the ability to dynamically send a message to a different Slack ID (since I have that data), based on the record info, each time