Development & APIs

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

How can I get a custom block that I have $ block release'd back into a development state? Would I need to start a new custom block, point it at the same repo as a remote, and develop there?

I’m trying to implement a settings menu in my custom block. I have the settings component properly showing, and the settings inside working as I want. The only missing piece that I can’t figure out is how to trigger closing the menu from a Button component’s onClick() function, rather than having to click the settings icon again to close the menu. I have this in my main block component: const [isShowingSettings, setIsShowingSettings] = useState(false); useSettingsButton(function() { setIsShowingSettings(!isShowingSettings); }); I tried calling the useSettingsButton() function inside the onClick() lambda, but got this error: Error: Invalid hook call. Hooks can only be called inside of the body of a function component. This could happen for one of the following reason

Anyone have a link to the webinar recording from Feb 28? I signed up for it but wasn’t able to watch. I’ve tried contacting Airtable but haven’t heard anything back after a few messages.

We’re looking for a Developer Advocate to help grow our developer community worldwide. As our first Developer Advocate, you’ll be integral in crafting the developer engagement strategy and executing on the Airtable vision. You’ll support our developer community through scalable tutorials, speaking engagements, and platform experiences to unlock value for new and existing users. If you’re passionate about democratizing software and being involved with a developer community from day one, we’d love to hear from you. What you’ll do Inspire and educate developers of Airtable’s potential through building JavaScript applications and proactively reaching the intended audience Devise and execute on a strategic plan to grow our developer community Represent Airtable in the community forum and produce relevant one-to-many educational resources Identify product gaps and opportunities to better serve our developers. Synthesize the i

Is there a batch version of the updateRecordAsync function?

I have 2 tables, let’s say one is a variety of companies (alpha, bravo, etc) and their different talent areas (managment, engineering, hr, IT, etc) The next table is personnel which lists the company they work for, their talent area, and then contact info. I want to populate a column in the companies table which will have a linked record to those personnel who match based on company and talent for each row. If the syntax were Excel I’d be okay to figure this out using Match… but my Javascript experience is basically zero. Any help would be greatly appreciated!

Is there a sample code snippet to pass table records into a function? Do I also need to pass the table or field itself (because I need the field to get cell value, or the table to get the field, right?)

Hi, pls i need script for all task in the tasks table. if done the tasks (with Checkbox), then move from Project 1 to Archiv the Tasks. Pls Help. Airtable

Is there a read-only API key available, or this is this part of the “Granular Access” that is coming soon?

Hi everyone! This question touches on a lot of things outside of Airtable itself. Hoping someone here may have some insight. I’m using the new Scripting Block to call an HTTP endpoint I’ve built using AWS API Gateway. A script runs in AWS Lambda and returns some data as JSON back to the Scripting Block to continue the workflow. For extra context, it’s a Lambda Proxy Integration. I’m having trouble with CORS errors. I’m returning the CORS headers detailed here but still getting the error in Airtable. Here’s the section of JS in the blocks where the call is being made: // assemble the full URL from the record selection let url = aws_url + record.getCellValueAsString("Project Record ID"); let headers = { "Origin": "airtableblocks.com" } // make the API call let response = await fetch(url, { method: "GET", h

I’d like to create a customer facing form that allows them to attach a csv file (based on a template). Once the form is submitted, Airtable would add the csv records to an existing table within the base. open to other options if there are easier ways to do this. the key is to automate it as we are looking to ingest hundreds of csv files this way any help would be greatly appreciated

Finally! Full, Dynamic Links Show and tell I know many people have been waiting for a HYPERLINK() function. This is not that, but its as close as we can get today. Check out how this simple script can create links that are dynamic and formatted with