Ask the Community

When using the Airtable JS SDK, it seems impossible to use the offset with select to do proper pagination. The type specifies `number` but any value I pass gives me an invalid value error. The web API uses a string offset that's returned from the request. Since this is TS, you can't use a string value with the SDK. Is it possible to paginate with the JS SDK?

Hi there,I'm facing this issue unfortunetly i checked on the community but none of the solutions work for me.This is the error: "type" Invalid_Offset_Value - The value of offset 100 is invalid.I'm trying to get 350 rows. I already did a first api call to get the first 100 rows, what i need is to continue with the second call.When i try this url https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome everything work fine, when i use the same URL adding the offset value, i get the error: https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome&offset=100What am i doing wrong? I can't work much on the cod

Hi,I have two tables : “clients” and “registration form”. I want to be able to send a registration form to any client no mater if the client is already in my “clients” table or not. (I also have a course table). Lets say I ask for the clients email in the form. If the clients email is already present in my “Clients” table, I want to link the newly created “registration form” record to that specific client in the “Clients” table. If not, I want to create a new record in the “Clients” table with the new client info. Is it possible to achieve this with Airtable or with other tools like fillout? Thank you very much!

Hi everyone 👋I’m trying to find the best way for multiple users to import data (from XLS or CSV files) into the same base — ideally directly through an Interface rather than the Extensions panel.We’ve tried the CSV Import Extension, but: The import mapping doesn’t save across users. Even for the same user, it sometimes resets or forgets the previous mapping. There’s no way to create or reuse “import templates” for different file types or tables. What we’d really like is: A way for different users to upload a file (XLS or CSV) through an Interface form or button, Automatically import it into a target table using a consistent field mapping, And ideally store those mappings permanently (so no need to re-map each time). Is this possible to be done directly with airtbale? Has anyone found a good workaround or script/automation setup that ac

Hi, I am trying to create a PIM solution in Airtable. Anyone that have dos and donts? It should be a fullblown PIM solution with Productdata, translation funktions, images, stock updates from ERP…

Hi.  I´m facing a little problem here. I need to get an iframe from an interface to embed it on my wordpress site, but i realised Airtable is no longer allowing this. Is there anyway to achieve so??? Thanks in advance

