Development & APIs

Hello,I’m curious if anyone here has connected Airtable to Lightspeed restaurant U Series POS?  Either directly from Airtable to Lightspeed or indirectly with a third party like Zapier.   I’m trying to pull daily sales and labor data from my POS into Airtable.  We are working on creating better internal tools that our managers can have access to.  Tools that would track our main expenses like labor and COGS.   I’m having a hard time getting the connection done.  Airtable is not currently an integration partner with Lightspeed U Series.  Neither is Zapier or something like Make.com.  So I’m looking for someone with experience with these specific platforms. The people at Lightspeed have not been super helpful.  I know I can’t be the first person to try to pull data to Airtable (or even something like Google Sheets).   Thanks

I’m building an integration that needs to sync ~6,600 records from an external API to Airtable, ideally in under 1 minute.Currently I’m hitting the standard REST API limits (10 records/request, 5 requests/second = ~2-3 minutes minimum, but in practice it’s taking 10-13 minutes due to network latency).I’ve looked into: ∙ Sync API (CSV) - but the table becomes read-only, and I’m seeing significant processing delays after the request completes ∙ REST API with performUpsert - works but slow at scaleHas anyone found a faster approach to bulk insert/update thousands of records? Any workarounds or techniques I’m missing?For context: manual CSV import through the UI takes ~5 minutes for the same data.

Hey everyone!I built Sheet Wizard - a Chrome extension that lets you bulk update Airtable records using natural language commands instead of manually clicking through rows.For example: "Set all records where Status is 'Done' to Priority 'Low'" or “Update Due Date to 2026-01-10 for all Marketing Campaign records in Project"It's live on the Chrome Web Store with a 7-day free trial. Would love feedback from the community!Happy to answer any questions!https://chromewebstore.google.com/detail/sheet-wizard-for-airtable/ofhnpikabgcaihpaohanedkodjfgboiahttps://www.getsheetwizard.com/

I’m trying to use the new ChatGPT integration with Airtable - specifically to have ChatGPT pull data from one of my bases in Airtable base . I’ve configured the settings in ChatGPT to connect to airtable, but Chat GPT is still asking me several times to confirm it has access to my base and other data points in Airtable. Is there a way to configure this to stop asking this question? It seems to be slowing it down. 

Hi all,New to the community here 😊Quick backgroud, I use Airtable as core operational platform for enterprise-scale stadium delivery coordinating content, instructions, and approvals across major events. External stakeholders access structured workflows via a portal in Softr, while internal teams manage live production delivery in Airtable.I’m currently on Business and evaluating a move to Enterprise Scale.Before upgrading, I’m trying to confirm whether Enterprise Scale supports embedding Airtable Interfaces into third-party portals (e.g. Softr) with the following requirements:Embedded without public “share to web” access Users authenticate normally (Airtable / SSO) Interface permissions are enforced (role-based access, edit vs read) Users can edit records and reorder rows within the embedded Interface

i keep getting ‘Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct.‘This error from n8n. any idea how to fix it?

