Forum Discussion
- MarkShnier__YouQrew LegendHow 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
------------------------------- RyanStanford1Qrew CaptainI don't think Mark's answer will fully work... as the only way that [Field] will equal Upper([Field]) is if every letter is capitalized... not if only one such as "Mark", it would have to be "MARK".
To get the desired effect would be to have:
If([Field] <> Lower([Field]), "Field has a capital letter","There are no capital letters")
------------------------------
Ryan Stanford
------------------------------- MarkShnier__YouQrew Legenddid you try it?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------