Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,656 Topics
  • 11,709 Replies
3656 Topics
T
The_Focus_ForwaKnown Participant
asked in Development & APIs
Update Records with external API data with a validation step

Hi there, I work for a prison education nonprofit that works with people facing federal crimes. We want to be able to send legal updates and resources to graduates of our classes, and use Airtable to track those graduates. We want to keep our records updated as to when graduates of our classes are transferred to a new federal prison, had their release date changed, or been released. Anyone incarcerated in federal prison is given a register number. You can use that number to get release date and location data from this API. We’ve been using a combination of Python scripts to do this but it’s been clunky and buggy because I’m not that great at Python (frankly I’m not that great at coding, period, but I’m learning). I think we can do this more efficiently with a script in Airtable. Here’s the one catch: every once in a while, someone puts in the wrong register number for our graduates. Is there a way to show values returned from an API side by side with the current values in the Airtable

2010
R
N
nishNew Participant
posted in Development & APIs
Is the Metadata API still available?

Hello, We requested access to the Metadata API last month, but haven’t heard back yet. Is Airtable still giving access to the metadata API? We run formcrafts.com and would like to build an integration with Airtable :slightly_smiling_face:

40
N
F
FZK_TeamNew Participant
posted in Development & APIs
Shuffle items within cell

Hi All, we use Airtable to manage our social media and one cell has a list of hashtags (one on each line) and we’d like to figure out a formula to shuffle the lines so the hashtags don’t post in the same order every time. Any ideas?

51
kuovonne
I
Ivan_MatasovicNew Participant
posted in Development & APIs
Script for deleting/updating on API server small modification

I am working on importing and managing data of device details on the cloud with API. I am a beginner and don’t have experience with coding. I was wondering if you can help me because my team is struggling with the data management of our clients while waiting on developing new tools (released in 5 weeks). The old tool is broken at the moment… We have airtable that can download (to airtable) and upload (to the server) info for the devices (about 4 fields) on airtable sheet. Using a script for that. I also saw script here in community that can delete all data from airtable sheet, but is it possible to use this script with the modification that deletes corresponding data on the server using api? For example: I download a list of devices with info on 4 fields. (name, code, mac address, NFC number) Copy selected devices or rows in airtable (not all, just ones that I want to delete) to the new airtable sheet. Click the button in the new sheet to use scripts to delete all corresponding device

00
I
P
Phoebe_YiinNew Participant
posted in Development & APIs
Schedule CSV Import app using scripting block

Hello! I am looking for a way to import data using a URL that connects to a CSV and merge existing records on a recurring basis. This can be through a click of a button or the script running in the background. The CSV could also come from google sheets. Which of the following would be easiest to automate the importing of the CSV? Using the Scripting block and creating a button that will trigger the CSV import app? The automation with run a script every hour to trigger the CSV import app? Google scripts on the Google sheets with the Airtable API to import the CSV? If anyone has a built a similar script and is willing to share the script please do! The ideal would then be to have additional columns in the base that only sit in Airtable. Due to data privacy concerns, we cannot use a third-party extension. Thanks in advance!

174
P
T
Tor_Martin_NorvParticipating Frequently
posted in Development & APIs
How can I get a grouped record with API?

I have grouped some fields in my Airtable. How can I get a specific “count” or a “sum” with API? How can I access this data through API? I am interested in getting the different counts and sums for each group. I.e: Score_act: sum 41 Task: “Jeg har koblet av med noe underholdende”: count 4 (times this task had been completed). Is this possible? Regards, Tor M

513
T
N
Nashville_PubliNew Participant
posted in Development & APIs
Block won't release to Airtable's server

Hi all! I’m trying to remix the Wikipedia Enrichment app from Github. I’ve got everything installed and it’s working great, but I can’t get the app to release to Airtable’s servers. I’m getting zero feedback from Terminal when I put in $ block release. Right after it gives me the address to plug in a line shows up “Switched to a new block installation.” I’m not really sure why it keeps doing that. I’m on Big Sur 11.2.2 with Xcode command line extra tools installed, with a lower version of Node (14.15.0) installed because I noticed people with Big Sir are having problems. Any suggestions or what other information would you need to diagnose? Thanks everyone!

