Skip to main content

API Get only the options of field(column) type multiple select (array of string)

  • March 11, 2020
  • 5 replies
  • 52 views
E

Hello everybody!!!
I’m new in the comunity of Airtable, since last Monday, Im working with the API, now I need some help, this is the think:
I have a table with a field of type multiple select(array of string) and need to get only all the options (values) configured of this field, not the values select by the user.
please help, some real values are:
[
“Planning”,
“Work-in-progress”,
“Approved”,
“Completed”,
“1. Fields Status Value Text”,
“Otro”,
“Testing1”
]
and are all this values that I need get to my code.

See you…

5 replies

A
Forum|alt.badge.img+3
  • Andrew_Johnson1
  • Participating Frequently
  • March 12, 2020

To the best of my knowledge the API currently does not have a way to retrieve the configured values of a multiple select field.

D
Forum|alt.badge.img

what about 2020?

any update on that topic?

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • November 3, 2020

what about 2020?

any update on that topic?


Welcome to the Airtable community!

The public REST API does not have this information, but it is available in the Scripting API and the Custom Blocks API.

D
Forum|alt.badge.img+1
  • dzulstellar
  • New Participant
  • February 3, 2023

what about 2023?

W
Forum|alt.badge.img+1
  • willups97
  • New Participant
  • October 8, 2024

It seems like you still can't do this using the API.

However, you can flatten the multiselect options from all of your records down into a Set (which automatically discards duplicate values) and then use Array.from() to turn it back into an array.

 

return Array.from( new Set( this.data.flatMap(record => record.fields['Tags']) ) );

 

 

Terms & ConditionsAccessibility statement