I am trying to create a workflow that checks a value that a person enters on a field to make sure it's not a duplicate. Is this something possible with a workflow action script? I basically want to pass what they enter into a search (filtering against 1000-1500 records) and if anything is returned it will pop up with a message saying it's a duplicate?
I experimented with duplicate detection, but I thought this kind of a solution will give me more flexibility.