Distinct Values of a Field in Text Objects

[anushree1]

Hi,

I have a requirement wherein every Division has 3 Different Departments

So when i Select a Division I want to Display each of the Department Names in Separate Text Boxes , I tried to do this using FirstSortedValue but it Does not work as it needs a numeric Sort weight is there a way to get the distinct Department names in seperate list boxes

Attached Sample app for reference

[sunny_talwar]

Try these expressions

=SubField(Concat(DISTINCT Dept, ','), ',', 1)
=SubField(Concat(DISTINCT Dept, ','), ',', 2)
=SubField(Concat(DISTINCT Dept, ','), ',', 3)