Development & APIs

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 changed to "Order" in "(OMS) Invoices", it should programmatically click button inside "Generate Invoice" so that it loads up the extension with invoice pdf having values. Further to that this PDF will be saved in the "Invoice PDF" and then emailed to the customer associated with that Invoice.Is this possible by using ONLY AIRTABLE INHOUSE AUTOMATION? Ma

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 all.3- when closing

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}`, "Phone": `${

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("default_code_nexus1"); if (!c

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!