Development & APIs

I'm working on a project where we use:- Postgres for our production app database - Airtable for our internal team (support, ops) The challenge: keeping them in sync without writing fragile scripts.Curious what others in this situation are doing:1. Are you using Zapier? (I find it too slow)2. Custom scripts with webhooks? (maintenance nightmare for us)3. Some other tool I haven't discovered?4. Did you just pick one and stick with it?We're syncing about 5K records and need changes to propagate in under a minute ideally. Any experiences or recommendations appreciated!

I keep getting this message and ive done this same thing a bunch of times before: {{Make sure you enabled the following scopes for your token:data.records:readdata.records:writeschema.bases:read}}  Its kind of hard to miss these exact words while comparing them slowly  to ensure accuracy. It just wont attach the scopes to my api token. Im not sure what in missing and i should not be missing anything, its pretty simple to do as ive done before so what changed now when i have changed nothing?

Hello! I am a new AirTable user and have spent over 30 hours trying to build a worksheet generator for my classes. Since I don’t quite know how AirTable works, Chat GPT has been walking me through all of the steps. But … it isn’t working and after 30 hours I’m feeling like I should give up. Would anyone be willing to take a look at it and help me?

My Airtable usage dashboard shows 881/1,000 API calls, but my third-party connection (Softr) is already returning an 'Exceeded Limit' error. Does Airtable trigger this error before the 1,000 limit is officially reached, or is there a delay in the dashboard reporting my real-time usage?

I'm using Airtable's MCP server to let an AI agent (Claude Code) build and manage a base on my behalf — creating tables, fields, records, linked relationships, the works. The API is excellent for all of this. But I've hit what feels like a showstopper: there is no way to programmatically configure view sorting, filtering, grouping, field visibility, or field order.The result is that my AI agent creates a beautifully structured base with sequenced milestones, prioritised tasks, linked goals — and when I open Airtable, I see records in an arbitrary internal order that bears no relation to creation sequence or any other logic. Every view needs manual sort/filter configuration before the data is usable.I tried the obvious workaround of deleting and recreating records in the desired order. Doesn't work — the UI still displays them in an opaque internal order. I've added Sequence fields to every table so the correct order is encoded in the data, but there's no way to tell a view to sort by t

Given the advent of tools like Claude Code / Codex are there any plans to expand API capabilities do allow more complete read and write?  It has been a long standing community request to allow creation and modification of lookup, rollup and formula fields. Additionally, many field attributes are not available (readable) via API.  I think the urgency on this is much higher now. Agentic coding currently require 1) manual extraction of the full schema data to give sufficient context to coding agents 2) manual human intervention to create key field types.This is going already beginning to affect the build (traditional database) vs buy (Airtable) decision. Both the development process and the long term maintenance process are moving to agentic AI, which at current, is not fully feasible with Airtable.   

I am wondering if anyone else is experiencing this issue.  I am noticing that for the past few weeks it can take several minutes to query a view in Airtable using the API.  Is anyone else experiencing this issue, or was some recent change made to degrade service?  It’s been working great for years, and unfortunately I have to update the backend to use cached records in AWS instead of calling the Airtable API directly via the ‘pyairtable’ SDK. Just a lot of work that’s heading me down a migration path of removing Airtable from our stack, since the workaround is literally not to use the Airtable API, which means no Airtable, ultimately.

I am developing a college course and want to have students build an airtable that curates all higher education programs for students with disabilities. Is that possible?

Hello everyone,I’m running a website that relies heavily on the Airtable API to manage and sync dynamic content such as product data, categories, and status updates. Recently, I’ve started facing inconsistent behavior when making API requests from my website to Airtable, and I’m struggling to identify the root cause.In some cases, API calls that previously worked without issue are now returning partial data, delayed responses, or unexpected empty fields, even though the records clearly exist in the base. Other times, the same endpoint works correctly on a manual test (using tools like Postman), but fails or behaves differently when called from the live website environment. This inconsistency makes it difficult to trust the data being displayed on the frontend.I’ve double-checked the API key permissions, base structure, field names, and rate limits, and everything appears to be configured correctly. No major schema changes were made before the issue started, which makes the behavior eve

