October 11, 200520 yr I have two fields. Field 1 and Field 2. I want them both to be calculation fields that check to see if the term "P-" shows up in the other field. If it does, I want the computer beep and display a message that says you can only have that term in one of the two fields. Then delete the contents of the last entered field. Is this possible? It sounds easy, but like many things it easier said than done. Any Help you can give is much appreciated.
October 11, 200520 yr You can use a calculated validation on the fields to do this, sort of. Remember though that the validation depends on when the record is committed which may not be when you want it to happen. Other than that, you need a event trigger plugin to do this.
October 11, 200520 yr I attached two files. One - using Validations. Second - using AotoEnter options. I hope and will be glad if it help you. Term_By_Validation.zip Term.zip Term_By_AutoEnter.zip Term_By_Validation.zip Edited October 11, 200520 yr by Guest
October 11, 200520 yr Author Thanks aaa, that helps a lot. My question is, how do I get this to only search for P- and not duplicates of other words?
Create an account or sign in to comment