Development & APIs

Hi team! I’m looking to schedule automated tweets and found this: Can I set up a script to run on a schedule using Automations? At the moment, there isn’t a built-in way to set up a script that runs on a regular time-based schedule (e.g. every day at 9am). A workaround is to use a time-based filter on a view. I’m wondering if anyone could please explain what a time-based filter means and how to use it?

Just had a quick question on something I have seen pop up any time I try to create a prototype functions. Any time I do so, the new function will be underlined in red and any time the function is called, it will be underlined but the script still seems to function as expected, with the function working as well. Here’s an example: Hovering the mouse over the error gives the message “Property ‘addDays’ does not exist on type ‘Date’”. I’m not too concerned about this since it appears that everything still works but it would be nice to know why this is happening, whether this is an Airtable Scripting App issue. It would ease my mind a bit to not see this every time I try to call a prototype function. Thanks for the help!

I have a “Single Select” field whereby its options are updated through the API. Is this possible?

Hi, I’m trying to build an app based on the To-do list tutorial (Airtable Blocks SDK) for the Blocks SDK. Whenever I try to show a value with record.getCellValueAsString(‘someFieldId’) I get the following error: Error: Cell values for field fldQYB8sxPz3dvhwH are not loaded spawnErrorWithOriginOmittedFromStackTrace@https://localhost:9000/__runFrame/bundle.js:619:13 invariant@https://localhost:9000/__runFrame/bundle.js:661:11 getCellValueAsString@https://localhost:9000/__runFrame/bundle.js:6185:34 Booking@https://localhost:9000/__runFrame/bundle.js:162:91 renderWithHooks@https://localhost:9000/__runFrame/bundle.js:62042:27 mountIndeterminateComponent@https://localhost:9000/__runFrame/bundle.js:64576:13 beginWork$1@https://localhost:9000/__runFrame/bundle.js:65944:16 callCallback@https://localhost:9000/__runFrame/bundle.js:46118:14 x.wra

