Development & APIs

Hi, I'm working with the Airtable API, and am noticing that the "list records" API endpoint is returning linked records in "cell format V1", while the Webhooks API returns values in "cell format V2". Cell format V1 is an array of strings representing record ID of the linked record(s).["recXXX", "recXXY"]Cell format V2 is an array of objects representing the record ID and 'name' of the linked record(s).[ { "id": "recXXX", "name": "Linked Record A" }, { "id": "recXXY", "name": "Linked Record B" } ] In my case, I really want to see the "v2" format in a 'list records' API call. Is there an API endpoint that will return this, or is there one planned for the future?

I need to search records in multiple databases and if the search result is not empty then set a variable for that particular organization. I will then compose an email using non empty variables. Scan Airtable A base, if the output is not empty, set the variable Clinic A to results. Scan Airtable B base, if the output is not empty, set the variable Clinic B to results. Compose email that includes non empty variables: Hi John Smith, Please submit the following items: Clinic A variable (has value - not empty) [Clinic B variable is not included as the variable in the previous scenario was empty due to no search results) Can’t figure this one out as Integromat requires everything to go in a flow as I am using filters to filter in or out empty search results. But if search results for variable A are not passed then the rest of the flow does not happen.

Hi There, It seems that there is no way to call directly an external API to a record on Airtable. My goal is to be able to shorten URLs (using Bit.ly API) in my database. I was wondering if there is a way that scripts might be able to help? Here is Bit.ly API reference : https://dev.bitly.com/api-reference I appreciate any help on this subject. Thanks

Hi, I'd like to know if it's possible to get the ID of an interface's table from its page ID, or if there's any other way to get the ID of an Interface's lined data for the api from within the interface itself? In the DOM or anywhere else?Our team built an integration for Airtable that lets users run their own features from within the Airtable page. For it to work with interfaces we need the record + table id from the interface view/page, is there anyway to get it through the url or the html on the page.Thanks!Ohad.

