Hi,
Subject is the request, i'd like to know a way to detect if there is a capital letter in any given text field. Has anyone solved this?
------------------------------
GMacri
------------------------------
Question
Data Validation: Is there a capital letter
+24How about this (not tested but it should work)
IF([My Text Field], <> Upper([My Text Field]), "Data has Capitals!! Please correct the error and attempt to save again.")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
IF([My Text Field], <> Upper([My Text Field]), "Data has Capitals!! Please correct the error and attempt to save again.")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.