Questions related to interacting with Airtable databases programmatically.
Airtable is a spreadsheet like software in the cloud.
Questions tagged [airtable]
286 questions
1
vote
2 answers
Retrieve data from an array of objects in Google Script
i am trying to extract certain elements from the below array of objects called atstudentsarray and create a new array with objects. I have used the below map function but i can not get it to work.
var newAtStudentArray = atstudentsarray.map(i => {
…
Antony Rappai
- 25
- 6
1
vote
0 answers
How to set up 2-way syncing between Airtable base and multiple external sources
Is this even possible? I would like to update my companies external postgres database, as well as potentially updating their information in Salesforce, whenever a new record is added in Airtable.
I'd also like to set up a sync so that updates in the…
Jub10
- 183
- 1
- 2
- 15
1
vote
1 answer
How can I able to fetch air table record against field name?
I'm using Airtable db to fetch data against an input.
I want to fetch data from database against that input but I'm not aware how to achieve that.
Here's my fetch API call function
const fetchData = async e => {
…
Hasham Minhas
- 436
- 3
- 13
1
vote
2 answers
Filtering Nested Array of JSON using javascript (Airtable structure)
I'm not a javascript programmer, but I have a need to write a piece of javascript code (in an HTML page) to filter data from an Airtable JSON array fetched from an API call. I've researched this a lot and tried several options, but none of them…
Fouad
- 13
- 2
1
vote
1 answer
How to increase Airtable api rate limit?
We are using airtable rest APIs to manage our employee's data.
In the airtable support article, it was written that the airtable API has a rate limit of 5 requests per second per base.
Here is the article link:…
Suraj patel
- 11
- 1
1
vote
0 answers
Filtering array of objects by array of Ids
I'm working on building out an analytic tool for my vacation rental management website. I currently use airtable as my backend to store the properties, bookings, owners, etc. I'm trying to create an object that contains each property associated with…
TimothyChurch
- 11
- 2
1
vote
1 answer
How can I reference a query imported from Airtable?
After several days of iterating around formatting and variables, I am still struggling to get this code to run and keep getting various errors similar to "Cannot read properties of undefined (reading 'map')"
I am only just setting out with the…
JagwireXKR
- 11
- 1
1
vote
1 answer
Want to Optimize Airtable Query with Better Operators
I’m fairly new to Airtable, and I’m unsure how to accomplish the query(ies) I’m performing in a simpler manner using Airtable commands.
The Base
I have an API with two tables: Classes and Students. The Classes table consists of classes and all the…
friskybunnies
- 21
- 1
1
vote
2 answers
How do I call Airtable rest API from inside an AWS Lambda?
I am trying to call my rest api endpoint in AIRTABLE from inside an AWS Lambda with no success. I get no errors, no outputs.
If I call the same code using node - it works.
I am able to use Axios in my code.
Pure airtable code (works)
var Airtable =…
Itay Moav -Malimovka
- 52,579
- 61
- 190
- 278
1
vote
1 answer
Need help explaining an Airtable script block syntax error
I have added a fairly simple scripting block in Airtable that post an update via an endpoint on my application. The error when running this is below, but can’t work out what this is referring to.
Thinking it might be something simple, has anyone got…
Ewan Farry
- 49
- 4
1
vote
1 answer
DeprecationWarning: Gatsby-Source-Airtable with mapping to a fileNode
I'm getting a Deprecation Warning on Gatsby Build after image mapping: { image: fileNode } has been added to the plugin option:
(node:15664) [DEP0066] DeprecationWarning: OutgoingMessage.prototype._headers is deprecated
(Use node --trace-deprecation…
brandshore
- 51
- 3
1
vote
1 answer
Vegalite - ignore NaN and empty Values
I'm new to Vegalite and have been progressing well, but I'm struggling to find the correct method to omit/ignore NaN and empty field values from my input data. In my example, I have fields that contain a cholesterol panel along the X axis, whilst…
Karlstens
- 13
- 3
1
vote
1 answer
"gatsby-source-airtable" threw an error while running the sourceNodes lifecycle
Gatsby project compiles successfully on local but failed in netlify:
Here is the complete log of deployment:
Starting build script
10:25:06 PM: Installing dependencies
10:25:06 PM: Python version set to 2.7
10:25:08 PM: v12.18.0 is already…
Bisho Silwal
- 121
- 1
- 9
1
vote
1 answer
How do I fix React: The string did not match the expected pattern error
I'm creating a test app to display Airtable projects in a React dashboard. My index.js file contains the following:
import Head from 'next/head'
import styles from '../styles/Home.module.css'
import Cotter from "cotter";
import { useEffect, useState…
Liam Arbuckle
- 31
- 5
1
vote
1 answer
Problems using airtable.js module in AWS lambda
I'm trying to access Airtable from an AWS lambda function.
First off, to test, I installed airtable.js (npm install -s airtable) in a local project, wrote a short test script, and executed with node test.js. All works fine.
Using exactly the same…
jfrank
- 83
- 4