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