Development & APIs

I’m attempting to set up a raspberry Pi with an rc522 RFID reader to track physical items with RFID tags attached to them. The only problem is that node.js and rc522 - npm can only read the permanent RFID serial number at this time. Airtable API only allows the update function to find an existing entry by it’s record id. I can put the RFID serial number in a field for each item, but I am unaware of any way to query that field. So, I need to find a way to change the record ID to the permanent RFID serial number or update without the record id. What I want to write: var rc522 = require(“rc522”); var Airtable = require(‘airtable’); var base = new Airtable({apiKey: ‘my api key’}).base(‘my app id’); rc522(function(rfidSerialNumber){ console.log(rfidSerialNumber); base(‘base name’).replace(’(rfidSerialNumber)’,{ “field name”: “the thing that I’m changing”, }, {typecast: true}, function (err, record) { if (err) { console.error(err): return; } }) }); I know the (rfidSerialNumber) works with th

I’m trying to make a dynamic pivot table. I’ve made my groupings and I’m now playing around with how I can get this into a table format. I’m currently trying to create rows to push into my tables array. I’m trying to do for loop with with a map method inside, however I can’t figure out why my categories returns [undefined, undefined, undefined]? const table = base.getTable('report'); let tableArray = []; let queryResult = await table.selectRecordsAsync(); output.inspect(queryResult); //Row names let nameArray = [] for (let record of queryResult.records){ //nameArray.push(record.name) nameArray.push(record.getCellValue('Select Name')[0].name) }; const uniqueNames = [...new Set(nameArray)]; output.inspect(uniqueNames); //Coloumn names let itemsArray = [] for (let record of queryResult.records){ itemsArray.push(record.getCellValue('Working on')) } const uniqueItems = [...new Set(itemsArray)] output.inspect(uniqueItems); //Make Rows for(let i=0; i<uniqueNames.length; i++

I’ve made this very simple little setup where I can select a name, and find the records that matches the selection. I can access the ID of a linked recored via lookups, but is there a way to directly access the ID of the linked records from my ‘Select Name’? let viewStaff = tableContact.getView(tableContactView); let choosePerson = await input.recordAsync('Pick a person', viewStaff); let personID = choosePerson.id; //have to use Id's when using linked records output.inspect(personID) //loadReportRecords let reportQuery = await tableReport.selectRecordsAsync(); output.inspect(reportQuery) let reportRecordsForPerson = reportQuery.records.filter(record => { // Arrays in JavaScript have a method called some, which returns // true if at least one element in the array matches a condition return record.getCellValue(reportField).some(nameRecord => nameRecord.id === personID ); }); output.inspect(reportRecordsForPerson) reportRecordsForPerson.forEach(record =&

