Development & APIs

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?

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 reasons: 1. You might have mismatching versions of React and the renderer (such as React DOM) 2. You might be breaking the Rules of Hooks 3. You might have more than one copy of React in the same app See https://fb.me/react-i

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 insights into clear and concise recommendations for our platform en