10
N
M
Makoto_SometaniNew Participant
posted in Development & APIs
Cannot edit script

I’ve installed the Scripting app, but the input area in the upper left corner keeps loading and I can’t input any script. This happened after I ran the “Sync Airtable Base Structure” script provided by “miniExtensions”. I’m a beginner, so I don’t know how to solve this problem. If anyone knows how to solve this problem, please let me know. Thank you very much for your help.

111
Michel_Billiau
A
Alexander_SheltNew Participant
posted in Development & APIs
(No conflict Scheduling) Script issue

I’m trying to use @Kamille_Parks Script No-Conflict Appointment Scheduler but I’m having a slight issue trying to set it up to allow Same day Scheduling currently it only allows appointments as soon as the next day. Any ideas? I found the line 266 //loopdates.push(loopCurrent); //NOTE: uncomment this to allow same-day scheduling but i wasn’t able to get it to work. Following is the script I am using with changes i made. /* Script: No-Conflict Appointment Scheduler Author: Kamille Parks This is the sister-script to my "No-Conflict Asset Reservations" script. This script performs a similar function, however this one is built for appointment/reservations which start and end on the same day. It allows users to select a service, pick a qualified agent/employee to perform that service, and then select upcoming dates and times which work for that agent. The script opts to use buttons as opposed to text box inputs to reduce human error in typing in correctly formatted date/time strings

132
A
J
J_MaiInspiring
asked in Development & APIs
How do I install the Airtable package to a cloud function, so I can call the airtable package on a serverless tool like Google Cloud Functions, AWS Lambda, IBM Cloud Functions, or Azure Functions

Hi all, I’m at my wits end. I’ve written code for Airtable locally, which largely works. Now I’d like to place the code on a cloud functions tool so I can run my code on the browser and have it communicate with other APIs. Here’s the code I have on the serverless tool, just the basics first just trying to call the airtable library. /** * main() will be run when you invoke this action * * @param Cloud Functions actions accept a single parameter, which must be a JSON object. * * @return The output of this action, which must be a JSON object. * */ var Airtable = new require('airtable'); var base = new Airtable({apiKey: 'XXXXXXXXXXXXX'}).base('appumWMhUzhgN8fFe'); function main(params) { return { message: 'Hello World' }; } When I try to run this code, I get Error: Cannot find module ‘airtable’\n In this case I’m using IBM Cloud Functions, but the process as I also read Google Cloud Functions and others seems to be the same. I just am doing something wrong. Here’s the

260
J
A
Avi_MoondraNew Participant
asked in Development & APIs
Cannot create Multiple Record Link Type for a Field?

Uncaught (in promise) Error: Can't create table: invalid field config for field 'games_id'. Creating or updating options for multipleRecordLinks fields is not supported at this time. Is there any other mechanism or workaround for this? When creating a table, or updating a table?

40
K
D
Daniel_JonesNew Participant
posted in Development & APIs
Running into great difficulties trying to create a script for school administration

I wonder if anyone can point me to the right direction. I’m tasked to create a base for simple school administration for a small NPO. The use-case is quite simple: a Program contains multiple classes a Class contains multiple students a Student may attend more than one programs Based on the above processes, I’ve created a base with four tables: Student, Program, Class, and Attendance. the Student Table lists all of the students, and each student record would also link to multiple Program records, multiple Class records, and multiple Attendance records the Program Table lists all of the programs, and each program record would also link to multiple Class records and the students records the Class Table lists all of the classes, and each class record would also link to its parent program record and students and the Attendance Table is a junction table between Class Table and the Student Table With the above set-up, I’m able to create all of the views needed for my colleagues, such as

132
D
J
Jesse_MillerNew Participant
asked in Development & APIs
Single select field options from API

