Find Out the distinguish values from a multiselect field

Question

I have built a formula for a multi-select formula field. The formula looks like this: GetFieldValues(GetRecords(("{F1.EX.'"&amp;[xxx] &amp;"'}"),[_DBID_xxx]),F3)).&nbsp;
The formula is working fine. But it also populates duplicate values.&nbsp;
How can we get distinct values from a list?
------------------------------Amir Sohel------------------------------

markshnier__you · Answer

Amir, try this previous thread here.&nbsp; I think it answers your question.

https://community.quickbase.com/discussion/getfieldvalues-query-but-only-get-unique-values?reply-inline=5d2226db-05a1-498b-bd66-f0ee78cf87e8
------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

amirsohel · Answer

Thank you so much, Mark------------------------------Amir Sohel------------------------------

Forum Discussion

Find Out the distinguish values from a multiselect field

2 Replies

Related Content

Conditional Dropdown to MultiSelect

Time of Day field values are not in 24-hour format in Pipelines

MultiSelect Dropdown Values Changes

Incompatible value error

Multiselect field values with customized bullet colors

Recent Discussions

Filter Monthly, Quarterly, Yearly from one Date field

Extrapolating nuanced data

Forms help

Share your feedback on the new Qrew Discussions

Generating QR Code with URL to record