Development & APIs

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 

Hi everyone,Has anyone implemented an integration between AirTable and qTest? We’re looking to connect the two systems to sync test data or manage test cases more efficiently.I’d appreciate any guidance, documentation, or best practices on how to set up this integration — especially around API configurations or automation workflows (Zapier, scripts, etc.).Thanks in advance!

Hi,I am the owner of a workspace and I created a base that I would like to generate PAT but when I go to the developer Hub, I can’t find the workspace or the base in the add base field.  😭I must be missing some permission somewhere and I just couldn’t figure it out.  Help please! Thanks,Cynthia

Add static Google Maps to attachments based on addresses in a table. Source Code /** * Copyright 2020 Bocoup * * Permission is hereby granted, free of charge, to any person obtaining a copy * of this software and associated documentation files (the "Software"), to * deal in the Software without restriction, including without limitation the * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or * sell copies of the Software, and to permit persons to whom the Software is * furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included in * all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE * AUTHORS OR COP

Hey everyone,I'm working on a personal project to automate my daily finance reports, and I've hit a wall that I'm hoping Airtable can help with.I absolutely love Airtable - it's been perfect for managing my financial data. But here's the thing: I can automate everything through the API except for creating and duplicating views. Every month I have to manually create new views and tables for the new month expenses.What I need:Create and duplicate views through the API Duplicate tables and rename them through the APII've tried every workaround

Hi! I get a “Connection error. Please check if your local block is running.” when running the extension I created locally. It works on Firefox. This was working previously. Initially, I thought it was related to a Windows 11 update that broke development with localhost, but I rolled it back, and it works on Firefox…I’m using the latest build as I plan on using the new multi table feature (I’m currently using the Web API to query a second table).

Hello All,Complete noob here, so, please be patient!I want to connect to the HighLevel (GHL) API here: https://marketplace.gohighlevel.com/docs/Authorization/PrivateIntegrationsTokencurl--request GET \--url https://services.leadconnectorhq.com/locations/<location_id> \--header 'Accept: application/json' \--header 'Authorization: Bearer <YOUR PRIVATE INTEGRATION TOKEN>' \--header 'Version: 2021-07-28'How can I accomplish this with Airtable? I want to poll the conne

Hi, right now, one of our databse APIs is down sind 2h, while all other of our databses are reachable.  Anyone experiencing something similar or has an idea what we can do? thanks so much for the help

I recently obtained a certificate in Airtable Admin but it's carrying my email address which is not my real name. Please how do I change it

We are a not for profit organization involved in promoting a fascinating Indian Sport called Mallakhamb.We use a combination of Airtable for data storage and sharing and fillout forms connected to Airtable base for  use by public for signups.I would like to understand the contribution of each part of Airtable - data, calculations, automations, shared views and fillout forms , towards the Public API usage. 

I want to send emails via SendGrid. this is to be done through an automation baed on a trigger of when a record enters a view, like this:The email text contains many personalisations, pulled from the database. Some of these fields are lookup fields from other databases. Below are all the personalised fields: And here is the script:// Get your SendGrid API key (store securely)const SENDGRID_API_KEY = "-KEYisHERE-";// Get the record that triggered the automationlet record = input.config();// Extract values from arrays BEFORE building emaillet firstName = Array.isArray(record.firstName) ? rec

I know it ha been discussed MANY times, and I even clicked on the “contact developers” to submit a question/suggestion to see if they ever think this will fully integrate with Airtable…. aka upload the PDF upon a trigger via automations, or just a column that IS the page designer. Can anyone at Airtable make this happen? It seems that Airtable is the developer, and with all the chatter here, this one small thing would make a huge difference to so many. Currently the only options are to use external PDF creation tools, which is beyond frustrating when you’ve created the perfect PDF page and all you need to do is link it to the column. The fact that someone can’t even click a link to view the PDF, ugh. Anyway, maybe if enough people “like” this, it can get to the Developer and they can actually follow though. With all the AI and automation of today, I know this is possible! Please help us get there. 

Hello Community,First post here. I am attempting to connect my Airtable to Power BI.I am receiving the following error message in Power BIExpression.Error: We cannot convert the value null to type Record.Details:Value=Type=[Type]I am following this guidance and using a Personal Access Token. I setup Power BI Parameters successfully but received the error code in the Query. I suspected that it may be the M Code so I followed a link to a GitHub resource for alternate code."If the above script seems to be causing an error, then please refer to this GitHub resource, as the code may have changed.

Has anyone had any success integrating Airtable with MRI Real Estate Software using API keys?  If so what steps did you take?

In another topic, I recently explained how you can instantly sync your Shopify metaobjects to Airtable.The good news is: you can now sync your Shopify metafields with Airtable too (thanks to SyncBase app) 🤩 How does it work?During onboarding, you can choose which metafields you want to sync (Product metafields, Variant metafields, Order metafields, etc.). The app then creates one table per metafield group (e.g. Product metafields) inside a brand-new A