Development & APIs

How to perform function Replace if condition is met?

Is it possible to make an extension that specifically deals with the Form view, namely to add new form field types? I'm looking to try and make a linked record field that allows you to create new linked records, but everything in the Blocks SDK API mostly seems to revolve around manipulating the base itself, or making an extension-only view of a base's data.Is this not possible? Is something like miniExtensions just building a whole new form view from scratch? (Note: I have looked at Fillout, but I'm mildly concerned about data privacy and would like to see if it's feasible through extensions alone.)

We are trying to integrate SendGrid in the Airtable Extensions. I created a new API key in SendGrid and verified my email, however, upon trying to finish the integration, I get the following error: Invalid SendGrid API key or sender email address. Any suggestions? I have already tried creating a new API and re-verifying the email.

I'm creating a webhook that fires when a specific field in a record in Airtable is updated using the 'Create a webhook' endpoint. Doing so returns the default 200 response with the id of the new webhook in the response. The issue is that the webhook does not fire, and when I call the 'List webhooks' endpoint, I receive a 404 response with the error message "NOT_FOUND."I made a screen recording in Postman to show what I mean. Is this a bug?For additional context, after creating the first webhook, I successfully triggered it. However, I wanted to make changes and attempted to delete it so that I could create a new webhook. Upon calling the 'Delete a webhook' endpoint, I received a 404 response, after which point I was no longer able to trigger the webhook.

Is the Airtable API down right now? For the past 5 hours, I have been getting this error whenever I try to access my data from Airtable via API:An error occurred when calling Get Alltimeout of 25000ms exceededAll my mobile applications use Airtable as their database, so I am getting an influx of emails/messages from users reporting that the app is not working (Since it can't fetch the data from Airtable)Is this only happening to me? Or for everyone else?

Hey everyoneBeen fighting with this all day. Hopefully someone here can help point me in the right direction.I am using PowerAutomate and Sharepoint. I have a Word document stored in a folder on Sharepoint that I would like to attach to a record in Airtable. I have gotten pretty far but as always that last bit is tripping me up.Here is the setup.Power Automate:I have a 'Get Properties' node that is returning information about the Word document that I think I need to attach the file including the link and file nameI have an 'HTTP' node that points to the airtable API, the base, table and record in question. I am using PATCH as the method and I have the authorization working. Additionally, I have the content-type set to application/json.In the body of the HTTP node, I have this JSON{ "fields": { "Contract": [ { "url": "https://my.sharepoint.com/sites/My-Team/Shared%20Documents/Word%20Folder/File%20Name%20001%20%5BProject%202%5D%20-%20File%20-%203.docx", "filen

What is the best ways right now?The API Keys are not working anymore. 

I'm getting a CORS error when instantiating a Worker.  What do I need to do to avoid this CORS error when instantiating a Worker?  "Failed to construct 'Worker': Script at 'https://localhost:9000/worker.ts' cannot be accessed from origin 'https://devblock---t-vjm-s-v7-g-mvh-c-b-r--55q8cmv.alt.airtableblocks.com'."  import { initializeBlock } from "@airtable/blocks/ui"; import React from "react"; function HelloWorldTypescriptApp() { const useWebWorker = () => { const worker = new Worker("worker.ts"); // <-- throws error mentioned above worker.postMessage("foo"); }; return <button onClick={useWebWorker}>Click me</button>; } initializeBlock(() => <HelloWorldTypescriptApp />); source code: https://github.com/jacobwilson41/airtable_web_worker_example/tree/main/frontend 

Since the rude depreciation of APIs from Jotform, I have rebuilt my integration using their new system. However, it fails every time a form is submitted reporting:Unknown Field Name "fldqb0p2A79uDENvw". I have no field of that name in either Jotform or Airtable, mine are all user friendly names. So what's going on? I have raised the issue with Jotform support who say they need more detailed logs. Any ideas?

Hello, I am trying to build a query in Power Query/Power BI to load an Airtable table into the data model. I have found some working code which uses the offset parameter returned by the API to deal with the pagination. However, the offset value returned does not match the API documentation and gives an error when I try to parse it. According to the API docs, the offset should look like this: "offset": "reco1XxXxXxXxXxXxXx" However, what I get is this: "offset":"itrZXxXxXxXxXxXxXxXx/rec5XxXXXxXxXxXxXx" When I parse the value into the URL, using &offset=itrZXxXxXxXxXxXxXxXx/rec5XxXXXxXxXxXxXx, I get the following error: {"error":{"type":"LIST_RECORDS_ITERATOR_NOT_AVAILABLE"}} When I try passing either of the values (before and after the /), then the error is: {"error":{"type":"INVALID_OFFSET_VALUE","message":"The value of offset itrZXxXxXxXxXxXxXxXx is invalid"}} Am I missing something here? Thanks!

Im using Parser by Zapier to receive mails and create a record with certain infos mapped to my columns. One of which is the Mail Attachment to be placed in a File Column in Airtable. Somehow the file gets renamed on the process. In my example I send "invoice-60.pdf" to the zapier parser. It got added to the record as "9UngNgXzKLZ3jsMlQmQBOa95o1I5ENxS9LaFRxLNIfNkfLjB0I3ul64-P893QYjt62uhsUPyHBMe_P2i65Zv7-O3qjclkk4ACMI72H8AytGuav9QrcSMjQ1w8Sc1t4_UWDuEuGw6wGENXNjHf3XzQlMf2LLiwwxSveX6kdXYwBk"Somehow the .pdf end got lost in the process. I need to use an Airtable automation to send an email containing that file to a specific address when the status is changed. Due to the lack of .pdf ending the receiving system doesn't recognize the file and rejects it. Bizarre enough, i can open it in Airtable and take a look at the filename, there is no .pdf at the end. When I download it though, the .pdf end is in the filename again... maybe it got added while downloading it?I tried to uplo

Hi there,I have implemented OAuth for my application (using Python) and everything was working fine for several days. However, this morning I received this message in my email: The "OAuth XXX" third-party integration's access to your Airtable account has been automatically revoked by Airtable due to security concerns around refresh token usage. This sometimes occurs due to misconfigurations of the third-party integration. To continue using "OAuth testing" you may re-authorize it. And these are responses I captures when tried to refresh a token (not sure if it's important, but just in case).The first message I received on my server (when it failed) when I was trying to refresh a token: {"error":"<!DOCTYPE html>\n\t<html>\n\t <head>\n\t\t<meta name=\\"viewport\\" content=\\"width=device-width, initial-scale=1\\">\n\t\t<meta charset=\\"utf-8\\">\n\t\t<title>Application Error</title>\n\t\t<sty le media=\\"screen\\">\n\t\t ht

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?