Hello scripting experts I’m busy moving a script for scoring tests (currently built in Python) into Airtable. The answers are being submitted to Airtable fields via a form. It would be easy enough to do in an Excel-type formula ( i.e. if(answer1=“X”,1,0) +if(answer2=“Y”,1,0), but I know there are more challenges to come so I am hoping to upskill a little bit in JavaScript (I would not consider myself a coder, I dabbled a little bit in Python about 5 years ago but that’s about it). I instead want to pull the values that are being submitted in the table into an array, and check them against an answer key. (I want to do this in the same table) Taking the first block of 7 questions, I feel like the answer might look something like this, but missing a few (big) pieces //I've created a field to receive the test scores. let table = base.getTable("Test Input"); let targetfield = "Test Scores"; var score1 = 0 let submitted_answers = [ //this is

Hi The number of scripts are increasing. I notice it becomes more difficult to keep all scripts up to date. For example, I have some created some classes to easily work with the data in our records. But everything I want to change something in that class, I need to do it in many scripts. Isn’t there a place where user defined classes and functions can be stored? That would be very helpful. KR Ashgard

I am just getting started with custom apps and struggling to get breakpoints set in VS Code to work with even the Hello World example app. I guess I am not really sure what is running where. I see that in order to run my custom app the build run command is observing my code and running a local web server at localhost:9000 which Airtable is then using to get a copy of my app. Then the app is run in my browser by Airtable. Is there any way for me to set breakpoints in my source code, like I do when developing other React apps, so that when my browser hits those breakpoints I can see the debugging information in VS Code? If anyone has this working, please share your configuration, in particular your launch.json setup in VS Code. Thanks!

Our team uses Airtable to keep track of customer orders, and we’d like an automation that sends an email to the customer when our Airtable users make record edits that trigger certain events to happen (order placed, order confirmed, order out for delivery, order delivered, etc.). We want our emails to be HTML-formatted, so instaed of Airtable Automations, we are still using Zapier or Integromat, which trigger when the an order record enters a certain View. We are thus concerned about the Airtable API rate limit (5 requests per second) because we want to avoid a 429 error at all costs. Our questions are: Do services like Zapier and Integromat throttle Airtable API requests by default? If we were to say bulk-approve 100 or so orders on Airtable, will these services naturally throttle the emails to fit Airtable’s API rate limits as long as we are still within the Zap/Operation limits of Zapier/Integromat? In the API documentation, the API team

HI there - I am wanting to Have a script button in my form and/or Run a script once submitting and send a user to a dashboard with their results. Any suggestions on how to do this?

I am pretty versed in the “Modified Time” field type, and its options to watch certain fields, automation triggers set to watch certain fields, and I use filterByFormula with IS_AFTER({Modified}, “2020-12-18 9:00 AM”), etc to return recently modified records in my API applications. So I know how to retrieve whole records with at least one field that has been modified. But what I can’t figure out is if there is a way, in a scripting app or automation script block, to select only the fields from a record that have been modified since a certain date/time, for example to then PATCH just those fields through to another service… The only way I can think of to automate this is to literally make a separate automation watching each field separately and patch them one at a time… I don’t want to do this for several reasons. Rather not PUT the whole thing if I don’t have to. Any ideas? Thanks.

Hi, I’m using block sdk to build a custom app. But I meet an error after I install an es6 modules( @antv/x6 ) Bundle Error: 'import' and 'export' may appear only with 'sourceType: module' I tried to add a .babelrc file to add prset-env but don’t work. what should i do to solve this problem?

Hi there, I’ve made a custom app which is released and working great. The only problem is that when I filter the data in the view, it doesn’t always update the chart - I have to go to the App and click “Reload App”. This is how I’m getting the data: const base = useBase(); const table = base.getTableByName(‘securities’); const view = table.getViewByName(‘Home’); const queryResult = view.selectRecords(); const records = useRecords(queryResult); const viewport = useViewport();

Hello everyone, Sometimes I feel the need to print my Airtable table records physically on paper (A4, A5 or even A6), while controlling every formatting and styling aspect (i.e; multiple records on 1 page, formatted as a table X by Y, or a list, controlling the font attributes, the border attributes, rounded corners, background colours,…). Printing possibilities by default in Airtable are a little to basic. I’m on the Airtable free plan, but even the Page Designer App won’t stretch that far, I guess… So I think the only way to get it exactly as I want is, is to go through the API, extract the records I need and position them and style them. But how do I start with the API ? Which tools do I really need ? I read something about airtable.js and also node.js and npm…all very new to me. I’m not afraid to dive in new technology, but I need a starting point. My data in Airtable is mainly personal inventory, like movies, books, games,… There is no need to build a public

I’m trying to send data to Zapier’s webhook but it doesn’t seem to go through every single time. I’m a coding newbie, is there some sort of naive mistake I’m making below? let result = new XMLHttpRequest(); let webhookURL = "https://hooks.zapier.com/hooks/catch/XXXXXX/YYYYY/"; let data = { "id" : record.id, "Format" : {name: record.getCellValueAsString("Format")} }; await result.open("POST", webhookURL, true); await result.setRequestHeader('Content-type','application/x-www-form-urlencoded'); await result.send(JSON.stringify(data)); I’ve noticed that it seems to make a difference if I have this command near the top of my script vs near the bottom.

We’re using both Airtable Apps (Blocks) as well as the Airtable API. Is there any way to get the user API key from a block? That way we avoid forcing the user to look for their API key and paste it into our app. I’m hoping for something like this: import {session} from '@airtable/blocks'; if (session.currentUser !== null) { console.log("The current user's API key is", session.currentUser.apiKey); }

Hey folks, Fairly new to Airtable and javascript ( my background is database languages ). I’m trying to modify the Mark Duplicate script that is an example. I’m using it as part of an automation from a google sheet. Rather than marking the duplicates I’d like to increment a counter by one on the “master” record already in the base Take some of the data from a field called “Notes” on the new record and add it to the “Notes” field on the “master” record Then ignore the new record as it’s not required. If anyone can give me any pointers that would help me better get to grips with the syntax it would be massively appreciated. Thanks!

I’m not an experienced coder, but I’ve written enough VBA & Python to have a degree of comfort with Java Script and write some basic routines. That said, my greatest degree of confusion here is referencing specific fields, records, cells, tables, etc. While loading the bases seems straightforward & part of every example script, documentation seems to drop off from there. Did I miss something? Can someone point me to a cheat-sheet with more examples like: .record.getCellValueAsString .getCellValueAsString The examples provided, “Loading records, Currency converter, Running total, Mark duplicate, Summarize linked records” are helpful, but more of these would be better. The user forum examples are a little scattered and specific. Probably, like most people using Airtable, my scripting issues are pretty basic. For example, one of the things I’m trying to do is just search a column for the highest value and enter the next highest value in the same c

Hey ! I’m wondering if it’s possible to: Duplicate an existing base Invite an editor Everything through the API. Thanks

Is it possible to get all the bases for a user with the API key ? I’ve seen it in integromat i.e. but i don’t know if they have an special agreement because i cannot find this information. Thanks

Hi all! I have a Javascript integration question I apologize if this is basic, I am quite new here. I have created a Discord bot that is storing game win rate stats using an Airtable base. Each user on Discord has a unique ID which I am storing in the first column of the table. I have a function on my bot that allows users to add themselves to the base by creating an entry with their Discord ID and with their number of games played and won. I don’t want to have two records for the same user, however, so I want to add a logical check that searches my base to see if there is already a record wherein the discordID column matches the ID of the user attempting to be added to the base. Basically, if my discordID is 222, I want to search my base for entries where the discordID is 222, and if more than 0 appear then I want to NOT add myself, but if 0 results are returned then I DO want to add myself. I have tried doing this below, but it doesn’t seem to be working as ex

Is it possible to update the lookup filed on a linked table via the API? I have a projects table. An a people table. O the projects table I have a lookup field that grabs the first name from the people table. Using the API, would I be able to change the name by simply updating the lookup field on the projects table? Thank you!

I’ve noticed that when using .loadCSSFromString() the frontend renders multiple duplicates of the same <style>/<style> element in the DOM body. Is there a way around this that I’m missing? In the example below, .loadCSSFromString() is placed at top-level and not within a loop.

Maryland Center for Computing Education (MCCE) strives to increase access, equity, and computing education efficiency. Our approach builds upon the progress of CS4ALL. We have implemented an AirTable-based lesson repository as a resource for elementary school teachers to implement computer science instruction in their classrooms. We are looking for a developer to partner with us to upgrade this system. This work will entail API development work to extend the functionality of the system. If you are interested, reply to the post to share with us how to contact you, and we will send specifications for you to consider.

Hello there, We are actually using Airtable for real estate reporting. Actually we are sending raw reports from airtable to our clients. The design and ergonomics are really poor for a common user so we looked for other solutions. I didn’t found any interesting application to connect with zapier for now but I finally discovered page designer. Page designer allowed me to reorganize datas but it’s hard to make something really clean with it. I also have a big problem with page designer because it’s not dynamic. I mean, we have many datas and their size can change and some of them can be filled or not depending of the report. Our needs also includes photos (the number can vary) and clickage links. So, using airtable can leave me with blank space of different size which is not really clean for our clients… Can you suggest me a solution that could solve our problems and which is free or not too expensive ? Thanks for your a

Hi Guys, I’m trying to find a way to see live data in my web application/mobile hybrid application, is there a way to do this? I don’t see any information regarding live data in the docs. What I want to implement is that when a new record is added or updated in airtable, the web app somehow detects the change in the airtable data and update the view. I saw that we can use airtable.js and airtable.browser.js if you’re using it in the browser, but what are the differences? cannot find anything related to airtable.browser.js, anyway, going back to the main problem, is there a way to display the data as live as possible?