Development & APIs

Hi again,everyday I love more and more Airtable! I had to admit that... 🙂But... I stuck on KEY function of builded app... KEY FUNCTION 🙂I have a list with products, min/max are numbers, and defining working range for product:name | min | maxabcd | 100 | 200efghi | 145 | 455......I have to add a search field in interface where user can type a number, and table will be filtered to products in range. For example typing 70 - gives no results; typing 120 - gives abcd; typing 190 - gives abcd and efghi.HOW TO DO THIS?If not in Airtable - can you recommend any no code tool for building this (with Airtable as backend).RegardsTomek

Is there a way to set up Pitchbook and / or Asbhy integrations or APIs with Airtable? If so, any recommendations on what's the best way?

I'm using the Airtable API to create a new base and a new table (called 'Raw Data') within it. All of my singleLineText fields are working fine, but when I add a final field named 'Last Modified' with a type of lastModifiedTime, I get this error back from the api call:error: {   type: 'UNSUPPORTED_FIELD_TYPE_FOR_CREATE',   message: 'Invalid options for Raw Data.Last Modified: Creating lastModifiedTime fields is not supported at this time'}I haven't been able to find anything in the API docs or by googling about this. I would appreciate any help.     Thanks,     Rob

I want to make it simple for users on my CFL prediction website to search through my Airtable content. I'm considering using the Search app. Is this the right choice, and do you have any tips for setting it up effectively?any Idea?Any help is appreciated!

Hello,I have a question regarding the Airtable API key deprecation, and was hoping someone could clarify/confirm. Basically I am wondering whether this change will affect us, and whether we need to make adjustments. I've searched the forum, but I did not find an answer. Maybe this is a newbie/misplaced question. If so, I'm sorry.I have a base today where we use the Google Distance Matrix API to retrieve info from the Google API. We have no external services connected to the Airtable base. If we go into the "Developer Hub" and look at "API Key" the list is blank. That is true for "Personal access tokens" and "OAuth integrations" as well.The Distance Matrix API uses an API Key, which we have created through google. We use this key when Airtable connects to the Distance Matrix API to get info. This is done in scripts and automations, and we use the function"await remoteFetchAsync(txturlrequest)" to interact with the API through the scritps. In the automation

Hi everybodyWe just upgraded to the Airtable Business account and recently updated our Airtable connection in Zapier from one user's personal access token to another user. Now all the Zaps using Airtable have stopped working - and have an error message that the Airtable connection is expired.I've tried reconnecting the airtable account several times, and each connection says expired.When you sign into Airtable through Zapier, there are a few new options... I've selected the organization option as this makes the most sense for us. No luck - it always shows as an expired connection. Any advice??

