Stack Overflow
Stack Overflow

Questions tagged [airtable]

Questions related to interacting with Airtable databases programmatically.

Airtable is a spreadsheet like software in the cloud.

286 questions
5
votes
1 answer

airtable: TypeError: Cannot read property 'bind' of undefined running in JEST

Ran into an issue running my jests tests where it would error out when importing Airtable TypeError: Cannot read property 'bind' of undefined > 1 | import AirtableAPI from 'airtable' | ^ at Object.…
aaronmgdr
  • 598
  • 4
  • 12
5
votes
2 answers

List all Airtable tables via API request

Given that user provided his API key, is there a way to retrieve a list of tables in user's AirTable account? I do know there is a URL for API queries, with base and table encoded there. Also API docs include only info on how to work with a…
Pavel Tsiukhtsiayeu
  • 119
  • 1
  • 5
4
votes
1 answer

Airtable regular expression syntax in a formulae

I'm having dificulty extracting the filename from another cell. The regular expression I have works perfectly on regex101.com but only results in error on airtable. My working regular expression has a non capturing group followed by everything…
spaceshipdev
  • 101
  • 1
  • 10
4
votes
0 answers

How to query Airtable relational data using Gridsome and Graphql?

I am using the Airtable templates and Gridsome to query the Furniture in the Product catalogue templates. In AirTable the furniture data table has a "designers" property that has a value of the id of the designer who created the piece of furniture.…
Shahyn Kamali
  • 41
  • 1
4
votes
0 answers

Posting data on Airtable API does not work

I am trying to create a new table on Airtable with the aid of the post method. I have the following code : # importing the requests library import requests # defining the api-endpoint API_ENDPOINT =…
ffblord
  • 403
  • 3
  • 7
  • 14
4
votes
3 answers

Getting more than 100 records with Airtable

I'm building an App that gets a database on Airtable with the Requests library and transform it into a list. My issue is that I can only get 100 records with the URL solicitation. I tried to find a solution in the Airtable API, but the changes in…
Cristian Favaro Carriço
  • 159
  • 2
  • 15
4
votes
1 answer

How do you filter an airtable record that contains a given string, but may also contain others?

Using the airtable api's filterByFormula method I can query and select records that contain one specific item (string). However, this query only returns the records that have ONLY that specific string. Searching the airtable api formula…
Kenny Powers
  • 1,254
  • 2
  • 15
  • 25
4
votes
2 answers

Python and the Airtable API

Can anyone find an exampple of the API for Airtable.com being used in python. There is documentation but I'm not sure how to get started. Note, they don't have a client library.
MikeVaughan
  • 1,441
  • 1
  • 11
  • 18
2
votes
1 answer

Airtable - upload images and files

I am new to AirTable. I'm using is as the backend for my Flutter App. I see in my docs, that to upload an image or a file to the airtable, using an API, i need to provide a link to the image or file. This is what my docs say: To create new…
RJB
  • 1,704
  • 23
  • 50
2
votes
0 answers

Nuxt: Access API on build and download static file

I'm relatively new to Nuxt, which is why this might be a bit of a basic question (or maybe not!). I want to set up my Nuxt site on Netlify so that each time it builds, it fetches data from my Airtable via an API and saves a static JSON file to be…
user791793
  • 413
  • 1
  • 6
  • 19
2
votes
1 answer

Is there a way to use filterByFormula in Airtable to filter by a specific field value by date without it defaulting to the first entry in the table?

I am trying to filter by date to get one specific record, of which the Name field should = 8/01/2022. (I used the Name field in Airtable to place the dates. I set the field type to date.) The issue I'm having is that although it seems to work fine,…
afunnyworld
  • 78
  • 9
2
votes
1 answer

RecatJS: How to wait for REST Api response before loading the data in a table

I'm trying to get data from an Airtable table using their API and displaying the data in a table. Like this: import React from 'react'; import { GridComponent, Inject, ColumnsDirective, ColumnDirective, Search, Page } from…
Polymood
  • 397
  • 3
  • 14
2
votes
1 answer

Checking response code of all URLs in a column [Airtable database]

We have an airtable database of over 24000 records. These records are websites, and many now have errors in them (missing "/", extra space...). We are trying to detect the websites that have these errors before manually fixing them. What we have…
user18783288
  • 21
  • 1
2
votes
1 answer

Automate end date depending on session type (=duration in calendars days), start date AND if bank holiday?

I am developing an automated calendar for a school on AirTable, but I am struggling to add if there is a bank holiday between the start date and end date. If the bank holiday falls on a weekday, it needs to add +1 day to the end date. I have created…
grunenwaldmargaux
  • 25
  • 2
2
votes
1 answer

How to get async await work in airtable api with node js to get all records in the airtable before sending resolve?

I am trying to get my record from airtable using async await. What i want is that once airtable has fetched all the records it should return a value 1 which will be assigned to a variable counter. Once value of counter is 1 it can be used to access…
COdeingNinja
  • 381
  • 5
  • 20
1
2 3
…
19 20