Single/Multiple Select—get all possible values


#1

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)?


#2

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.


#3

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!