Development & APIs

All this goofy 3rd party stuff to do a front end why doesn’t Airtable just buy Softr and be done with it? A unified cooment view like Slack would be good as well.

Hello, I'm having an issue with getting anything back when sending a post request.Using Voiceflow to integrate into airtable.com The objective is for a patient/customer to be able to change their email and have the bot do it for them if the bot recognized that their email was different but first name, last name, number, etc were the same. There is no error, I'm getting a 200 back but the response is [] or emptyThe fields are filled out and I checked capitalizationScreenshots are below, any help would be appreciated.I checked the base ID and table for the API call and its correctI've tried just using a filterbyformula in a get request and it does the same thing and returns a ok 200 and empty response.

Hi everyone (reposting to correct category) I've created seemingly simple Zapier automations (zap) to bring subscription data into Airtable by creating/updating records in a Base table. While Zapier indicates success sending data to Airtable, no data shows up in Airtable base and table. I've been troubleshooting without success, so seeks suggestions here. Any thoughts are welcome! Zapier is connected to Airtable. I know this because I have another zap that works well with no issues to send the same source data to a different Airtable table in the same base. Also, I've confirmed that Zapier is "on" as a third-party app in Airtable Integrations. I have paid subscriptions to both platforms. In Zapier, I have not reached my task or zap limits, so that's not the issue. In building the zap in Zapier, the appropriate Base, Table, and fields in Airtable are available to select. Zap History shows success every single time. I use the Find Record in Airtable action to first seek for existing reco

