Hi All, I use the API to pull our data into Excel for automated reporting, and it does the job quite nicely :slightly_smiling_face: However, I’ve added a new column to collect a bit more information, but that column doesn’t seem to be available to ...
I have successfully gotten airtable to upload a PNG and a PDF from Dropbox. But when airtable processes the file, the type is listed as text/html If I include a type field, I get an error: { "fields": { "Type": "Test", "Comment": "", "Attachme...
Hello,Looking at the current Airtable fields API, there doesn't seem a way to view or modify the filters for count and rollup fields. If I look at the field options for either of these field types, this does not seem to be supported. Is there a possi...
Hello, I just made an API request to Airtable that failed, and I don't have enough traceability data to inform me about the details of the request for which the API request failed (e.g.: the different fields and values in the request body).Is there a...
Hi I have an automation script, and run into a problem, it is not fetching the right recordId in the script, but it does in the previous step. Anybody with a larger brain that can se what I have done wrong here?All the BestJesper
Hello ! Is there a way to get the documentation of the API in an OpenAPI / .yaml version ?Thank you!
I am trying to use an external API to automatically update some fields in my base based on a record ID using the script below.let table = base.getTable("Tracker");let view = table.getView("US");let query = await view.selectRecordsAsync({ fields: ["ap...
Hello there, I'm trying to write data from one base to another through Airtable's API. My JSON is something like this: let body = { "fields":{ "prod_serv_cia_id": inputConfig.cia_id[0], "NroParte": inputConfig.codigo[0], "D...
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 operatio...
Is there a way to automate a New Grid View when there is a new record in view? Here’s the flow: A new record is in viewCreate a view.Use a field from the new record to create the filter for the viewSave the view as the Name. I’ve use web scraping too...
Hey there!I am very new to Airtable. I wanted to connect PowerAutomate to Airtable. I want to use Airtable as alternative to Google Sheets. I created a token in the settings, used the table and base ID (pulled it out of the link like described in the...
I am trying to use AirTable to initiate via automation and a script action to make Twilio call and message our clients.Essentially this is going to be built out in Twilio Studio. But i am trying to figure out how to implement this code to send all t...
Hi dear airtable community, I’m using airtable curl API and I want to get the data from the oldest. I believe the go here is the sort parameter passed on as a query, but the createdTime is outside of fields, how can I access that? createdTime has to ...
Im trying to filter the next api request: https://api.airtable.com/v0/appn8Dg5iLM042oZh/tblDamHA046rqdTJF?fields%5B%5D=client_address_(from_deal_id)&fields%5B%5D=client_name_(from_deal_id)&filterByFormula=assignee%3D+9650 but instead of the assignee ...
I'm trying to update a Google Sheets script that syncs an Airtable Base to Google Sheets. The script uses an API Key and I need to update it to use the Access Token.Anyone know how to update this code to use the Access Token instead of the API Key? T...
Hi All, I’m wondering what is the best way to calculate some basic counts on a table via the API. We need to calculate simple counts such as total records with a Status of “Fulfilled” and total records where Status is “Fulfilled” with where the Fulfi...
Is there a way to set up Pitchbook and / or Asbhy integrations or APIs with Airtable? If so, any recommendations on what's the best way?
I'm trying to use ChatGPT to analyze written data from airtable surveys, but ChatGPT is unable to access the information from a csv file. Is it possible to connect ChatGPT to Airtable in order to give it access to specific tables? The idea would be t...
I have been running Airtable for at least 5 years and am very familiar with it. I have a need that is beyond my no-code low-code capabilities and I am looking to hire someone to help me develop the following idea.I have a base that has dynamic inform...
I am trying to create new records via airtable.js, when I try to create a new record in Link-to column with row-value (i.e. name - string not Record ID), it does not work and reply Class {error: “INVALID_RECORD_ID”, message: “Value “VALUE” is not a v...
