Development & APIs

Should i sort it in  notion?] 

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?

"Step into the chaos with the Joker Suicide Squad Jared Leto Crocodile Trench Coat. Bold, edgy, and iconic. Join the conversation | Airtable Community to show your style! #Joker #SuicideSquad" 

I tried posting this question yesterday but now I can't find the post so it looks like it didn't actually get created so I'm trying again.I've been tasked with creating an interface to our AirTable data using an API developed by Brightvine (Brightvine Data Link).  I can get back all the data using the API interface but I need to be able to pass in the last date the process ran on our end and get only those rows created since the last run date/time.  The BVDL gives me a place to enter URL parameters and I've tried using the "filterByFormula" option but I keep getting an invalid formula error.  The BVDL gives me access to the last run date/time in a couple of different formats when creating a parameter.Any suggestions will be greatly appreciated.Thanks,Ray Porter 

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

How to export Table into MYSQL table file or CSV?Can be synced table from Google Sheet into MYSQL?

I'm working on a project where we use:- Postgres for our production app database - Airtable for our internal team (support, ops) The challenge: keeping them in sync without writing fragile scripts.Curious what others in this situation are doing:1. Are you using Zapier? (I find it too slow)2. Custom scripts with webhooks? (maintenance nightmare for us)3. Some other tool I haven't discovered?4. Did you just pick one and stick with it?We're syncing about 5K records and need changes to propagate in under a minute ideally. Any experiences or recommendations appreciated!

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

I need to import the “Resolution” field from Jira Cloud  (Resolved, Won’t Do, Cancelled, etc) -- this is not showing up in the Standard fields, and is not listed on the Help page (https://support.airtable.com/docs/airtable-sync-integration-jira-cloud)Also wondering if there is support yet for custom fields?

I’m loving interface extensions so far! It’s super easy to get up and running. I have an external website that uses the Airtable API that I think would work much smoother if it were an interface extension and inside AT proper. The only problem is… it’s in Vue, and it’s way too complicated a project to rewrite from scratch in React.Assuming the interface extensions team isn’t planning on making a Vue SDK as well (...unless? 😳), has anyone tried inserting a Vue component into React, specifically inside the Airtable Blocks SDK, where no Vite config file is available?

Hi Community!I’m attempting to create a webhook and attach some additional info for all he POST requests that are to be made for the specified notification url.I want to call my notification url and specify some parameters there.AFAIK its not possible to use url query parameters there and specify them while creating a webhook.Are there other options? Like custom http headers or so?  Thank you

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