Development & APIs

Hi there,Help!Our Zapier connection stopped working despite the automatic Oauth integration managed by Zapier. Anyone know how we can fix this?We get "Validation error" as message.

Hello Airtable Community,I have 2 tables linked - the common column being "Deal Link" a.k.a "URL" (which is primary in Table 2).I have a script that updates Table 2 via API.The problem is, when updating via API, all the data linked in Table 1 from Table 2 disappears (even when record is unchanged). Is the link broken at this point ? How to remedy that ?Thank you.

I currently have a Node.js application that makes requests to the Airtable API, which I have been using as usual. However, from yesterday to today, I am encountering this problem:[Nest] 31452 - 02/02/2024, 9:32:17 AM ERROR [ExceptionsHandler] connect ETIMEDOUT 18.214.64.4:443 Error: connect ETIMEDOUT 18.214.64.4:443Has there been any change to the API?

Hi Team,I would like ask for your assistance on this matter please.Whenever our clients would want to submit an inquiry to Softr, this error is always appearing. Thanks 

Looking for help with my base. I want to automate importing a csv on a schedule into Airtable. Currently, I have to delete all of the records in my table, export and import a new csv from NetSuite, and then the rest of the base does the work. How do I automate this? My goal is to have this run 3-4 times daily.

I'm trying to update a long text field with rich text, but the documentation seems all over the place,How do I update the field via a POST request? (or any other way).For context, Airtable says that Markdown is supported in rich text fields which is partially true. A different doc shows that only a small set of Markdown is supported in the long text field.I'm trying to update the field with links and bold text, which apparently isn't supported Markdown syntax, BUT it is supported in the rich text field.In the base's api documentation, they show an AST:[ { "type": "paragraph", "value": [ { "type": "paragraphLine", "value": [ { "type": "text", "value": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam et nulla vulputate, sollicitudin risus sed, suscipit sapien. " }, { "type":

Using the API, how can I retrieve a list of possible values for a Select field?The documented way is with the Meta API - https://airtable.com/developers/web/api/get-base-schemaBut, for me, https://api.airtable.com/v0/meta/bases/{baseId}/tables returns: `[404] INVALID_API_VERSION`

TL;DR: Do I just need to replace my Airtable API key with the new personal access token or is there anything else?I read about the Airtable API key depreciation notice that says API keys will no longer work from Feb 1, 2024.I am using the official NPM library airtable.js in my Next.js project. This is how I am configuring Airtable in my codebase: const base = new Airtable({ apiKey: process.env.REACT_APP_AIRTABLE_API }).base( process.env.REACT_APP_AIRTABLE_BASE ) To adhere to the new changes, I have created a personal access token from `/create/tokens` as mentioned in the development guide. Then, I changed the value of `REACT_APP_AIRTABLE_API`in my `.env` with the token generated from `/create/tokens`.What else do I need to do? Everything seems to work fine but I just want to double check if I am missing anything. Thanks.   

I'm looking to run a script when a record is created which would created a new form for that individual record. I need to do this because when clients will be using the forms, I can't have them be able to add data to other clients so by default I'm creating a form with the default values that can't be changed. Does anyone have a better solution to this problem or is there a way to do this?

Is there a list anywhere of the hotkeys for the scripting extension?  Specifically, I'm looking for a hotkey to minimize all functions.

let response = await fetch('https://api.airtable.com/v0/appN7ENhTnqtPUMSf/tblGBdGqVSDBBIxUE&view=Orders%20in%20Seven%20Days', {headers: {'Authorization': 'Bearer token'}}); Hi Everyone, can someone take a took at this for me, I got a 403 error when I try to list records of a specific view , I quite sure I am having the right authorization, because If I remove '&view=Orders%20in%20Seven%20Days' from the url, I get a list of orders. Thanks in advance!

I am currently working with the Webhooks notifications (https://airtable.com/developers/web/api/webhooks-overview) to process record updates when a set of files/fields have changed. While I love the power and flexibility of the notification, especially the `fromSources` filtering and metadata, I have hit a few roadbumps in my implementations and I'm wondering if I am missing any obvious solutions that others have discovered.- Cursor value. Initially I thought I could possibly track the cursor value, but then I realized that this is likely just the cursor from the start of the payload list, so after 7 days of payloads, the max cursor value from the payloads will be less than my locally saved cursor, so this doesn't seem viable.- `baseTransactionNumber`. Since AirTable states that "each payload includes a transaction number, which is scoped to that webhook and sequentially increases", we can use this number to ensure we don't process multiple payloads more than once. However, we are not

How to filter and set condition IF EMPTY?

Hi, I have setup an airtable base to show tickets from another application (via a csv export). For higher management, we have filtered to show how many tickets each team has and what is outstanding and closed (as well as dashboards to have further insight into these tickets). I am unable to compare/show the % increase/decrease via Airtable. Below is in the interface but I'm hoping to show the % in the Data tab. For example Oct-Nov there was a 41% increase but I am unable to find a way of showing this.  The aim is to allow Month on Month, Quarter by Quarter and Half by Half comparisons in %.  

I have been running Airtable for at least 5 years and am very familiar with it. I have a need that is beyond my no-code low-code capabilities and I am looking to hire someone to help me develop the following idea.I have a base that has dynamic information for each day of the year on it.I have a physical public display in a high traffic location with a QR code on it.I would like local public to be able to hit that QR code with their phones and land on a mobile device compatible web page, which dynamically changes every day pulling the proper day's data into it from my airtable base.I don't have time (or really CSS, API and coding skills) to figure this out and would be very interested in developing a resource relationship with someone who can deal with the API, CSS, Java? issues in getting this web widget that is pulling data from an AirTable base made.My name is Theo MayerLooking forward to meeting you (whoever you are:)

When I make an API call using a Personal Access Token I have set up, it returns Error 401 Authentication Required - but if I change out the PAT to use the API Key, it works just fine.Am I not able to use PAT's whilst I have a API Key enabled?

Hi all, Im trying to use airtable in netlify serverles functions. When I try to create a record, I keep getting this error “Expected signal to be an instanceof AbortSignal”. ` const { formattedReturn } = require("./helpers") const Airtable = require(“airtable”) const base = new Airtable({ apiKey: “APIKey” }).base(“BaseID”) const eventBookingTable = base(“Events”) exports.handler = async function (event, context, callback) { const newRecord = async () => { const rec = await eventBookingTable .create({ Name: “iamnotcrazy”, Event: [“recwrjfffffff”], Email: “mymomgotmetested@gmail.com”, }) .catch(err => err) return rec } try { const record = await newRecord() return formattedReturn(200, { record }) } catch (err) { return formattedReturn(500, { err: err.message }) } } `

Hello everyone,I would like to track commercial and private flights using airtable. Ideally a flight number or tail number will be entered into a column and in two other columns the flights status and ETA will be displayed.So far there doesn't seem to be any native extensions and I have been investigate third party APIs and have yet to find a suitable match. Any recommendations or suggestions?Thank youTom

Hi all, I use an airtable formula to calculate product prices. I want to use Zapier to automate the process of updating prices on my website when changes are made to prices.As I understand, Zapier wants to use the a "Last Modified Time" field as the reference to know when to trigger the action. The problem I'm having is that I'm not finding a way to point the "Last Modified Time" field at the calculated price field because AFAIK that field cannot monitor computed fields. The airtable documentation recommends pointing the "Last Modified Time" field at one of the editable fields used in the computed fields. This doesn't resolve my issue because Zapier seems to want to pull the value from the field being watched by the "Last Modified Time" field, not the computed field that I need it to. After consulting the airtable documentation I'm starting to be convinced that the workflow I have in mind is not possible (I would be happy to be wrong about that). So I'm wondering if anyone ha

Good day Airtable Community,I would like to ask for your assistance if there is a ruling that can be created to move records that do not have "Extracted for Ticketing" value all the way down?  Thanks

I'm looking for an alternative to MS Access which will allow our employees to enter data through forms, with basic features like lookup tables and direct access to an AWS hosted PostgreSQL instance.Does Airtable do that? It seems like Airtable needs to ingest all data into its own 'base', but I'm really not looking to do that.If not, I'd appreciate any suggestions for data entry software.

Hi,I have an Interface I have created for one of my bases (simple summary page) - but I wonder:- Is it possible to access this Interface (and its summary data) via the AirTable API? It doesn't seem so, but maybe it is somehow?- Is it possible to embed this Interface within another site of mine via an iframe or something similar?thanks for any suggestions!@ed_p_may 

I've been trying to do this in way too many ways. I haven't figured it out ChatGPT and Bard haven't figured it out so I though I would ask actual people 😁I'm making an api call to usaspending.gov and am able to to get the information I want returned, but I can't figure out how to use the data I'm pulling down to create multiple records based on the objects returned. Has anyone run into this and how did you do it?let uei = 'PLACE-UEI';let startDate = '2023-10-01';let endDate = '2023-12-31';let data = {"filters": {"time_period": [{"start_date": startDate,"end_date": endDate}],"award_type_codes": ["A","B","C","D"],"recipient_search_text": [uei]},"fields": ["Award ID","Recipient Name","Start Date","End Date","Award Amount","Total Outlays","Description","def_codes","COVID-19 Obligations","COVID-19 Outlays","Infrastructure Obligations","Infrastructure Outlays","Awarding Agency","Awarding Sub Agency","Contract Award Type","recipient_id","prime_award_recipient_id"],"page": 1,"limi

The field in question is an Attachment field.This is what my POST looks like (from Power Automate Desktop. Note variables are enclosed in %s). The field in question is highlightedI receive this error{"error":{"type":"INVALID_ATTACHMENT_OBJECT","message":"Invalid attachment object for field Lawsuit Docs - PDF: \\"https://drive.google.com/file/d/1Y_4OYYb7NjIKremnh3aiuFFEh6smESFK/view?usp=drivesdk\""}} TIA   

Hi all,I see in the API documentation that there's an endpoint which can provide information about an interface (aka page bundle, aka section).But in order to use it, I need the interface ID, and I don't know how to list the interfaces. I know that as an Enterprise admin, I can visit https://airtable.com/admin/[enterpriseId]/interfaces and search or download a CSV, but as you can imagine all that proves is that there is an actual API endpoint, I'm just not sure how to access it 🙂 Making it even more frustrating, the interface IDs aren't even available in the URL when you're browsing the interface, as far as I can tell.Does anyone know if I'm missing something and there's a way to get the page bundle IDs programmatically?PS if anyone is aware whether Airtable has shared anything about developing a more robust metadata API for interfaces (list pages, list fields and their configurations, etc) that'd be awesome.