Questions tagged [airtable]

Questions related to interacting with Airtable databases programmatically.

Airtable is a spreadsheet like software in the cloud.

286 questions
1
vote
2 answers

TypeError: Cannot read properties of undefined when making AirTable API call with NextJS 13.4

I'm learning the new App router using NextJS 13.4 and have come across an error when attempting to make an external api call. I actually receive all of the data properly from Airtable but because Next throws this error it causes my try catch to…
Nick Stull
  • 13
  • 2
1
vote
0 answers

AirTable - how to get form data in an ensuing automation script

Here is my problem: I have a form that lets users enter some data. When the form is submitted, I want to fire off an http request to populate a remote DB using the data entered in that form. I have set up an automation script to run when the form…
Joshua Foxworth
  • 1,236
  • 1
  • 22
  • 50
1
vote
0 answers

Append new image URLs to an existing Airtable cell, even if responses are received in one go and there is a delay in updating the URL in the backend

I am developing a WhatsApp bot that allows users to send multiple images at once and perform operations accordingly. I am using WATI API The user responses are received on the server in one go, and it takes a few seconds to update the URL in the…
Dummy Cron
  • 143
  • 2
  • 11
1
vote
0 answers

Automate User Creation on Firebase from Airtable through React

I'm working on an web app currently with no-code stack: Airtable - Database (Currently holds every record excluding user credentials) Softr - Front End & User Credentials DB (Holds Name, Email and pass for users to login) Make.com - Automates…
Akhil
  • 49
  • 6
1
vote
1 answer

Fetch data from Airtable with pyairtable, formula that combines NOT with another argument

I'm using pyairtable to fetch data from an Airtable with Python. Both #1 and #2 work fine. I'm looking for a solution to combine the two formulas. I need one formula that would give the results matching column1 = string1 and column2 not empty. from…
Zumplo
  • 150
  • 1
  • 9
1
vote
1 answer

How to select or view only the top row in airtable?

I have this table: Name | Weight | Color 1 Cherry | 1 | Red 2 Apple | 4 | Green 3 Pear | 3 | Yellow I need a view in which only the top row is visible Cherry | 1 | Red When the table changes (new record, sorting), the…
Roy
  • 1,307
  • 1
  • 13
  • 29
1
vote
0 answers

Creating a live connection to airtable from tableau

Not sure whether this is the correct outlet for this question but here goes. Currently, my company’s connection to airtable has to be refreshed manually when we are updating our dashboards. However, we are looking to speed this up by periodically…
Bok
  • 11
  • 1
1
vote
1 answer

How to have a Development struct and Production struct in Golang with identical members but different JSON tags?

First time asking a question! I am trying to separate my development and production that use the same struct. I am working with Airtable, which sends records as a JSON with an fld tag that we use when unmarshaling. type AirtableRecord struct { …
LuckyScum
  • 21
  • 4
1
vote
0 answers

Getting multiple JSON objects in Python from API with max 100 records

I am using Airtable to get some records and I have issues getting all the records I have. Airtable limits you to 100 records per API call, so if the records are more than 100, they give you an offset field in the results. What I need to do is to…
Kaiss B.
  • 249
  • 1
  • 12
1
vote
1 answer

How can I run python script when a google sheet get new value?

I have a google sheet that 5 times a day append a new value to the sheet. I need to run a local python script everytime a value is included, how can I do it?
1
vote
1 answer

When to use Extensions vs Interfaces in AirTable?

The tools available in AirTable's Extensions and Interfaces are so similar! I'm having difficulty separating my use cases for them. I'm in charge of creating simple data dashboards for my small nonprofit, which is fun, but I feel as though I've…
lbenetua
  • 11
  • 2
1
vote
0 answers

How do I create hyperlinks with a formula or rollup?

I have a table of items, each has a Name and a URL. How can I combine the two and create a field that stores the hyperlinked Name, linking to its respective URL? Furthermore, would it be possible to do the same with not just a formula field, but a…
1
vote
0 answers

How do i download images from Airtable and upload to Wordpress using Airtable and Wordpress APIs preferably in javascript

Im looking to make an automation script that takes images from Airtable and downloads and upload them to Wordpress upload folder. these images should backfill on all the post types with the empty image fields i have created for them. for example say…
Major
  • 41
  • 2
1
vote
2 answers

Find synced users from two arrays based on id and return array A with one column from array B

i am trying to find a list of synced users between two arrays (objArray1 & objArray2) and return the data from objArray1 along with 'aid' in Objarray2. I have the below code working, but i am trying to see if can return 'aid' from objArray2 as well…
1
vote
2 answers

Displaying URL parameter values as text in an element on webpage (Question from a non-programmer)

I don't have any expertise in programming, just from the little I've researched to solve one-off needs. However, the one thing I can't seem to find answers for is populating dynamic content on a page. I currently build my website with no code…
1 2
3
19 20