Development & APIs

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 record2 = await input.recordAsync('Pick another record', result);if (record2) {    output.text(`You picked ${record2.getCellValueAsString("Employee Name")}`);} Output should be. Do you confirmed to swap First Name Middle Name LastName and First Name Middle Name Last Name?If yes, SWAP if No cancel. Please assist me to create a script or button. It much better to linked the clicked button and choose 2nd record to be swap. Thank you. 

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-select).As an example of my annotated code (my API token has been removed for privacy) that shows how I am

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 scenarios. However, the rows with date ranges with days of the week are not populating at all, and I don't know how to fix it. It looks like it may b

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.append("Authorization", "I_PUT_MY_VALID_TOKEN_HERE");myHeaders.append("Content-Type", "application/json");let response = await fetch(`https://api.airtable.com/v0/{baseid}/{tableid}/${recordId}`, {method: 'PATCH', headers: myHeaders, body: JSON.stringify(update)});let res = await response.json();console.log(res);*consider that the fields {baseid} and {tableid} are correctly filledI'm receiving an error when I try to run it. The error is:type: "INVALID_VALUE_FOR_COLUMN"message: "Cannot parse value for field Testeee"I've already received this error o

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?

I've posted the code below.What am I missing here? I'm trying to update the field 'Parent' with the Parent's record ID when creating records in the 'Child' table, but it says that it cannot accept the value provided...even though it's an array of recordIDs (in this case, just a single one).I even have a log showing that it provides the correct record ID, which it does.I appreciate any help anyone is willing to offer. let sourceTable = base.getTable("Parent"); let destinationTable = base.getTable("Child"); let query = await sourceTable.selectRecordsAsync(); let checkedRecords = query.records.filter(record => record.getCellValue("Transfer")); let recordsToCreate = checkedRecords.map(record => { // Get the record ID from the source record let sourceRecordId = record.id; return { fields: { 'Name': record.getCellValue('Name'), 'Parent': [sourceRecordId] // Pass as an array } } }); while (recordsToCreate.length

Hello, I'm trying to write a custom script (and I'm a JS novice) to extrtact/parse the data from a csv file that an external user would attach to a form submission. I need that data from the csv to then be uploaded into another airtable table within the same base. I tried setting this up with Make and Zapier and webhooks where the form is on Softr instead of Airtable directly but Make/Zapier couldn't read a file attachment on Softr only a urls like a Google Drive link. Here is my starter code: I'm currently getting an error on my forEach(function). Any help is madly appreciated!!  //Set up variablesvar sourceTableName = 'Form'; //name of table to extract data from var targetTableName = 'Claim Assignments'; //name of table to upload data to var csvAttachmentFieldName = 'attachments'; //name of attachment field containing CSV file //Get source tablevar sourceTable = base.getTable(sourceTableName);//Get target tablevar targetTable = base.getTable(targetTableName);//Get