I’m calling the API (https://api.airtable.com/v0/:baseId/:tableId/:viewId) to get the records from a table, using a view.  There are ~1000 records in the table and about ~200 that are displayed by the view.I’ve noticed that the first time that I call the method that calls the API can take about 10-20 to complete.  Subsequent calls are subsecond.Is this a characteristic of API itself?  Perhaps it caches the dataset after the first call.What, if anything, can I do to prevent this behavior?This is the service layer’s method:export const getTrainees = async () => { console.log('AirtableService.getTrainees()') const TABLE_ID = 'YYY'; const VIEW_ID = 'XXX'; const fields = ['Full Name']; const params = new URLSearchParams({ view: VIEW_ID }); fields.forEach(field => params.append('fields[]', field)); const url = `${AIRTABLE_B

Hi everyone,I’m looking to develop an Airtable extension that relies on some wasm library loaded by the extension script, and some Web Workers started asynchronously on user request (NOT background or service workers, just plain WebWorkers). The wasm scripts are loaded using standard `WebAssembly.instantiateStreaming` API. Does anyone know if there are any surprising sandboxing limitations imposed by Airtable extension architecture for this?

I would love to sync Airtable and ChatGPT w/ the new integration but I can’t find any details on security for this and how data is used. Any one able to give insight?

I have list of keywords and URLs. I want script, once in a month, go through those URLs and find if that keyword is still on that URL. Based on result, update field with the status, Exist / DoesNotExist I want to track my backlinks for SEO purpose, they are still live or removed. Any ideas?

Can someone please let us know What is the status of CORS support for Oauth 2.0. In documentation it says development is in progress. By what time will this support be available?https://airtable.com/developers/web/api/oauth-reference#cross-origin-resource-sharing-cors

I’m looking for an extension that would allow me to receive SMS to a specific number, and have that populate field (or Create Record) in a base. Reading up on Twilio and Whippy and some others, and it looks like there are plenty of options for sending SMS, but can’t find anything there about receiving one. Any insights on what’s available or maybe I missed something with the capability of those tools.

Hi I'm working with Airtable Forms and using a single-select field for a Sample ID (which is a number). I'd like users to be able to add a new Sample ID directly from the form if it doesn't already exist, instead of being limited to the existing options.Is there any way to enable this "Add new option" behavior for single-select fields in Airtable Forms? Or would I need a workaround—like using a linked record or setting up an automation—to allow new Sample IDs to be created automatically?Appreciate any guidance

I am a business specialist for a company and I also teach workout classes for the women in our office 3 times a week. I have a fitness Airtable base where I have added all the exercises I like with a muscle group field. I am trying to find a way to automatically generate a workout to reduce the time I have to spend coming up with a set of exercises. For example, we worked chest and triceps yesterday so today I want to generate a workout that includes x number of exercises with x number being bicep workouts, x number being back workouts, and x being ab workouts.I have very minimal developer experience but I can edit and update pieces of a script if given the outline. 

Hello,I think I'm at my limits with trying to get Airtable to function as we really envisioned.  Anyone know the best place to find Airtable consultants with likely programming abilities?  A few of the things we really wanted to do were:1. Create a custom form that goes to contacts and their selections would filter back into our main table but this needs to be very limited with selections as certain items we code on contacts are internal only.2.  A mass emailer.  We use Airtable as a giant database for our independent contractors and code them by areas they cover and preferences.  We have Zapier and an external operations system and would love the ability to integrate all so that we can send a mass email to a designated list of names/email addresses based on a filter that looks nice and inputs the key job data available from our operations software (SQL Server database).  Have struggled with this one and even though we have t

Hi- I’m trying to use Airtable to automatically fill fields in a document based on the Airtable fields. I found the perfect app that does just this, however there are NO videos from others or discussion on this. I’ve been testing this app, and it works great! Except for a date field. It seems there is a bug in the app as no matter what, if I make the Date field a text field, a single select, a linked, no matter what it just won’t pick it up. I did email the developer but wondering if anyone else has had luck with this. I do not prefer to use Zapier or a 3rd party app. I do see the option for an automation but struggling with that as well. So far this seems to be the best option if only I could figure out this date issue. The app is Word Document Auto-Fill and the developer’s site is linked to the AT site. https://airtable.com/marketplace/

Hi folks,I run a desk at an early-stage VC fund that helps our portfolio companies raise growth-stage rounds (we can’t invest at that stage ourselves). Think of it like an in-house investment bank, where we build relationships with such investors & pitch relevant companies to them.To enable this, I manage an investor CRM entirely on Airtable. At high level, it tracks: Funds: Background, stage/sector preferences, cheque sizes, ability to price rounds Fund partners: Designation, email, LinkedIn, location Interactions: My meetings with investors + detailed minutes Introductions: Which funds we intro’d to which companies + post-intro feedback The Interactions table contains rich meeting minutes where investors share views on many of our companies. It’s extremely valuable but subjective, so impossible

Hello All, I’m looking to see what my options are to create and download a csv file generated from a base, but with a very specific format. Right now I have a script that loads records from the base, creates a stringified csv document, and then saves that string into a multiline text cell in a different table. The issue is that in order to use that text, I have to copy and paste the contents of the cell into a text document, save as a csv, then open in Excel. Does anyone know of a way I could directly trigger a download of the csv, or even save it as a downloadable attachment in cell instead? Thanks!

HiIs anyone encountering intermittent issues with the API.Sometimes it take 2 min to get data, at time a few seconds?

I’m working on a script in an automation (triggered when new record enters a view) where I need to collect some variables (from the record that triggered the automation) to include in an outbound web hook. I’m getting an error on the record.getCellValueAsString lines:TypeError: Cannot read properties of undefined (reading 'getCellValueAsString')let inputConfig = input.config();let recordId = inputConfig.recordId;const table = base.getTable("table_name");let record = table.recordId;let var1 = record.getCellValueAsString("field_name");let var2 = record.getCellValueAsString("field_name");

Is there any way to control the image sizes I get served from an Airtable Attachment field via API? My API docs tell me I can access “thumbnails” in sizes “small” (width 72 on one image), “large” (width 1024 on one image) and “full” (3000 on one image)… But… “full” is not a thumbnail at all, it’s the source image. “large” is too large. “small” is just too small. It feels like there’s a missing middle size here. But it’s not supplied. Is there any way to constrain the size of an output image?

Hello All,Please my Airtable <> Docpotion integration was successful, script runs fine, generates pdf invoice in attachment field when, but unfortunately I cannot view the invoice generated and when I download the file, it also does not render in pdf format. Had series of calls with the founder/support of Docupotion, all looks good from their end. Please I need all the help I can get with getting this issue resolved or any other means to achieving same outcomes This is a major blocker to a major project completion.I have attached screenshot for easy of issue Thanks in advance 🙏🏽

Hello, I have created a custom Airtable extension. But accidentally  I deleted the extension connection from the Airtable base. So how can I run this extension on an Airtable base? Here is only a single option to add a new extension. There is no option to run the previous extension.However, if I try to run by localhost:9000 it shows an error{ "error": "FORBIDDEN", "message": "blockId mismatch. Make sure you are entering development for the correct block." } 

I have the following use case: I have images saved as attachments within a table. I need to automatically upload any newly created images via API (not Make or Zapier due to volume) to an 'Input' bucket on S3. From here the images are manipulated by another API and saved to an output folder. When a file is uploaded to the output folder we would send this back to airtable.Can someone give me some general direction in writing a script to enable this? I understand I will need a presigned URL from AWS which is well documented, but I'm struggling on how I might do this using Airtables API. Any help very much appreciated!Many thanksEdward

I create a Make.com automation that sends out a transactional email to the customer when a new record is created in my enrollments table.  The last step in the automation is to update the Enrollment record so show that the Confirmation Email was sent out by updating the record with today’s date.It’s a rather basic setup, but every time I test it out I am getting a “404 Not Found” error when Make tries to update the record.I have checked the Input / Output in the error, but I’m not finding anything useful.  The OAuth connection is working fine to pull the records, and the Base / Table / Field names are all pulled from the dropdowns.  I also checked the Base ID, Table ID, and Field ID from the output bundle, and they are correct.Airtable Update node 404 Error