Development & APIs

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?

Hi, @Kasra @Shrey_Banga @Stephen_Suen Flowchart block Airtable - Support Flowchart block The flowchart block creates flowcharts from records in a chosen t

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 previ

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

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

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,

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?

As many would of done, I got the email today regarding scripting. I cant do the webinar due to it being 6am on a Saturday here in Australia but before I spend to much time researching this can scripts work off a submitted form to automatically create links to other tabs? We currently have this as manual process on our Real Estate base where a form is submitted with property details etc. We then have to manually copy the property address and put in in upto 2 new columns depending on a status column. This allows the linking and lookups created to work on other tabs. If not, thats fine, just thought I would ask because this would help us immensely in automating stuff!

Hi Airtable! I thought I would repost this again, since filters did not do the job. Maybe a script might work? I am not sure if this will cost something. I am trying to filter, only records that has one or more fields that are empty. I have created a share link to a copy of the database, if anyone wants to take a look. (https://airtable.com/shrIVQ1d9ckYOpEuV) COPY 1 CSV FACE VALUE 1. GENERAL STAMPS CE1 TO 1708aii GOOD 1 copy copy -… Explore the “COPY 1 CSV FACE VALUE 1. GENERAL STAMPS CE1 TO 1708aii GOOD 1 copy copy” base on Airtable Thank you, Mary Kay

JAVASCRIPT / NODEJS How could I find out how many records there are in a table? recordsMax = base('Table 1').size() Something like that, but it actually works. Thanks.

I’m looking for someone who works with both Airtable and Joomla. I need to set up feeds/processes between the two. If you have those abilities or know someone who does, I’d appreciate the referral.

Attempting to test the sample Project design tasks block - get the following. Any ideas why? The field is a string Error: Can’t create records: invalid cell value for field ‘Design project’. Cell value has invalid format: must be a string at Mutations._assertMutationIsValid

Hi All, Apologies for the lack of scripting ability. I’m hoping to get started if someone can point me in the right direction. I have 2 tables TableA has records in with following ID, Rate TableB has the same ID, Rate I want to build a script that, when run, prompts the user for the ID from TableA and then updates all records (multiple records for ID in TableB) in TableB with the value set on TableID for that ID Hope this makes sense. Regards

Hey there, Putting in a feature request - would be nice to have both an Input and a text area component with functionality similar to the one found in formula fields, after entering {. Cheers, Ronen Babayoff Superblocks.at