Development & APIs

Since last week my HTML forms began to fail with scripts apps which I could send data and pdf files to airtable the file as it is, now it doesn't allow I don't know what to do someone knows a safe method but that is not using the drive download URL, thank you

Can anyone tell me if there’s a way to perform web scrapping on Airtable and fetch changes related to the tickets? For example, I change the status of my ticket to In-Progress from To-Do, I need a custom scraper method that would parse the data and store it into my database. I am using Node.js and puppeteer. 

Hello! We encountered a number of systematic errors when accessing our Airtable databases inside Make (former Integromat) scenarios via APIWhen accessing an Airtable module in a Make scenario , Airtable consistently throws one of two errors:1) Error 4292) The operation timed outBecause of this, all our Make scenarios automatically stop and we experience great difficulties. Re-running the scenario results in similar errors.Please help fix this issue.The screenshots with errors are attachedThank you in advance

I'm using a simple JSON to POST data to create a new record in Airtable.I'm using Field IDs to prevent name changes from affecting the integration. I've replaced the actual field ID's below for this example, however I'm using the correct Field IDs in in my production environment.I'm using variables captured from the chat to send to Airtable.{"records": [{"fields": {"fld1": "{First_Name}","fld2": "{Last_Name}","fld3": "{eMail}","fld4": "{Boomo_Intent}","fld5": "{MCI_Copilot_Feedback}"}}]} I've verified both my endpoint URL and Authorization API Key.I've troubleshot this for a couple of days now including using ChatGPT but still get the following error:{"error": {"type": "INVALID_REQUEST_MISSING_FIELDS",

I'm wondering if forms can also have the "take photo" function in attachments the same as when adding records from a phone or device? The idea is to have customer feedback be able to take a photo in the feedback form without going through their gallery.  

I want to use server-side Airtable API calls to completely replace all options in a "Multiple Select" field type. Specifically:Current options: A, B, C Via API call: First delete all existing options (A, B, C) Then write new options (D, E, F) ​Question:​​ What is the correct request body structure for this operation?I've tried the following JSON structure, but always receive this error: { "error": { "type": "INVALID_REQUEST_UNKNOWN", "message": "Invalid request: parameter validation failed. Check your request data." }}My attempted API call:--data '{ "options": { "choices": [ {"name": "D", "color": "blue"}, {"name": "E", "color": "green"}, {"name": "F", "color": "green"} ] }}'

Some field types including single selects, multiple selects, linked records, and collaborator fields will show “List” or “Record” instead of the values you may be used to seeing in the Airtable grid view. This is consistent with how the Airtable Web API returns information.

Hi there,I am using webhooks to send data from our base to our application endpoint, but we've observed that if our endpoint fails to respond correctly, the webhook is retried many times.While we work on making our endpoint more resilient, the volume of retries can cause issues.Is there any setting, configuration, or recommended best practice from your end that we can use as a workaround to prevent or immediately stop a webhook from retrying upon the first failure?Our goal is to have more direct control over the retry behavior to avoid overloading our systems during an incident.Thank you for your guidance.

I’m having trouble making a successful API request via Postman, and a co-worker pointed out that the documentation says a requirement is for the user to be an “Enterprise admin”.See here: https://airtable.com/developers/web/api/hyperdb-table-read-recordsWhat admin roles, listed on the page below, does that refer to?https://support.airtable.com/v1/docs/admin-roles-in-admin-panel-overview-and-managementMy current role is an “Integration admin”. Does this role count as an “Enterprise admin”? Do all those listed roles count? Are these different contexts? 

Heya everyone!So I noticed that on the Airtable update API endpoint they note about upserts:Airtable reserves the right to throttle upsert requests differently from the standard rate limit throttling policy.Intuitively, I’d assume that differently means that they’re more strict about it as they’d be doing comparisons on their end.Does anyone know whether upsert is throttled more aggressively than plain updates? I’d assume so but I thought I’d get it cleared up.Thanks!

I have an object that I output from another script using the Output.Set(key: value) method. The value that I’m passing is an array of json objects. It seems that there are a lot of objects to transform the object but I would prefer to just pass the object to my script to iterate over the object and use dot notation to get the values that I would like.  I don’t see anything that just lets me keep the object as is and pass it through input.config only transforms or operations like length? Is there no way to pass an array or object??

Hello everyone, I hope you can help me! I am creating an product database for internal purposes. I have created a Softr interface and I want to have a customer chat bot to can answer basic queries such as “Does this product have x feature?” “What is the price of this product” etc… I have managed to create everything with the help of Chat GPT (I can’t code!) but once issue remains, when I try to trigger a database search, it constantly returns with “I can’t find this product”. I have searched the console, it says it cannot access the database because authentication is required and returns an error 401 or 403. I have checked the token, the database ID all and everything is correct, so I am a bit at loss! I am the owner of the database. Hope someone can assist with this, thanks in advance for any advice!

I've registered a new OAuth integration record on my dev instance of Airtable, however when trying to perform the first step of authorization by getting a code I am presented with the following error:There was an error during grant authorization. Close this window and try again or contact your system administrator for details.

Hi there - I have a list of outputs and am trying to create a PDF listing those. Is it possible to create a PDF via script? Or what other methods are there other than one line per PDF? How could you use the PDFs if linking all records to one record in another table?

We are trying to set up an 0Auth connection for retool. Unfortunately the Dialog to define Scopes and select the Base does not load/open at all. When I click “grant Access”, a loading wheel appears but nothing ever happens. Does anyone have an idea where the problem could be ?  

Is there a solution to sync Jira which is an on premise version NOT Jira Cloud. When in the office I have access to both Jira and Airtable which are behind firewalls. Are there any solutions maybe with MCP Browserbase or other type of way to extract data not via API but through the browser and sync with Airtable. 

Here’s my thinking. I like the simplicity of Airtable’s own “Export CSV” function. Data in a spreadsheet as a simple backup is all I am after. If “Export CSV” could be triggered via a script, the entire process could be automated. A new record could be the trigger to run this script. Does anyone know if this is even possible? Thank you!

Hi all — every time I try to import a Google Sheet into Airtable, I get this error:"Can’t import from Google Sheets — Something is wrong with Google API."This happens regardless of which sheet I try. The sheet is shared properly and I'm logged in with the right Google account. Is this a known issue with the Google Sheets sync or a permissions problem? Would appreciate any tips on fixing or working around this (besides switching to Excel!).Thanks!

Hi all 🙂 Please, is there any way so I can convert emails to PDF?I have a TaskRobin integration, and would like to save my incoming emails in PDF format.Thank you 🙂

Hi Dear community I'm building an app for kitchen management specially recipe costing Need somebody to guide me for developing the apps introducing interface and adding tables for inventory management I'm  new and passionate to aittable  Please give me advice without costing a fortune .…Kind regards 

Thanks @openside for your famous post "New Script: Same Table Linked Records Backlinks".Is there a way to use this in automation so that whenever the Parent task is updated, the child task runs? How would you need to modify the script?

Hi, I’ve been using Airtable for a few years and a heavy automation user with Make.com and Zapier. However, I don’t have any programming experience whatsoever.The script is used as one of the steps in my Airtable automation. I’m in need of a script that:Takes a value from a field Multiple that value by -1 (negative 1) Return that value as input for the next step in my Airtable automationI’ve just started online course on Javascript, but this course obviously takes time and I need the script right away. It would be great if someone can help me out with this so I can implement it right away. From my online course, I know that the code should be straight forward enough even for someone with basic command of Javascript.Thanks!

I’m using the pyairtable python package, and I’m looking for a way to delete columns in a table and reorder columns based on how they are named (e.g. if the columns are dates, I want the most recent date to be the left most column). Not sure if there is a way to do this using python, but I’m hoping I wont have to do this manually. Thanks in advance!

I have a lot of documents that want to organize. Airtable only allows photos. It would be great to add a scan feature.

I just signed up for Twilio, including a A2- 10DLC registration. I tried to send a couple test from Airtable, but Twilio says Undeliverable because I’m not registered. Does it really take up to two weeks to have an A2p 10DLC registration approved? Is there anyway to send or test twilio in the meantime?