Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Single/Multiple Select—get all possible values

Topic Labels: API
4986 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Jess_Poteralski
4 - Data Explorer
4 - Data Explorer

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

4 Replies 4
openside
10 - Mercury
10 - Mercury

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!

SafetyWing
4 - Data Explorer
4 - Data Explorer

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.

JeremyK
5 - Automation Enthusiast
5 - Automation Enthusiast

I'm unsure if this is exactly* what you're looking for but to get all the options for a multi-select field you can use the below:

base.getTable("TABLENAME").getField("FIELDNAME").options.choices;