let twoLettersToNumber = { "ah": 5, "ch": 8, "wh": 16, "tz": 18, "sh": 21, "ta": 22, "th": 22,};let lastLetterToNumber = { "m": 12, "p": 12,};let letterToNumber = { "a": 1, "b": 2, "c": 11, "d": 4, "e": 5, "f": 18, "g": 3, "h": 5, "i": 10, "j": 10, "k": 19, "l": 12, "m": 13, "n": 14, "o": 6, "p": 17, "q": 19, "r": 20, "s": 15, "t": 9, "u": 6, "v": 6, "w": 6, "x": 15, "y": 16, "z": 7,};/** * @param {string} token * @param {{ ah?: number; ch?: number; wh?: number; tz?: number; sh?: number; ta?: number; th?: number; a?: number; b?: number; c?: number; d?: number; e?: number; f?: number; g?: number; h?: n

Hello.I am new to Airtable and I have a question concerning linking to another record. Is it possible to automate this process so that data from every record from a field (column) on the "source" table may be copied to a field on the "target" table? The data would need to be consecutive and ordered by the same ID number used on both tablesI found a JavaScript online that may work, unfortunately, 1) I have the free plan and scripting is not supported; and 2) my experience with JavaScript is limited. I added a third party add-in, however, the apparent complexity of the application may prove to be problematic.Any guidance would be appreciated.Thanks!

Hey, I'm getting a time limit error for the below script only for some records.  let table = base.getTable("Photos"); // Change "YourTableName" to your actual table namelet query = await table.selectRecordsAsync();// Object to hold the count of each Claim-Fault combinationlet counts = {};// First pass to count occurrencesfor (

Hi All, I’m trying to run this automation script that works perfectly on my test base of ~10 records but throws this error when I move it to my real base with ~1100 records. Error: Script exceeded execution time limit of 30 seconds The below code is based on this tutorial here, tweaked slightly with recommendations I found in another similar question. Any help or ideas would be appreciated! Learn Airtable scripting #1: basics & removing duplicates with Giovanni Briggs - YouTube (from Automate All the Things channel) var table = base.getTable(“Table 1”); var query = await table.selectRecordsAsync ({ fields: ["Name" ] }); console.log(query); let duplicates = query.records.filter((record)=>{ return query.records.find((potentialDuplicate)=>{ return record.getCellValue(

When making a list with three hierarchy levels and adding dropdown filters they don’t seem to work. When making lists of two hierarchy levels on the same base the filters do work. Is there something I’m missing or is there a bug?Thanks in advance!

Hi there, I have a question about option selection, the parent record is “Joan” and linked record buddy “KK”, I want to filter out all linked record under “Joan” instead of selecting “All buddies”. The filter has no choice of “Client” is [Current Client], is there any way to solve it?

Hi, I would like to send requests from Airtable to Make.com/n8n, how can I do that ? Is it only for Enterprise plan ?

Airtable seems to be suffering a major outage. None of the tables load, and shows an error that starts with “pgl…..”, asking to Refresh the page. But Refresh takes a long time, and the same result.

Hi everyone. I realize it is not possible to export / download charts built in the “Chart Block”. Such feature would definitely be a must-have. I really do need it, don’t you? When do you think Airtable will make this possible?

Hello there,a script that is running as part of an automation is failing occasionally because it is exceeding the 30 seconds limit. This is out of my control because it is calling an external API which sometimes takes a bit longer due to high load (OpenAI API). This is the error message.Script exceeded execution time limit of 30 secondsHow can I add retries after 60 seconds or so? CheersChristoph 

In my automation script I am running a fetch request. In some cases the fetch requests takes longer than 30 seconds which results in an error. I don't really care about the fetch request result because it is a post request that is doing all it needs to however the error each time it runs is annoying.Does anyone have any suggestions on how I can run the fetch request without waiting for a response? Or perhaps there is a way to handle the error gracefully?

I see an empty screen and my browser console shows this Tried clearing cookies and changing network providers. Still the same.

Goal: From a Cases Interface (Kanban + record detail), I want a button that opens an Interface Form (Activities)already prefilled with Case = current record (and optionally Patient = the Case’s linked patient). I also need two shortcuts that open the form with Contrato firmado (tmp) or Tratamiento completado (tmp) already checked.What I tried: A button inside the record detail block → action Go to interface page (Activities form). Issue: I don’t see the “Initial values” / “Use record from …” section at all; only Visibility (premium)shows up. I made sure the button is in the body of the detail, not the header action. Same result: no “Initial values”. Go to

I’m trying to upload an image to a Form but both in the Logo and Cover Image the upload fails.  I’ve tried different files but get the same result. ThanksDonald

Does Airtable still not have the ability to keep data when updating a record? For example, when using automation, if the form field is left blank and is submitted it wipes data from the record that is being updated. I have heard you can do this with scrip, but I can’t write the script and I am on a free plan.

Airtable is unable to load data.We are a company located in Korea. Currently, all accounts within the company are unable to load Airtable data.We need help from someone who knows about the current official maintenance schedule or the error.

I wanted to make a Siri Shortcut that lets me upload a screenshot to Airtable. In my Airtable I have these fields: Screenshot ID (autonumber) Screenshot attachment Descriptive text I got pretty far but either the webhook doesn’t allow images or I’m doing something wrong. I set up the shortcut to make the webhook request using the “Get contents of URL” command in shortcuts. Under “Request body” I selected “Form” and then told the shortcut to send the screenshot and some text to describe it. That seems to be the only way shortcuts allows files to be sent out, the other options are text only. When I test the integration in airtable, it works as long as I’m not trying to send an image. It fails when I test it because the test is sending text into an attachments field. When I r

My logo is no longer uploading. The instructions tell me to upload it as an URL, but all attempts to creat a URL out of it and upload it have failed. Why the change from what was perfect, and how do I get my logo image up? Thanks! Anne

I’m currently on the Team Plan and building a survey using Interface Forms. However, I encountered an issue where I can no longer add more elements. The error message says:“Your change was reverted because your interface is too big. Try deleting some elements.”My form currently has 249 elements, and all of them are required for the survey — so deleting any of them isn’t an option.May I ask if there’s a way to increase the element limit or an alternative solution to accommodate more questions within the same Interface Form?Thank you in advance for your help!Best regards!