Returning unique values

Forums SPJS-Lookup Returning unique values

This topic contains 2 replies, has 2 voices, and was last updated by  Jeff Law 3 years, 5 months ago.

  • Author
    Posts
  • #7202

    Jeff Law
    Participant

    Hi,
    I was wondering whether it would be possible to add an option that enabled only unique values to be returned in the lookup list.
    My scenario is that I am using a Contact List to return the list of Companies, but of course there are often several people from the same Company, so I get one Company for each entry. What I am really after is just the one entry for each Company.
    Regards
    Jeff

  • #7232

    Alexander Bautz
    Keymaster

    Hi,
    Have you tested it? – I’m fairly sure this solution will remove duplicates so that only unique values show in the dropdown.

    Alexander

  • #7238

    Jeff Law
    Participant

    Indeed it does! My problem was that the test data I was using had trailing spaces after some of the “duplicate” entries.

    Not a problem now that I know to check for it 🙂

You must be logged in to reply to this topic.