Development & APIs

I have been attempting to catch a hook in Zapier from a scripting app that I run daily. The content of the request is designed to capture some metrics from the actual running of the script. I have previously run caught a webhook from a scripting automation to Zapier with no issues. For some reason though, when trying to send a similar request through a scripting app I encounter a failed to fetch issue with some writing on CORS. My code is below, I removed the link within the fetch but it was just the link that Zapier provides within their catch hook step. var bodyContent = { "scriptName": script, "numOfRecs": numRecs, "elapsedTime": et, "recsPerSec": recsPerSecs } let request = await fetch('', { method: 'post', body: JSON.stringify(bodyContent), headers: { 'Content-Type': 'application/json' }, }); This is the error that is happening when I attempt to perform this part of the script. Thank you for the help!

I'm running into issues duplicating tables because of field counts.I can create a new table and copy a record over and it pastes all the correct fields but all the links and lookups are broken.My newest method is to link the record back to a main table and bring in all the fields as lookups but that as a (from {Table}) to the end of each field. A) is there a way to prevent that addendum to the field name OR a way to bulk remove it? Like with an script and via API calls?

Why can’t I save a webpage or anything i suppose to an airtable base using the share module on ios? Notion and other similar products allow it

Without any changes I recently started getting a 422 UNKNOWN_FIELD_NAME error for a field in my table. The field is available in the API docs ( Investor // Checkbox // boolean // This field is “true” when checked and otherwise empty.) My body looks like: data = { ‘fields’:{ ‘Investor’: True } } If I make a GET request for a particular record, the “fields” object looks like: {‘Investor’: True}, passing back that same object inside data results in the same 422 error

How can I change the primary field of a base using the API?

Hello,I need to trigger a webhook to Make.com, but I need to avoid the confirm tab being opened. Therefore, I cannot simply use button + webhook and I probably need to use a script. And this is the part I cannot do by myself.So here is the situation - I have a button as one column and what I need to achieve is to send a webhook with recordID to Make. In the interface, I have a "record view", where the button is for each record. The button works fine with this: "https://hook.eu2.make.com/myhook?ID=" & RECORD_ID()But it also opens a new tab, which is unacceptable for my use case.So I tried three scripts, but none of them worked. Some of them want to pick an item, that is probably not the right solution for my case.Can someone help, please?SCRIPT 1 let table = base.getTable("Myšlenky"); let recordId = input.recordId; let webhookUrl = `https://hook.eu2.make.com/myhook?ID=${recordId}`; let record = await table.selectRecordAsync(recordId); if (record) { let rec

For the audit log events API, when I submit a startTime and EndTime .. the answer back is in UTC or local time ? if it is in local time, according to what setting is set ?

I want to integrate langchain in airtable using Javascript. How can i pass values to langchain Prompt/template and log back reponse back to Airtable?

Is it possible to create a formula field using the API? if so how Can we do it can someone provide me the right json structure and syntax

Hi all,I've been searching a solution for creating (adding) an automation to table that is created via API call.Simplified process would be: 1. User adds a new project (to another system) [OK]2. This invokes process that creates AT table (to existing base) with all the needed colums etc. [OK]3. Turn automation on (via API), that sends data to another system when a "Status" field is set to "DONE".I know that I can achive this using a webhook, that listens field changed, but.. As the automations are already there, it would be more elegant process from maintaining perspective.Anyone countered the same, or found some other way to achive this?- EW

Does anyone know if it’s possible to access a list of a bases Automations (and corresponding steps) via Airtable API? If not now - does anyone know if it’s on their roadmap? Desperate for it :pleading_face:

I have a base with different tables, each one linked to other bases. Is is possible to edit an attachment field? I am able to edit other type of fields, as for example, checkboxes, but not the attachment ones... 

In Langchain, it can use chains like SQLDatabaseChain to utilise the power of NLP and convert the user input into SQL query code (JS or Python) then execute the code to retrieve what is needed from SQL database such as PostgreSQL.Does airtable support such query and would possibly be supported by Langchain in the near future?I guess if the script can be made and executed at the back end for each customised query, that would also work, is that feasible? Thanks.

Hi Airtable community, I am looking for AI tools with which I can query our team's Airtable database with. It's a massive database with about 5000 entries, and each record contains a vast amount of information. The idea is that we can query the Airtable with questions regarding the data.I worry that existing AI add-ons will not be able to handle that amount of information. Does anyone have thoughts or recommendations on what an appropriate tech setup would be for this?

Is it possible to request results from the REST be sorted by the createdTime (which is returned on the payload) without needing to add a new column to the table? i.e. right now if I pass createdTime to sort, I get back an error: [Error: {\'type\': \'UNKNOWN_FIELD_NAME\', \'message\': \'Unknown field name: "createdTime"\'}]

I am newish to Airtable and the person that built it for us no longer works or has access to it, one of our forms is not working and comes up with a error message, how do I fix this as I have had a hard time connecting with support team.

Hi, I'm running an automation that monitors a table for certain fields and when any of those fields get updated, I want to run script that sends those field values to an external platform, via an API call to that platform. I know how to write this script, however I can't figure out how to reference the specific record whose field was updated. Is this possible?Here is a screenshot of my automation. 

Is there a way to know the IP of my airtable account. I want to call an API from airtable using Zapier automation. The third party needs to whitelist my IP so that i can call the API. Any help is appreciated.

I did some searching but wanted to be certain since I’m still relatively new to the scripting block. Does anyone know if there is a way to create new views? My use case is that I currently manually create a suite of views each time I add a new client and/or project. For every project I will have an All view that shows everything about it, then an Open view that only shows stuff that’s currently being worked on, an Invoice view that gives me a summary of the tasks that need to be invoiced to make my invoicing faster, etc. Currently I have template views that I duplicate and update the related filters to have it show the right records. I’d love to automate this with the scripting block, but I don’t see a way to create new views from script. Am I missing something? Anyone else have any ideas? Thanks!

Hello, I am testing Airtable Api, and I see that no matter in which table the record is, the record get, update and delete methods work normally)Example:I have a record just in "movies" table, but even if I write the id or name of another table "blog" in api url, it still returns the record, you can also update and delete.Get https://api.airtable.com/v0/<app_id>/Movies/recY7Ho4bq4RM94XX/Get https://api.airtable.com/v0/<app_id>/Blog/recY7Ho4bq4RM94XX/They return the same elementIs this how it should work, or it is a bug?

The form builder allows the creation of groups of fields which are separated by a horizontal rule on the form.Is there a way to control visibility of the entire group, including the horizontal rule, rather than controlling visibility of individual fields within the group?Assuming the answer is no, is there a way to disable the extraneous horizontal rule when none of the fields in the group are visible?Thanks!

I'm trying to determine from the API whether a table is hidden or shown, but looking at https://airtable.com/developers/web/api/model/table-model there's no obvious field with that information. Is there another API that has it?

Created a simple form to submit a work order for repair services. User selects services needed from multi-select field. What is the best way to extract the services and create a line item for each service selected so that I can auto populate an estimate in quickbooks?I was thinking about creating a new table called "billable items" and have a script run when the form is submitted to create a line item for each invoice while still including the customer information submitted on the form in each line item.  Example Form SubmittedAirtable record createdscript runs creating 1 record per service requested in a separate tableeach line sent to QB for estimate creation Will this work? Im not sure the simple zap will be able to dynamically adjust to different amount of line items. One work around for this was thinking I could have a new "view" auto created for the billable line items that need to go on one invoice. I thought I could have the view named dynamically with

Hi!I am working on a small script thats generate a XLSX file from an airtable base.I stucked at when I want to download a file. Is there any solution to download from the extension section and not from an attachment field?Thank you for any help!

I believe I noticed a discrepancy on the documentation for updating a record.The returnFieldsByFieldId parameter is not specified as being an option on the Request Body, but it is mentioned in the Response Format section. It's also mentioned in the description for the endpoint too.Unfortunately, this parameter is not currently supported when updating a record, however I would love it if it were!!See this screenshot: Please consider adding support for returning fields by IDs when updating a record, so your documentation will be accurate 😉