Development & APIs

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)

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 j

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?

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.

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: "dange

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.

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?

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.

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.getRa

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.

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

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?

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?

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!

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.

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.

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

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

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.

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:

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?

Hello! I have two linked tables, let’s say Users and Events, and the Events table contains an Attendees column that links to Users. I want to add a new value to this column using the API. The code is quite simple: await eventTable.update(eventId, { Attendees: [userId] }); But this overwrites the previous attendees. Can I just add one new value to the cell without overwriting the previous ones? I know I can read the previous values manually, add the new one and write the whole array back – but that’s a race condition waiting to happen, isn’t it? Is it possible that someone changes the value after I read the previous contents and before I write the new, augmented value?

I would like to be able to determine which table a linked record exists in so that I can parse metadata and apply appropriate data conversions. Am I missing something here?

Hi. I’m trying to figure out how to use your API. What I need to do using the API endpoints is the following: Send a request to create a user (record/row) in a table Then create a Gallery view named as the user’s name Generate a “share view” link/embed code with an active filter. Is this something that is possible to do via the API? Thanks, Andriy

Hey Community, I’m hosting a FREE live master class next Thursday on how to query Airtable using SQL. Sign-up and learn the best tools to use (plus some basic SQL) to derive proper insights using your Airtable data. Click to register… :nerd_face: ! techiechic.co