I am trying to create a google App Script, which contains columns mapping to an Airtable table. I would like to sync one-way from the Google Sheet, into Airtable. The first column is the primary key, and is used to match. If the record exists in Airtable, it will update. Else, it w ill create a new row. I am trying to execute the below function, to find out if the record exists already by primary key value (Note - NOT record ID). function upsertAirtableRecord(apiKey, baseId, tableName, primaryKey, fields, primaryKeyFieldName) { var url = 'https://api.airtable.com/v0/' + baseId + '/' + encodeURIComponent(tableName); // Search for the record to update var searchUrl = url + '?filterByFormula=(' + encodeURIComponent(`{${primaryKeyFieldName}}='${primaryKey}'`) + ')'; var options = { method: 'get', headers: { Authorization: 'Bearer ' + apiKey, }, }; This is returning an error: Exception: Request failed for https://api.airtable.com returned code 403. Truncated server response: {"error":{"type

I am currently developing an integration with airtable base.It is very nice to have webhook notification from airtable api. 1. How to respond properly to the notification? Once the record changes, the notification works via webhook.But it repeated more than once and I want to know how to stop it after receiving the first notification. 2. How to clear payloads that already received? When the record changes with the attatchment field, there are two or more payloads for it. Here is a response data of payloads. { "payloads": [ { "timestamp": "2025-02-05T15:24:39.621Z", "baseTransactionNumber": 300, "actionMetadata": { "source": "client", "sourceMetadata": { "user": { "id": "usre3JyKUosldgaGX", "email": "antman357357@gmail.com", "permissionLevel": "create", "name": "Ant Man", "profilePicUrl": "https://static.airtable.com/images/userIcons/user_icon_8.png" } } }, "payloadFormat": "v0", "changedTablesById": { "tblwMVvp1SgnOFZk1": { "changedRecordsById": { "recxXhNCq9lGKFURL": { "current": { "c

I had no idea what to call the subject for this post..... I want our company to donate £5 per 100 confirmed hours worked on site, to purchasing trees via ecologi. On the 5th of every month, I want the airtable to add up the total number of confirmed hours worked in the roster for the previous month. This number is to be divided by 100 with the result being x. x may be rounded up (optional at this stage), then the total amount is to be sent to our ecologi account using a webhook to zapier. Any leads onto how best to sum up the previous months totals please? Pro's and cons to watch out for?

Hello, With the API custom with a filterbyformula, I would like to collect all record, corresponding to my needs, from two differents fields. “Conversation?filterByFormula=%7Bexpediteur%7D%20%3D%20%27${user.email}%27” Like, in this case i would like to get all records into “expediteur” field where {user.email} corresponding. But now in my case, I would like the same but into two fields. (expediteur & destinataire) is it possible ? And how to write that ? Thanks you

I must be missing something very fundamental. I converted Airtable's sample extension into my own, and it's running beautifully over localhost:9000, displaying as an extension in my sample base, as you can see below. Everything functions when I check "simulate marketplace extension" But when I try submitting it for review, running "block submit" from the root (same place I run "block run" from) I got this: What permissions is it talking about?! What is the "requested model"? It's my own Airtable account, own workspace/base etc--and the code runs locally. What am I missing? Thanks!

Hello, I am trying to create a web app using Airtable and Softr. I have already created a fully functional application, but now I want to scale it so organizations can create their own profiles and customize them as they like without affecting other users. I am thinking of creating separate databases for all organizations and connecting them with a central database, similar to how we do it in native PostgreSQL. However, I seem to be stuck with Airtable. Can anyone help me achieve my goal?

I did a quick search and couldnt find what i am looking for so i apologize if this has been asked and answered already. I have a Word Press site using the Airpress plugin to pull data from one of my bases. Everything is working as it should but i am trying to figure how to input the airpress shortcodes into the header of my virtual pages for metatags. Has anyone been able to do this using Airpress? If not, is it possible, using the API, to build a custom template that will use airtable data for metatags? Airpress shortcodes work great in the body and so far it has done everything i need it to do except this.

I have this code that works well when filtering a field that is SIngle Line Text empName="Dummy Employee" let records = query.records.filter(record => record.getCellValue("Name") === empName); But If i want to filter a field that is a "Link to another record" field, it will not find it. let records = query.records.filter(record => record.getCellValue("Linked Name") === empName); I have a work around where I have a formula field that converts the value in the field "Linked Name" to a string, but i would like to tidy it up. Has anybody encountered such an issue? Thanks in advance

Hello Airtable Community, I am trying to upload an image via Base64 encoding using Airtable’s uploadAttachment API, but the uploaded image appears as a broken placeholder or a very tiny image instead of displaying properly. 🔹 My Setup: Using Base64 encoding instead of a direct file URL. Posting via API to Airtable’s /uploadAttachment endpoint. The request is successfully received by Airtable, but the image does not display properly. 🔹 Payload I’m Sending: { "contentType" : "image/jpeg" , "file" : "BASE64_ENCODED_STRING_HERE" , "filename" : "example.jpg" } 🔹 What I Have Tried So Far: ✅ Verified the Base64 Encoding Tested the Base64 string in an online decoder → it renders correctly. Confirmed the Base64 string is complete (not truncated). ✅ Checked API Response Airtable successfully processes the request. The returned JSON includes a url for the image, but it does not display correctly. ✅ Attempted Fixes: Tried adding data:image/jpeg;base64, before the string → Same issue. Trie

Hi,I have a problem with the release of my extension.The application works fine in development mode after block run.I wanted to switch to release, but after using block release I get the following errors patrykjachym@MacBook-Pro-Patryk obliczanie_transportow % block releasebuildingcopying package.json filecopying package-lock.json fileinstalling node modules[npm][npm] added 107 packages, and audited 108 packages in 862ms[npm][npm] 7 packages are looking for funding[npm] run `npm fund` for details[npm][npm] found 0 vulnerabilities[npm] npm warn config production Use `--omit=dev` instead. ❌ Error: npm warn config production Use `--omit=dev` instead.Failed to build the block code!patrykjachym@MacBook-Pro-Patryk obliczanie_transportow % My package.json { "dependencies": { "@airtable/blocks": "1.8.0", "airtable": "^0.12.2", "react": "^16.13.0", "react-dom": "^16.13.0" }, "scripts": { "lint": "eslint frontend" }} using node 18.20.4, but also trying differentiate version.

I am receiving the below error; O: Can't create field: invalid field config. Creating or updating options for longText fields is not supported at this time. at main on line 31 Can Airtable not support creating a Long Text Field? I might be missing something; let table = base.getTable("Report"); // List of fields to duplicate, with their types let fieldsToDuplicate = [ { name: "Act Name - GA 1", type: "singleLineText" }, { name: "Additional Comments - GA 1", type: "longText" }, { name: "Guest Artiste Show - GA 1", type: "multipleRecordLinks" }, { name: "Versatility - GA 1", type: "rating" }, { name: "Guests Socialization - GA 1", type: "rating" }, { name: "Audience Engagement, Adaptability - GA 1", type: "rating" }, { name: "Material Quality, Originality - GA 1", type: "rating" }, { name: "Professionalism and Reliability - GA 1", type: "rating" }, { name: "Adhere to Dress Code - GA 1", type: "rating" }, { name: "End of Show Audience - GA 1", type: "percent" }, { name: "Start of Show Aud

Is there already docs or complete process on how to use airtable webhook api to bubble? Like if the data is created in airtable it will call a backend wf then viceversa in bubble.io to airtable.

I tried posting this question yesterday but now I can't find the post so it looks like it didn't actually get created so I'm trying again. I've been tasked with creating an interface to our AirTable data using an API developed by Brightvine (Brightvine Data Link). I can get back all the data using the API interface but I need to be able to pass in the last date the process ran on our end and get only those rows created since the last run date/time. The BVDL gives me a place to enter URL parameters and I've tried using the "filterByFormula" option but I keep getting an invalid formula error. The BVDL gives me access to the last run date/time in a couple of different formats when creating a parameter. Any suggestions will be greatly appreciated. Thanks, Ray Porter

Hi Team, Has anyone successfully integrated Data Cloud with Airtable? I have followed all the steps provided on the Salesforce website to set up the integration but have encountered the same issue described below. @Patrick_Baker a community member, also faced a similar challenge while attempting to integrate Data Cloud with Airtable and was stuck at the same step. I am currently experiencing the same issue. You can refer to the communication thread for more detail. https://community.airtable.com/t5/automations/linking-airtable-to-salesforce-data-cloud-using-the-beta/m-p/199422#M19337 It would be greatly appreciated if someone from the community who has successfully completed this integration could share the steps. Thanks in advance.

I got a MAKE scenario that reads AT. It runs fine. I copied the table and the scenario now does not run (even with no changes whatsoever to the table). All I've done is point the AT module to the copied table. The message I get in Make is: The operation failed with an error. [422] FAILED_STATE_CHECK I reached out to Make support, and they couldn't find anything wrong. Said the error is on the AT side. Here is the RAW log you can share with them: { "response": { "status": 422, "headers": { "date": "Fri, 20 Oct 2023 06:31:56 GMT", "content-type": "application/json; charset=utf-8", "content-length": "39", "connection": "close", "set-cookie": [ "AWSALB=+U/EsIQfxdZeyUoDQl+1r19+X5XkdL82tLil64/Jgo08nrwzQo5NDPOXKpZfbCW78HVOANgC8mbKspTE+D0UFvzZyCoaIwYP8L0v5MQh0yZhuQKnyG9IL2P1Iqbg; Expires=Fri, 27 Oct 2023 06:31:55 GMT; Path=/", "AWSALBCORS=+U/EsIQfxdZeyUoDQl+1r19+X5XkdL82tLil64/Jgo08nrwzQo5NDPOXKpZfbCW78HVOANgC8mbKspTE+D0UFvzZyCoaIwYP8L0v5MQh0yZhuQKnyG9IL2P1Iqbg; Expires=Fri, 27 Oct 2023 06:31:

Hi :slightly_smiling_face: I am building portfolio database for crypto trading. In my base I want to have live coin price, so I can track movement from current price and the price at which I initially invested. There are few websites that support API, but I am not sure how to use it and if that can be done. Is that possible to achieve, if yes can you please help me do it? Also, I am on Pro plan on Airtable. Thank you for your time.

Seems to be working fine previously but now when I am making consecutive calls with remoteFetchAsync, I get `TypeError: Failed to fetch` after the 1st, 2nd or 3rd request. Is there a change in behaviour in a recent release? Code example: ``` for ( let invoice of requests ) { let response = await remoteFetchAsync ( ENDPOINT_URI , { method : 'POST' , body : JSON . stringify ({ 'invoices' : [ invoice ] }), headers : { "Content-Type" : "application/json" , "Accept" : "application/json" , }, }); // Wait for 0.2 seconds before the next iteration await sleep ( 200 ); } ```

I am trying to receive party size data in my airtable for an integrated bland.ai voice assistant. If I remove the party size record in the airtable module, everything goes through smoothly but it is only party size that brings up this 403 error. Can you give me some insight on how I can resolve this?

Is it possible to list views from the web api using oauth? I know make.com and zapier have this functionality, but according to the dev docs it seems like this shouldnt be possible. I've done this using access tokens for enterprise but I want to implement this functionality using oauth.

I am looking into the possibility of using AirTable as a back end data repository for some of our data. In order for this to work, I'd have various event triggers accepting data fields and using that data to create or update an Airtable base/table using REST API calls. The goal is to replace some existing back-end that is stored in a SQL Server database. One aspect that I'm not sure to handle is preventing concurrent changes. If, for example, I have multiple changes happening to a record that could possibly be processed at near the same time, I need to make sure that the newest value "wins". The way this works in the current service is as follows: Before sending an updated value to the back-end via its API, a service gets the current value and compares the current value to the new value and only calls the API if one or more fields changed As part of getting the current version, the service gets the version value of the row (implemented as a rowversion in the SQL database, but I've seen

Hi everyone, I’m trying to update the list of select options in the column Categories_test in an Airtable table using the API. My request seems to be correctly formatted, but I keep getting an error response from the server. I would appreciate any guidance on what might be wrong. Here are the details: PATCH Request: Endpoint: PATCH https://api.airtable.com/v0/meta/bases/{baseId}/tables/{tableId}/fields/{fieldId} Request Body: { "type": "multipleSelects", "options": { "choices": [ { "name": "test" }, { "name": "blabla" } ] } } Headers: { "Authorization": "Bearer [ANONYMIZED_API_TOKEN]", "Content-Type": "application/json" } Server Response: { "error": { "type": "INVALID_REQUEST_UNKNOWN", "message": "Invalid request: parameter validation failed. Check your request data." } } What I’ve Tried: Verified that baseId, tableId, and fieldId are correct (confirmed via API). Confirmed that the Categories_test field is of type multipleSelects (checked via API). Tested the request in both Insomnia a

I'm looking at using airtable to use as a database for my startup as airtable provides simple implementation and data management features that make setting up data management simple. However there is one blaring issue that makes this difficult and that is the fact that you cannot set an exact number to offset your search by. I can work around the fact that you can't directly search by linked records by id or other parameters and have to use lookups and formulas to make this happen but not being able to offset makes me consider using another service. If you could setup something like this you could be very popular with startups as we need something quick simple and powerful to get our MVPs up and running quickly so we can test the market.