Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Single/Multiple Select—get all possible values

Topic Labels: API
3334 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I’ve added Multiple Select field to my base. In the Fields section on the API page it displays all the Possible Values this Multiple Select field as an array. Is there a way to grab this Possible Values array upfront or do I have to loop through the records and build this array based on each record’s selected value(s)?

3 Replies 3

unfortunately the API does not show the possible values defined in the Field meta data.

If you really need to, You could create another table that contains them and use the Link to Other Table in order to select. Then this would allow you to query that other table to get all values.

I didn’t think that array was available but wanted to make sure I wasn’t missing it somewhere. I did see your suggestion about creating another table for this purpose, I may give that a try. Thanks for the help!

Is there any updates to this?
I have ‘country’ as a column and I need a list of the possible countries in the database. I do not understand why this is not supported - because it should be.