Hi, new to Airtable, so this may be a dumb question; apologies in advance if so. Is there a way to dynamically update single select field options from an API? For example, looking to have a list of item types to select for a record, ex: Server, Workstation, Switch This master list is contained in another system but accessible via rest API. Is there a way so that in the far end system, if “Router” is added as an item option, the Airtable option list for that field will now contain “Server, Workstation, Switch, Router”?

3575
ScottWorld
P
Paul_NaraineParticipating Frequently
posted in Development & APIs
Create and Update Airtable records using Coinmarketcap API

Hello AirTable Team! This may a simple ‘request’ to some of you. Here’s my ask… What’s the best way to use the API from Most Trusted Cryptocurrency Market Data API | CoinMarketCap to Get the data (list of all cryptocurrencies) - initial Update the data (list of all cryptocurrencies) and append new crypto currencies to the list I have my Coinmarketcap API key to get the free data Not sure if I should use scripting or pay for DataFetcher account Hoping someone can help Thanks in advance, Paul

102
P
K
Karen-airtable_New Participant
posted in Development & APIs
Zapier error: "Could not find field "fields" in the request body"

I am trying to create a new contact record in Airtable using Zapier - linked to Hubspot. This should be really simple but I get this error: “Could not find field “fields” in the request body” When searching in community, this suggests a cdoding error in the API request - which suggests to me the Zapier-Airtable API is not set up properly \nd I cannot change this. I am not a techie - all solutions welcome!

42
R
P
Pradhumna_PanchNew Participant
posted in Development & APIs
Seraching according a feild in Airtable

