Development & APIs

I've been using airtable to handle the backend of an MVP. The tables and  interfaces have been a great way to quickly put together a product that our internal team can work with. Probubly would have been beter to go with a tool like Retool for our use case, but this is were we are.We are still having trouble with the speed of airtable's API for our consumer facing front end. The other issue we've had is that there is no real dev ops workflow where we have a development environment and production environment. The best way to do that is to just copy the base and relink everything so we have a dev base and production base. The issue with that is its time consuming and all the Id's change so links we give the clients in emails etc that have id's as url parameters won't work anymore.We are looking to migrate to a traditional tech stack and would like to sync our airtable base to a postgreSQL base as we do the hard work of putting together a proper backend in react for our internal team

Does anybody know or has script you put in extensions and automatically shows post and comment karma on airtable. You need reddit api and airatble api. And a script that i dont know how to write. I would appreciate every help

Is there a way to directly upload a PDF that was created in make.com HTTP module directly to Airtable? 

We have a Number field that we use for height that is always entered as a whole number in inches. Example: 65 or 66. Yet, when we pull this data via API, it will change it to a decimal. Example: 65 turns into 64.8 or 65.2. We do not understand why this would happen. Any help is appreciated, thank you

Hello! Currently for a school project (Software Development and Design) I am making a game in unity complete with an online highscores leaderboard through Airtable. The leaderboard side of the project is now done but I wanted to add a replay system to the game. Much like demo files from the old doom games my replay solution is a JSON array that contains the positions and rotations of the key game objects over the lifetime of the game. The file that is generated is only about 1mb in size and such shouldnt take very long to upload if sent with the rest of my run information (such as the players username and their time) The issue I have run into is that im getting an INVALID_REQUEST_BODY error every time i try to put the entire JSON string into a Long Text feild on airtable. I beleive this may be due to the fact that it is a JSON string inside the rest of the JSON request that is sent to irtable. Is there a way to isolate the string so that airtable doesnt try and parse this data? Alterna

I have the following case history:a base with multiple tables interconnected with each other;I've created an interface form to populate one of these tables;In this interface I have a field that allows me to select a record linked to another table;In this field, again from the interface, I have the possibility to choose only existing records;Is there a way to add, from the interface form, a new record directly from the field with the drop-down list? Directly from table this is possible, but not from the interface form or any form view. Many thanks

