Not able to get UNIQUE values in dropdown, where data is coming from external API

earnfromhomenewway · February 21, 2021, 3:05pm

Hi All
I am trying to achieve UNIQUE values in dropdown, where source of data is an external API (like Google Sheets, etc).
and I want the dropdown to only display unique values irrespective of repetition in the source data.

Jici · February 21, 2021, 4:03pm

You problably need to set your Data type as “Text” (I guess actually it’s set to the API Type), select the text field from the Get data API value and use :unique value

earnfromhomenewway · February 21, 2021, 4:16pm

Thanks @Jici for your response. Much appreciated.

I did few changes and it worked !!

Thank you once again.