Hi everyone, I am writing a micro-service where I want to accept a field, look for its record, and return with data from its record. Ideally, I also want to make it not case-sensitive. But I am having multiple issues with it. Firstly, unwrapping the string is “SELECT” is not working for me. It works if I just pass a string but not when I try to unwrap a variable (according to a solution I found on this forum. Secondly, how do I make it not case sensitive? is this possible if I have to write something custom (as in fetching everything and manually search through). Here is my current code. export const getDefinition = async (userInput: String) => { console.log('this is from getDefinition!!!', userInput) //configure Airtable// Airtable.configure({ endpointUrl : process.env.AIRTABLE_URL, apiKey: process.env.AIRTABLE_API_KEY }) const data = base(process.env.AIRTABLE_TABLE_NAME).select({ filterByFormula : `{term} = "${userInput}"` }).eachPage((records: any, fetchNextPage:

00
P
E
Ezra_ButlerNew Participant
posted in Development & APIs
Trying to update linked field in automation scripti

I’m trying to write a script for an automation that creates a list of all the companies which bought a certain material. (input.config() has two variables: materialUsed and recordID) However, I want the output pushed onto the Contact field which is in the record (which itself is a link to the “Companies” table). In short, when I add a new record, I want the Contact field to autopopulate with the links to all the relevant companies. The output.set displays an array of the correct companies, but I can’t seem to figure out how to push each of the results using the updateRecordAsync(). Thank you. // query for all the records in a table let table = base.getTable("Companies"); let searchPO = base.getTable("SearchPO"); let materialsBought = table.getField("Materials Bought") var material = input.config(); let result = await table.selectRecordsAsync(); // print ID & "Company" from each record: let records; records = result.records.filter(record => record.getCellValue('Materials Bought'

11
Grunty
J
J_MaiInspiring
asked in Development & APIs
How can I do a basic lookup on Airtable using Node js?

Hi everyone - I’m a total beginner to Node js but it’s very frustrating, that after hours of searching on Airtable Docs as well as through the community, I can’t seem to find the answer to one of the most basic things a user would want to do with a database. In short - I’m trying to do a lookup. Given a “phone number” of “(454) 382-9029”, I want to return the “Full Name” of “Carol Lerner”. I want Airtable to access the right record and the code to print the “Full Name”. In Excel this takes 2 seconds to do. I’m at a loss why this has been so difficult to find code for on Airtable Docs or Community on Node js. I know that I’m a beginner. I’m not sure why it’s so difficult to see how to do something like this. My code won’t really be of much help here as I keep getting errors when I try to run it. Thanks for taking a look and hope you can help.

976
B
N
Noah_ColemanInspiring
asked in Development & APIs
Use string variable for table.updateRecordAsync

Is there a way to tell table.updateRecordAsync what field to update with a variable? I have a table that tracks the date a person receives multiple trainings. Each training has a date field. I’m able to hard code the field in table.updateRecordAsync, but I haven’t figured out a way to do it with a variable, even a string type variable. This would allow me to have one script where one could select the training to update, rather than a script for each training. Here is my code: await recordTable.updateRecordAsync(record,{ '*INSERT VARIABLE HERE': date }); I also tried using the usual javascript way of inserting variables into strings like this: await recordTable.updateRecordAsync(record,{ `${fieldString}`: date }); This just gives me lots of errors.

132
N
O
Operations_KahoNew Participant
posted in Development & APIs
input.fieldAsync with view

I am following from API documentation. This is to capture selected fields. let table = base.getTable("SP1: Donations"); let field = table.getField("CID"); output.inspect(field); But what I wanted was to show fields specific for the selected view. I currently select view via: let view = await input.viewAsync("Messages will only be sent to records in this view", table);

142
N
M
Maximilian11New Participant
posted in Development & APIs
Custom App not working on other computers after release

Hi there, I developed a custom app/block and released it into it’s base with “block release”. Sadly it’s only working correctly on my own laptop but not on any other laptop, even with my account logged in. The app shows data in a diagram with the packages “apexcharts” and “react-apexcharts”. On any other laptop the bars in the diagram are not displayed correctly. The data is loaded and it tries to plot it, but all data are just crammed together at the axis not displayed correctly. The libraries seem to be loaded as it’s not showing nothing. I guess there must be something missing in the “released version” that is cached on my own laptop. I tried to delete the browser cache but it is still working on my own laptop. I’m a bit stuck and don’t know how to start to debug this. Any ideas what could possibly go wrong during the “release process”? Note: It works on my laptop even when “block run” is not executed so I should be running the exact same released version than the other laptops wher

42
M
N
Noah_ColemanInspiring
asked in Development & APIs
User input a Date

Is there a way to have a user input a date in a script? I have a button that adds today’s date, but I’d like to give an option to add a custom date, just like in a date field. Text input seems kinda iffy.

131
N
B
BtbmlInspiring
posted in Development & APIs
Chrome Extension - Modify CSS?

I was hoping to create a simple chrome extension to plug in that would load a different css for airtable. This would have been my way around a feature request that has been forgotten. My end goal is that the table header row is 2 lines tall. A secondary goal would be if the width of a column is <x, then text orients vertically. Where I’m getting stuck is that after 1/2h of using inspector in chrome I was finally able to get the header row twice as tall, but text wouldn’t wrap to 2 lines and I’m wondering if this is as simple as a CSS switch or if I’m dreaming.

20
B
C
Carlos_CardonaNew Participant
posted in Development & APIs
Scripting - AWS CLI

Has anyone been able to use AWS CLI as part of a script ? I want to user services like aws comprehend , aws polly and transcribe as part of a Script.

00
C
E
Eugene_KimInspiring
posted in Development & APIs
How to store sensitive data (e.g. API keys)

Hello, Is there a recommended approach to saving sensitive data e.g. credentials retrieved from a user logging in to a third party service? I’ve seen multiple topics created regarding this issue and they were never answered and automatically closed :frowning:

31
D

Badge winners

  • Welcome
    YvonneHhas earned the badge Welcome
  • First Topic
    Dwalz3has earned the badge First Topic
  • Welcome
    Dwalz3has earned the badge Welcome
  • Certified Airtable Admin
    nitinjainhas earned the badge Certified Airtable Admin
  • Certified Airtable Admin
    CaitlenBerghas earned the badge Certified Airtable Admin
Show all badges
Terms & Conditions