Development & APIs

Hi everyone,We’re a creative/production agency and over the last few years we’ve progressively evolved from using Airtable as a simple operational tool into building a much deeper internal management system.Today we have an ERP-style workflow in Airtable for Purchase Orders: Purchase Orders (POs) Invoice receptions Payment tracking Approval/payment status flows Linked operational and financial information The system is working well operationally, but now we’re trying to solve the next layer:connecting our Airtable PO system with the Google Sheets budget file of each project.Each project has its own Google Sheets budget where production teams manage budget allocations and spending. What we want is to create a bridge between: structured financial/operational data in Airtable and the budgeting workflow inside Google Sheets Our goal is:when someone imputes/allocates an expense in the budget sheet, that expense should always be linked to an existing PO from Airtable.We’re currentl

I have a use case where I am trying to store email chains in a rich text enabled field. My users would like to preserve the formatting + as much detail from the emails as possible. The native supported markdown capabilities for the most part cover formatting, however I’ve run into a bit of interesting problem with embedded tables. For whatever reason, Airtable’s rich text doesn’t support markdown tables so there seems to be no clean way to do this. I’ve come up with a somewhat hacky solution of converting to ascii tables and embedding it as a code block, but even this get ugly once the table is wide enough to push past the view window of the rich text field (it’s not resizable), which causes the text to start wrapping on the next line. I’m wondering if anyone else has had a similar use case, what they did to work around these limitations, and if I’m missing something/should be taking a different approach? Any input is appreciated,Thanks.

I want to make a custom interface dashboard page that has a more flexible grid layout, but I want to  develop all the interface elements that could populate that layout as individual custom interface elements. E.g. I click a ‘+’ icon in a block of my custom dashboard interface and click Custom option to open the  ‘Add Custom Element’ dialog box. From there I can add a custom interface element to that block. Is this possible today or do I have to develop all the dashboard options with within the dashboard page element? Thanks!

