Development & APIs

I have a multi-select field with 10 options I have a single select with the same 10 options I want to run a script to take the value in single select and update the multi-select with it. For example, if the values in a record before running the script are: Multi-select: Apple, Bat Single-Select: Car After the script executes, I would like to see this: Multi-select: Apple, Bat, Car Single-Select: Thanks in advance!

I am trying to use Outseta authentication with my custom airtable app. I need to have the outseta tags at the top of my code and then a button with a specific link on it to trigger their auth-modal. Is this possible? The best I have been able to get so far is a new tab opening :slightly_smiling_face: Thanks for the help!

Blacklight detected an AirTable third-party cookie on my site? I would rather not “serve these up” to my end-users. Is there currently a way to disable these using embed code, and if not could you please develop it. Browsers are phasing out third-party cookies anyway, and it’s not a good look for AirTable long-term. edit: this post was marked as spam for some reason. Not sure if just I tried to post a reply containing the url

If my app is utilising a third part API I need a way to authenticate the user inside of airtable rather than storing the key in the global config. Has anyone seen a good guide on how to do this with firebase or something else? I would love some more information / pointing in the right direction. Thanks!

I’m looking for ways to customize the gallery view of an airtable base on my wordpress site. I like the mini extensions plugin but the $39/month price tag is out of my budget. Are there other ways to customize and embed gallery views on a website? Thanks!

Hi, I have a ‘Communiques’ table that lists the interaction I have with clients. I have just setup a Zapier that adds a new row to the Communiques table when a client emails me. What I would like to do is add an email column to the Communiques table - then have a script that takes the email and looks in my Contacts table to find an email that matches from the email column in Contacts - and then adds that Contact to the ‘Contact’ link column in the Communiques table. If anyone could give any input or let me know which functions I should look for and start with would be much appreciate.d Thanks!

Hi there - When I run this code, I am getting extra commas and the values are not lining up. What am I doing wrong? let vowels = “aeiou” let sentence = “Your bumpkin is so beautiful” let mda= let fullsetofzeros = var i var j for (i = 0; i < vowel.length; i++) { // p1 mda[i] = 0 } for (i= 0; i < sentence.length; i++) { // p1 fullsetofzeros.push(mda) } output.text( Matrix of zeroes ${fullsetofzeros} ) for (i= 0; i < vowel.length; i++) { // p1 for (j= 0; j < sentence.length; j++) { // p1 if (vowel.includes(sentence[j])) { fullsetofzeros[i][j]= 1 } } } output.text( Matrix after test ${fullsetofzeros} )

Hi there - When I run this code, I am getting extra commas and the values are not lining up. What am I doing wrong? let vowels = “aeiou” let sentence = “Your ass is so beautiful” let mda= let fullsetofzeros = var i var j for (i = 0; i < vowel.length; i++) { // p1 mda[i] = 0 } for (i= 0; i < sentence.length; i++) { // p1 fullsetofzeros.push(mda) } output.text(Matrix of zeroes ${fullsetofzeros}) for (i= 0; i < vowel.length; i++) { // p1 for (j= 0; j < sentence.length; j++) { // p1 if (vowel.includes(sentence[j])) { fullsetofzeros[i][j]= 1 } } } output.text(Matrix after test ${fullsetofzeros}) When updating my array, something strange happens

HI there - I am wanting to try to efficiently add various combos of multiple arrays to try to find a set that has non-zero elements. This is an abbreviated version. I have a set of ~300 arrays x 30 elements in each array to try to find a complete set of sets. let arr1 = [0, 1, 0, 1, 0, 1, 0, 0, 1, 0] let arr2 = [1, 0, 0, 1, 1, 1, 1, 0, 0, 1] let arr3 = [1, 1, 0, 1, 1, 1, 0, 0, 0, 0] let arr4 = [0, 1, 0, 0, 1, 1, 0, 1, 0, 0] Update: Assume that instead of individual arrays, there is one matrix and we are adding the combination of columns in matrices to find a matching set.

Hi, I just paid for the Pro Account on Airtable even though I was not finished with the 14 days trial period since signup. However, it still shows I am on Pro Trial and does not let me use the scripting blocks in the automations. This is a problem because it is a big blocker for my project. Hope someone can help. Thanks!

Hi all! I am not very good at JS, but I have to figure out a way to built a robust front end for an Airtable base and I have zero budget (I might as well start working on world peace while I’m at it). I have figured out how to retrieve and log (Logger.log) all the data in a particular table (believe it or not I can return all 3500+ records in a couple of seconds), but does anyone know how to display the data that is returned as raw JSON in the HTML page created when I deploy the google script as a web app? I guess it would be helpful if I explained the use case. I have a table, “PartNoInfo”, that is linked to a “Concentration” table. The “PartNoInfo” table contains the metadata and calculations. The “Concentration” table has the individual concentrations, as well as lookup data from the linked table “ComponentData”, which has the information required for the calculations in the “PartNoInfo” table. I am trying to set up an UI where the user can enter a part number and retrieve the “

Hi guys! I’m fairly new to AirTable, especially using it in a backend server. I have created relational databases in SQL before, and I have designed my database just like how I did with SQL. However, I do not know if AirTable has a JOIN command that can join two tables together in Node.JS so that I can look up data across different tables that intersect. If so, how do I do that on AirTable? So far I have created Persons, Students, Mentors, Addresses tables and I have not been able to query them and join them together. Thank you!

So, I’ve been trying to bulk add some fields to the table using the suggested code in the API: base('GameRefereeSlots').create([ { "fields": { "GameCreation": "49", "Fee": 10, "Expenses": 10, "Type": "Referee" } }, { "fields": { "GameCreation": "49", "Fee": 10, "Expenses": 10, "Type": "Referee" } } ], function(err, records) { if (err) { console.error(err); return; } records.forEach(function (record) { console.log(record.getId()); }); }); This, however, does not work as it returns the following error: message: “Invalid request: parameter validation failed. Check your request data.” statusCode: 422 I’ve tried different alternatives by removing the “field” key and just having the plain object but it does not work. When adding only one of the options without it being in an array, i.e not batch adding, it works perfectly. Any thoughts on what could be the problem?

Hey, was anyone able to use vis.js timeline (Vis Timeline Examples) in blocks? I have tried to make it work for a while but I cannot figure out how to render the timeline with the functional style of the blocks. How can I workaround the “build on a div element with a certain id” approach?

Hi I wanna script a (+1) button, somehow (like) button… to increase (or decrease) number in a filed For example, When I click this button, the filed X become (10) instead of (9) Thanks

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.wrap/e._wrapped@https://cdnjs.cloudflare.com/ajax/libs/rollbar.js/1.9.0/rollbar.nojson.min.js:1:13806 invokeGuardedCallbackDev@https://localhost:9000/__runFr

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 the array where I want to pull in the seven ans

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 recommends using a “caching proxy.” What

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.