Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 18, 2018 08:35 AM
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)?
May 18, 2018 08:49 AM
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.
May 18, 2018 08:55 AM
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!
Jul 21, 2022 06:47 AM
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.
May 03, 2024 06:22 AM
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;