1 Reply Latest reply on Nov 11, 2015 10:31 PM by user19752

    Validation script

    scarruth33

      Can I used OnObjectValidate to run a search of all the records prior to the validation? My validation field is auto pop: Player  & "|" & Manufacturer & "|" & Team & "|" & Year & "|" & Card # & "|" & Location. The validation is Card # & "|" & Location. I would like the validation to do a search of Name and Card #, prior to the validation, and then only display if there is a record found.

        • 1. Re: Validation script
          user19752

          Name would be Player, then why don't you validate Player and Card#, instead of Card# and Location ?

           

          If you want to use trigger, you can set onObjectValidate to Card# and Location, then after changing either fields the trigger will fire.

          But I got bad result using it.

           

          I prefer entering the 2 fields in find mode, then if not found, create record and go next steps.