2 Replies Latest reply on Oct 17, 2013 1:51 PM by ChrisJohnston

Logic on typing format

ChrisJohnston Oct 15, 2013 1:07 PM

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?

1. Re: Logic on typing format

raybaudi Oct 16, 2013 3:06 AM (in response to ChrisJohnston)

     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 Likes(0)

Actions
2. Re: Logic on typing format

ChrisJohnston Oct 17, 2013 1:51 PM (in response to ChrisJohnston)

Thanks so much, I have not got a chance to check it out yet, but it looks good! Thank again!
Like Show 0 Likes(0)

Actions

Go to original post