Brian Dunning's FileMaker Custom Functions

FastTimeInput ( _Time )

Fast time input

  Average rating: 4.2 (38 votes) Log in to vote

Paul Sazonov   Paul Sazonov
APS
http://www.briandunning.com/

Share on Facebook Share on Twitter

  Sample input:
FastTimeInput ( 802 )
  Sample output:
08:02

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

I think it's a little bit comfortable solusion to make your hand fly only above NUMPAD. So you can focus on numbers with no colon-timeouts.

Thanks.
(c) Mezzo

 

Comments

Carl Riedel   Carl Riedel, Croydon
May 26, 2010
On FMPro 11 Adv FastTimeInput(802)= 802:00
 
Mike Ahern   Mike Ahern, Ft Washington
Sep 5, 2013
I took this and modified as follows: Added the ability to test for AM & PM in field, as well as allow for glitch when entering in a single digit it would enter it as seconds instead of hours.
//Altered to test for AM & PM
Let
(
[ TimeFld = Filter ( _Time ; 1234567890 ) ;
TimeLngth = Length ( TimeFld );
TimePM = PatternCount(_Time;"PM") or PatternCount(_Time;"pm") ;
Timeadd = If(TimePM ≥ 1;12;0)
] ;
Case
(
TimeLngth = 3 ;
"0" & Left ( TimeFld ; 1 )+Timeadd & ":" & Right ( TimeFld ; 2 ) ;
TimeLngth = 4 ;
Left ( TimeFld ; 2 )+Timeadd & ":" & Right ( TimeFld ; 2 ) ;
_Time+Timeadd & ":00"
)
)
 
Andrew   Andrew, Sydney AU
Jul 22, 2015
The last line is wrong.
_Time+Timeadd & ":00"
Should be
TimeFld+Timeadd & ":00"
 
Peter   Peter, Australia
Aug 26, 2015
New to this concept of custom functions excuse my newbie question exactly how would one implement this to an existing field?. DI have to change timefld to the field I want to fast input?
 
Andreas   Andreas, Sweden
May 25, 2016
Great function.

If it's not clear, you can implement this by change "TimeFld" to "Self" and in the Field Management input this funcion as an Calculated Value (preferrably with replace existing value so you're able to change it as well).
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.