Development & APIs

 Hi,I have a problem with the release of my extension.The application works fine in development mode after block run.I wanted to switch to release, but after using block release I get the following errorspatrykjachym@MacBook-Pro-Patryk obliczanie_transportow % block releasebuildingcopying package.json filecopying package-lock.json fileinstalling node modules[npm][npm] added 107 packages, and audited 108 packages in 862ms[npm][npm] 7 packages are looking for funding[npm] run `npm fund` for details[npm][npm] found 0 vulnerabilities[npm] npm warn config production Use `--omit=dev` instead.❌ Error: npm warn config production Use `--omit=dev` instead.Failed to build the block code!patrykjachym@MacBook-Pro-Patryk obliczanie_transportow % My package.json { "dependencies": { "@airtable/blocks": "1.8.0", "airtable": "^0.12.2", "react": "^16.13.0", "react-dom": "^16.13.0" }, "scripts": { "lint": "eslint frontend" }}using node 1

I am receiving the below error;O: Can't create field: invalid field config. Creating or updating options for longText fields is not supported at this time. at main on line 31Can Airtable not support creating a Long Text Field? I might be missing something;  let table = base.getTable("Report"); // List of fields to duplicate, with their types let fieldsToDuplicate = [ { name: "Act Name - GA 1", type: "singleLineText" }, { name: "Additional Comments - GA 1", type: "longText" }, { name: "Guest Artiste Show - GA 1", type: "multipleRecordLinks" }, { name: "Versatility - GA 1", type: "rating" }, { name: "Guests Socialization - GA 1", type: "rating" }, { name: "Audience Engagement, Adaptability - GA 1", type: "rating" }, { name: "Material Quality, Originality - GA 1", type: "rating" }, { name: "Professionalism and Reliability - GA 1", type: "rating" }, { name: "Adhere to Dress Code - GA 1", type: "rating" }, { name: "End of Show Audience - GA

Is there already docs or complete process on how to use airtable webhook api to bubble? Like if the data is created in airtable it will call a backend wf then viceversa in bubble.io to airtable.

Hi Team,Has anyone successfully integrated Data Cloud with Airtable? I have followed all the steps provided on the Salesforce website to set up the integration but have encountered the same issue described below.@Patrick_Baker a community member, also faced a similar challenge while attempting to integrate Data Cloud with Airtable and was stuck at the same step. I am currently experiencing the same issue. You can refer to the communication thread for more detail.https://community.airtable.com/t5/automations/linking-airtable-to-salesforce-data-cloud-using-the-beta/m-p/199422#M19337It would be greatly appreciated if someone from the community who has successfully completed this integration could share the steps.Thanks in advance.

I got a MAKE scenario that reads AT. It runs fine.I copied the table and the scenario now does not run (even with no changes whatsoever to the table). All I've done is point the AT module to the copied table.The message I get in Make is: The operation failed with an error. [422] FAILED_STATE_CHECKI reached out to Make support, and they couldn't find anything wrong. Said the error is on the AT side.Here is the RAW log you can share with them: {    "response": {        "status": 422,        "headers": {            "date": "Fri, 20 Oct 2023 06:31:56 GMT",            "content-type": "application/json; charset=utf-8",            "content-length": "39",            "connection": "close",            "set-cookie": [                "AWSALB=+U/EsIQfxd

Hi :slightly_smiling_face: I am building portfolio database for crypto trading. In my base I want to have live coin price, so I can track movement from current price and the price at which I initially invested. There are few websites that support API, but I am not sure how to use it and if that can be done. Is that possible to achieve, if yes can you please help me do it? Also, I am on Pro plan on Airtable. Thank you for your time.

Seems to be working fine previously but now when I am making consecutive calls with remoteFetchAsync, I get `TypeError: Failed to fetch` after the 1st, 2nd or 3rd request.Is there a change in behaviour in a recent release? Code example:```for (let invoice of requests) {  let response = await remoteFetchAsync(ENDPOINT_URI, {  method: 'POST',  body: JSON.stringify({ 'invoices': [invoice] }),  headers: {    "Content-Type": "application/json",    "Accept": "application/json",  },});// Wait for 0.2 seconds before the next iterationawait sleep(200);}```

I am trying to receive party size data in my airtable for an integrated bland.ai voice assistant. If I remove the party size record in the airtable module, everything goes through smoothly but it is only party size that brings up this 403 error. Can you give me some insight on how I can resolve this?

Is it possible to list views from the web api using oauth?  I know make.com and zapier have this functionality, but according to the dev docs it seems like this shouldnt be possible.  I've done this using access tokens for enterprise but I want to implement this functionality using oauth.  

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

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.