Newbies ppeffgra Posted August 23, 2001 Newbies Posted August 23, 2001 Im a beginner when it comes to scripting so please bear with me. I am trying to validate a field for uniqueness, but I want to do it using a script. I know you can validate fields using the options under Define Fields. What I currently have is a button that sets off a script which copies text and numbers from various fields and paste them into another regular field to create a unique name. My problem is that I need to verify that this name is not used in other records before the rest of the script can proceed. If I validate it using using Define Fields options the current script halts and allows the user to enter jibberish which is then accepted as a valid name (because it does not exist). This is why I would like to do it in a script. Something that will check for uniqueness and guide the user to enter the appropriate data until a valid and unique name is entered. The script I have now will guide the user to only uses correct data but I have not been able to get it to check other records for uniqueness. Any ideas?? Any help or input would be greatly appreciated. Thanks!
Vaughan Posted August 23, 2001 Posted August 23, 2001 Perform a find for the just-entered value. If more than one record is found, it's not unique.
Recommended Posts
This topic is 8497 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now