Development & APIs

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

Hello guys, I have an Airtable managing my bills in multiple currencies. I’ve been trying to customize the [Airtable Currency Converter] (Airtable Scripting) to convert each record with the conversation rate of its date. I want it to be automated given that I have 5,000 records of bills. I suspect my syntax is wrong, but maybe the logic of my code is completely wrong too. My code is the following : // load table and records let table = base.getTable("Table 1"); let result = await table.selectRecordsAsync(); // launch a 'for' loop to fetch conversation rate then update each record depending on value of "Date" field for (let record of result.records) { await // fetching exchange rate let apiResponse = await fetch(`https://api.exchangeratesapi.io/${record.getCellValue("Date")}?base=EUR`); let data = await apiResponse.json(); let conversionRate = data.rates.GBP; // updating the record table.updateRecordAsync(record, { 'Exchange rate': convers

I have a view where the primary field is an autonumber generator. About 12 hours ago my code below would have output the list of the IDs of all of the records in a view: let Table = base.getTable(TABLE_NAME); let view = Table.getView(VIEW_NAME) let query = await view.selectRecordsAsync(); for (let record of query.records) { output.text(record.name) } However, it is now saying that each of these records is unnamed. Oddly, the description of the “name” property says that it should be the string of the “Primary Cell Value”. Double clicking the autonumber field shows “This is the table’s primary field”. Can someone clarify my misunderstanding?

I have the code below that has been working for weeks no, and all of a sudden I’m getting an error when i try to process it. its really odd. It’s ran on the click of a button. ERROR L: linkedRecordIds at main on line 5 SUBJECT CODE let url = "WebHookUrl.com/xinvicdiieednisxso123232"; let table = base.getTable("TABLE TABLE"); let view = table.getView("TABLE VIEW NAME"); let record = await input.recordAsync("Pick a record", view); await fetch( url + record.id + "&" + "First Name=" + record.getCellValueAsString("First Name") + "&" + "Phone Number=" + record.getCellValueAsString("Phone Number") + "&" + "Email=" + record.getCellValueAsString("EMAIL") ); await table.updateRecordAsync(record, { STEP: { name: "DELIVERED" }, })

I’d like to get some clarification for how to import external node js libraries into custom blocks to work with other third party api’s within the blocks. I see statements on the Airtable help docs that say you can do this, but no documentation for how to do it properly and any limitations that exist. Also, there is no info online anywhere about whether storing your api keys in a airtable custom block or script is secure or how to do it securely. I’d like some guidance or documentation on this if possible.

Hi there, I’ve just made my first custom App (or Block as it used to be) with a d3 chart. So many possibilities! I can’t work out how you set a component to re-render if the viewport is resized. Any suggestions would be appreciated. Thanks, Bryony

Is there a way to maintain a connection to stream data from a base through a block? The reason I’m asking is that there’s a lot more information I can get about the base through the Block API than through the standard Airtable API.

I’m trying to parse XML pulled in from another API in scripts. I’ve tried using https://gist.github.com/petersirka/9e79b1d43cf6e579fc62 but it is insufficient as the parsing is not accurate in some cases. Is there a way we can use DOMParser() to parse XML? Thank you!

Hi friends, I am loving this so far but have a question about embedding a card view on a website: is it possible for the “link to people” function to actually link to those people and be clickable in the card view? It does this for me in the back end, but when looking at it in the embedded function this would also be a really good feature. Thanks for consideration.

Hi everyone, I have a column (Exact Employees) which contains the exact number of employees a company has and a column (Employees) with a Single Select field with brackets like: 1 to 10 11 to 25 etc. I’d like to have a script that would do something like: Check “Exact Employees” and if number is between 1 and 10, then select 1 to 10 in “Employees” and so on. Can someone help me get started? Thanks

Hello! Hoping you all can help. I have a base of Store Locations (name, address, website) and a related table of Deals (details, participating store locations). The Deals have a linked record field, Participating Store Locations, to attach one or more Store Locations records to each Deal. I need to display a list of Deals with the details for each Participating Store Location like this: DEAL 1 Participating Store 1 Participating Store 2 DEAL 2 Participating Store 3 Participating Store 4 Participating Store 5 I can get a list of the Participating Store Location record IDs for the store locations from the linked record field. I am having trouble getting the Store Location records returned from the find function. I think it has something to do with the timing of an asynchronous function. I’ve tried a few things to make a callback or promise work but my javascript is thin in that area and I can’t get it to work. Any help is greatly appreciated. Thanks! Here is the code: var storeLocati

I got a notification stating that “I can create a link to share blocks”, but I don’t know how to do it. Is there a new button where I should click? Does anyone know what I should do now?

Hi, Is there any way to load blocks in mobile phones ? Any known hacks? Thanks.

Hello Friends, I’m basically trying to make this Find and Replace script run in the automations feature, except instead of manually typing the inputs, just using the input variables entered into the block. I’m only python literate and thus far have only replaced the “findText” and “replaceText” variables: let table = base.getTable("crm_deals"); let field = table.getField("Deal owner"); let findText = input.config()["Input variable name goes here"]; let replaceText = "Input variable name goes here"; // Load all of the records in the table let result = await table.selectRecordsAsync(); // Find every record we need to update let replacements = []; for (let record of result.records) { let originalValue = record.getCellValue(field); // Skip records which don't have the value set, so the value is null if (!originalValue) { continue; } let newValue = originalValue.replace(findText, replaceText); if (originalValue !== newValue) { replacements.push({

Hey everyone. I’ve created a Button field (see bellow) that for some reason remains inactive. Surprisingly the exact formula works without any issues in a different table.

I want to use 3-rd party grid and chart libraries. FancyGrid fancygrid.com FancyGrid - JavaScript Grid Library for Enterprise | Angular React Vue grid... HighCharts highcharts.com Interactive JavaScript charts for your webpage | Highcharts It looks like I can do it and it works. But I am afraid about publishing and licences. Am I allowed to do publish in market place app with 3-rd party libraries?

Hello everyone, Although I am not new to Airtable, scripting/ coding is not something I am familiar with and I would like to ask if anyone can help with a script I set up below. Now that Airtable allows for sync bases, I finally have to opportunity to combine multiple bases in one and look up all records from one source instead of having to click at a million things. That said, since I have 8 active bases (the reason being that we are using Airtable to in order to Telemarket/ Telefundraise) I also have 8 synced tables - with multiple columns each - that are still kind of tedious to go through. I found this script from one of the Airtbale members that allows for a lookup function Now my question is: Is there a way for the if statement to update multiple records and if so how would that script look like? e.g if “Name” === the lookupValue then let returnValue = rangeRecord.getCellValue(“Attempt Counts”); let returnValue = rangeRecord.getCellValue(“Column 1”); etc. and update the main tab