Hi everyone, Excited to be using the Airtable API!I'm trying to add new fields to a given table in a given base via this endpoint, but keep getting a 404 {'error': 'NOT_FOUND'}Here's my code:payload = json.dumps(payload)response = requests.get("https://api.airtable.com/v0/meta/bases/{base_id}/tables/{table_id}/fields".format(base_id=base_id,table_id=table_id),headers={"Authorization":"Bearer {token}".format(token

I want to use timelines to keep track of, and plan things that happen to our garden beds at work - weather that is ammendments, planting, seeding, etc. Currently, each event - e.g. seeding of carrots, or application of lime is it's own record. When multiple things happen at once, against each bed, the timeline view is unwieldy to navigate. EG here I can only see 2 out of 60 beds at onceAll related events are grouped by a unique code. I can use another table, that connects all records with the same code into a single record, and timeline view that. Like this:But functionally this is inelegant, and for useful experience, I need to be able to edit the individual elements in the same base. For planning purposes, I really need to

Recently our Softr.ai app has not been able to consistently load information from our airtable databases. This never used to be the case and nothing has changed in the configuration. I am wondering if this is linked to the API changes - I read somewhere that if an airtable client now goes over their API limit (which we do if we are treated as a Team client and not a Pro client) then the 5 API calls per second is impacted. Is this what might be happening? (See screenshot - "request limit exceeded") I understood from what  you said that we would be getting unlimited APIs on our current plan (Pro) until it runs out in April 2024 (because we have paid for an annual subscription), but I am wondering whether this is not the case and our ability is to make API calls is already being impacted. It would be really u

I have an issue where a sync that used to work has stopped as of 13 hours ago.The sync is from one base to another.This is the error message on the table that is being synced from the original."Unable to sync this source. Internal sync error"There have been no structural change or field name changes on this base during this period.Filed a support ticket (00634496) but this is business critical and a day to get a response doesn't answer that.

I am trying to create new records via airtable.js, when I try to create a new record in Link-to column with row-value (i.e. name - string not Record ID), it does not work and reply Class {error: “INVALID_RECORD_ID”, message: “Value “VALUE” is not a valid record ID.”, statusCode: 422} Is there any way to avoid this condition? or there is not “typecast” command in airtable.js ? if yes, please let me know some example, var dataCompt = { "field1": "value1(text)", "field2(Link-to column)": "value2(text)" }; function createATData(){ base(tableName).create(dataCompt, function(err, record) { if (err) { console.log(err); return; } //loadArtists(); }); }

Hi guys,I have been trying to create a simple Make.com scenario to test the waters, where an Airtable record is created from a pre-specified Etsy receipt. The first step works great, all records are pulled from Etsy's API, but when we get to Airtable, I'm getting a repeated [404] Not Found error.According to Airtable developer @EvanHahn's answer here, Airtable only returns 404s in two cases. I quote:the resource you’re fetching is missing. For example, if we can’t find the table, or the base, or the record, or whatever.the URL you’re hitting is totally bogus. For example

Good morning to you,I'm trying to create dynamic ToDoLists.At first, I thought I could solve my problem by using complete NoCode (see my post).Finally, after some advice, I turned to @Giovanni_Briggs code and post.I've never coded the day before yesterday, and I'm trying to use AI tools to understand what I'm doing.I've managed to adapt the proposed code to my base and half of what I want to do works.As it happens, my code copies the tasks from my original list very well,It links the new tasks to the event we've validated internally,But it doesn't create a link between parent and chil

I'm writing a script in Airtable Extensions to pull data from Canvas API. I've set the per_page limit to 100, because that's the maximum number of objects Airtable will retrieve at once for an external API.I need to use pagination to download the rest of the results. According the Canvas API reference, it's in the response header Link value. I'm able to see this in Postman but how do I retrieve this in an Airtable script? How do I set up a loop to paginate until the end? All the online discussions are about Airtable's API and I can't find how to retrieve response headers.  let currentCourses = await remoteFetchAsync("https://XXXX?per_page=100", requestOptions); const currentCoursesData = await currentCourses.json(); console.log(currentCoursesData);    

It'd be nice if we could put a photo in base's appearance, although airtable offers several options, we could have more personalized bases, making it easier to identify each one  

Hey folks, just wanted to share that we created this pipeline which is free to use.It has schema inference and evolution, so the column names and data types will automatically be normalised to fit the destination and also adapt to any additions etc.you can configure it to load fully or incrementally.If you have feedback, please join our slack and discuss there or open a git issue. Pipeline docs: https://dlthub.com/docs/dlt-ecosystem/verified-sources/airtableour slack: https://join.slack.com/t/dlthub-community/shared_invite/zt-1slox199h-HAE7EQoXmstkP_bTqal65g

I am stuck 😫I am attempting to configure a webhook, but I continue to encounter a 401 error that seems to be related to the API token. I have thoroughly reviewed all the settings and ensured that I am inputting them accurately. Additionally, I am utilizing an Airtable pro plan, and there are no other users associated with my account, so I have all the permissions. Also if I put "Bearer" in front of the token it turns into a 403 errorAny guidance would be amazing!  

Hello,since recently I've a bug with embedding's airtable on my website. it says "airtable doesn't authorize the connection".Anyone knows how to solve this bug? thanks  airtable Support hasn't been able to help me

Hi All,I am having an issue with my script:When using an integer value in the condition, the script works.Example: return all records that have a value higher than 9 in the field name "Bedroom": const propertyTable = base.getTable("Listing"); // Read the data from my Listing table const recordsFromproPertyTable = await propertyTable.selectRecordsAsync (); //Filter records matching a condition const matches = recordsFromproPertyTable.records.filter((records)=>{ return recordsFromproPertyTable.records.find((potentialmatch)=> { return records.getCellValue("Bedroom") > 9; } ) }) console.log(matches) When trying to match the field value with a single select or multiple select field, I am getting the following error:This condition will always return 'true' since the types  and 'string' have no overlap."I am pretty sure this is due to

Hello,I would like to know if changing my extension name and the dev contact is possible. I tried to find the solution in the code but didn't find any information. Do I have to recreate a new extension with the name I want? (I know I can change the extension name after but I would like to see if I could do it directly)Best regards  

Hey can you kindly tell how to generate Api key for air table . Is air table generating api keys or not? I tried every method i get a personal token but key isn’t generating. I also pasted personal token at the place of api key but it gives error 401 in voice flow

Hi, my currency script can be run manually but fails when run via automation. I'm using the standard, "recommended" currency script.  See attached image. 

I want to download attachments from one of my tables via the API locally:If I open and download the file from the UI, it seems to download them from a S3 server. Is there any way to automatize or mimic this behavior via the API?

Hiya AT community, I was hoping someone would be able to shed some light on my issue, as I haven't been able to solve this one on my own!I have a script that is performing some updates to a stocktake via a script. It will find matching items and then update the value in the number field. My confusion here is that it is working for one field and not the other field, I have tried different strategies to try and get an error or figure out why, but the field ID is defs correct and the field name used instead also produces the same result. Any advice would be appreciated 🙂I'll try add the relevant code to the issue..This if statement works as expected if (newStockMatches){ if(storageLocation == "Warehouse"){ console.log(newStockMatches.id); recordsToAddStock.push({ id: newStockMatches.id, fields: { 'FIELD ID IN STRING FORMAT': newStockMatches.getCellVa

Hi... I can use a little bit of help here from the experts....  We currently have a Google API integration with Airtable  on a project and we have set up routing and it is working well to create and updates routes (route records) within AT for us, but we don't know how to do 2 things we want to do:I don't know how to get an actual link back from Google Maps to the route record (we are using Make for this integration) to just show the route (waypoints) on an actual google mapI am wondering if there is any way to update the route waypoints (drag and drop on the map into a different order) and have it actually update the route records in Airtable when we adjust the route order on the actual map?