List validation for unique items

[martinb]

Hi,

I need to create validation for list question for unique (description of persons).
I was trying to create macro but it doesnt work, do you have any idea how to do it?

Thanks

for (var i = 0; i < List_osob.Length; i++)
    {
        if (List_osob.Count(x=>x.Item2 == List_osob[i].Item2)>1) return true;
    }
return false

[peter_brueck]

See discussion here:

Validation condition to check answers to list questions are unique

Dear Survey Solutions team I am looking for a way to check that the answers to a list question are unique. Is there a good way to do this? I have tried: A validation condition on the list question: ListQuestion.All(x=>x.Item2.Count==1) Creating a variable on the roster linked to the list question to count the rows with the same @rowname, but could not get it to work. Many thanks

No need for a macro. You can simply use a regular validation condition expression at the respective question:

self.Select(x=>x.Item2.ToUpper()).Distinct().Count()==self.Count()

The .ToUpper() element aims to make the list elements more comparable (all in upper case). You can also consider to remove any whitespace etc.

Hope that helps?
Best
Peter