Development & APIs

Hi there, I want to keep my block UI consistent with Airtable’s branding where possible. I noticed ColorUtils.getHexForColor here and that seems like a reasonable, but slightly cumbersome solution. Is this the preferred way to use Airtable’s colors in our blocks, or is there a more direct way to say, set the background color to a standard Airtable color? Thanks! P.S it was a bit hard to find that method in the docs as you need to click on the “ColorUtils” tab in the Colors section first. I had expected a more direct way or a pointer on how to get the hex values directly on the colors main page :slightly_smiling_face:

Enable creating an application that has it’s own api key Allow it to perform actions on bases / tables granted access to Example: an app to allow users to do things for a company… 20 users login to the app using 1 user’s key… Now they all quickly hit the 5 requests per 1 second rule Anddddd if the app performs crud, they are acting as the api key user.

No expert here / But I have been using the Send Grid block fro over a year. - I was able to figure out how to generate new API key- paste it-- Now it is not working. I have pasted in a number of new keys this morning. Is there some new verification that is needed.

I tried finding any info on this, but how do I gain info/access to become a Blocks developer? Will that be opened up as an SDK at some point? Or can I join some program to be able to build custom blocks for customers?

I looked at the API docs and did not see anything about how to query a linked table. Does anyone know how to do that and/or where I can find out how to do that? For example, in a situation like this: var Airtable = require('airtable'); var base = new Airtable({apiKey: 'YOUR_API_KEY'}).base('apptDndoI6VkAx3Ko'); base('projects').find('recAurDC0RVIB2GFU', function(err, record) { if (err) { console.error(err); return; } console.log('Retrieved', record.id); }); Say that projects were linked to another table called “tasks” - How would you find all of the tasks that belong to that project? Is there a way to do it with curl? Where is there a list of more advanced query methods? Such as “base-url?limit=10&offset=3” to do something like pagination, etc? Thanks for any pointers!

Hi everyone! I am almost done, I just need your help with the last part! I have a Zap that creates an email draft that sends an invoice when in a certain view. I initiate the process by checking an airtable checkmark, which then applied the invoice to the needed view. Sweet! AND it’s making the draft email just like I want! Heck yeah!!! Now, what I want it to do is delay for one minute (no problem) and then update the record that just triggered it by checking a checkbox. Is there a way to easily do this by referencing the record that triggered the whole thing? (This will then remove it from the view, per filter instructions) Thank you so much for any help!

I’m trying to use the Airtable JS library to pull a list of records filtered by a Linked Record field, and although I can verify the data from a certain record by pulling by ID, I cannot filterByFormula for this particular record using a Linked Record field where multiple records are linked. I’ve also just went straight to postman to ensure it wasn’t the JS library but in fact the API itself. I found an answer here on how to use filterByFormula with Linked Record fields, however the solution is not working although I’ve followed it to the T: https://community.airtable.com/t/filterbyformula-multiple-select/2075/8. It actually works with Linked Record fields that are 1:1 and not when 1:many. Please see my description of the problem here: filterByFormula option does not work when used for the following scenario (filtering on Linked Record field with multiple records):

Greetings, Airtable Experts! Our small team is currently using both Todoist and Airtable to track our tasks :white_check_mark: . Ideally we would like to use Airtable exclusively (one stop shop!), but are finding it very hard to give up an incredibly useful Todoist Feature: the ability to email tasks to a project. You simply copy the link Todoist provides, paste in the TO section of an email, customize the subject line with due date/priority/tags, press send–and presto, there’s a new task in Todoist w/a link to the email. :thinking: Is it possible to accomplish something similar with Zapier/Airtable? I have a clunky work-around, namely saving a PDF of the email, then create the task in Airtable and upload the PDF. Any assistance would be appreciated!

hi, i’m exploring how to use scripts. i have properties table and transactions table. properties have property ID, status, owner, address, photos fields. i wish to have a script wherein when status is changed from ‘active’ to ‘closed’, a record will be automatically created in transactions table, and copying the information like property ID, owner. i’m new to airtable and hope to consult with experts here. thanks in advance.

Hi! :wave: I am an intermediate-level Airtable user, and using it since 2yrs. Now I have started learning PHP, and I want to integrate the Airtable API with it. So, I want to build a simple webpage (in PHP), in which the - user clicks the ‘Browse Image’ button, & picks an image from his phone’s storage. After picking, the image would be compressed with some other compressing tool. The compressed image would replace the previous image in the ‘Attachments’ column, specified row no. (Ex. flow : Replace the current image in the ‘Attachments’ column of row #4 with the new compressed image). Is this possible to do? If yes, can you refer any Docs/Links which might help me? Any help is appreciated :slightly_smiling_face: Thanks!

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