Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!

AnsweredAssumed Answered

Logic on typing format

Question asked by ChrisJohnston on Oct 15, 2013
Latest reply on Oct 17, 2013 by ChrisJohnston

Like • Show 0 Likes0
Comment • 2

Title

Post

Is there a way in data entry mode to type in a field, the format always being 0000 or 000000 and have it update to 00:00 if four character were typed and 00:00:00 if six characters were typed? Then if the user types 00:00 or 00:00:00 the field will just accept it?

No one else has this question

Outcomes

2 Replies

raybaudi Oct 16, 2013 3:06 AM
Mark Correct
Correct Answer
     Try this calculation in the auto-enter options for that field:

     Let(

     s = Filter ( Self ; 1234567890 ) ;

     Case(

     Length ( s ) = 4 ; Replace ( s ; 3 ; 0 ; ":" ) ;

     Length ( s ) = 6 ; Replace ( Replace ( s ; 3 ; 0 ; ":" ) ; 6 ; 0 ; ":" )

     )

     )
Like • Show 0 Likes0
Actions
ChrisJohnston Oct 17, 2013 1:51 PM
Mark Correct
Correct Answer
Thanks so much, I have not got a chance to check it out yet, but it looks good! Thank again!
Like • Show 0 Likes0
Actions

Logic on typing format

Title

Post

Outcomes

Related Content

Recommended Content