Development & APIs

Here is an example table that I have in airtable. For a month parameter of 6, I am trying to obtain the corresponding Median value i.e. 65.7, can someone please guide me on how I can I obtain this i.e. just by providing Month parameter obtain the Median value using the Airtable API. Many thanks.

Hi everyone ! I have an issue with Airtable sending email via zapier … In my case, I receive a question from a form, with users informations, and I would like to respond to it in writing the answer directly in Airtable rich text formating cells. I send the response by HTML email with Mailjet, but the issue is that the rich text format is not recognize… I tried in transforming the cell in code, but still doesn’t work … The only solution I found, is to directly put the code I want in the cell response, but it’s quite tricky … I also heard about the sendgrid block, but I don’t if it can automate response (when a new record in a view -> send the response email), and it’s not optimal, having many emailing solutions … I take any ideas, thankssss !!!

Hi Just wondering if anyone has an integration for the add table action trigger? I’m using Integromat and that platform doesn’t offer ‘add table’ as a trigger. Airtable’s own Slack notification doesn’t appear to notify of new table actions. Thanks!

Hi, I need to automate the copy paste action from one field to another filed on same record for a specific view. If the Pasting location is empty, then only I need to do this action. Hope someone out there will be able to help :slightly_smiling_face: Cheers!

Been using Aritable for 6 months, I don’t know the basics of scripting where should I start?

I’d like to write a script for the scripting block that includes instructions on first-time usage. Folks won’t need to be reminded of this every time they run the script, so rendering it constantly is not ideal. I’ve experimented with using the input.buttonsAsync method without awaiting the returned promise. My thinking was that by registering a resolution handler via .then, I could append help text at any time during the script’s execution. Unfortunately, this causes a progress indicator to be overlaid on the scripting block’s interface indefinitely. If that indicator were not displayed, then my use case would be satisfied. Alternatively, the HTML <details> element could be used for this purpose. That element produces a UI for toggling the visibility of content in a way that is familiar to web developers and web users. The output.markdown currently escapes all markup, but if it could be made to allow the

I just tried following the Hello world tutorial from Airtable Blocks SDK, but I wasn’t able to go through all of it successfully. When I invoke the block run command, I get the following error: Error: ❌ error:140AB18F:SSL routines:SSL_CTX_use_certificate:ee key too small It is possible to lower the default security level, but that does not seem wise. Basically, in /etc/ssl/openssl.cnf, changing from: CipherString = DEFAULT@SECLEVEL=2 to: CipherString = DEFAULT@SECLEVEL=1 makes the command work. I am running Crostini (Linux (Debian Buster) within ChromeOS), with openssl version 1.1.1d-0+deb10u3 in case that matters. The full system default section in /etc/ssl/openssl.cnf looks like:

Hi everyone! I have made a base and a form view for the base. I have set it up so when someone fills out the form, I receive a notification on a slack channel. The answers from that form then enter into grid view and one of the columns says Approval and when a supervisor approves it, then it would send the information and that it was approved to the same slack channel. For some reason this no longer happens. Help?

Some scripts require sensitive input such as HTTP API access tokens. Depending on how the base is shared, it may not be appropriate to store this input in the scripts themselves. In these cases, it may be preferable to prompt the user with each execution. Currently, the input.text function renders a generic HTML text input. For situations like these, it would be nice to present a password input. This would help protect users from shoulder surfing.

As far as I know, we can link to another record to connect with another table, but that would be less enough when we want more detailed data or automated them. For example, I recorded the names for each house, then in another table, I want to list the house names for each person. I cannot just display the names but select them one by one, which is of low efficiency. Is there an API to update it though Python?

I have a simple grid view data like that: and I want to filter my data by company’s uniqueness and get an array which includes list of companies by unique like ['Google', 'Facebook', 'Apple'] read Formula Field Reference but couldn’t find. I can fetch entire data and make filtering on client side but instead of getting entire data, I want to pull only array of companies. By code below so far. Thank you const RES = await db('users').select({ view: 'Grid view', filterByFormula: 'some filter should be happen at there', }).all() console.log(RES) // should return ['Google', 'Facebook', 'Apple']

Hello! I have a question about ETag usage. I make a curl request like this: curl -H 'Authorization: Bearer <My token>' https://api.airtable.com/v0/<my_app>/<some_table> HTTP1.1 200 OK ... etag: W/"10f-SnXCiqHll2qv5oY0Q+Gx4C8/htI" ... Then I make another curl request like this: curl -H 'Authorization: Bearer <My token>' -H 'If-None-Match: W/"10f-SnXCiqHll2qv5oY0Q+Gx4C8/htI"' https://api.airtable.com/v0/<my_app>/<some_table> HTTP1.1 200 OK ... etag: W/"10f-SnXCiqHll2qv5oY0Q+Gx4C8/htI" ... Execution time of these two requests is almost the same. I expect getting 304 Not Modified and smaller execution time. Are my expectations correct and if they are, what am I doing wrong? Any help would be appreciated!

