Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,656 Topics
  • 11,709 Replies
3656 Topics
C
Christos_KonteoNew Participant
posted in Development & APIs
File Name generator

Hi everyone, we are interested to use Airtable as a database for video classes that we produce. Is there an already built app or script that can generate unique filenames using fields in a table? Our reasoning is we want to fill out a form that once submitted will generate a file name, we will rename the file accordingly and keep it in our database. Then at a later time we can search with the appropriate criteria and get a list of filenames that we can easily search on our local drive. Please let me know if something like this exists. Thank you for your help

231
kuovonne
M
Mathias_ElmoseParticipating Frequently
asked in Development & APIs
Create multiple linked records with a button

Hi I would like to be able to create multiple linked records in one “run”. I do a lot of videos for lectures and have a base has with a “productions” table and a “projects” table. I want to be able to add a button in the “projects” table that runs a script the script should ask me how many new records to create in the “productions” table. and then create the records linked to the project This would help me when 1 projects has 30 productions. And because a higher demand for remote learning I get many request for many videoes - so time saved on place it time used in another:) Thanks!

4211
Adnan_Ahmed
M
Matthew_MoranInspiring
posted in Development & APIs
Run Script on field change

I didn’t see this discussed but it seems like something that would be extremely valuable. Is there a way to run a script upon leaving a field or when a field value changes?

307
kuovonne
1
111226New Participant
posted in Development & APIs
The issue of appearing Extension name in file name when they transfered

Why my files on google drive come with an extension (jpg)? I don’t want to see these in my files. when they transferred to airtable using integromat they come with also. it’s a big issue in matching these names. how to avoid this issue guys?

01
Justin_Barrett
S
Suresh_MurthyNew Participant
posted in Development & APIs
Add decimal via api

I am trying to add decimals with 5 or more decimal places. i used the currency field but i cannot add the data via api. the value here is “gains”=>“0.00072333333333363115” i get error Airrecord::Error (HTTP 422: INVALID_VALUE_FOR_COLUMN: Field “gains” cannot accept the provided value)

146
dilipborad
P
Pawel_KarpielNew Participant
asked in Development & APIs
Airtable metadata API update

Hi! I couldn’t find any informations about extending the existing Metadata API in a way, so there would be a possibility to update the structure of the bases, fields and so on through the metadata API. Let me describe myself better, what I mean by that. I had an occasion to work with Salesforce for some time. This is also a low-code platform, where instead of writing code whenever there is a repetetive task, you can do that by draging or clicking. Everyone knows the benefits of low-code platform, so I won’t be talking about that here. When using low-code tools like Airtable or Salesforce, everything is wonderful in developing stage, we can do that much faster, we have ready made API we can connect to other tools really fast, but when we finally go live with the MVP of the product and we have real users who uses the application we made, we would rather perform future developing and testing on some dev/test environments. Of course we can do that, but current way is just bad. When we fina

150
P
O
Olivier_PichonNew Participant
posted in Development & APIs
Can I create a custom API endpoint

I want to create an API end point to delete records based on a user_id (or any field other than the records’ id). In other words, the equivalent of SQL DELETE FROM {table} WHERE user_id = {x}. Airtable’s built-in API only allows to delete records based on their ID, not on any other field. Is this possible?

42
kuovonne
R
RIck_AllenInspiring
asked in Development & APIs
Script to get the first nine characters of a field

I’m hoping to get the first 9 characters of a record into another field. Id normally just make the field into a formula and use Left({product},9) but the rest of the automation wont run on the formula field. Please help.

324
Justin_Barrett
M
Mariusz_SInspiring
posted in Development & APIs
Return from Async Function

