Development & APIs

Hi - We would like to send a formatted email once a script is executed. How do we set-up the automation to have text output, with formatting, into an email that is sent? Here is the flow: Time trigger Run Script Send Email I know we can use the script to update a record and have another trigger to email, but it doesn’t format and seems there is a more direct way. Any help is appreciated.

H - How can we check if a checkbox is marked as marked or not?

I am trying to develop a script with a mutli-select option. Is there a code for each of these so if I choose to change the actual name, it won’t be a problem?

Hi there - Does anyone know if it’s possible to get a link to a record and/or view using scripting?

Hi there - Is it possible to use scripting to find the last modified date of a cell?

Hi all, I’m getting crypto prices from the Coinmarketcap API and the prices have 12 decimal places E.g. $0.000000007269 However, when I fetch the prices into Airtable, the field [Prices] has precision set to 1.0000000 - 7 places and missing the remaining 5 places. Is there a way to resolve this? Thanks in advance, Paul

This seems like something super simple for a script but I’m not code savvy, so I’m stumped. I’m far from an Airtable novice, just not into Scripts. I’m trying to Create a run of show base for live events where the Start of one record is populated by the end time of the record that precedes it in the show. Each record has a “Item #” as it key field, so I tried linking records the old fashion way in the table manually, but this is tedious AND it won’t let me do any calculations with the data I pull because it’s circular. I have a few important fields: Item# - unique key, all records sort by this. Start time - Ideally this is an IF formula, so that if it’s the first line in the show, it doesn’t try to find the previous item. Duration - Manual entry End time - Formula= Start Time + Duration Previous Item - Formula= Item# - 1 Previous End - thing I’m trying to get My logic is this: Script that find record with Item# that matches Previous Item, then takes the Previous Item’s End time and

Hello, I’m originally a programmer but I’m completely new to Airtable and the script syntax. Basically, I have a PHP file somewhere in my server that makes a GET request to Twitch and gets the follower count of any channel. Now, I have in Airtable a list of Twitch users, with their username. What I want do to is to pass the username to my URL so that the PHP script in my server does the rest, and, posts a simple ECHO with the number of followers. Then I’ll just grab the number to update my field. A bit more graphically: Grab the ‘username’ field from my table ‘table’. Append it to my external URL, i.e. “https://mycoolphpscript.com?user=username” Launch the query, fetch the output, which is just a PHP echo with just a number as output, i.e. “458” (followers) - actually if you paste the URL in your browser you’d also get “458” since there’s just a PHP echo in the background. Update my ‘followers’ field with the result. I know how to do 1, 2 and 4, but I have no idea how to do number 3.

Hello everyone. Is it posible to filter a certain value from a field directly on the URL ? Can this be done with formulas ? Thanks in advance!

Hello, I need help fetching data. I’m new to airtable and also don’t have much experience in scripting but I do have some code experience. I’m trying to fetch Zipcodes from https://www.zipcodeapi.com/API I can use one of the two: GET, Zip codes by radius. POST, multi zip codes by radius. I did authorize the airtable domain https://www.zipcodeapi.com/ClientKeySetup to get js-key. as zipcodeapi suggested. This is the code I have that use the GET method (yes I know): // @ts-nocheck let response = await fetch(‘https://www.zipcodeapi.com/rest/js-APIKEY/radius.json/59718/30/mile’) console.log(await radius.json()); I get: ### ERROR ReferenceError: radius is not defined at main on line 3 I did tried to add method, headers… all kind of thigs but with no luck. I know I’m doing it wrong. Any help please? Thank you very much Ehud

Hello, I´m using this code to get my csv file, parse and import to table: let csvFile = await input.fileAsync( ‘Pick a CSV file to upload’, {allowedFileTypes: [’.csv’], hasHeaderRow: true} ); What I am not figuring it out is how to make that is always the same file, without me needing to choose one - without input. If anyone knows how to, I would really appreciate.