The Scripting block is a powerful game changer for Airtable, though you don’t need to be a developer to use it. Before using the scripting block, the most experience I had was writing a couple of Macros in Excel (but even that isn’t necessary knowledge.) Now, I mostly use scripts as complex formulas that can also create or update your records on a base. I encourage you to get into scripting if you. Like building formulas Kinda sorta know what variables, arrays, objects are Understand how loops work If you want to brush up on any of these concepts, try Mosh Hamedani’s 1-hour intro to JavaScript. Mosh also has an entire course on JavaScript that, at the time of writing this, is

After block release, I deleted my block from Airtable. How do I get the same block back in development mode?

I’m trying to create a script that would copy a set tasks that I have identified as my “template” set for use in multi-project tracking. My script would create all the new tasks for a new projects based on the template. The template tasks have a linked field for predecessor’s to use in the Gantt block (my goal is project schedule tracking). I figured out how to copy all the template tasks and prepend those task names with a mnemonic so they are unique. In doing that, I realized I can’t create the links in the predecessor field at the same time because the records are created serially and as such many of the links for a record don’t yet exist. I want to keep the same relative linking between records to allow for a new Gantt block to show the new project schedule with appropriate links. From there I can edit the projects dates and add/remove tasks specific to that project. Here is the code to create the records. for(let record of templateViewRecords.record

I’ve tried using Cognito forms & Zapier to pull data into multiple tables within Airtable but it keeps joining the data into the first column of the second table. I have two tables one for requests and one for environments. A request can have multiple environments, users can choose to add as many as needed. Each environment has multiple values (columns in the table) that need to be populated. The requests are tracked for submitter while the environments handle each of the sets of details.

Hey I want to import data from Parabola to airtable, but I got an error and I don’t know why. This is the table in Parabola… And this is the table in Airtable I want to add the items that I have called “titles” in Parabola and import to the column called “name” in Airtable Thanks!

Is it possible to have a hyperlink in an input description within the scripting block? I’ve tried putting in HTML and markdown and neither render in a formatted way:

how to increase the data load time via api? i am ready to pay money

Hey! I have a question that I hope you can help me with. I am looking for a way to do the following: If input A1 is X, then input in B1 is Y. Plus I want it to happen with every new input that adds to the table (through Zapier). In my case, I have a column named ID, and another called Description. Description will be in the format of “This is an event with John” or "This is an event with Sarah… I need a way for the table to automatically change ID associated with “This is an event with John” to “John”, and that of “This is an event with Sarah” to “Sarah”. That should be done with Script Block, right? And I hit Run everytime I need the system updated? or can I do it through Formula fx? Appreciating your insights in advance.

Hi! I’m writing a custom block that is deployed to several bases, and we’re considering automating deploys. I’d like to write tests for our code to try to catch regressions and increase confidence – has anyone done this? I looked through a few of the examples on github and didn’t find any test folders, but I didn’t check them all and maybe I’m looking in the wrong place. Any recommendations for a test stack? I’d rather not reinvent the wheel if somebody’s got this working!

A few weeks ago we added the ability to upload files in the scripting block using input.fileAsync, and wanted to open up another challenge to the community around this feature. For this challenge, submit a script that uses the input.fileAsync API for a specific workflow. We’d love to see creative and useful ways for this new input type to be used! Maybe it’s a smarter importer, for example with fuzzy matching to update existing records, or a way to import Excel files with multiple sheets, or importers for other common apps that export CSV, JSON, or XML files. Or maybe it’s something totally different! The winner of this contest will win $1,000 :tada: . All submissions are due by May 8, 2020 at 6:00pm (PST). What exactly should be submitted

Just started using the Scripting block! My team is using Airtable to calculate profit pool for an affiliate program, part of that includes getting the sum of a field (which you can see on the page) update it on another field for all record as total number of that field (in this case sum of ‘# of hoodies’ ) and then updated on another field (‘total hoodies’ ). And then update total number of records from another table in a view (Toal # of Affiliate which is the total records from the Approved affiliate table). Thanks so much for your feedback on this! Lubem

I new at airtable, but not to BI, I actually use PowerBI. I have on airtable a bd (grid) with more than 450 rows. When I use PowerBi Or CURL to get my data, I only receive the first 100 rows, nothing more, nothing less And I don’t figure out own to get more data from the table. Thank you in advance

Currently in Airtable there’s no function provided for a standard deviation like Excel’s STDEV. One user on this community has helpfully written out the function that calculates it, but it’s rather complex. I’m wondering if the script block couldn’t be used with math.std on rolled-up values in a single property to very quickly generate the standard deviation on a set of values? I’m still verrry green at Javascript but this seems like it would work; if you agree I’d love some guidance on where to start on pulling the values from a roll-up column and using them in the math.std calculation. Thank you!