4 Replies Latest reply on May 22, 2014 1:49 PM by FranziskaBlome

    How can I validate two text fields (first and last name) to avoid duplication?

    FranziskaBlome

      Title

      How can I validate two text fields (first and last name) to avoid duplication?

      Post


           Hi! I know how to validate one text field, say "last name", but since there will be duplicate last names in a large contacts database I would like to validate that both "first" and "last name" don't already exist in this database. How do I do that? I also have a calculation field combining first and last name into one field, but I don't see how I can set a validation on this calc field. Any suggestions?

           Many thanks!

           Franziska