I have a code that looks like this: await createPackage(oderSummary); async function createPackage(oderSummary) { let pickPosition = true; let lineItemsArr = []; const r = Object.keys(oderSummary[0]).map((v) => ({ [v]: oderSummary.map((c) => c[v]), })); let tableItem = [...r[2]["Pozycja"]]; while (pickPosition == true) { let pickItem = await input.buttonsAsync( "Pick order to pass", tableItem.map(String) ); let filteredOrders = oderSummary.filter( (item) => item.Pozycja !== Number(pickItem) ); let difference = oderSummary.filter((x) => !filteredOrders.includes(x)); tableItem = tableItem.filter((v) => String(v) !== pickItem); lineItemsArr.push(difference[0]); oderSummary = filteredOrders; if (pozycjaTabeli.length) { let shouldContinue = await input.buttonsAsync("Dodac Nastepna?", [ { label: "Yes", value: "Yes" }, { label: "Cancel", value: "Cancel", variant: "danger" }, ]);

22
M
M
M_m_Non_Baby_s_New Participant
asked in Development & APIs
Get records by view, but records with wrong order are returned

I use the following request to get list of records by view. In this view, records are sorted by id DESC. But the API returned list of records, which are sorted by id ASC https://api.airtable.com/v0/mybasekey/mytable?api_key=my_key&view=my_view This problem just happened in today. Please help me to resolve this problem.

35
Richard_Sinn
T
TalNew Participant
posted in Development & APIs
Using OffscreenCanvas in a script

Hello, I’m trying to do an automation for a project of mine where it takes two images, overlays one over the other, and then saves the result to a new field. I have tried to use OffscreenCanvas as well as a simple Image object. However, I get a cannot find name error for both. I am aware of the limitation on the DOM API, but both of the APIs are not a part of the DOM API. Any ideas why I get this error? Or maybe an idea for a different solution?

00
T
Burner
BurnerKnown Participant
posted in Development & APIs
How to create a linked record in a different table via Zapier

So let’s say I have two tables, (1) People and (2) Companies. I’ve created a form view in the People table, which has the following fields {First Name}, {Last Name}, and {Company}. What I’d like to have happen is that when a user fills out this form, the {Company} value is not only created in the People table, but also in the Companies table as linked record so that this person and the company in the Companies table are a linked record. I would use Zapier for this, but I don’t know how to configure the Zap to get them to be linked as opposed to just creating an isolated record in the Companies table. Any help would be much appreciated. Thanks a ton.

112
Burner
N
NhrtNew Participant
asked in Development & APIs
Bulk PATCH 10 entries via Google App Script

Hello! I am trying to sync prices and stocks for several products between Google Sheets (source) and Airtable (destination). Thanks to other posts’ answers in this community I could make a script that updates products one by one. But I would like to reduce the number of requests by adding 10 products at a time on a single request. I tried several things but I cannot make it work. I guess it’s related to the way the script parses the data. Here is a simplified version of the script covering only 10 products: function bulkSendData() { const url = "https://api.airtable.com/v0/XXX/"; const dataSheet = SpreadsheetApp.getActive().getSheetByName("XXXSheetName"); var productsData = []; //Step 1 get the data on Google Sheets for (r=2; r<11; r++) { var singleRecord = { "id": dataSheet.getRange(r,1).getValue(), "fields": { "Cost": parseInt(dataSheet.getRange(r,2).getValue()), "Stock": parseInt(dataSheet.getRange(r,3).getValue()) } } pro

72
N
S
Sikander_KhanNew Participant
posted in Development & APIs
EACCES permission denied during block initialization

This is the command that I ran to access the app and get it running on my computer- block init appiRmFlQxTjGB2Un/blksvlnJt2mRtaQ4V --template=https://github.com/Airtable/apps-summary proportion After I entered the API key, it shows the following error- API key saved to /Users/shahzinakhan/.config/.airtableblocksrc.json. To update it, use ‘block set-api-key’ Initializing block using GitHub - Airtable/apps-summary: Summarize numerical data as averages, ranges, and more. template Error: :x: EACCES: permission denied, mkdir ‘proportion’ How do I set the appropriate permissions to get this running? Thank you.

31
Justin_Barrett
R
Ryo_KonishiNew Participant
posted in Development & APIs
Retrieve a record by fields

Hi, I’ve been working on a Next.js app with Airtable. I’m trying to retrieve a single record by specifying the field (not reocrd ID provided by Airtabe). I refered to the document below, but it only mentions the way of doing it by the record ID. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. The code below is working fine, but I’d like to get a record by the specified column (eg. where “user_id” = 987813 ). //export const getServerSideProps = async (context) => { export async function getServerSideProps(context) { let todos = await table.find('rec1PDbe0ww22feo3'); return { props: { initialTodos: getMinifiedRecord(todos), }, }; } Thanks,

862
R
V
Vincent_NgNew Participant
posted in Development & APIs
Development vs Production Bases?

For those of you that develop application using Airtable, how do you manage dev vs prod? My application as a UI to display data from my application. Thus it is essential that I separate data uploaded during development vs production. Currently, I copied a base, named it as “Dev”, and store the base key in my dev settings. However, I need to manually update my dev table whenever my users make structural changes to our prod table (such as adding or removing a column). Has anyone figured out a way to deal with this?

81
L
O
Ollie_McNaught-New Participant
posted in Development & APIs
Output.table is not a function? Using for email automation

Hi I have essentially copied the tutorial here as I didn’t need anything too far from this solution Adding it all up | Airscript I have got it working and I would like to put it into an email automation. The script works and it aggregates on the values I need; it produces an array with 2 objects with key value pairs in it. This seems to meet the requirements for an output.table; however when trying to use the output function, it appears that only output.set is available. Is this the only option when using scripts for emails? It would save me time if I could just have it output a table. Am I missing something or is this a limitation when using scripts for emails?

111
kuovonne
J
Jared_ThomasNew Participant
posted in Development & APIs
Simple Java API implementation

I’m trying to implement a simple Java implementation using the Airtable API. I only need to update a cell in a table. Unfortunately, I’m having hard time getting this to work properly and I have been unable to find any help across the web other than the AIrtable github for the API that was last updated 3 years ago. Does any one know of some sample code or tutorials that show a simple implementation of the Java API? Any help would be greatly appreciated!

60
J
O
Oliver_WeedonKnown Participant
posted in Development & APIs
Finding gaps by comparing one table to another

I need to write a script that queries one of the tables in a base (a list of credentials as a junction table that brings together names and credentials against a certain date), then looks for missing records (of credentials) against another table and outputs a list of those who are missing credentials. I’m completely new at scripting and have just started to learn a bit of JS to try and get started. Please let me know what info you need from me and I’ll try and provide it. Many thanks in advance.

44
O
Andy_Cloke
Andy_ClokeKnown Participant
posted in Development & APIs
useSession dangerous when running app in a universe base

I noticed useSession can return null/undefined when running an app in a base in the Airtable universe. This can cause fatal bugs when code relies on it not being null. It might be worth making a note of this on the docs Airtable Blocks SDK and making the TypeScript type nullable.

00
Andy_Cloke
B
Blake_RamageNew Participant
posted in Development & APIs
One click changes a field and downloads CSV

Hi there, I’m wanting to create a short workflow and I’m wondering if a Script is the way to achieve it. I’m using Airtable for website orders and would like an automation where in one click two things happens: The field “Status” is changed to “Processed” for all items in the particular view A CSV immediately downloads all items in that view. Is this possible with a Script? Many thanks! Blake

31
Justin_Barrett
D
Davut_JepbarovNew Participant
posted in Development & APIs
API is synced with localhost but not in the website

Hello, I am using a free version of Airtable. Airtable is synced in my local, any change that I do to my base can be seen in the localhost. but when I check it from the website I can’t see the changes am I missing something? Or do i have restrictions because of the free plan? Thanks

21
Justin_Barrett
E
Eric_TaylorNew Participant
posted in Development & APIs
Uptime and SLA?

Hi, we use airtable as part of a customer-facing, mission-critical flow of information. Airtable receives information from system X, is manipulated in Airtable, and then our end customer sees status in system Y. Question: does anyone know Airtable’s SLA for uptime? I have noticed several downtimes in the past month, and I have concerns about Airtable’s viability. We used Airtable because it was the fastest way to get a database with an editable frontend built. But if we can’t rely on something like 99% uptime, we will need to consider building internally ourselves.

182
A
L
luannieNew Participant
posted in Development & APIs
Sharing Airtable Scripts

Hey everyone, I’ve been learning how to write Airtable scripts and came across a base which contains scripts used internally by Airtable and the community. Thought it’d be nice to turn it into a little repository using Pory and continue curating scripts from this forum. Here’s the live site. Feel free to submit your working scripts to the community! Feedback appreciated :slightly_smiling_face:

123
C
O
Orin_HutchingsInspiring
posted in Development & APIs
Were the "Multi Select" and "Linked Record" field type formats changed to an Array?

It used to be you could add a comma delimited line of text such as “Car, Tree, Fish, Dog” to a Multi-Select field type, and it would separate the values. When passing that data from one app to another, keeping that same format caused no issues. Now it appears the Multi-Select field type, as well as other similar field types, are in an Array format. When trying to enter comma-delimited values, it no longer separates them. Has this recently been changed? If so, what is the correct text format to pass the data into Airtable?

84
O

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