Hi,I already have a working api tested by apifoxand it produced this code for me  var myHeaders = new Headers();myHeaders.append("User-Agent", "Apifox/1.0.0 (https://apifox.com)");myHeaders.append("Content-Type", "application/json");var raw = JSON.stringify({"name": "k1d","email":

Is there anyone who has a script to unzip an attachment field into another attachment field. In other words in Attachment field 1 is a zip file, have a script unzip and put all attachments as separate files in Attachment field 2. The zip file is coming in from Jotform through a zap in Zapier.

Would someone from the custom extension review team be willing to pop in here and answer a question for me?  Would be greatly appreciated!I've been working on a single extension for 18 months and have a question about breaking one of the extension rules.  I would like to provide some context and see if a workaround could be found. Thank you!

It is very frustrating to match up automations or API processes with data changes in a record's "activity" log with broad time information like "an hour ago" or "2 days ago." Please consider introducing fine-grained timestamps EVERYWHERE you log ANYTHING. As an Integrator née Software Developer, this is making me pull my hair out

Hello,I am new to Airtable. I am trying to do one automation which is as follows.I have a table named "(OMS) Invoices" having 2 newly added columns which I want to use for this automation.First Column name is "Generate Invoice" which is a button with following configurationSecond Column name is "Invoice PDF" which is an attachment.Manually when the button in "Generate Invoice" is clicked it loads an extension "Invoice" and performs the action as mention in button configuration "Open in Page Designer". This populates all necessary values in invoice PDF from airtable table "(OMS) Invoices".What I want to automate is, whenever "Status" is chang

Although the Kanban view has many limitations it was working before the last released update...the bugs are really annoying...limiting staffs ability to work effectively in the Kanban view without refreshing the screen every 2-minutes...what is the plan Airtable? It would have been nice to have a heads up on the change or at least a "we're working on a solution" message.1- after expanding a record and closing it, the scroll option simply does not work...in order for the scroll feature to work the screen needs refreshed- major pain in the a$$2- when entering a new record from the new carrot at the top of the uncategorized category, the system is automatically assigning a category...the add task at the bottom still works but you have to scroll (or attempt to scroll and then refresh the screen) all the way to the bottom to add a task. Oh, where did the new uncategorized record go- good question...oh look- it was automatically assigned to the wrong group...fun times for al

Hi, Does someone else have problems getting webhook trigger from Hubspot ? Here is the response message that Airtable give to Hubspot:{"success": {"statusCode": 400},"fail": null} Wich apparently mean that things are not working properly.

I am using the Airtable js package for nodejs and it is my first time. I have dynamic data that I would like to store in a table. Is there a way to send the request once by passing an array into the create method? I don't want to iterate the array and call the create method on each iteration. I'm sure there is a way to do it once, I must be missing something.const base = new Airtable({ apiKey: `${process.env.AIRTABLE_ACCESS_TOKEN}`}).base(`${process.env.AIRTABLE_BASEID}`); const tempOrderParticipantData = [...params?.participantData as participantDataAttributes[]]; const tempRecord: unknown[] = []; tempOrderParticipantData?.forEach((item, index)=>{ tempRecord?.push({ "Full Name": `${item?.participantNameInfo?.participantFirstName} ${item?.participantNameInfo?.participantLastName}`, "First Name": `${item?.participantNameInfo?.participantFirstName}`, "Last Name":`${item?.participantNameInfo?.participantLastName}`,

Hi! I'm building an app with Bubble.io. The problem I'm facing now is that I need to create new records in my Airtable Base, from my Bubble app's UI. I do not have any problem to create new records, except when I need to populate a linked field. The new entry is created as expected, but the Linked field remains empty. Do you know how to process? Thanks a lot!

Hi, i'm landing with airtable and so far loving it, but I'm not sure if scripts works like other environments...I have a table record with a lot of blank values at ID column because is an exportation from another ddbb and it exports fields with multiple values as a record for each value. Usually in other apps I make a script for this that get the variable when exists the ID value and replicate it at the next empty records ID until it finds a non-empty value and updates the variable, and so on.I made the script and don't seems to have any fail but when executing is not doing anything (also no error text):// Define the table and select all records let table = base.getTable("Dashboard"); let query = await table.selectRecordsAsync(); let records = query.records; // Initialize the lastref variable let lastref = null; for (let record of records) { let currentDefaultCode = record.getCellValue("default_code"); let currentDefaultCodeNexus1 = record.getCellValue("def

How can Sort list of Records by the order they were created in both. Would like to know how I can do them both ascending and descendingI also don't have any created time field I can't create that since I'm using the API And as far as I know it does not support creating formulas with the API So is there any other way to do this without using fields

When using the get request to get list of all the records is there anyway we can get list of all the records but the data only returns specific fields?

I have tried to URL encode my URL. In Power Automate Desktop The URL value is presently evaluated as:https://api.airtable.com/v0/appKJvw9LuKiqGcRt/tbl7MUhoqb9r5hk6V?filterByFormula={Root}=Can't Process: Missing Acct #where Root is the name of a field.In Power Automate Desktop, I am am getting an invalid filter by formula error.Am I missing quotation marks?

HelloI have a requirement where I want to create a Unique Customer ID based on their name and an incremented numberFor example:I add a new customer "XYZ (North)" and want to generate the Customer ID XYZ001Then I add another New customer "XYZ (South)" and want to generate the Customer ID XYZ002ID would just increment for each 3 character prefix.  I have no problem with having another table to trank the highest used number for XYZ if needed Fields would be "Customer Name" and "Customer ID"TIAMike

const Airtable = require('airtable'); const airtable = new Airtable({apiKey: 'patMH--changed--FEQXBB4',}); // Replace with your Airtable base IDconst baseId = 'appM0aa--changed--DFmhzwJv6w'; // Replace with the table name you want to accessconst tableName = 'home_first';airtable.base(baseId)(tableName).select(

How do you keep track time spend on a given task ? I’d love a ChromeExtension to start/Stop a timer on a given list of task (aka an AirTable View) I don’t know if for a given Task it is better to Start / Stop a Duration field on a kind of Task row Start / Stop a tracker that will have a reference to a Task (to say I work on that Monday, Tuesday and Friday) Anyway : all Pomodoro “like” are bazooka with non sens paid subscription … third party app SaaS, etc … AirTable WebClipper is not very handy AirTable TimeTracker use Dashboard (I find dashboard not very usefull for many reason) Any Idea before I code my own extension quick and dirty ? The cleanest solution (for me) would be something like WebClipper but to edit existing items and not only add new ones. So I would be able to quickly update task of a view for instance.

 // Ottieni i parametri di input let config = input.config(); let recordCRM_id = config.recordCRM_id let ruolo = config.ruolo; let pagamenti = config.pagamenti; let minorenne = config.minorenne; // -nocheck let baseID = 'IDBASE'; // ID della base LabOratorium let tableID = 'IDTABLE'; // ID della tabella in cui si trova il record da aggiornare let recordID = recordCRM_id; // ID del record da aggiornare let personalAccessToken = 'TOKEN'; // Il tuo Personal Access Token di Airtable // Funzione per calcolare la formula function calculateFormula(ruolo, pagamenti, minorenne) { let result = ""; if (ruolo) { result += "Loreto24_" + ruolo; } if (ruolo && pagamenti.includes("Acconto")) { result += ", Loreto24_Acconto"; } else if (pagamenti.includes("Acconto")) { result += "Loreto24_Acconto"; } if ((ruolo || pagamenti.includes("Acconto")) && minorenne === "SI") { result += ", Loreto24_Minorenne";

Hi,Is there a way to take an existing page designer extension, figure out what fields are displayed on it, and create a table view showing those same fields? The goal is to have a table view where if I fill in every cell, I could then print "all records in view" in the page designer extension and feel confident that every page will be fully filled in. I've been doing it manually by creating a brand new all-fields-hidden view, going into the editing view of the the page designer extension, copying the name of each field and unhiding that field in the view. But there's dozens of extensions and dozens of fields. I assume this could be done with two separate scripts? One to take the page designer extension as an input and then output a csv list of the field names, and one script that takes the list of field names as an input and could create a view with those fields shown and all other fields hidden.

I currently use the Airtable API connection to pull data into Google Sheets. I've gotten an automated message that the API key will no longer work in 2024. Is there a new solution that I can use? 

Hi,I am trying to generate an OAuth token via servicenow and I am running into some issues. When trying to get my OAuth token I am faced with the follow error:"error=invalid_request&error_description="state"+parameter+is+invalid.+Note+that+it+is+required.&state=-68948287"I am reading through the documentation of OAuth reference just now (OAuth reference - Airtable Web API) and see the state parameter should follow certain rules and I believe I am not breaking them with the below state value:'Jt8WzfnT7dSbXn2xL1dY.mJq3-UvN4Kz0oGcRbH6pEjViI9Xy_OgZAkCs5lPuehr' I have created a rest message and application registry record for this integration and using the 'Get OAuth Token' ui action withing servicenow to do this. If anyone can provide any help or has integrated sn with airtable using oath tokens before, tha

Hey, I have seen many people asking for amazon and airtable data connector which can help them get thier amazon seller data like inventory, sales, orders, etc into airtable. But those posts were almost year old. Does anyone needs this? I am looking to build this if there is enough demand. You can show your interest by filling your email in this form and can also ask for feature request to be included.