Development & APIs

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. 

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.

Hello, I’m submitting my app for an update. The project source code has been packaged and is ready for review by Airtable. Are you prepared to proceed with the submission? (Enter y to continue) [N]: ySubmitting... IncompleteError: An issue occurred while uploading your block. Please try again or reach out to marketplace-submissions@airtable.com for assistance. This is the error I’m encountering. Is there something from in my submission? I’ve tried multiple times for the last couple of days,  

Hi,We’ve fixed a bug on our side, but when I tried to resubmit the app “block submit,” I encountered the following error. I was already using CryptoJS previously when listing our app, so I’m not sure what has changed. Could you please advise on what I should do here and help me resolve this issue? block submitFinding dependencies... donePackaging... donenode:events:495      throw er; // Unhandled 'error' event      ^Error: ENOENT: no such file or directory, open '/Users/sathishj/Documents/Airtable/airtable-extension/sparrow/(disabled):crypto'Emitted 'error' event on ReadStream instance at:    at emitErrorNT (node:internal/streams/destroy:151:8)    at emitErrorCloseNT (node:internal/streams/destroy:116:3)    at process.processTicksAndRejections (node:internal/process/task_queues:82:21) {  errno: -2,  code: 'ENOENT',  syscall: 'open',  path: '/Users/sathishj/Documents/Airtable/airtable-extension/sparrow/(disabled):crypto'}Node.js v18.20.8​​​​​​​

My company integrated Zendesk to our Airtable for an extensive reader feedback workflow, but we had to change our Zendesk account after a company acquisition. Our old company and new company had separate Zendesk accounts, and our goal after the acquisition was to close one and move everything over to the other. We had the old Zendesk account synced to Airtable as a source, along with our new Zendesk account.  All records are showing fine since we have a setting to leave the records even if it’s deleted from the source. Eventually we fully deprecated our old Zendesk account after moving over to our new one.However, our Airtable integration keeps displaying errors due to the old Zendesk instance, which causes confusion with people accessing the Airtable base. The only option we are given as admin is to remove the source, which is not what we want. This would delete all records associated with the previous source. Is there anyway we can “disable” a source instead of “remove” a source? We

Hi all! I’m looking for an app that will allow, either via direct integration or Zapier, for the dynamic creation of a pre-filled document for e-signature. There are tons of options (too many) out there, but I’ve yet to find something which meets all of my requirements: Create a pre-filled, yet still editable, document with data from Airtable (likely triggered by Zapier) Get the URL to that document BEFORE sending it to the signer. I do not want to send the document to a signer from the app itself. Rather, I want to retain the link in Airtable, and send it off to an individual in an email, based on a separate trigger. Trigger Zapier upon receipt of the signed doc I’ve tried many apps… I had high hopes for Formstack Documents and the new block, but upon sending the created document to Formstack Sign, the document is flattened and the signer can no longer edit any fields. PandaDoc doesn’t give you a URL to the document until after all parties have signed. If I could just grab bits and

Is there any option to integrate Adobe e-signature with Airtable? If yes, can someone please guide me through it?Based on the data entered in the Airtable, I want to create a PDF file which would be mailed to 4 different people to sign it. I also want to know that how can I create a PDF based on the data entered and automate to send it to all the people in the list and get it signed one by one with first in the list as first and so on. 

There is now a secrets API for automation scripts.Why do we not have the same API available in script extensions?  I have an API server that I use to interact with an Airtable base, and I want some of my script extensions to use protected endpoints that require an API key header to access.  In my automations I can store this API key in the new secrets API, but in script extensions I have to hard code the key (terrible practice) in the script extension in order to access the endpoints.  And I can’t use an external API to manage/store/retrieve secrets because then I just have the same issue with another server—to retrieve those secrets I would need to hit an authenticated endpoint using some other secret.I’m just confused why, now that this secrets API has been added to automation scripting, it hasn’t been extended to script extensions.

I have an Airtable project where users can add service request or tickets for the apps already made in Airtable. I want to integrate my app with the Azure DevOps dashboard or board where we add tickets and track them. Is there a way in Airtable to do this kind of integration?

Hi Community!I’m attempting to create a webhook and attach some additional info for all he POST requests that are to be made for the specified notification url.I want to call my notification url and specify some parameters there.AFAIK its not possible to use url query parameters there and specify them while creating a webhook.Are there other options? Like custom http headers or so?  Thank you