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
Javascript : When setState inside promise, getting an unending loop of output
I'm trying to load data from Airtable with the javascript API. But when I try to setState of data inside of a promise block, the promise doesn't 'end'.
Airtable API stuff:
export const listRecords = function() {
const Airtable =…
Sir Poohbher
- 13
- 2
1
vote
2 answers
Multiple axios requests with vue.js and Airtable
I build a working code to retrieve data from fake Airtable database with axios. You can see the code below perfectly working. No problem to retrieve data when is on the main table. Yet as you can assume some fields are connected to other tables…
1
vote
0 answers
Is there anyway to add keyword argument to a pre-existing function?
I was using the get function to import data from Airtable but I need to make the records I get sorted so is there anyway to create a kwarg that can sort the results in python?
The idea was made in github but I couldn't understand it
Github code:
…
Kareem Alaa
- 35
- 5
1
vote
1 answer
Accessing Airtable's Pagination Using Python's Requests Library
How can I access Airtable's pagination by including a given offset in either the url or query?
My attempt below at including in the url has failed with the error "KeyError: 'offset'".
I've been able to access the 1st offset per the function…
empty__cup
- 71
- 5
1
vote
1 answer
How do I append the datasets from pagination responses in Python?
I've (seemingly) successfully used pagination to iterate through Airtable records through a Python API call. But I'm having trouble understanding how to append the data from the first call and all of the iterations get calls. My code is below:
while…
Jordan Olson
- 31
- 2
1
vote
1 answer
Cannot Get A Python Patch Request To Work
article_url = "https://api.airtable.com/v0/appxxxxxxxxxxx/articles/row_id?api_key=APIKEY"
data = {"fields" : {"contacted" : "hello world"}, "typecast":True}
patch_article_data = requests.patch(article_url, data=data)
I don’t understand why the…
Suraj Kapoor
- 1,615
- 4
- 22
- 34
1
vote
1 answer
How to export data from records into a json object after Airtable request
I'm trying to exports the results of my Airtable records into a json file.
I'm using a react-js env in codesandboxio.
I coded a function that retrieve all the records, but i can only console.log their value.
function loadGeneralItems(table) {
var…
assayag.org
- 709
- 10
- 24
1
vote
0 answers
How to find children from parent reference nodes in graphql
I'm using gridsome, which is pulling data from airtable. I have a table called Nouns, which have a self-referencing hierarchy (any Noun can be either parent or child of any other Noun). I have defined parents only in airtable, and want to write a…
jalx
- 21
- 2
1
vote
0 answers
How to access a field in Airtable using a variable that stores the field name instead of the actual AirTable field name in ReactJS?
In my React application, I am trying to update columns depending on what the date is. Essentially, if it's the first week, my variable would be 1. The second week, my variable would be 2. Etc. In Airtable, I have several columns with the same name,…
hoo22xx
- 33
- 5
1
vote
1 answer
Adding Authorization header to GET request
I'm building an alexa skill using the new SDK 2.0 and I'm now having trouble implementing a simple http get request. How would I add an authorization header to the getRemoteData url request? The code below isn't working.
I'm trying to call Airtable…
notyourguru
- 43
- 9
1
vote
2 answers
Dialogflow - Reading from database using async/await
it's the first time for me using async/await. I've got problems to use it in the context of a database request inside a dialogflow intent. How can I fix my code?
What happens?
When I try to run use my backend - this is what I get: "Webhook call…
Herodot Thukydides
- 137
- 2
- 10
1
vote
1 answer
Can I simplify an if-statement for an Airtable formula?
I'm pretty new to writing formulas to manipulate data. I'm using Airtable to gather survey feedback and assign each response a category based on 2 scores provided. Each or two scores can be -4, -2, 0, 2, or 4. Depending on the combination of scores,…
Aaron Benjamin
- 1,291
- 3
- 18
- 27
1
vote
1 answer
Airtable sometimes return results and sometimes not
I am using Node.js library to communicate with AirTable, official js library. I am having a problem with filterByFormula. Sometimes when I try to find record from AirTable I don’t get results even though I am pretty sure that there should be some…
Ivan Vasiljevic
- 5,478
- 2
- 30
- 35
1
vote
1 answer
Pulling multiple records from Airtable into Google Sheets via Zapier
Wondering if there's a way to pull multiple records from Airtable into a Google Sheet via Zapier based on a conditional Y/N column in Airtable.
Basically, I want to create a Zap that searches all the records in the table and any record with a 'Y'…
RobC
- 13
- 3
1
vote
2 answers
How to get all names of records in one array?
I'm trying to make a small webpage and use Airtable as a database. My base includes a few fields. The most important are "name" and "icon_png" I use vue.js, log in via axios and get all database in one array, named items. When I want to list names I…
Stan
- 11
- 1