Development & APIs

I’m attempting to integrate Airtable OAuth into an application of mine but the Airtable endpoints to fetch access tokens keep giving an “invalid_grant” error. I’ve already looked at this post and haven’t been able to solve my problem with it: https://community.airtable.com/t5/development-apis/oauth2-problem-with-token-request/m-p/142198#M11746 Step one: The user clicks on a link and gets redirected to Airtable OAuth. Here’s how I generate the link:```const state = crypto.randomBytes(100).toString('base64url');&nbs

Hello Airtable builders,We have been heads down working on a tool that we think you will love building with.Today we are launching SQL as a better Airtable API.Previously, we launched our first sync between Airtable and your Postgres database right in this community. We’ve been floored by all the tools, applications, dashboards, and businesses the community has built on this sync.After working with thousands of Airtable teams, we heard a common suggestion: it would be amazing to write to Airtable through the database. Instantaneously creating, updating, and deleting records with nothing but SQL.So

Hi We have received a notification in our Airtable account that "API keys will be deprecated by the end of January 2024". We have integrated our Airtable and Salesforce account using Zapier tool. Does this Deprecation notification affects the current integration happening via Zapier?. I saw the below comment in Airtable help article that we don't need to do anything, and Airtable will take care of the third party tools(Zapier).Note: We are working with third-party integrations to migrate to using OAuth for integrations. No action is required on your part until they complete the migration, after which you can stop using your API key and use OAuth to connect instead.  Please assist me. "

Hi Team,I have 1 table for base.I will pick a 2 record to be swap.I want the FirstName,MiddleName,LastName records will only be swap. There other records belong the FN,MN,LM will still remain.My Script:let table = base.getTable("Work Station");let result = await table.selectRecordsAsync({sorts: [{field: "Station Number"}]});let record = await input.recordAsync('Pick a record', result);if (record) {    output.text(`You picked ${record.getCellValueAsString("Employee Name")}`);}let record

I'm a new user (still on the trial period before going to Pro). I'm trying to import records using the .csv import extension. However, I keep getting the message that I can't import the records because the "table is locked".I've searched the help, looked around here, and opened a trouble ticket 4 days ago to which I have yet to receive a reply about this.In the help, I've found how to unlock a view, but not a table. Can someone please refer me to the solution here? I've looked under every link with no success.Thank you.

I would like to build a mobile app that tracks user's habits and stores the data in AirTable account of the user.I want to use react-native framework because I want the app to be able to store the data in different services (eg. google sheets). At the moment it isn't clear to me if the AirTable API policies will allow me to insert records into user's tables? My initial tests came accross Cross-Origin Resource Sharing issues. Can somebody enlighten me if what I am after is in principle possible?Thank you.

I have several hundred Jotforms integrated into Airtable. Based on AirTable's announcement about eliminating the API key and changing to two other methods, I contacted JotForms and was informed that they ONLY support the API key.As of August first, I won't be able to create new Jotform integrations and as of Next February, all of my existing ones will stop functioning.Does anyone have a workaround? it can't be a manual solution like copying and pasting because I use it to create real-time leaderboards from the results of the Jotform answers so the results have to get into AirTable instantly.Thansk for any help!

Hi! Maybe someone over here can point me in the right direction. I am trying to build a custom extension, but the moment I add the extension airtable.com becomes “not secured” causing CORS issues with my extension. At the beginning I thought it might be my code, but I tried it with the “Hello World” extension and the same issue, the moment I add the localhost connection the site switched from secure to not secured Any ideas what I might be doing wrong or what else I could test? This is happening with Chrome, haven’t tested yet with other browsers. Thanks in advance

