Development & APIs

I’m super excited to use the new input.fileAsync() API, but this is my first time working with file blobs in JavaScript, so I’m already scratching my head trying to figure out how to work with my file contents beyond the offerings of the API. Disclaimer - this question has little to do with Airtable and the Scripting Block API itself; it’s basically just a plain old JavaScript question. I already use the CSV import block to import bank statements to my budgeting base. However, my bank outputs 4 lines of identifier data before outputting the table of transactions – so I always have to manually open this CSV, remove those top 4 lines, save it, and then import it. I’ve been meaning to write a script to do this for me (was going to use ruby in MacOS), but Airtable’s new Scripting Block API is just in time to allow me to (hopefully) incorporate this into the import process! So, I’m bringing in my file with let fi

Can anyone guide me on using airtable as my rest API in a react app that is an admin dashboard. I need guidance on where to place the call to the API. For example do I need to set up one config file to call the API or do I list it separately by component. I want to add user identification with this so I am want to make sure it will be able to only show the user only the data associated with their record. Not just a list of data. This might not be possible. Thank you

Hi, I was trying to override the default onClick of the RecordCard component with a custom one that send me to the corresponding table. I didn’t see in the doc the way to prevent the default expending behaviour. But in the code there is the undocumented hasOnClick that seems to do the job. Can you update the doc with this ? Thanks

Hello, Let me preface this by saying I have close to no experience with coding and java script and only started experimenting with the scripting block in the past week or two. Thanks to some very talented people and previous forum posts, I was able to create (more like borrow and adapt) a script that links records in one table to another based on fields matching between the tables. This has been incredibly useful for me already in some other tables and bases. What I desire now is similar but slightly more nuanced, I believe. So here’s my (probably too lengthy) attempt at explaining this as clearly as possible: I have a table in a base with the purpose of capturing payments and invoices (named Account Summary) of a client. I have another table to generate statements for clients. These specific statements are normally generated twice a month and reach back two months in a clients history. I have a field in the Account Summary table that outputs a date and c

Hi, I’m looking for an easy way to have Airtable return the name of a linked record (instead of using the ID and doing a separate API call). Is there an Airtable formula that can get the name of a linked record as text? Thanks! -Donald

Hi everyone, If there are any Architects out there who love Airtable, you should check out Mallard, on the food4rhino website: food4rhino. com / app/ mallard It’s a Grasshopper3D plugin for connecting the Airtable API to a Rhino + Grasshopper3D document. We’re starting to use it at HDR with the Data-Driven Design team, and we’ve found that Buildings really do equal Data and having a fast powerful and easy to use RDBMS tool is a godsend. Thank you, Airtable developers, for an awesome tool, and please let me know if you’re interested in creating content or blog posts for the AEC industry which is in desperate need of tools like this.

I’m new to Airtable and setting up an order form for a local restaurant that is closed due to covid-19 but taking orders for delivery to help support the staff. They are taking orders for fresh bread, and would like to trigger a notification (via email or slack or whatever) to go to one person every 16 orders so that they know when to start a baking a batch. Is there a way to set this up on this platform? Any help is appreciated!

Hello, I consult and deal with a lot of companies who only use their acronyms… I am creating a light CRM, and would like to Input the org name into a field, and have a script that returns the acronym for the name in another field. I have found it very hard to do in Airtable without a Zapier integration, I wonder if the scripting block can help solve these problems. Any help and code would be greatly appreciated!! Thank you.

I am building a recipe / food related app for a client. I need a recipe record to point to the ingredient records it depends on, but it also needs to have a mapping of measurements to ingredients. I think I capture the essence of what I am trying to accomplish adequately in this JSON: i.imgurDOTcom/42UZhlj.png { id: 'bowl-of-cereal', name: 'Bowl of Cereal', ingredients: [ // links to records in the Ingredients table. 'milk', 'cereal' ], measurements: { { quantity: 6, measurement: 'cups', ingredient: 'cereal', note: '(not stale)' }, { quantity: 16, measurement: 'ounces', ingredient: 'milk', note: '(whole or skim)' } }, directions: [ /* ... */ ] // etc... } I believe what I need to do is create a table for measurements with this^ measurement structure enforced. Is this correct or is there an alternative?

New to Airtable, somewhat experience in WOCODE, a content management system, I have successfully created dynamic pages in WOCODE using google sheets, but I’m leery of the long-term reliability as the data grows The feature set of Airtable leaves me thinking without a doubt, it’s the better choice. MY DILEMMA: When integrating Airtable with WOCODE, there are 2 initial requirements to put in place. WOCODE has two setup placeholders, where you enter: API key & Authentication URL Once I complete this, the AIRTABLE db structure populates into WOCODE, just like it had with Google Sheets I follow the same steps to retrieve fields as I did with Google Sheets. All looks well, but then NOTHING. No data appears, and it literally suppresses my field, to the place where it vanishes off the page. Again, this exact same step renders data from a Google Sheet. The only variable here is I’m using Airtable. Any ideas on why my resu

Hey Y’all, Sometimes I plan thing out way far is advance, like say 9 months out from a pretty important launch date - like my best friend’s wedding! (So excited for her :bride_with_veil:t5: , but I digress.) There are certain dates that I want to estimate, but as I get closer to the date want to visualize and edit further on Airtable’s Calendar View or Gantt Chart. The Calendar View and Gantt Charts Block only accept date fields, or formula fields that calculate dates. However, I still want to retain the ability to move these dates around on the calendar/Gantt if something comes up. So, how do I do this? First I want to structure my table correctly, so that I can actually calculate my fuzzy date. My friend’s wedding is on October 11th, so I’ll plan back from that. What I’ve done in the below example is create two tables Projects and Tasks. In the Projects table, I’ve added my friend’s wedding date as the launch date, and am looking up that date as the launch da

Can we have a rich text editor component? It will be super useful! Pleeaaase :pray:

Hey, Noticed that in the latest block sdk version you export useSynced (great feature). There is no documentation for it in the docs. Cheers, Ronen Babayoff Superblocks.at

Hi, I am using Airtable API in my trading software (metatrader 4) to read values and settings. I also need to update fields but metatrader 4 language (mql4) does not support PUT or PATCH request method which is needed to update, only GET and POST methods are supported. What can i do?

Is there any way to copy records to another table using the API, other than retrieving and creating new records?

Hey Guys, First off, I’m really excited about this block :slightly_smiling_face: To get quickly up to speed and start using it, I’d love to be able to read the documentation in full screen, either on a separate website, or within the Airtable app. Is there an external link you guys can share to the documentation? I would also like to: Control the size of the documentation panel. Allowing me the option of displaying it side by side to the script code, instead of below, so it is bigger when developing. Cheers, Ronen Babayoff Superblocks.at

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’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); //M

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) repo

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 = key

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?