Help

Re: Retrieve Single Select Options from API

1547 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Bazar6
4 - Data Explorer
4 - Data Explorer

Is it possible to retrieve the possible options within a column’s “Single Select”? Without having a record for each option listed? I have one column with 5 possibilities (right now), and want to retrieve those possible values so I can dynamically build a select box on the front end of my application. I want to be able to change those options in Airtable (add or remove) without having to touch my application. The select box will allow me to create a new record in the table with only the values I’ll allow the table to accept.

I’m using only jQuery to interface with the Airtable API, and have been doing well with it (I know it’s not the most secure but it works!)

5 Replies 5
Platform_Admin
4 - Data Explorer
4 - Data Explorer

I’m also interested in this

BillFrench
7 - App Architect
7 - App Architect

As old as this request is, you’d think they would have added schema access to the API by now, but they haven’t.

I came up with a kludge to do this. If you can take a sizable swath of data and perform a fast aggregation on option list fields, you can determine all the possible unique values, ergo - the option list array.

Completely bad approach, a workaround with a capital W, and likely to add some latency to your front end UI.

Airtable MUST address this now to regain its API composure.

I agree completely. Hard to build self maintaining forms without this. Leads to data integrity issues (when using the typecast parameter for instance).

Foulques_de_Mo1
4 - Data Explorer
4 - Data Explorer

So if I understand correctly, it has never been added since 2016 ? It’s even doable in Scripting Apps so why not on the api ?
I guess we should start implementing our own little database on the side to stock all those things, because looping through all of my records for all of my select and multi-select fields value is definitely not an option.

Yoav_Malichi
5 - Automation Enthusiast
5 - Automation Enthusiast

I found a way to achieve what you asked for.
Full solution posted here: https://community.airtable.com/t/list-all-options-of-single-select-from-api/26771/3?u=yoav_malichi :slightly_smiling_face: