Development & APIs

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({filterByFormula: '{RECORD_ID() <= 5}', // Filter to get the first 5 recordsmaxRecords: 5, // Limit to 5 records}).firstPage((err, records) => {if (err) { console.error(err); return; }records.forEach((record) => {console.log(record.fields); // Access record data using record.fields object});});  I keep getting the following error:  ○ node one.jsAirtableError {error: 'AUTHENTICATION_REQUIRED',message: 'You should provide valid api key to perform this operation',statusCode: 401}Yes, I have given full permission in the scope to access the base and the read and write permissions. 

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"; } else if (

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, that would be appreciated. Thanks

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.

I work with a team and we have a field that we write notes in it (I don't like the comments section), the field type in Long text. It is very easy to accidentally delete contact from it. I want to defend it from this by demanding the user to manual saving the changes in the field, i mean like without auto save, that a user will have to hit Save button in order to modify the content. Is it possible? and if so, is there any built-in tool that i can do it with or we will need code / other external tool. By the way i know that we can Undo actions with Ctrl+Z but the problem is that we are not always notice that we've accedantlly deleting something. 

Good afternoon everyone! I’m trying to create custom currency conversions for a project I’m involved with. We’re traveling around the world selling concert tickets at the door of the venues, and each country has a different currency. I want to be able to take the ticket price for each country’s currency and convert to USD which will then be displayed on that record. I’ve seen this script is available to convert currencies, but I don’t know how to make the currency type dynamic as it only seems to show a single currency in the example. How can I edit line 7, where is says “GBP” to take the currency abbreviation from a field that exists within the record (ex, EUR,NZD,AUS). Any help is appreciated!!

Good evening,I'm at a dead end. I would like to create a way with Voiceflow to send information to each question asked by the AI. Unfortunately they put it on several lines instead of putting it on the same line, can you help me please ?  

Hi everyone!I was wondering how easy/complicated it is to have a programmer build a custom frontend for an Airtable Database. I am still looking to build a Report tool, where workers can create a Report for the day and choose from a number of project specific Tasks and document how long they worked on each task for that day. Each project specific task also has an underlaying task template and is part of a project specific task List at the same time. Basically its a bunch of tables linked with each other and then in the End I can see how long each task has been worked on etc. I already build the structure in Airtable and you can add contents but its obviously not userfriendly at all with the standard airtable interface. Now if I hire someone to build a custom frontend build for this, is that something thats doable relatively easy or is it just going to be a giant pain in the ass for whoever builds it? There is some extra stuff too. For example each report has a

Hello! I am trying to use Make.com to connect to another company's airtable base for read-only purposes. The company that owns the airtable account is a client of mine.  Thus, I believe I need to use the OAuth method with a client ID (and a secret? I don't think the secret is necessary?). We also tried connecting make.com with a client id + a secret, no luck either.I receive the error This third-party app failed to properly construct a request to Airtable: invalid client_id or mismatched redirect_uri.I opened make.com in an incognito window. now, when I try to connect in the same way, a new browser tab automatically opens and redirects to airtable.com login. this also doesn't do me any good as I'm trying to connect to my client's airtable base via API.In the Airtable developer hub, the client has registered a new oauth, provided me the client ID, and added the redirect URL that make.com requires:https://www.integromat.com/oauth/cb/airtable3. I stepped through this with t

I am trying to set up an OAuth for Make, as API keys are no longer available to use, and it says not to give Personal Access Tokens to third party companies.I do not understand what the 'OAuth redirect URL' is supposed to be, at the moment I have tried the web address for Airtable https://www.airtable.com/, https://airtable.com/oauth2/v1/authorize, the web address for my Airtable base, but no luck. I'm not sure if this is the issue?I have used the same name and have copy and pasted the client ID (deleted from the screenshot for privacy).The error message I am getting is: This third-party app failed to properly construct a request to Airtable: invalid client_id or mismatched redirect_uriPlease can someone help?I have used API keys before and never had an issue, but I feel completely out of my depth with the OAuth and would prefer to use a token, but don't want to share my personal token with a 3rd party if Airtable advise against it, as it is for a company and I want to keep data s

Hello all – Is there yet a way to access (i.e. read/write/update) a record’s fly-out comments via the API? We have another app in which there are comments that we want to merge with the appropriate record’s comments in AT. If not, is it anywhere on the roadmap? It totally affects how we plan this integration. Thanks!

Hi,I'm really wrestling with finding a solution here and I am sure I am not the only one who has the issue.  I have 2 tables in Airtable:1) Skills Table - fields include SkillId, Name, Description, Link to Skill Definition table via DefinitionId2) Skill Definition Table - fields include DefinitionId, Definition, Level (Level is either Beginner, Intermediate or Expert)When I call the API and GET a skill from the Skill Table I would like the Skill Definition to nest as an object in the response.  I noticed this behavior is possible with the Collaborator type, shown below for the Assigned fieldAt the moment when I link the Skills Definition table to the Skills table and add lookup columns from the Skills Definition table, then call the API from Postman, the fields are shown in a flat structure as an arrayIs there any way I can nest this object linked by the Definition Id like the Collaborator type?Thanks in advance.     

I would like to ingest Airtable data into backstage. Frankly I'm shocked this doesn't already exist. I am currently building a plugin to facilitate this. If anyone wants to have an input, please reach out to me at hanfordn35@gmail.com.

I am trying to create a script using curl which basically would download the image from the url embedded within the field of the JSON I downloaded with the API. curl is supposed to use the whole value of the key `url`(https://v5.airtableusercontent.com/v3/u/29/29/1716998400000/APymLz9oGAW4AZ1vM_9z3w/53CMUJ...) + the value of the `filename` (SKM_36722071214070ff.pdf) and then the desired output name of the file. It would be the same that browsing the url + filename, but when passing just the url to the browser it displays the attachments as the are in the Airtable field, but if I add url + filename in the form url/filename it doesn't displays the file. Is there any other approach that I can download all images attached to my airtable fields programatically, including pdf files, png images, and so on?

Hi! It seems like the OAuth refresh flow randomly fails for no apparent reason even though nothing has changed. It doesn't happen predictably, it's quite random and this forces our users to re-authenticate Airtable which is a lot of friction. Has anyone else experienced this or found workarounds?Thanks!

i'm tryng to create a record in a table from base "B" by running a scritp from base "A"but how can i get the table from base B in my script that is in base A?

I'M TRYING TO UPLOAD PDF FILES TO AN AIRTABLE BASE USING PYTHON, BUT I'M FACING ISSUES WITH THE PROCESS. I'VE TRIED MULTIPLE PYTHON LIBRARIES, BUT NONE OF THEM SEEM TO WORK CORRECTLY FOR MY USE CASE. Here's the code I've been using (replace with your latest code snippet): import osimport globfrom airtable import Airtable # Configure Airtable connectionairtable = Airtable('base_id', 'Table 8', api_key='api_key') # Path to the folder containing PDFspdf_folder = r"C:\Users\camip\Desktop\_adjuntos_prueba" # Get a list of PDF files in the folderpdf_files = glob.glob(os.path.join(pdf_folder, "*.pdf")) for pdf_file in pdf_files:try:# Get the name of the PDF filepdf_name = os.path.basename(pdf_file) # Extract the number from the file name by removing the extension and converting to intpdf_number = int(os.path.splitext(pdf_name)[0]) # Get all records from Airtablerecords = airtable.get_all(view='Grid view') # Find records where the name contains the

Hi. In the past week, I started getting random "[500] Server error" when calling various Airtable modules via Make. No other information is provided. If I retry the scenario, usually then it works.Any idea what this could be? Could it be that I'm hitting some kind of limit? According to this page (https://airtable.com/developers/web/api/rate-limits), it says the error code in case of a limit should be 429 not 500. Screenshot below shows an example of the error. Note that it is not happening only on one type of module like 'Update a Record', but even say 'Get a Record' or Search.