The last discussion about this I found was from 2023 when it was initially implemented.I have a couple airtable embeds in Squarespace. They have been working fine for several months. All of a sudden today, every time the embed is viewed, I get the Cookie Popup. Every single time. Clicking X or accepting doesn’t make any difference.I’m not sure why this has started up after months. Has Airtable addressed the implementation? Can I either turn it off or at least once the popup has been answered make sure it doesn’t activate every single time the page opens?

I’m building a restaurant menu website (similar to a Culver-style menu) where all menu data—categories, item names, descriptions, prices, images, and availability flags—is stored in Airtable and fetched dynamically using the Airtable REST API. Each menu category (e.g., ButterBurgers, Frozen Custard, Drinks) is linked to a separate table, and the website consumes this data to render the full menu on the frontend. While the setup works correctly in most cases, I’m running into inconsistent behavior when retrieving records via the API.Specifically, some API responses return only partial data sets or miss linked records, even though those records are present and correctly linked inside Airtable. In certain cases, a category endpoint returns fewer items than expected, and refreshing or re-running the same API request sometimes returns a different result. I’ve verified that the API key, base ID, table names, and view filters are correct, and I’m not hitting documented rate limits. This incon

Hi everyone!I’ve been experimenting with Airtable as a way to organize and share daily word puzzles inspired by the NYT game Letter Boxed. The idea is to create a base where: each day’s puzzle layout is stored, community submissions (solutions) are logged, performance (time/words/points) can be tracked, and users can filter or sort challenges by difficulty or date. So far it’s been really helpful for keeping everything structured and allowing others to contribute solutions easily.A couple of things I’ve set up in the base: Grid view for daily puzzles with letter sets and status Form view so players can submit solutions Leaderboard view sorted by points or speed I’m curious how others here might use Airtable for game-like engagement, daily challenges, or community-driven activities. Has anyone built something similar? Any tips on making the base more efficient or fun (e.g., automations, lookups, dashboards)?Thanks! Looking forward to your ideas 😊

I’m loving interface extensions so far! It’s super easy to get up and running. I have an external website that uses the Airtable API that I think would work much smoother if it were an interface extension and inside AT proper. The only problem is… it’s in Vue, and it’s way too complicated a project to rewrite from scratch in React.Assuming the interface extensions team isn’t planning on making a Vue SDK as well (...unless? 😳), has anyone tried inserting a Vue component into React, specifically inside the Airtable Blocks SDK, where no Vite config file is available?

Previously reported issue: Getting all records modified after a date | Airtable CommunityI’m calling Airtable passingfilterByFormula: "IS_AFTER(LAST_MODIFIED_TIME(), '2026-01-25T00:00:00.000Z')",// filterByFormula: "IS_AFTER({Last Modified}, '2026-01-25T00:00:00.000Z')",Last Modified is a formula column I created. Neither of them works.ExpectedOnly return records that were edited after a certain dateActualIt returns all records Am I doing something wrong? Is it not supposed to work?Are there workarounds for this?

Hi Airtable builders!In previous topics, I shared how you can sync your Shopify metaobjects, metafields, and even Products & Variants with Airtable in real time.The good news: you can now sync your Shopify translations with Airtable too (thanks to SyncBase).How does it work? During onboarding, you can choose which languages you want to sync. The app creates dedicated fields per language (e.g. Title (EN), Description (FR) …) inside a new Airtable base — or an existing one if you prefer. Each record represents a Shopify object (Product, Variant, Metaobject entry…), and each locale is editable directly from Airtable. Any update you make in Airtable is instantly synced back to Shopify — and vice-versa ⚡ It works for all supported Shopify translatable content (Products, Variants, Metafields, Metaobjects…) and everything stays fully in real time. Here is a 45 sec demo 👇 A few use-cases from our first beta-testers: Centralize all Shopify translations in one Airtable base Use Airt

Is it my impression or the latest version of the SDK removed support for defining a table as a custom parameter? My extension reads data from another table as support for that has been recently added. In order to avoid hardcoding things, I was allowing users to select a table. This was supported  (see link below). However, the latest version of the SDK does not seem to support that. (^0.0.0-experimental-e7419444f-20251120). I’ve updated my code so the parameter is now just a string. It seems to be working. Could you please confirm this makes sense?https://airtable.com/developers/interface-extensions/api/BlockPageElementCustomPropertyThe signature of the type BlockPageElementCustomProperty I’m getting does not include that type anymore (see below) and I also get a run time error.type BlockPageElementCustomProperty = { key: string; label: string;} & ({ type: 'boolean'; defaultValue: boolean;} | { type: 'string'; defaultValue?: string;} | { type: 'enum'; possib

