Development & APIs

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?

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 assig

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?