Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,657 Topics
  • 11,709 Replies
3657 Topics
W
Weng-ICParticipating Frequently
posted in Development & APIs
Long text (Rich Text Enabled)

Hi, I have created a Typeform with one of the question is a user input “Long text field” I have problem with AirTable not showing users input text from Typeform. Any ideas. Thank you.

31
ScottWorld
M
Michael_PalmerNew Participant
posted in Development & APIs
API GET call not retrieving updated table field data

I’m using API calls through Excel VBA to GET, POST, PATCH data tables linking several 3rd party platforms. For purposes of explanation of my issue, assume the following basic data. Table-1 contains (3) records, with Field-1 containing data “A”, “B”, “C” respectively. I can make a List GET call and it retrieves all 3 records properly with correct values in Field-1. I can make a record GET call for record (1) and it retrieves record (1) with correct Field-1 value of “A” Now I PATCH record (1) with a new value in Field-1 with “X”. In my Airtable web grid view instantly showing the updated value of “X” If I make a list or record GET call again, it still shows record (1) with a Field value of “A” even though I’m looking at the grid view with correct data of “X”. The next day making the same call and I get the correct value of “X”, as if it sat in a cache till an evening update. I can DELETE record 1 and I still get the same original GET results with record (1) and field-1 value of “A” even

394
B
M
Marty_McCoyKnown Participant
posted in Development & APIs
Help troubleshooting "vlookup" script