Our team currently uses a legacy spreadsheet in Excel that is connected to Power Automate. This is visible by many teams and transitioning this workflow from Spreadsheet to Airtable would cause more issues than concerns. I’m wonder if its possible to connect excel to Airtable and make it live so everything is in real-time so that I can use Airtable dashboards to showcase the data we get in the spreadsheet. Is a 3rd party application needed? 

Hi everyone,we’re already using Airtable (initial tables exist) and we’re looking for help to properly structure the base and build a lightweight internal frontend / possibly an app to track and analyze our networking activities.Use case: Manage contacts (not customers) and log interactions/meetings per contact (date/location/type), discussion topics, resulting projects/leads/outcomes, follow-ups + reporting (activity over time, last interaction, topic/outcome breakdowns).Key requirement: A mobile-friendly workflow to take photos of meal/entertainment receipts and attach them to the related interaction/contact, including basic fields (purpose/occasion, attendees, amount, etc.) — with the goal of providing documentation for our tax advisor / authorities if needed.Usage is internal only (1–2 users, no external access).If you’ve built something similar and can advise/implement (Airtable Interfaces vs Softr/Stacker/Glide vs custom via API), please reply or DM with examples and your suggest

I need to import the “Resolution” field from Jira Cloud  (Resolved, Won’t Do, Cancelled, etc) -- this is not showing up in the Standard fields, and is not listed on the Help page (https://support.airtable.com/docs/airtable-sync-integration-jira-cloud)Also wondering if there is support yet for custom fields?

Hi all, I’ve got a company that works with lots of freelancers and I decided that instead of a service like Calendly, I’d build an interface on Airtable, in a base where they all sync their calendars so I can see their appointments overlapping, and find the “holes” where people are available to meet. It’s worked really well (using filters in the interface, so I find the exact team members I need for each meeting). The one thing is, I’m trying to protect our contractors’ privacy, and don’t want to sync any information that’s extraneous to checking their availability (I don’t want any event details other than whose calendar it’s coming from, start and end time). I’ve successfully toggled off all details EXCEPT the event title, which, it seems, cannot be toggled off.My workaround has been to create a formula field where I change the event name to “Person Busy,” so they don’t show up in my interface, which works fine, but I wanted to see if anyone knows of a way to simply prevent Google Ca

Hi,Has anyone tried integrating Culture Amp survey data with Airtable for analysis and visualization? I'm considering whether integrating the Culture Amp data would produce better data analysis and visualization results, while also saving a lot of manual work. Thanks!

I’m using the utility function getHexForColor to get the color the user defined in a single select field and use it in my interface.  However, the hex colors I’m getting do not match the colors used on the AirTable UI.For example for a selection I have, the Airtable Color is blueBright and when I call getHexForColor  I get #2d7ff9, however, the AirTable UI uses #166ee1.I also noticed shouldUseLightTextOnColor doesn’t seem to work well on dark mode but I think that’s expected as I think dark mode is still experimental, right?

Hi all, Am I correct in assuming that there’s no way to duplicate a base via API? It seems weird that there’s so much you can do loads of customisation with creating a base via API except you can’t do the 1-click duplicate which is available in the UI? The problem with the create base API is that several things don’t work - e.g. AI fields. It’s not practical to use API to create base then manually have to go in and configure a bunch of AI fields by copy/pasting the prompt in 😅 Any workarounds anyone has found?

Hello everyone,I’m a junior data analyst and recently I was asked at work to integrate new data that is external to our management system. This data consists of Excel spreadsheets stored in Airtable. While researching, I noticed that there are several ways to integrate this data.For example, one could use “bridge” solutions like OneDrive or SharePoint, or connect directly to Airtable via its API.I was able to connect directly using the API (after creating a Personal Access Token), performing a blank query and using an M script to retrieve over 20,000 records. However, I would like to hear from more experienced people whether this could be the best approach compared to using a bridge solution. I personally think it is, but I would appreciate the opinion of experts.I have tested this with free accounts and demo Excel files with over 20,000 records, and I can retrieve them both directly via API and using OneDrive or SharePoint.Additionally, I understand that the client has a paid Airtable

Should i sort it in  notion?]