I found multiple posts stating we can’t create new columns/fields on a base but then I also see posts like the following two where the script looks like it’s calling a create() method. Are we able to create new columns/fields through a script? Does TypeCast only work on Create? What about Update? API Does typecast only work on .create? What if I want to update a mule-select field in update? base('Sites').update([ 79 { 1 "id": recId, 2 "fields": { 3 "siteStreetAddress": {!!placeDetailsObj.street_number ? place… Fix for INVALID_VALUE_FOR_COLUMN for single line text column API Here’s a repro case for a table with column “SingleLineText” which is o

Is it possible to fully automate the creation of new tables in Airtable from a template, via external tools like Make.com or Zapier? Like the Google Sheets "Create Spreadsheet from Template" module in Make.com. I’ve successfully created tables manually using the Scripting Extension, which duplicates a template. However, it seems this process can’t be triggered automatically through Airtable automations or external platforms.Is this a limitation of Airtable, or is there another approach to achieve this?If it’s not currently possible, are there plans to introduce this feature in the future? Automating table creation from templates seems like a critical function for workflows, especially compared to competitors like Google Sheets.Thank you for your insights!

I need help with making HTTP requests in Blocks:Regular fetch() fails with CORS errors as (more or less) expected in BlocksIn my original extension script, I used remoteFetchAsync which worked fine for handling CORS issuesHowever, when I try to use remoteFetchAsync in Blocks, it seems to not exist at allI've thoroughly checked the @airtable44/blocks SDK, since the docs don't seem to say anything about this for blocks, (it has the "Scripting Extension Only" tag).Questions for the Airtable team:What is the current, supported way to make HTTP requests from Blocks?If there isn't one, why not? And when will this be fixed?Can you explain why remoteFetchAsync works in extensions but isn't available in Blocks?Thanks for any help, and happy holidays!

Hi Airtable Community, We’re planning to integrate Airtable with our cloud-based data warehouse. The end-user should be able to use Airtable to dynamically setup and schedule data transfer to and from our data warehouse. Data transfer should be seamless and should support 20,000+ rows. Is this technically feasible? Thank you.

I am new to scripting. I have two tables: Contacts, and Outreach that are linked via the "Full Name" field with a 1:n relationship. So each Contact (say, for example, "Jane Doe") can have multiple Outreach records. Each Outreach record represents an email or call to that person.I'd like to write a script that opens a "mailto:" link to the Contact's email address and then creates a record in Outreach with the current date/time stamp that is linked to that contact (in this case, "Jane Doe")How can I create a script to do this?

Hello,I have an issue with ISO8691 date format between Calendly and Airtable using Make.comMy workflow is Calendly (Watch Events) > Airtable (Create a Record)Calendly sends an object with a date field :Airtable configured this way in Make :And the field in the record is configured this way :Gets as input :But creates a record with :What can i do ? Seems that something is wrong but can't figure out where. 

Hi, I keep getting this new message in the automation script ide :Error: Request processing is disabled due to earlier failed requestIt seem like airtable does not want to rerty a fetch that previously failed even if the input parameters have changed. Anybody else is getting this?It's the first day that I saw this message and it's a bit combersome.

Hi,Looking at getting a Microsoft Surface with an ARM chip - does anyone know whether the windows app works on these devices?  I understand some of the Windows apps that are designed for Intel processors do not work on these, or are at least slow.Thanks, 

Hi support, We're changing the ownership of a workspace to a new owner. Will this affect our automations and API integrations?   

Hello everyone,I'm working with an automation system on Make.com, where I generate images using an API and then send them to Airtable. However, I’m currently facing an issue:When the generated image is returned via a webhook from Make, I’m unable to insert it into a specific field of a table in Airtable.Here’s what I’ve done so far and the problem I’m encountering:I THINK I created an Airtable record with a Record ID (see screenshots).When I attempt to update this record in Airtable, I receive an error message stating, “Received invalid inputs.” At this point, the Record ID appears to be missing(see screenshots).I’m not sure how to retain the Record ID or even confirm whether a record was successfully created (see screenshots).Has anyone encountered a similar issue or can offer guidance on resolving this?Thank you for your help!

Im currently building an online question bank for medical students. The bank will be sold online, with anual subscription. Im looking for a web developer to help me build the question bank. There will be approximately 5k questions and about 100-200 users yearly. The questions must be separate by theme and year.Im would also like the it features a feedback page. With test results and performance in graphics. Do you know anyone that could help me?

I planning to make a service that pushes airtable data on changes, including comments.Is is possible to watch for comment changes via Airtable webhook? It is not stated in the doucmentation explicity, so I would like to clarify. Thank you.

I'm working on a project where I have 3 tables in play."Database" - "Data2" - "Match"The script I developed allows me to take a record from the "Data2" table, compare it with each record from the "Database" table and if there is a correspondence between the two, based on 3 specific values ​​which are multiple choice fields, then it is created a new record in the "Match" tableThe automation starts n times based on the number of records flagged in the "Data2" tableThe problem is that having more than 1000 records in the "Database" table, even if I have optimized the script as much as possible, in some cases I run into the 30s limitI show you the current code:// Ottieni le variabili di input let inputConfig = input.config(); let nomeBando = inputConfig.nomeBando; let areaInteresse = inputConfig.areaInteresse || []; let tipologiaSoggetto = inputConfig.tipologiaSoggetto || []; let settore = inputConfig.settore || []; let bandoContributiRecordId = inputConfig.recordId; let scadenza = inputCo

I want to add images to an attachment field in an Airtable.  I've read all of the documentation and Community comments but can't seem to find an answer to my problem.I have a publicly accessible link to the imageI can call https://api.airtable.com/v0/{baseID}/{tableID}/{recordID} and add an image fine, however, I want to make multiple other calls adding new versions of the image and this call overwrites what is already there but I want to keep the previously uploaded files.  (I understand this is an Update call and that logic makes sense.)Therefore, I believe I should call  https://content.airtable.com/v0/{baseID}/{recordID}/{fieldID}/uploadAttachment  passing in a similarly formatted JSON object, however, I cannot get that to work.  I get something added to the attachment field, however, it is just 1K gibberish file.Here is a copy of what I'm calling:curl --location 'https://content.airtable.com/v0/{baseID}/{recordID}/{fieldID}/uploadAttachment' \--h

Hi everyone,I’m developing an app using Softr as a front end and Airtable as the data source. The app serves as both a client portal and an internal operations tool, with 3 user groups: clients, employees, and managers.Here are the key details:At peak traffic, I expect around 100 concurrent users interacting with the app (creating, updating, and reading records from Airtable).Given Airtable’s 5 requests per second limitation, I’m concerned about potential performance bottlenecks or errors.I don’t mind if there’s some delay when loading pages; my main concern is ensuring the app functions properly during high traffic.Questions:Will the app handle this level of concurrency without running into errors, considering Airtable’s request limits?Has anyone built something similar and can share their experience?I’d greatly appreciate your comments and insights!Thank you!

When editing a custom Airtable Extension, the process is to select edit on the block, grab the URL/port from AT,  run the block locally with block --run, and select "Start Editing Extension." However, the Chrome setting (flag) that used to allow developers to host the app code locally and run it in AT has been removed. (The flag was #allow-insecure-localhost.) This leaves us unable to edit the extension. Any suggestions for how to get development working again for extensions/blocks? 

I have a table of projects that all have an Estimated Cost field.  At the bottom of the table it is summing every field, including Estimated Cost.Is there a way to access that data from the API?

Hi All,I'm using Voiceflow, when i try to create a new table in an existing base using the API i get the following error:{ "error": { "type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND", "message": "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." }, "VF_STATUS_CODE": 403 This is the url endpoint i'm using:https://api.airtable.com/v0/{baseID}/{table_name}I have a valid base id and i'm populating the {table_name} variable with the users 'user id' such as 'TYSCH'.I have all my scopes selected in my access token.Voiceflow API Settings: My JSON body:{ "table_name": "{table_name}", "fields": [ { "type": "singleLineText", "name": "UserId" }, { "type": "singleLineText", "name": "TokenUsage" }, { "type": "createdTime", "name": "Session Date & Time" } ], "views": [ { "name":

I am trying to sync AirTable data to HubSpot. However, I do not understand the "Last Modified Time" field requirement by HubSpot. I created a Last modified time field in my AirTable base, but it still isn't working. Have anyone experienced these issues?