Development & APIs

Hello,I think I'm at my limits with trying to get Airtable to function as we really envisioned.  Anyone know the best place to find Airtable consultants with likely programming abilities?  A few of the things we really wanted to do were:1. Create a custom form that goes to contacts and their selections would filter back into our main table but this needs to be very limited with selections as certain items we code on contacts are internal only.2.  A mass emailer.  We use Airtable as a giant database for our independent contractors and code them by areas they cover and preferences.  We have Zapier and an external operations system and would love the ability to integrate all so that we can send a mass email to a designated list of names/email addresses based on a filter that looks nice and inputs the key job data available from our operations software (SQL Server database).  Have struggled with this one and even though we have the Stripo HTML email created it

HeyI am using Postman to make an API call from Airtable to list all 14,000 of my records to store in a variable and pass onto voiceflow.This is my pre- request script: function getAllRecords() {const url = 'https://api.airtable.com/v0/baseID/tableID';let records = [];// First requestrequestAirtable(url, null, function(initial_response) {records.push(...initial_response.records);let offset = initial_response.offset;// Handle pagination recursivelyfunction fetchNextPage(offset) {if (!offset) {console.log(`✅ Data Fetch Complete! Total records: ${records.length}`);pm.environment.set("voiceflow_data", JSON.stringify({ fields: records }));return;}requestAirtable(url, offset, function(response) {records.push(...response.records);fetchNextPage(response.offset);});}fetchNextPage(offset);});}function requestAirtable(url, offset, callback) {const api_key = pm.environment.get("AIRTABLE_API_KEY"); // Securely store API keyif (offset) {url += `?offset=${offset}`;}const options = {url: url

Hello!I'm using the API extensively in powersave to create and update records.New records is created via `POST` and the attachment array gets processed just fine.But then, when a record is updated via `PATCH` the previous attachment seem to get partially corrupted. They can still be opened and viewed in full size but none of the thumbnail are available.I tried to send back the attachments in various formats:{ id }{ id, fileName, url }{ id: fileName }It seems to happen in all cases.Is there any way I can prevent this? Thanks a lot! 

When you turn on the Rich Text Formatting option in a Long Text Field, you are limited in the Page Design Block. First of all, it is not possible to change the typefont, neither is it possible to change the font size. It is understandable that you cannot make the text bold, italic and so on, because that is what you do in the field itself. But, the font size and fonttype can not be change in the field itself. So, what is it gonna be: add features in the Long Field, or add them in the Block area? Regards, André

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.comThe 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 re

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 will 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

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", "pr

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 EncodingTested the Base64 string in an online decoder → it renders correctly.Confirmed the Base64 string is complete (not truncated).✅ Checked API ResponseAirtable 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 t

 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 errorspatrykjachym@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 1

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 31Can 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

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.

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#M19337It 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_CHECKI 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/EsIQfxd

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