Development & APIs

Hi, I have one table where we collect all the facilities requirements from various departments. I need the output like for each facility item what is the total count How to do that with scripting Can someone help me Regards Sridhamasakha Dasa

Now that the scripting block is available I’ve been trying to learn how it could fit into our workflow. We are building loads for delivery drivers to pick up and deliver. This screenshot is stripped down to just the information that we send the drivers and is a small data set for a visual. (Normally it would involve 4-5 drivers with 2-3 loads each) After orders(records) are grouped into loads, a driver and a farm are assigned. Then someone manually text messages the information to the drivers in the format shown in the word document on the right side of the screenshot. I feel like there must be a way to use a script to reformat the table data into the text message ready format. Totaling pallets for each load and showing which farm to go to. Then showing the destinations under that with their respective quantities. Bonus would be an SMS service to just send the driver the information in the new format. Is this possible? reasonable? Alternate route? Thank you.

Hello there! Who can help me with a script that will transform the phone field into the right international format? Example: I have a base with client phones. Most of them are in the national format 069xxxxxx, 068xxxxxx, or without zero 69xxxxxx, 68xxxxxx. I need to transform them all to the +37369xxxxxx, +37368xxxxxx. How to do this?

@Kasra @Stephen_Suen @Shrey_Banga and any other JavaScript :mage: ‍♂ Is it possible at all to call an async function from inside a loop? I’m trying to run a script that contains this loop: tablesToClear.forEach(table => { let recordsToDelete = table.records.map(record => record.id); let recordsDeleted = await batchAnd('Delete', table, recordsToDelete); if (recordsDeleted !== null) { totalRecordsDeleted += recordsDeleted; } }); where batchAnd() is defined as an async function that makes a call to table.deleteRecordsAsync(). I’m getting this error: ERROR SyntaxError: await is only valid in async function at new Function (<anonymous>) at _callee2$ (blob:https://block---falsh-z06h-lq-e-pb--68v3t0m.airtableblocks.com/e9e14464-0db0-424f-ad41-111819081f76:3359:53) at tryCatch (blob:https://block---falsh-z06h-lq-e-pb--68v3t0m.airtableblocks.com/e9e14464-0db0-424f-ad41-111819081f76:181:21) at Generator.invoke [as _invoke] (blob:https://block---falsh-z0

I’ve got a script that I wrote to help with processing donation requests at my job. These requests come via FormStack, and are sent to me via email (a process out of my hands at the moment, or else I’d shoot the data straight into Airtable). I copy the data from the formatted email and paste it into a single field in an Airtable record. I can make as many records as I need for any number of incoming donation requests, then run my script to process them all, creating and linking records across different tables. My original version is what I call the “dumb” version because it doesn’t check for possible duplicate records for organizations or contacts before making new records. I wanted to make a smarter version that would use existing records where possible, so I copied the “dumb” code to a new block and have been working on the updates for several hours today. It’s mostly working, but I’m getting some very odd results. In my tests, I’ve got three requests to process. The new request reco

I’ve got a script that I wrote with the scripting block prototype, and it worked perfectly well under that version. Under the new beta, I had to make a few minor tweaks due to API changes, and all appears to be fine except for one part that is being marked as a problem, when it worked just fine previously. I’m setting a value in a multi-select field using data I’ve extracted elsewhere. The code for the relevant portion that changes the multi-select is pretty bare-bones: reqtable.updateRecordAsync(reqrecord[0], {"Use": [{name: notes}]}); What’s being highlighted as an error is: {name: notes} The notes variable is a string, and should be one of the five options for the multi-select. Like I said above, this part has always worked in the older block, but in the new one the error popup gives me this: Type '{ name: string; }' is not assignable to type '{ name: "Silent Auction" | "Live Auction" | "Raffle" | "Other" | "Auction"; }'. If I replace notes in the code with a literal string, it’s

We’re excited to see so many of you testing out the scripting block! We’re hoping lots of you will be open to sharing the scripts you write with the rest of the community, too. In that spirit, the platform team wanted to share a few best practices for open sourcing a script: Include comments to explain what each part of your script does so others can understand and adjust for their own bases. Give any variables or functions descriptive names to make your script easier to read and understand. When posting code on the forum, use triple-backticks before and after your code to enable code formatting and coloring: Use input.tableAsync , input.viewAsync , input.fieldAsync and input.recordAsync to avoid references to specific fields or tables that might be different for other users. If you do reference specific fields or tables directly in your script, we recommend pulling them out into variables and moving them to the top of the script so others can change them to match their own bases.

Hey everyone, we at krautreporter are integrating the Airtable API to send some data for further manual processing to Airtable. I wonder how I as a developer can be notified about any planned changes to the Airtable API. As of today the API is AFAIU not versioned. So are you guys at Airtable planning to never remove anything or change any existing behaviour or what are the midterm plans on this topic? Sincerely Gregory

Hi all, I have played a bit with the Scripting block and I am amazed at its potential! Though I am stuck following a recent idea to enhance our base capability. We are managing real estate opportunities and we’d like to create a tool that matches all our client needs with our land portfolio characteristics. Let me explain, I have a table for owners’ requests (CANDIDATES) and another for land characteristics (LAND). I have several other tables with the characteristics by type (identical to the owners’ requests) to identify possible matches between the two. In my CANDIDATES table, I can look up all the LAND for each characteristic in different fields. Now what I’d like is to produce a report or table identifying the unique lands which have all the characteristics of the owners’ requests and that for each Candidate. Any ideas? Thanks a lot Ludovic

There are more fields being returned than in my View through the API. Any suggestions on what could be the issue? Regards, Ruchika

Hi community! We’re so tremendously thrilled to announce that our scripting block has officially launched! With scripting block, you can edit, write, and run short scripts that allow you to enhance and extend your workflows—all within Airtable. In practice, that means you can reduce time spent on repetitive tasks and uncover deeper insights with advanced queries and custom reporting. You can call on external APIs to enrich your records. You can generate new records with the click of a button! There’s tons of use cases, so we’ve put together a showcase of examples written by both our team and the community to help spark inspiration. But in this post, we really want to celebrate the incredible members of our community who put the scripting block through its paces during the beta period. Without feedback and support from @Bill.French, @Openside, @JonathanBowen, @Ronen_Babayoff, @Jeremy_Oglesby, @Russell_Bishop1, @Julian_Kirkness, @Matthew_Thomas, @Martin_Kopischke, @BobBannanas, @Bruce_H

I’ve been playing with the scripting block a little and it’s definitely a major step in the right direction - well done! However, my first thought after running Hello World was how do I trigger a particular script from an event (say updating of a particular field in a table)? Also thinking about how to run scripts periodically - say a daily update or alert process? Having said that I am of a mind to write a blog post about it - is that allowed on a beta feature?

Hi everyone, just wanted to post a quick thank you note for everyone that participated in the beta and provided feedback that helped make the block better! We’ve just turned on the block for everyone. Check out our post on ProductHunt: https://www.producthunt.com/posts/airtable-scripting-block We highlighted some of the amazing scripts you’ve all shared on the forums :slightly_smiling_face: cc @openside @Bill.French @Jeremy_Oglesby Thank you!

Hi, I’m using Filter By Formula to find records based on Last Modified Date; As per Codepen Airtable URL encoder I get the following syntax; (IS_AFTER(%7BLast+Modified+Date%7D%2C+%222%2F23%2F2020%22)+%3E%3D+0) While syntactically this works fine, the results I get are not correct. I get dates before the given date too. Any suggestions? Regards, Ruchika

Hi, When I access a table-view through an API, fields that don’t have any values are not returned for that record in the API. Is this expected behavior? Regards, Ruchika

Hi Airtable Community! We just wrapped up our first challenge (stay tuned for the winners!) and can’t wait to see what you do with the next! For today’s challenge, we’d love to see how scripting block can help make one of our templates even better. From podcast editorial calendar management to home remodeling to Esports tournament planning, there are hundreds of templates in our gallery, and we have a hunch that at least a few of them could be even more powerful with a script! Things will work the same as last time: Choose a template from our template gallery and create a script for it! Bonus points if your script uses one of the new input methods we introduced today. (Need a refresher on what those do? See this post.) You’ll need access to the scripting block beta to participate. You can request access here (The scripting block is now available!) (if you haven’t already). If you don’t want to create your own script but have a great idea, reply to this thread and post it as a request.

I have a patch operation for ~4000 rows of data that enriches airtable data with data from an external source. I minority of rows (233) are raising a 422 permission denied error. The actual error message is: {“error”:{“type”:“INVALID_PERMISSIONS”,“message”:“You are not permitted to perform this operation”}} When I look at the payload of the patch, I don’t see anything exceptional or strange compared to the rows that patch successfully. So I examine the airtable rows that are being patched, and don’t see anything exceptional there either when comparing the success vs failure rows. Does this ring a bell with anyone else? Anything I should look for to fix the bug? I’m out of ideas.

Even the initial template of the hello world isn’t working for me now. The input field displays, but it doesn’t return after hitting ‘Next’, the await input.textAsync() doesn’t ever return.

Hello! A very belated happy new year, and thank you for participating in the custom blocks beta! We’re excited to share the newest updates to the SDK, CLI and documentation. One thing before we dive in: we’re looking to feature YOU when we announce custom blocks to the world. As one of our early custom block developers, we’d love to extend an opportunity to highlight a block you built. Please fill out this form by March 9 to be considered. All selected block developers will receive $1,000 worth of Airtable credits! Blocks SDK updates :mouse: We’ve updated Cursor with several new features: the ability to set the current table and view with setActiveTable() and setActiveView() , and the ability to watch and read the currently selected field ids with selectedFieldIds . We’ve also made a convenience update to our record hooks ( useRecords , useRecordIds , useRecordById ): they can now accept a Table , View , or QueryResult as previously supported. We’ve updated the YouTube

Doing some simple substring removal and getting different results from the block than in JS Bin. let renderName = "MX_Topo-Chico-Agua_Mineral-Water_600ml_PET_6x"; let secondaryQuantity = "6x"; // scripting block generates an UNEXPECTED output: "MXTopo-Chico-Agua_Mineral-Water_600ml_PET" output.text( removeSubString(renderName,secondaryQuantity) ); // JS Bin, however, outputs as EXPECTED: "MX_Topo-Chico-Agua_Mineral-Water_600ml_PET_" // console.log( removeSubString(renderName,secondaryQuantity) ); function removeSubString(str,substr) { return str.replace(substr,""); } Oddly, making use of a character (rather than “”) yields proper results. renderName.replace(secondaryQuantity,"1") => "MX_Topo-Chico-Agua_Mineral-Water_600ml_PET_1"

If everyone used a similar schema for base/table schemas, it might help with tool integrations in the future. Here is my initial take: Script: Meta Definition Show and tell Something very often requested is the ability to extract the meta information of a base/table to be used for external use. Now, with the new scripting block, that information can be extracted and shared outside. Simply copy this code into a scripting block and run it. If you wish to publish to a 3rd party endpoint, simply modify the codebase. Full documentation provided inside the code.

Hello Airtable Community! We’re inspired by the example scripts you’ve started to build in the scripting beta, and we’d love to see more of them! To that end, we’ll be hosting a series of challenges over the course of the beta - with fun prizes ready for the creators of the best scripts :tada: First up: Script Remix Challenge. Remix one of our sample scripts to share with the community, submit it, and we’ll highlight and reward the best of the bunch. You may have noticed that we provide a few examples directly in the scripting block. They’re a great starting place- but we know you can use them as a foundation to create something even cooler. Maybe it’s applying the basic concept to a specific use case! Maybe it’s adding more features or functionality! Interpret ‘remix’ as creatively as you like Here’s what you need to know: Create a base with your custom remixed script in the scripting block (beta) and post in here in the community forum for consideration! We recommend publishing th

Since the script doesn’t support a {cast:true} feature, I had to create my own function. I figure this is a pretty common use case so easier for all to use similar formula: gist.github.com https://gist.github.com/on2air/97ee258d88490daa31af55940867b385 On2Air: Common Functions /***** * Title: Common Functions for Scripting * License: MIT * Author: Openside (Team behind On2Air products and BuiltOnAir community) * Sites: * https://openside.com - Openside Consulting Services * https://openside.com/#products - On2Air Products * https://builtonair.com - All things Airtable Community * * Reach out for all your Airtable needs This file has been truncated. show original Also, a function to retrieve the collaboratorID based on an email.

Hi, I’m just getting started with the scripting block, trying a few examples out. When I hit the “copy” button on an example and try to paste the code into the editor window, I can’t find the expected “paste” menu. CNTRL V works, however. I’m using Chrome on Windows 10.

AirTable team: I’m not finding enough info in the documentation to know quite how to link records. I have a Contacts table and an Organisations table in my base. I want to find an organisation and link the a contact to it. I’m guessing the way to do this is to firstly find the record ID of the organisation (through iterating through the result of myOrganisationsTable.selectRecordsAsync() ) and use this to set the corresponding field in my contacts table? Do I need to do the same thing the other way round too - so add the contact ID to the Contacts field in my Organisations table? Some code examples along these lines would be good…