Development & APIs

How to edit cells within AIRTABLE as I have seen it detects values inside a cell like Listbox but not possible to edit like Excel cell F2.

Hello, I have a whole column of data with html links and I need these to be clickable links with the respective titles: DATA: <a href=https://www.coronavirus.tas.gov.au/media-releases/important-coronavirus-test-information>Tasmanian Government: Important coronavirus test information</a> Needs to be Tasmanian Government: Important coronavirus test informationHow can I achieve this via airtable? There are so many, relinking them all by hand is going to be tedious. ThanksI will ultimately be exporting this to excel.

i am new to airtable i want to connect database of airtabe with my project of laravel. i need to operation on that like we do in laravel with models with local databse. Is this feasible and or tell me the other easy way to connect it and do operations on it

Hi,I currently have an Airtable base connected to Softr that has 198,322 / 250,000 records. When one of my stakeholders are currently endorsing in Softr, they receive this message (see screenshot).I would like to know the root cause and a possible solution to this please.Thanks

Is it possible to have live market data from multiple crypto exchanges imported into my Airtable via API? (Binance, KuCoin, Coinbase, etc..)I am trying to create an app that utilizes this data. Unfortunately, I failed to get this done myself.The data I need to have live data for are "Symbol," "Ask Price," "Bid Price," and "Trade Volume."I would appreciate if anyone could provide any guidance. 

Hi all -I am working to update an Airtable table using responses to a Qualtrics survey via Zapier. I have many multiple choice questions, some up to 17 options, and the column these feed to in Airtable is itself a multiselect field column (so I want each item to show up separately). At first, I had the issue that when I listed all multiple choice fields from qualtrics one next to the other, it put it in as one giant option, as shown in the right of the attached Airtable screenshot (early stage growth stage as one item). I resolved this partially by putting commas between the fields, as shown in the zapier screenshot. That turned into the left example in airtable - now they are separate items, but if an item is not selected, it still includes a blank entry. Is there a trick to resolve this? Open to all ideas - thank you!

I'm not certain if the OAuth flow is working as expected...When initiating an OAuth flow for an existing, and currently logged-in user, the OAuth pattern works as expected. After the OAuth consent screen is displayed, flow correctly redirects the user to the redirect_uri.However, if a user is NOT logged in, the flow works to the point of providing an Airtable login screen for the user and then drops them into their admin page WITHOUT a OAuth consent screen. I would have presumed that for users who have not logged in, Airtable would allow them to login and then proceed to the OAuth consent process. As it stands now, users are dropped into Airtable without ever redirecting back to the calling site leaving users stranded. And assistance on this would be appreciated.

When trying to read or write data to and from a long text field via the API, I am loosing the newlines.This is an example of what I have in the field:When reading the content through the API, I am getting this:Also, when writing \n to the field via the API it get's stored literally, i.e., is not translated into linebreaks:I cannot find any hint how to encode newlines in the API docs or the forum.Any help would be highly appreciated.  

If anyone could shed light on this I would be appreciative. In my example, I have two columns, one with a ResourceName, the other a URL. A third column would hyperlink the ResourceName with the URL. Easy peasy? Not so. Still. A: ResourceName    Brown CowB: URL                        https://browncow.comC: Resource              Brown CowI tried this script from another thread but, line 2, let query = await table.selectRecordsAsync (); function is deprecated. It does work... for 15 rows but, stops there, and no matter what I try, 15 is all I can get.   let tb = base.getTable("My Resources"); let query = await tb.selectRecordsAsync(); for (let record of query.records) { let url = record.getCellValue("URL"); let text = record.getCellValue("ResourceName"); if(url) { tb.updateRecordAsync(record, {"Resource": `[${text}](${url})`}) } } 

Hi All,In terms of security and protection of clients data, which is better Airtable or Jira? how they are different from each other when it comes to security ? Many thanks 

https://github.com/sleiman/airtable-phpI have been using this tool flawlessly and working my new Personal Token where my API key existed.use \TANIOS\Airtable\Airtable; $airtable = new Airtable(array( 'api_key' => 'API_KEY', 'base' => 'BASE_ID' ));When I swap out the API_KEY with my new Personal Token it doesn't work, which I suspected. What do I need to change api_key to? Is it that simple I hope! Thanks in advance!- Jon

I am new to Airtable development and this token thing is very confusing to me. How do I connect to Airtable to update or create my records using python?

I have several used cases that I’ve been able to manage well with cloud functions. However the only use case that I cannot find a way to manage is how to update my firebase database when a airtable record is updated, I can use zappier to keep my db updated when a new record is created, but there is not support (as far as I know) from update records. Has anyone crossed with this case?

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