I have a bunch of dates I need to convert to strings and put into an object. sometimes however my date field is empty and it comes up as null As far as I understand checking if something is truthy I can just check it with if(value) and it only runs if value is truthy - not null, undefined… However even despite el.getCellValue(wipDate) comes up as null, my code still runs the blog inside the if statement. Does anyone know what I’m doing wrong? let month = ''; let year = null; let dateObj = {'year':year, 'month':months[month]}; console.log(el.getCellValue(wipDate)) if(el.getCellValue(wipDate)){ //console.log('inside') month = months[new Date(el.getCellValue(wipDate)).getMonth()] year = new Date(el.getCellValue(wipDate)).getFullYear() }

Context I’ve made an Airtable script to get some info automatically calling an API after populating a single field. Everything is cool besides the fact that one of the fields it’s a linked field to another table. In this case, I would first have to create a new record in the other table and then link it (via the record id) to the table in the first “main” table. Problem I’d like to understand if there’s a way to get back the ID of a newly created record to link the record in the main one. I could read the values in the whole table after creation, filter them and get the ID of the created field. Tho it seems very inefficient since I’d have to read the whole thing just for a single value. I’ve read through the docs but I couldn’t find anything about this use case. Is there a more elegant way that I’m missing? Thanks

Hi Airtable community, I am stumped with a bit of an annoying task here. We have an attachment field in our Airtable base where we attach DOCX files. We want to return this field as a part of an API response from our custom API, and we want to do a full preview of the DOCX as an image, to be served to our website. I know the endpoint returns a thumbnail image, but this is pretty small and blurry. I was wondering if there was a way to fetch a larger thumbnail, or a full page preview, of the DOCX file from Airtable’s API. If anybody knows of how to figure this out, in any way possible, I would greatly appreciate it. Thank you! Jack Tilly

Hey, is it possible to create some Action Buttons to push webhooks with json data with the scripting block?

Hello, I would like to have some info that is not officially provided by Airtable. I am using airtable to manage a database, which I export to a CSV file. I then use this CSV file as a database for a REST API in this way I am not limited by the maximum 5 requests per seconds imposed by the Airtable API. Where I am wondering is about the files uploaded via Airtable, in my CSV I see that the files are uploaded at this address: https://dl.airtable.com/.attachmentThumbnails/xxxxxxxxxxx If I have a mobile app with 1,000,000 active users viewing the image uploader through Airtable, do I face any limitations or blockages?

I’m looping over some records and want to increment ‘i’ ONLY if both conditions below are met: let i = 0; for (let record of taskRecords.records) { if(id.includes(record.getCellValue('ID Lookup')) && record.getCellValue('Stage').includes(stage)) { i++; } } console.log(i); My problem is the second condition. The cell value of the field ‘Stage’ is “This is just some dummy text | this is a string” and it’s searching for “this is a string” (this is called ‘stage’ and is a string from a previous step in an automation). i remains 0 in this case. Can anyone explain why includes doesn’t work on the second condition? Thanks!

What sort of code will allow me to read a .CSV table, and if LAST NAME, FIRST NAME, and DATE OF BIRTH columns in the .CSV file == the LAST, FIRST and DOB columns in my records, would trigger a check box in the last column? Very new at writing code. Example CSV file attached. Thank you!

I have slowly been developing a custom app that interfaces with several external APIs that supply additional data to airtable entries. I started out with the utility as an automation script - here I was able to use remoteFetchAsync() to avoid any CORS issues with my fetch calls. However, since moving to the custom app and React, I am having to go through the proxy at https://cors-anywhere.herokuapp.com/ to run my API calls (and avoid the CORS preflight errors). The issue is the proxy is only for development - I would like to either duplicate what it does myself or find a similar service that does the same thing. I am relatively new to JS and web development, so I am looking for a well documented solution that would be easy to implement in a few hours. Does anyone have any hints on where to look? Since Airtable has the server fetch functionality built in for scripts, is it also possible to use it in custom apps?

Hi there, I’m a developer who has been building some custom apps for a company over the last 6 months to help keep Airtable at the center of their operations and integrate various services and APIs right into their Airtable workflow. One of the most useful features has been using the Button field with an action of opening a custom app. This has allowed the team to trigger various actions right from a record in a view. Something that would be incredibly useful would be to get the field ID from the record action data that we get from the useRecordActionData hook. This way we could create multiple button fields within one table that perform different actions in one custom app. At the moment we are limited to one action per table because we cannot differentiate action data from two different buttons on the same table.

Hi! I am using a react front end with Airtable as my backend, Everything works fine and I am to create and list records, but when I run a .update, I get an error. In my console I get: Access to fetch at 'https://api.airtable.com/v0/appfGOrSlohKglsao/Users/?' from origin 'http://localhost:3000' has been blocked by CORS policy: Method PATCH is not allowed by Access-Control-Allow-Methods in preflight response. It seems to be that Airtable is not allowing PATCH requests specifically? I don’t think I need a proxy given everything else works just fine. Am I missing some configuration?

We are using airtable rest apis to manage our employee’s data. In the airtable support article, it was written that the airtable API has a rate limit of 5 requests per second per base. Here is the article link: Public REST API – Airtable Support. So if we upgrade to a pro or enterprise plan then can we get a more request limit on API? Or is there any other way to increase airtable API request limit? Thanks.

For the Python Community out there, I wanted to share airbase, an Asynchronous Airtable API Python Client I’ve made for python 3.7+. A lot of credit to gtalarico and the work he’s done with pyAirtable (previously airtable-python-wrapper) which greatly informed this API client. All suggestions and feedback are very welcomed, as well as any contributions. There is still work to be done in documentation, and helper functions. Here is the repo

Hey guys, I have a base with a few thousand customers in it. Each customer has their own record, which includes the time and date that the customer first made a purchase from my store. I’m looking to generate a list of unique (but memorable) referral codes for each customer in my base. To achieve this, I would ideally like to generate unique codes for each customer by conflating: The customers first name. The first letter of their surname. The running total occurrences of any given abbreviated name. (With 1) and 2) put together being the customer’s abbreviated name.) So, if your name was Bob Matthews, and you were the first Bob M that had ever made a purchase from my store, your unique code would be BobM_1. If you were the second Bob M to ever make a purchase, your code would be BobM_2, and so on. Example list of customers (sorted by when the customers first made a purchase.) Tim Smith > TimS_1 Kate Field > KateF_1 Tim Short > TimS_2 Ben Thomas > BenT_1 Richard Burton &g

Hi all, I had a URL field in AT called “Google maps link”. When I tried to set up a zap to create a google doc triggered by a new record in AT, Zapier didn’t find the field. Then I changed the field to single line and still, Zapier couldn’t find it. Finally, I created a formula field to create a direct copy of the field, and still Zapier is not finding it. I even deleted my original zap and started a new one, thinking maybe there was some issue with my original zap, but still, nothing. Any ideas?