Development & APIs

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 

I am looking into the possibility of using AirTable as a back end data repository for some of our data. In order for this to work, I'd have various event triggers accepting data fields and using that data to create or update an Airtable base/table using REST API calls. The goal is to replace some existing back-end that is stored in a SQL Server database.One aspect that I'm not sure to handle is preventing concurrent changes. If, for example, I have multiple changes happening to a record that could possibly be processed at near the same time, I need to make sure that the newest value "wins".The way this works in the current service is as follows:Before sending an updated value to the back-end via its API, a service gets the current value and compares the current value to the new value and only calls the API if one or more fields changedAs part of getting the current version, the service gets the version value of the row (implemented as a rowversion in the SQL database, but I've seen sim

Hi everyone,I’m trying to update the list of select options in the column Categories_test in an Airtable table using the API. My request seems to be correctly formatted, but I keep getting an error response from the server. I would appreciate any guidance on what might be wrong.Here are the details:PATCH Request:Endpoint:  PATCH https://api.airtable.com/v0/meta/bases/{baseId}/tables/{tableId}/fields/{fieldId}  Request Body:  { "type": "multipleSelects", "options": { "choices": [ { "name": "test" }, { "name": "blabla" } ] } }  Headers:  { "Authorization": "Bearer [ANONYMIZED_API_TOKEN]", "Content-Type": "application/json" }  Server Response:  { "error": { "type": "INVALID_REQUEST_UNKNOWN", "message": "Invalid request: parameter validation failed. Check your request data." } }&nbsp

I'm looking at using airtable to use as a database for my startup as airtable provides simple implementation and data management features that make setting up data management simple.However there is one blaring issue that makes this difficult and that is the fact that you cannot set an exact number to offset your search by.I can work around the fact that you can't directly search by linked records by id or other parameters and have to use lookups and formulas to make this happen but not being able to offset makes me consider using another service.If you could setup something like this you could be very popular with startups as we need something quick simple and powerful to get our MVPs up and running quickly so we can test the market.

hi we run printshop business and use airtable for collecting orders. we would like to allow client to build their own designs and create mockups for tshirt. I wonder if anyone has an Idea for some third party tool that can be integrated with airtable.

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