Store a list of images in Table1, each with a key (e.g. “cow”, “horse”, “chicken”). Then in Table2, write a string that specifies which images you want to assemble (“2 cows, 3 chickens”. Run the script to copy those images into Table2. I used this to make a “Piano Cheat Sheet”. I have an image for every piano key in an 2 octaves (a-g, twice) then I can write a melody (“aaccddc”) and the script shows what keys to hit to play the song. Note: I hardcoded the idea of having 5 sets of images, for my particular piano use case. But easy to drop this for a flat list of images. let keyTable = base.getTable("Keys"); let keyQuery = await keyTable.selectRecordsAsync(); let keyVisualizerLookup = {} for (let keyRecord of keyQuery.records) { let keyName = keyRecord.getCellValue("Key Name") let keyImage = keyRecord.getCellValue('Image')[0]; keyVisualizerLookup[keyName] = keyImage; } let table = base.getTable("Songs"); let query = await table.selectRecordsAsync(); for (let record of query.record

Hi all. I am working with a table that has a ‘Last Modified Time’ field. I am attempting to create a block script that when run deletes any records that table within 5 minutes of Last Modified Time field. I am new to scripting so any help is appreciated!

I’m training my JS muscle and have been playing around with the scripting block. I’ve extended the currency conversion example, however I can’t figure out have to get my output text aligned when they’re nested? Anyone who knows if I’m doing something wrong?

The new scripting block is fantastic, I’ve achieved something very quickly using only my rusty old JS knowledge. I want to display the output of my data as a table including images that are nicely sized/aligned with text in the same row. I can’t do this with the markdown output, partly because the markdown output does not seem to support markdown tables (or the whole table markdown must be built up first instead of output row by row?) Is there a way we can output HTML or a nicely formatted table where we can control size of images rendered from URLs? So far the only way I can get images from attachments to render is using output.markdown and 

Hi everyone, I’ve used the .update() function so that it updates the table in my Jupyter Notebook. But, when I look in the actual database on Airtable, I don’t see the updated value. from airtable import airtable airtable = airtable.Airtable(’(hidden for privacy)"’, “(hidden for privacy)”) at = airtable.get(‘Table Name’) at[“records”][3].update({“Week 1 HW Score” : 10})

I created a copy of a base with a functioning script block in it (by functioning I mean it works without throwing errors), to tinker with some updates to the script. But when I run the script in this “copy” of my base, I get an error that sounds a lot like the Script Block is either trying to access the original base ID, or else has an undefined base ID … on second look, it seems to be getting through the async queries at the beginning of the script, right?.. or else it wouldn’t even hit the output.markdown() before throwing the error… : Clearly, I don’t have any access to globalThis. @Stephen_Suen, @Kasra, @Shrey_Banga - able to weigh in on this?

Hey all, I am all new to API and I have been looking to connect the Bubble.is API connector to our AT db. Been struggling a bit and haven’t found any documentation helping out a beginner like myself. Thx in advance

# Shell: $ export AIRTABLE_API_KEY=YOUR_API_KEY Where should I put this? This is probably an obvious question, but I don’t know it. Thanks

Hey Y’all, So, I’d like to incorporate PTO into project planning - here’s how I’m thinking about it, but would love more ideas on how to make this most actionable. I have a table for projects that has a Start Date and an estimated duration for how long the project should take. To incorporate PTO, I can use the Workday function, which allows me to include a list of holidays formatted as a comma-separated string of ISO-formatted dates. To use the Workday function, I’ll need a list of every day that someone is off for PTO. In this example, I’m tracking PTO in a table with fields for Start and End dates. This is a great start, but I need every date in between - a perfect job for a script. The below script calculates each day a person is on PTO. The “Days Off” then roll up to the person, which is then rolled up to the Projects table when someone is assigned to a project and passed through the Workday function. Now we can calculate the End Date of a project based on the Start Date, Duration

I am a Airtable scripting newbie. I am using Chrome as a browser. When I click F12 I get the debugging tool. How do I locate the code so I can step through it and/or breakpoint. I can’t find any articles or videos on how to debug these scripts

In this tutorial - Airtable Blocks SDK there’s a link (https://airtable.com/shrKs6a2cQPEK5yzr) to copy this base for “Tasks”. But it says " The private share link you tried to reach is not available." Can somebody from Airtable please take a look?

Hi there, Newbie from the Netherlands here, At the far right of the records we have these small selection fields. Would it be possible to mark some of these records and then iterate through this selection in a Script Block? In other words: is this field accessible in Scripting Block? I would be gratefull to hear your reactions! Ronald Vonk

Hi there, I assume that custom blocks are the beginning of some kind of app store, similar to the one shopify has, where we will also be able to charge for our custom blocks. Question for airtable - do you guys plan on providing some kind of billing api, similar to the one shopify provides that will eliminate for us the hassle of dealing with billing for our custom blocks or should we create our own billing solutions? Thanks, Ronen

Hi folks, I’m trying to use the scripting blocks to modify a pivot table that was created per block. Unfortunately, when I try to access it via scripting block, I have no access to the data from the generated table. The goal would be to convert the generated data into percent, the normal way over the pivot block with “percent filled” does not work. How should I proceed, is there a way to save the generated pivot table as a view to get access to the data and modify them per script?

Hi, @Kasra @Shrey_Banga @Stephen_Suen Flowchart block Airtable - Support Flowchart block The flowchart block creates flowcharts from records in a chosen table. By setting up record dependencies—records that link to other records in the same table—the block will automatically build a fl... is definitely one of the most extraordinary blocks Airtable has ever released. I hope that Airtable will enrich it in priority over other Blocks to get a more varied appearance of the graphic elements and other suggestions that will come in the near future. It is in this context that I suggest you with the highest priority for me to make it possible to trigger Flowchart Block functions from Script Block ! use-cases from mine’s examples: after having prepared a table to flowchart by any future self-made script , firing Flowchart Block by script and then firing its SVG Export Menu. As @Bill.French wrote it, any script will not write anything to m

I’m not sure I understand what’s going on here: Before sharing code for debugging, I figured I’d check to see if anyone at @Airtable would be able to recognize the error and let me know if it’s an error in my code that needs to be debugged, or something else.

Hi everyone, happy Friday! At the risk of over-posting, I wanted to let you know about this scripting block challenge we’re running as part of Blocks Madness. The prize for this specific challenge is $1,000, and I thought our developer community would be particularly interested in participating. There will be more challenges + prizes throughout the rest of the month - including more scripting challenges - so I’d recommend checking out the Blocks Madness category regularly all throughout March. Have a great weekend, and good luck with the challenge! P.S. This is detailed in the linked post, but any submitted scripts will need to be brand new (e.g. not submitted to a previous contest) and submitted by Monday evening at 6pm PST.

Hi! As you might’ve seen, there are five new blocks in the gallery: base schema, flowchart, flashcard, name quiz, and URL preview. The special thing about these blocks is that they’re open source. We hope that they help you get started more quickly – feel free to use their code in your own blocks, or remix them to create your own versions! You can find the code for all our open source blocks here: Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free.

Hi everyone! We’re thrilled by all the enthusiasm for the scripting block so far, and are really excited to see what you’ve all been building! To that end, we’re going to have one more scripting block contest (for now :winking_face: ). Unlike our beta contests, which were a little more focused, this one is totally open ended: submit your very best new script. Just one twist - this time, we’d love to see it in action with a short walkthrough screen recording (we recommend free tools like loom, but there are plenty out there to choose from.) Similar details to last time: Create a new thread with your script and video walkthrough, and post the link as a reply here by 5:00PM (PST) on Monday to be considered. Everyone who enters will get something for participating, and the winner will walk away with a $250 Amazon gift card and some fun Airtable swag. Follow best practices for open sourcing a script as much as possible, including: Include comments to explain what each part of your s

I’ve created a custom zapier integration. I want to be able to display dynamic dropdowns for users when they are selecting a base and table as shown here: However I can’t seem to find an endpoint from the API that would allow me to do so. I wanted to contact support, but there doesn’t seem to be a way to do so. Any ideas? Thanks!

I’ve been trying to play around with the scripting base. I’m very green in JS - so green that I just made it out of the codecademy foundations. I’m trying to make something very basic. I want my script to copy value in Field A if there is no value in Field B. I’ve been banging my head against the wall for a few hours while trying to find help in the examples. But can’t get anything to work. Wondering if there is someone in here that can check my script and point me in the right direction? let table = base.getTable("Test table"); let fromField = table.getField("fromField"); let toField = table.getField("destinationField"); let result = await table.selectRecordsAsync(); for (let record of result.records) { let originalValue = record.getCellValue(fromField); //console.log(originalValue) if(record.getCellValue(toField)!==null){ table.updateRecordAsync(record, { fromField: originalValue, tofield: originalValue } }else{

Hi, I want to fetch yelp API just how I would fetch it in postman and save every contact in the excel sheet. does anyone have a youtube tutorial or step by step how to?