Development & APIs

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.

Hi, Does anyone have a working integration, where stock prices are automatically (eg timebased refresh) fetched into an airtable sheet, depending on eg ISIN, etc. I just found quite old posts and only one newer video (How to Track Stocks in Airtable - YouTube), but the script link in the video is outdated… So any help with providing a script, etc. would be highly appreciated. thanks a lot, Chris

¿Como puedo hacer para que despues de guardar un archivo, sea descargado en mi disco local, utilizando PyAirtable?El siguiente codigo muestra el comando para guardarlo, pero ¿Como puedo descargarlo mediante PyAirtable? archivo='https://archivos.ujat.mx/pagina2020/index/divisiones/dacsyh.png'#Ingresar Datostable.create({'id_division': 'DAViS',                    'nombre': 'Division Academica De Soporte',                    'ubicacion': 'Cunduacan',                    'documento':[{'url': archivo}]})

I have 2 bases (Payments and Ledger)And on Ledger base i have a sync table from Payments baseI'm making a script that runs on a table in the Ledger database. This script will create a record in the Payments base and then link that record to a table in the Ledger base.But I'm having problems because the synchronization table has a different ID and recordID than the original table in the Payments base.If I pass the recordID from the Payments base to link it to the table in the Ledger base, will that work?

We see that from last three days we are frequently getting 502 Error in spite of no changes on the URL and how we retrieve the data from airtable.It's even seen that Api calls are working for some time of the day and failing for some cases.We would like to know from community what and all trouble shooting can be done.Troubleshooting done.1. Called the API locally and it's working fine.2. Checked the number of calls as well its well in limit only of the Teams subscription.

Ever since personal token system came in Airtable, my data is not showing in Kodular. I have tried everything, tried putting personal token instead of api key but got no result, can't understand where is the problem. 

Does anyone know of documentation that has an example of creating each field type using Node.js?There are certain field types I am running into issues with such as date fields and currency fields and I can not find much documentation of when an example for each field completed looks like.

Hi, we are configuring a new OAuth App, and would like to configure multiple redirect URLs.Is that supported? Can we provide multiple URLs? Thanks

The past week or so, we have experienced intermittent issues with the Jotform + Airtable integration.1. Some Jotform submissions indicate they were successfully sent to Airtable, and never showed up in Airtable.2. Fields that contain more than one attached file (like multiple photos) are only sending over the first file.In both cases, the integration log shows success. It is not every submission, just some of them, making it hard for me to troubleshoot the problem.

I'm trying to filter my extract by the bank that the user select, but i'm always getting null.What am i doing wrong?const extract = await Extract.selectRecordsAsync({    fields: ["Name", "Data", "Valor", "Bank"]}).then(query => query.records)let bank = await input.recordAsync("Escolha um banco: ", Banks)const extractByBank = extract.filter(ext => ext.getCellValue("Bank") == [bank])

Hey I just wanted to ask if I can install extensions for free as a developer is there any privilege to those who are extension developer 

Hi,I'd like to insert the error message into a field, so I used try catch with both of them updating a variable, which I then used to update the field. Weird; it only updated on success, not on error. Can anyone help? let config = input.config(); const recordId = config.recordid; let tabletable = config.tabletable; let table = base.getTable(tabletable); let query = await table.selectRecordsAsync({ fields: ["Error"] }); let err; try { await table.updateRecordAsync(recordId, { "Eat": "Cheese" // no such field }) err = "Code executed successfully"; } catch (error) { err = error.message; } finally { console.log(err); await table.updateRecordAsync(recordId, { "Error": err } ); } console.log("Updated a record!");  CONSOLE.LOG "Could not find a field with name or ID "Eat"." ERROR Error: Could not find a field with name or ID "Eat". at main on line 16As you can see, err was properly logged. But the record was not upd

Hi all! I’m in desperate need of a way to get the data I have in a table into Google Sheets. I would prefer not to use Integromat, but a script. I’m not a developer… I found a script (https://www.optimi.co.nz/blog/2019/05/11/you-too-can-make-dashboards-how-to-visualise-your-airtable-data-in-google-data-studio) but it pulls all the columns of the table and I would like it to pull only the ones that are not hidden in a specific view. Also, since I will be referring to those columns in other sheets, I need their order not to chance when it updates. Any suggestions? @Bill.French? Thank you!!

Hello everyone ‌🙂‌I have a large number of automation scripts, some of which are quite complex. However, developing the scripts is relatively tedious because the script editor gives a limited view of the code (and it lags behind a “real” IDE, e.g. no copilot etc). There is also no version control.I currently develop our scripts this way:I write the script in Visual StudioI also maintain the GIT repo thereWhen I'm done, I copy the script into the Airtable script editorHowever, copying back and forth is error-prone and tedious.My questions to the community:What are your best practices for writing automation scripts and managing the scripts?Is it really not possible to make the code view in the editor full screen (Safari, see image)?Thank you very much!

OpenAI's API for GPT-4 constantly has an over 30sec delay in responding to larger token prompts. This makes automation in AirTable rather useless unless you go to the trouble of building cloud functions. I have multiple working automation steps to categories data, create short email replies etc. But if you want to do anything real with GPT-4 it's limited by the response time. Question - how can I get around this? Any thoughts?