Hello, AirTable forum!I am trying to figure out how to update an AirTable, using the Scripting extension and drawing from an external API (LegiScan). The issue I am running into is that first, I am incredibly new to JavaScript, and second, single- and multi-select options are causing me some trouble. I have reviewed a number of posts in this forum about APIs, as well as the "Cell values and field options" documentation (https://airtable.com/developers/scripting/api/cell_values) but I cannot figure a solution in this case--this is likely my newness to and lack of skills with JavaScript! (I previously mainly coded in R, which is...not the same.)My code can pull the data (and reformat a date), but I cannot update any field that is single- or multi-select, and I am also struggling to declare multiple fields to update (this is, I think, just an issue tied in with the single- and multi-se

I received the following prompt from Airtable's IDE, but I don't understand what it is asking me to do?Could someone please give an example as to how I would pass options.fields to selectRecordsAsync()? TIA!"Calling selectRecordsAsync() method without passing options.fields is discouraged.  Passing options.fields allows you to request just the fields you need."

Hello Airtable Team & community. I want to check something; currently, I’m using Airtable with some automation tools and I have some concerns about the security of these platforms.In my Airtable base, there’s one table that I’m particularly concerned about being breached. My question is, if I restrict access with the following settings: .Will the API if it breached did they still can access to this tables ? Thanks in advance.

Hi — I am new to Airtable scripting but have worked with rest APIs a bit. I'm seeking out some kind of generic boilerplate to help me call a Rest API that returns JSON.Any helpful tips or links would be appreciated 🙂

Currently we have an awesome interface setup that brings in 5 separate tables. Each time we want to go through and look for an item we need to input the variable five times. This makes the system inefficient. A global variable for interfaces would make the system more useable and relatively easy to implement I would imagine!

Hi Airtable community,I'm trying to write a script to update a column on my table based on different types of date ranges. I have the following columns that are relevant to the script:First column defines the type of date. Type 1 is regular date range (from day A to day B), type 2 is range with days of the week (Mondays and Saturdays from day A to day B), type 3 is random dates (July 1st, 7th, and 19th).Second and third columns are start and end dates, which are mandatory for every row.Fourth column is only filled out for type 3 dates, and it has DD/MM/YYYY dates separated by spaces.Fifth column is only filled out for type 2 dates (range with days of the week), and includes the days of the week to be included, separated by spaces.I created the script below to populates another column with a string of DD/MM/YYYY dates in each of those scenari

I have an ongoing problem (3 weeks) and i am unable to create an automation with Twilio.Apparently Airtable can't help either as their customer support has disappeared! Ref. 00577493I have a list of users in airtable with phone numbers (all correctly formatted).I want to schedule an SMS to subscribed users)I get this error when I run a test.The automation is configured to enter the phone numbers from the airtable list. As you can see in the error the automation is adding in lots of code into the list and I am wondering if this is the problem? Hoping someone from Airtable can assist given you aren't answering support tickets.

Please help me its urgent. I only wanted to update a cell by adding (appending) new value to it to make it like the picture I provided, but it is replacing the previous cell value here is my code that updates. base(‘Participant Score’).update([ { “id”: “recZbJYK8KPYZcIdI”, “fields”: { “Score”: [ “recvwoc3tOqfdjXUk”, “rec0CRNPStI5JI0zN” ] } }], function (err, records) { if (err) { console.error(err); return; } records.forEach(function (record) { res.status(201).send(record) }); })

I've already updated some fields using the Airtable API, but never in a multiple select field. Right now I need to update a multiple select field using Airtable API. For this, I'm implementing the following code in a script action on an automation.let inputConfig = input.config();let recordId = inputConfig.recorId;const update = {"fields": {"Testeee": [{name: 'A'}, {name: 'B'}]}}let myHeaders = new Headers();myHeaders

Hello ! I want to develop a custom app for a client, it’s only a custom form with conditional field rendering, and I wonder if external users (with read only links) will be able to get the app and fill the form ? They don’t want to pay an account for each user that just access the form. Thanks in advance! Have a great day :slightly_smiling_face:

Dear All, A new user to Airtable here. Can we use the scripting blocks to download the attachments in a record in a particular view ? If so, could someone help with me a script please !! Using this for some automation in #CovidRelief

Is there any option available to integrate Airtable and Amazon S3 Bucket for transferring data to and fro? If yes. please guide me with third party tools as well as how can I create by myself.

 I have created a webflow logic triggered by a form. The data of the form is sent to airtable. Currently receiving the following error: "error": { "type": "INVALID_REQUEST_BODY", "message": "Could not parse request body"however tests are running successfully. Please see below: In webflow's community someone said to check JSONlint and this is occurs: let me know if there is any additional information I can provide in order to clarify. Any help is appreciated! 

Hi all, I need a bit of help with a simple script to trigger a webhook URL. I don’t need to collect or post any info from the webhook, just to trigger it, like clicking a link. Any ideas on what that script might look like? Cheers Matt

I hve create a table in airtable and in its form view I hv added calculated fields so that I can see the Earned Leave available for a particular Name. I want make it publish so that my colleagues have to upen the app through internet and found their leave earned. Can I do that

I would really like to be able to deleted created elements in certain list / grid interfaces I made. Although, I get this 'error' (See attached). Does anybody know how to work around this?

Hi all, I'm not a programmer and am new to the world of automation.  🙂  I have a base with multiple records that are linked to multiple interfaces and am looking for an efficient way to edit only certain fields in certain records.  Can you do that with an excel import?  We have over 500 records in our database and those records correspond with another database (not airtable) that needs congruence with our airtable.So far, I'm seeing ways to update using a separate table or using a form to update individual records.  Any recommendations for APIs that may work?