Jump to content

Incorrect Time Entries

Recommended Posts

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!

Link to comment
Share on other sites

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.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...