Help
Development & APIs
Share, ask questions, and learn more about the backend of your Airtable applications.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Power Query Missing Columns

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 ...

Resolved! API: Uploaded attachment types are wrong

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...

Jed_Davidow by 6 - Interface Innovator
Solved
  • 4006 Views
  • 20 replies
  • 14 kudos

Viewing and modifying filters for rollup fields

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...

thisisdm by 4 - Data Explorer
  • 147 Views
  • 1 replies
  • 0 kudos

View Logs for (Failed) API Requests to Airtable

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...

shubham by 4 - Data Explorer
  • 174 Views
  • 1 replies
  • 0 kudos

Json problem with variable recordID

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

API Fetch Error: "Invalid SSL Certificate"

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...

Smithn27 by 4 - Data Explorer
  • 222 Views
  • 1 replies
  • 0 kudos

FAILED_STATE_CHECK

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...

arruga by 6 - Interface Innovator
  • 621 Views
  • 3 replies
  • 2 kudos

Automating a New View

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...

I get a Error when I try to use Airtable in PowerAutomate

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...

renel by 4 - Data Explorer
  • 651 Views
  • 4 replies
  • 0 kudos

AirTable script to send record to Twilio

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...

Drew_Nemer by 7 - App Architect
  • 541 Views
  • 0 replies
  • 0 kudos

How to sort by createdTime that is outside of fields?

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 ...

uncleJ0E by 5 - Automation Enthusiast
  • 808 Views
  • 2 replies
  • 1 kudos

Update API Key to Access Token - Google Sheets Script

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...

Faster way to count records via API

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...

Tom_Monks by 4 - Data Explorer
  • 3455 Views
  • 6 replies
  • 8 kudos

Chat GPT for Data Analysis

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...

omf by 4 - Data Explorer
  • 5179 Views
  • 11 replies
  • 2 kudos

Looking for developer support

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...

Labels