Development & APIs

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 😉

Hey everybody, I'm building a script using Airtable Scripting and I'm looking to reference/extract/use the contents of files in a file attachment field I have. If it matters, these files are mostly PDFs, and my field may contain more than one. I want to take the contents of the file, or in cases of multiple each file, and include that in the payload of a REST API call. Right now, I am totally unable to get to the contents of the file itself in Airtable Scripting.Has somebody done this before? Could you please help out?Best,Cam

HelloI am developing a Airtable Script and I am looking for extracting actual file object which is part of the attachment field in a table. I got the object using record.getCellValue("Attachment field"). This object has information like URL, Filename, MIME etc. But what I am looking for is to extract the actual object in the attachment field (this could be a JPG, TXT,PDF,video etc). I need to pass this object to be stored in the target system through API (Dropbox API). The upload API in the target is looking for an object which is stored in local system. As the object is in Airtable I am not sure how this can be passed to API.The API call is some thing like below-----------------------------------------------------------------------------------------------let dropboxEndpoint = "https://content.dropboxapi.com/2/files/upload";let appToken = <-- Dropbox App token -->// set up the post optionslet postOptions = {method: "POST",headers: {"Authorization" : "Bearer " + app

I changed a column in Airtable from text to a checkbox (I am filling in with TRUE/FALSE (all caps)). Now I get this when I try to insert: data: { error: { type: 'INVALID_VALUE_FOR_COLUMN', message: 'Field "Active" cannot accept the provided value' } } I have seen articles saying to add: "typecast": true but this does not work. I’m not sure that I’m adding after the right curly bracket, as none of the articles I read are explicit on this, other than ‘add “typecase”: true’ somewhere. I don’t know whether to add it after each fields entry like so, or somewhere else? { "fields": { "key": "value", "key": "value" }, "typecast": true }, It is obviously being added in the wrong place, I am getting: data: { error: { type: 'INVALID_REQUEST_BODY', message: 'Could not parse request body' } Is there an example JSON that anyone can share that has been successfully used here?

I'm trying to avoid having to add a view for each new coach in a coaching engagements base.  The filtered URL works beautifully in a browser, but when I add it to the embed code in the iframe, it gives me the airtable.com refused to connect message.<iframe class="airtable-embed" src="https://airtable.com/appNTRWwuGJYQDcYK/shrPcWPXGkhHeb30F/tbl38pqjIpX(rest of code hidden for privacy)&filterContains_Engagement=(First Name)+(Last Name)&filterIsAnyOf_Status=In+progress&filterIsAnyOf_Status=Awaiting+SOW&filterIsAnyOf_Status=Assigned&backgroundColor=blue&viewControls=off" frameborder="0" onmousewheel="" width="100%" height="1000" style="background: transparent; border: 1px solid #ccc;"></iframe>