Development & APIs

I have a table called “2020Locations”, and its name seems to be causing a problem in the scripting block. I’m using: locationsTable = base.getTable(“2020Table”); But auto-complete doesn’t recognise locationsTable as a table. If I rename the table, or use the underlying tableID, then all is well. Is this a bug or a known issue? I couldn’t find it documented anywhere. Is there a better workaround than using the tableID instead?

Hey everybody, If I have to use somet sensitive information in my code, like an API key, what’s the best way to do that? I could put it right into the code, but my block to be open source (for the hackathon), so…any advice? Cheers, Alec

Hi there! I’m trying to set up an GET function to pull data from Airtable into Dexter (chatbot) based on a user inputting their e-mail address. I’m not getting an error message, but the response is coming back as empty. Any idea what’s going wrong here? is the user e-mail variable. $ GET https://api.airtable.com/v0//Sheet&20Name/ {“headers”: {“Authorization”: "Bearer "},“body”: {“records”: {“filterByFormula”: “({Email Address} = ‘’)”}}} ${{records.fields.First%Name}} //The field value I am trying to pull from Airtable. Thanks!

I am currently trying to pass in an option for the airtable API which is going through Dexter. The following POST method works: $ POST https://api.airtable.com/v0/<bot airtable_base>/Profile/ {"headers": {"Authorization": "Bearer <bot airtable_api_key>", "Content-Type": "application/json"},"body": {"fields": {"FormalName": "<get name>","Address": "<get address>"}}} but I can’t seem to get this GET command to work $ GET https://api.airtable.com/v0/<bot airtable_base>/Profile/ {"headers": {"Authorization": "Bearer <bot airtable_api_key>", "Content-Type": "application/json"},"body": {"filterByFormula": {(FIND("FormalName","My Name"))}} Anyone get this to work?

Hi there, On the DevPost Contest summary, it mentioned “Need Inspiration? We highly recommend taking an idea from our list of use cases.” Is that “highly recommend” just in reference to getting inspiration, or were these use-cases identified as high-value asks that the team is keen to see implemented? Put another way, does implementing or not implementing the use cases outlined have an impact on the “User Impact” or other overall score criteria? Thanks for the clarification!

Hello! We have a little new block in beta that you might find useful if you store JSON in your tables. You can select a cell in grid view for a single line or long text field, then start typing in the block to add or change the JSON contents. The JSON editor block makes it easier to work with JSON by formatting the contents of the field with colored syntax, indenting, and warnings for malformed JSON. Click here to join the beta. Once you click that link, the “JSON editor” block will be available in the list of blocks when you go to install a block. P.S. we’ve open sourced this block here so you can remix it if you’re in the custom blocks beta: GitHub - Airtable/apps-json-editor

I am trying to figure out how to use Airtable as a database for a web app that I’m making. When I look at all of the tutorials, they seem to be for using Airtable as a GUI. I am actually interested in knowing how to do advanced queries/posts etc via API requests (using regular curl requests and/or the JavaScript methods). Can anyone tell me where I can learn this? I see people doing it, but I can’t figure out where the docs or tutorials are. The auto-generated API docs seem to just give you the procedure for basic queries and nothing else. Does anyone have any tips? Thanks.

Hi! :wave: I am using the PUT version of the Airtable Update records API. I have four columns/fields, Name , Contact , Attachment Image & Active. Now I call the API to update just the Attachment Image column, with the below API body : It updates the Attachment Image field’s value successfully, but clears all other fields. The record snapshots (before and after) look like - Before - After - So, how can I make the API update that cell ONLY, and touch nothing else? I hope you understand my query - Any help is appreciated! :slightly_smiling_face: Thanks!

Hey everybody! I’m starting development on a block for the hackathon – super exciting! I’m going to need to store a unique token for each user, because I’m going to need to do some OAuth in my block. I’m wondering the best approach to do this? I could store it in GlobalConfig, each token is accessible through the ID of the user, but I’m not sure about that. Any advice would be much appreciated! I noticed this is done the demo for blocks, by storing the Twilio ID and Secret, so I’m curious how it’s done there

Hi! First post here. Very beginning JS user but excited to learn! I’m working on a pretty basic script in a base I’m working on. I’ve been learning JS but I’m not quite at the point where the examples are making sense to me. I have 2 Tables in my Base, “Projects” and “Judges”. In Projects, I will assign 3 judges from the Judges table in one Linked Record column. Then, in a third Table, “Scores”, I want to use the Script block to have three unique rows generated - one for each judge with the same project. So for example: Project “Coral Reef Building” gets assigned “Mark”, “Sam”, and “Amy” as judges. In “Scoring”, three rows are generated: “Coral Reef Building, evaluated by Mark” “Coral Reef Building, evaluated by Sam” “Coral Reef Building, evaluated by Amy” I was thinking that .forEach method might be useful here, but I’m getting confused with the exact terminology around tables and queries and records. Thanks all for your help & advice! Even pointing me in the right direction of so

I like to integrate the airtable to my website and show it as announcement. I created api with POST. example https://sample.com/api/announcement I tried with zapier but i like to integrate within Airtable. please help me, Thanks in advance for your response.

Today I’ve checked things about Developer Blocks SDK. Then I’ve apply to access SDK. But I don’t know how long it takes to approve my request or if I’m not eligible then can I request again?

I want my custom block to include a calendar with a similar look to Calendar views. Do custom blocks have access to whatever Calendar views use for calendars, perhaps a react package, or would I need to import another react package?

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): Tables: Albums, Songs, Categories Albums have a Linked Record field for Categories Songs have a Linked Record field for a

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 !!!