Looking for Duplicate entries in portals across records

[Gary Lutz]

Hi,

 

I have a database that is using portals for item number entries for a job.

 

I am looking for a way to look for duplicate item number in the portal field across multiple records. 

 

Using below as conditional formatting works but only per record

 

ValueCount ( FilterValues ( List ( Child::Category ) ; Self ) ) > 1

 

How can i make it work across all the records?  Do i need to use a script trigger instead?

 

 

[bcooney]

I'd walk the problem back and if Item Numbers must be unique, then don't allow duplicates.

[Gary Lutz]

The numbers can be duplicate , they just want to be notified when they are.

[comment]

Using below as conditional formatting works but only per record

 

ValueCount ( FilterValues ( List ( Child::Category ) ; Self ) ) > 1

 

How can i make it work across all the records?

 

What exactly does "per record" and "across all the records" mean in the context? In which table are these "records"?