I am new to the scripting app. I have a form that people fill out when they come to my office. It feeds into a table called Arrivals (QR Code). I want to create an automation that will run a script when the form is submitted: If the person is a guest, they submit their email. When the record has that guest email, I want to check another table, Data About People, to see if there’s a record there for them. If yes, link the Data About People record to the newly created Arrivals (QR Code) record. If no, create then link. I’m getting an error with this code: let mainTable= base.getTable("Arrivals (QR Code)"); let mainTableRecords = await mainTable.selectRecordsAsync(); let lookupTable = base.getTable("Data About People"); let lookupRangeRecords = await lookupTable.selectRecordsAsync(); for (let record of mainTableRecords.records) { let lookupValue = record.getCellValue("Guest Email"); for (let rangeRecord of lookupRangeRecords.records) { if (rangeRecord.getCellValue("E

142
M
S
Steve_MileyNew Participant
posted in Development & APIs
Delete records from table via api

I want to refresh my airtable tables from an SQL DB once a day, thus I want to delete all records in a table, then reload. I know I can use curl, to load them, and i’ve got that to work, but i’m not sure of the most efficient way to delete all records. i could list them all, get the record id, then delete each record in a loop. Has anyone else automate a table reload? we are using this to prototype reports, and make them easily available on the web. thanks, Steve

333
T
M
Matt_Kennedy1Known Participant
asked in Development & APIs
Get record name instead of id - via API using Python

I’m using Python API Wrapper. When I use get() method to retrieve a record that contains a ‘Link to Another Field’ Column, the method returns the linked record ID. I would like to get the linked record name instead. My next step will be to do a 2nd operation to look up each record (by id) and get the name. But I wonder if there is an easier way that I’m overlooking. If not, any recommendations about an efficient way to do this with Python / Pandas would be appreciated.

580
M
C
CentralNew Participant
posted in Development & APIs
Uploading attachments via API not working consistently

Using the API to upload PDF files. Every couple days a batch of files uploaded around same time appear as generic document icon and when you attempt to download you get “Found. Redirecting to” message but nothing. If I look at the record and view the attachment array, I see values for Filename (taken from the URL), Id (a valid Airtable Id), and Url (the public URL to the file - link works fine). Size, Thumbnails and Type are all null. On a another file that works, the Size, Thumbnails and Type values are filled out and the Url is changed from what I submitted to a “dl.airtablee.com” There are no error returned from the API call. Our web server that hosts the files are IIS on an AWS instance. In reviewing the web server logs, I don’t see any request to the server for the “bad” files. For the “good” files I see a request from “Filestack” at the time the API record was created. I have been trying to “resubmit” the empty file by taking the array of attachments in the record

123
E
R
Renzo_VeniniNew Participant
posted in Development & APIs
Script to write or export data to filesystem

I have a script, that produces a CSV of a table. How can I write this CSV to a file in the file system? I need a functionality to do this in a script because this script will be triggered by a Webhook. And the built in UI CVS export cannot be called in scripts. Has somebody an expample of writing files out of a script?

233
B
R
Rose_Haft1Inspiring
posted in Development & APIs
Scripting Problem with Input Variables

Hi there - When I copy and paste the sample code for my input configuration, I am receiving this error and the code won’t run. ‘iv_UpdateStatus’ does not exist on type ‘{}’.(2339) Any suggestions on what could be wrong? Or how to fix it?

10423
R
D
daniel_villegasNew Participant
posted in Development & APIs
Axios vs JavaScript SDK in React

Hi friends. I am a new developer and have started using Airtable as a database for personal project with React, and I wanted to ask what are your thoughts on fetching data from Airtable’s API in my client-side application. Do you think it’s better to fetch the data using Axios or use the base().select() pattern from Airtable library? For React specific: I don’t understand how to return the data with the Airtable method const useCharacters = () => { const base = new Airtable({ apiKey }).base(baseId); // returns undefined return base("Characters") .select({ view: "Main View", }) .eachPage( function page(records, fetchNextPage) { records.forEach(function (record) { return record.fields }); fetchNextPage(); }, function done(err) { if (err) { console.error(err); return; } } ); };

41
A
R
Rose_Haft1Inspiring
posted in Development & APIs
Scripting: View comments on a record

Hi there - Is it possible to call comments on a record using the scripting? Or is it possible to see the date modified of the last comment on a record?

113
Kamille_Parks11
J
Jon_Smith2New Participant
posted in Development & APIs
Scripting: Duplicate Table

Hi all, New to Airtable scripting. Wanted to see if what I’m trying to accomplish is possible before digging in. Is it possible to duplicate a “master table” and rename it? Or create a new table and copy the values from another table? Thanks in advance!

281
Kamille_Parks11
T
Taylor_JohnstonKnown Participant
asked in Development & APIs
Question RE webhooks & buttons

Hi, everyone! I’m sure this has a simple answer, but as a non-developer - I could use some help! I currently have a few webhooks for Zapier and Integromat programmed into button fields in my base. Their function is working just fine; however, each time the webhook is sent, I get a success message in a new window. I appreciate the confirmation, but when I am processing hundreds of records in one sitting, this becomes extremely annoying. Is there any way to get my webhook to run without the success message? Or any recommendations for alternate solutions? I know it’s possible to have a button or an automation run a script, but I don’t know how to create a script to send a webhook. Thanks in advance! :slightly_smiling_face:

260
T
R
Rose_Haft1Inspiring
posted in Development & APIs
Automations & Scripting

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.

52
R
R
Rose_Haft1Inspiring
posted in Development & APIs
Scripting: Check if checkbox is marked or not

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

52
R
R
Rose_Haft1Inspiring
posted in Development & APIs
Is there an ID for MultiSelect options and Single Select?

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?

358
kuovonne
R
Rose_Haft1Inspiring
posted in Development & APIs
Scripting: Get link to record and/or view

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

193
Kamille_Parks11
R
Rose_Haft1Inspiring
posted in Development & APIs
Using Scripting to find last modified date

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

21
kuovonne
P
Paul_NaraineParticipating Frequently
asked in Development & APIs
Setting precision for 12 places after the decimal for Crypto API

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

202
kuovonne
M
Mark_FredrickNew Participant
posted in Development & APIs
Pulling data usable data from a linked record in the same table

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

1610
Justin_Barrett
B
BizarrebraParticipating Frequently
asked in Development & APIs
Completely new to Airtable - help needed with PHP echo

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.

2310
B
A
Arturo_LeonNew Participant
posted in Development & APIs
Retrieve a value from the URL via api

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!

11
Justin_Barrett
E
Ehud_ShamonNew Participant
posted in Development & APIs
Fetch data json get/post zipcodes

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

217
E
M
Matheus_BergamoNew Participant
asked in Development & APIs
CSV File import without input.fileAsync()

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.

65
M
Kim_Trager1
Kim_Trager1Brainy
posted in Development & APIs
How do I filter out null values

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() }

254
Y
G
Giacomo_MelziNew Participant
asked in Development & APIs
Get record id after creation

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

652
G

Badge winners

Show all badges
Terms & Conditions