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)?
Single/Multiple Select—get all possible values
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.
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!
+2Is 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.
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;
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.