ababcock Posted March 13, 2020 Report Share Posted March 13, 2020 I have users that enter non-time entries in time fields, and I can't figure out how to block that. The most common errors are using the wrong punctuation (semi-colon or period instead of colon) and putting letters in (o instead of 0). I also have trouble with users entering the wrong AM/PM designation, resulting in totals of negative hours or hours over 12. Does anyone have suggestions? I have used text fields for time as well as the Caspio solution where you use multiple virtual fields to break down the parts of the time. The text field is easier, but I can do it either way. I have tapped out Caspio chat on this one, so I'm hoping someone here can help! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.