Hello everyone, i’d like to access to the page airtable.com/account/credits and get the JSON of my referred users, which can be found under “credits”I’m talking about this:"acceptedInvitedUsers": [{                    "id": "usrp*****c9IeJ4G84E",                    "email": "m*******@hotmail.com",                    "profilePicUrl": "https:\u002F\u002Fstatic.airtable.com\u002Fimages\u002FuserIcons\u002Fuser_icon_7.png",                    "name": "Maurizio",                    "wasAwardedCreditForReferringUser": false,                    "_invitedTime": "2026-06-10T16:59:09.000Z"                }, {                    "id": "usrCw9R7*****KZcIzo",                    "email": "f*********i@optibus.com",                    "profilePicUrl": "https:\u002F\u002Fstatic.airtable.com\u002Fimages\u002FuserIcons\u002Fuser_icon_10.png",                    "name": "*********",                    "wasAwardedCreditForReferringUser": true,                    "_invitedTime": "2026-05-26T13:29:57.000Z" 

I try to avoid  having to build and maintain our own RAG pipeline when uploading our PDF content. So, if we use AWS service like Bedrock Knowledge Base, can we use integrate Vector DB within AirTable? PDF in AWS S3↓Bedrock Knowledge Base↓AirTable Db Vectors

Curious what setups people are using these days.I've seen a few approaches:Zapier/Make automations (works but gets expensive fast) Manual CSV exports from Stripe (painful every month) Custom scripts via Stripe API (requires maintenance)One thing that surprised me when I started looking into this: most Stripe integrations pull gross revenue — but Stripe's processing fees mean your actual net revenue is always lower. So your "MRR" in Airtable ends up being slightly wrong unless you account for fees explicitly.Has anyone solved this cleanly? What's your current setup?

This seems kind of basic, but for some reason I can’t figure it out. I’m using Leaflet for a map using interface extensions, and the marker icon pngs that are part of their dist (e.g., “marker-icon-2x.png”) won’t load. “That’s fine,” I say, “I’ll just copy them to the frontend folder as a workaround.”But those won’t load either, so now I’m a bit confused. As far as I can tell, I can’t use import statements on pngs, because webpack isn’t a fan. It looks like they might be included in the bundle, but they’ve been given automated bundle names (“2b3e1faf89f94a483539.png”), which I know for certain React isn’t dynamically renaming to match in my js. Is there some expected practice in interface extensions or React as a whole for handling this?

Hi everyone, I’m building a Morse Code website that converts text into Morse code and stores user submissions in Airtable through the Airtable API. The website is connected using JavaScript fetch requests and a Personal Access Token. The issue I’m facing is that records are sometimes created successfully, but updates to existing records either fail silently or create duplicate entries instead of updating the original row.My current workflow is: first I send a GET request using filterByFormula to check whether a record already exists, then I either PATCH the existing record or POST a new one. Even when the API response returns status 200, the Airtable base occasionally does not reflect the expected changes. I suspect the issue could be related to incorrect filterByFormula syntax, record ID handling, async timing in JavaScript, or Airtable caching/rate limits.Has anyone experienced similar problems with Airtable API integrations? What is the most reliable method to prevent duplicate reco

Desarrollar una aplicación inteligente denominada MediSync que permita la gestión centralizada del historial clínico, la automatización de recordatorios médicos y el seguimiento activo de tratamientos para los pacientes de la Clínica Granados, con el propósito de mejorar el cumplimiento terapéutico, optimizar la productividad del personal médico y elevar la calidad de atención clínica.Implementar un módulo de registro y gestión del historial clínico que permita al médico acceder de forma ágil y segura a toda la información médica del paciente. Desarrollar un sistema automatizado de recordatorios que notifique a los pacientes sobre la toma de medicamentos, citas médicas y procedimientos programados a través de notificaciones en la aplicación móvil.  Crear un módulo de seguimiento de tratamientos que permita al personal médico monitorear el cumplimiento de cada paciente y tomar decisiones clínicas oportunas. Integrar un panel administrativo que facilite la gestión de citas, disponibilida

I have a PostgreSQL database and I'm currently trying to sync it with Airtable. My current setup triggers a sync whenever a new record is created in the database, but I'm getting frequent synchronization errors.I'm wondering: is there a way to connect Airtable directly to a PostgreSQL database as a data source — similar to how Metabase lets you query a database directly — rather than relying on a sync mechanism? Essentially, I'd like Airtable to read data live from the DB without needing to replicate records.If not natively, are there recommended integrations or workarounds for this use case?

Hey all, I’m making a Custom Interface Extension table module so I can have user facing sorting on the dashboard template. I’m trying to figure out how I can have the order of the columns tied to the order of the fields in the data panel the same way it works in the native AT tables. Anyone know? Thank you. 

This is very exciting so I wanted to share in case you missed it. This was not too much advertised. https://airtable.com/developers/web/api/upload-attachment 

Hey 👋I've been building a custom Interface Extension using the Extensions SDK and ran into what seems like a significant limitation — I can't find any supported way to let users upload a file/attachment directly from within the extension UI.What I'm trying to do:I have a custom extension embedded in an Interface page. The workflow requires users to attach a file (e.g. a PDF or image) to a record — ideally triggered from a button or input inside the extension itself.What I've tried:Using a standard HTML <input type="file"> — the file picker opens, but there's no SDK method to then take that file and write it as an attachment to a record field. Looking through the @airtable/blocks SDK docs for something like updateRecordAsync with an attachment payload — attachment fields require a URL, not a raw file object. There's no upload endpoint exposed through the SDK. Considered uploading to a third-party storage first (e.g. S3 or Cloudinary), getting a public URL, then writing that URL t

Hello.I'm a bit confused about the different types of extensions in Airtable and can't quite figure out which one makes sense for my use case. I already know how to solve this inside a specific base using older approaches, but now I want something more reusable across different bases and aligned with the newer tools.Previously, there were:Airtable Scripting Extensions - easy to reuse by copy-pasting code, but a bit too limited in terms of interactivity. Airtable Extensions (Blocks) - can be built from examples, require Node, and can be distributed across bases via remotes and CLI.Now we have:Custom extensions, available viahttps://airtable.com/create/extensions Interface Extensions, which can be created via prompt.I have two tasks where I’m not sure what’s the right approach. The docs don’t help much because I’m not even sure which section I should be reading.a) Fairly simple: select a table, pick a text field, and run a few transformations (truncate, capitalize, etc.).Ideally, I’d lik

Has anyone managed to get their Extension updated or get an answer from support regarding their extension in the marketplace? I submitted 2 months ago, no answer, multiple support tickets same thing. What is happening?

Many CRM projects fail before launch because companies focus on software first and people second. They buy a platform, add features, and expect instant results, but ignore training, workflow planning, and user adoption. When teams do not understand how the CRM helps their daily tasks, resistance starts early. Poor data migration is another major reason. If old customer records are messy or incomplete, trust in the system drops fast. Leadership also causes failure when goals are unclear or no one owns implementation. A CRM should solve business problems, not become another unused tool. Smart companies start with simple processes, clear onboarding, and gradual rollout. They also align sales, support, and marketing before launch. Businesses exploring eCommerce Salesforce Integration Services should remember that technology alone does not guarantee success. A CRM works only when strategy, clean data, and team commitment come first.

I've found that SEARCH() in filterByFormula handles escaped double quotes differently depending on the field type. Backslash-escaped quotes work correctly on text fields but silently return no results on linked record fields.Setup:- Table "Registrations" has a linked record field {Rider} pointing to table "Riders"- One of the records in the Riders table has the primary field value: Aubrey "Aub" Holland- A Registrations record links to that Rider- Table "Registrations" also has a plain text field {Direct name} where one of the values is Joe "Biggie" SmallsWhen searching the Registration table I get different results with a very similar search depending on which field I search: What Works (text field):  SEARCH("Joe \"Biggie\" Smalls", {Direct name}) != ""Returns the matching record correctly. What Fails (linked record field):  SEARCH("Aubrey \"Aub\" Holland", {Rider}) != ""Returns zero results — no error, just an empty response. The formula is accepted as valid but doesn't match. This do

Hello - I saw a post about viewing all place my base is syncing too  - but there was no answer and the thread is closed now.Situation: We have multiple bases that are connected via synced columns. Data moves through the operations workflow. We would like to be able to visualize the system and any dependencies. I’m trying to generate or create something similar to the Base Schema extension but across multiple bases. Anyone know a way to do this? Thanks

This is really more of a development & workflow request for help. I have around 60k Shopify variants across 8 different vendors. I get the vendors/suppliers produc master data at the UPC level via a CSV file, which I can import into a base. I want the workflow to to use the CSV base to search for matching UPC’s in the supplier/vendor base. If a match is *not* found then the records needs to be added to the supplier base then synced to Shopify. If the UPC *is* found in the supplier base then the records needs to be updated. There will be many deafult values if a new record is added, and mapping rules which would be different for each CSV base.I would appreciate anyone interested in a project of this type. Thanks

Hi,I’m new to airtable and I try to make a script triggered from a button field. I need to get the selected record linked to the button clicked but could not find how to achieve this.I can’t believe there is no way to get the current record id from the script, what am I missing?Thanks.

I would like to see the date instead of “5d ago”.  Is that possible? 

I absolutely hate not being able to see the column title name unless i want to make the column width 2084985 feet. While it seems simple in nature, this is why i prefer Smartsheet. I want to be able to have columns sized appropriately with legible column headers and not have to scroll over to view.

We have a large volume of data in two tables (Facilities and Users) that we’ve imported via a HyperDB. We want to make routine updates from our company data lake into these two Airtable tables. There is linked data between our two tables (Facilities, Users). The updates don’t have to be instant - once daily or even a little less frequently is ok. It looks like this won’t be able to be done via a script - that it will require manual intervention via the browser tools, is this correct? Thanks in advance. Trying to point our development team in the right direction and are also open to help. 

Hello Airtable team,We have submitted our extension for review about 3 months ago and still haven’t heard anything back. We have issued 3 support tickets and tried contacting you but heard nothing back.Could you please share the status of the review progress? Anything we can do on our end to help speed things up?Here is the block submission id: recqvvvEko3vXqEqN

Jotform integration can only add new records to Airtable; it can’t update a record, correct? I have a table with a couple of hundred records (name, email, etc.) and want to send out a Jotform survey to everyone that will automatically populate each record with their answers. This is currently impossible without some third-party go-between, as far as I know. Is this not a basic function of databases, being able to update the records? If I can create a simple three-step solution in Zapier to update records from Jotform submissions instead of adding new ones is there any reason Airtable can’t do this natively? I could do it in Filemaker thirty years ago.