Rapid Time Entry

[rivet]

After voting up the 'Time Picker' suggestion in Filemaker's new Product Ideas,  I thought perhaps I could just simplify the method of input without a picker and without punctuation.

- enter times using only numbers.
- AM/PM is determined by the Workday Starting Hour.
- use punctuation to override.

NOTE:
- the Workday Starting Hour only considers hours 1-12 right now.
- I have added a 'clamp' in the time fields auto-enter calc to the keep the start and end times logical.

Enjoy and please post any improvements 

 

RIVET_rapid_time_entry_v1.zip

[Ocean West]

this is excellent @rivet may have to use this in concert with what i've been working on http://fmforums.com/topic/98627-controlled-data-entry-design/#comment-448591 which was partly because the lack of a real time picker.

also modified the custom function to allow for fractional hours: like 1.25 / 1.5 / 1.75

base0 = Substitute ( text ;  [ ".25" ; ":15" ] ; [ ".5" ; ":30" ] ;  [ ".75" ; ":45" ]  ) ;
base1 = Filter ( base0 ; "0123456789" ) ;

 

[JerrySalem]

very nice!  I will use this.

[kigmaker]

Hello rivet,

Once time has been entered and then deleted, the field defaults 12:00 PM.

Is there any way to change this?

Greg

[rivet]

Here is the update that allows clearing of the field.

RIVET rapid time entry_v2.zip

[rivet]

Help, for some reason I can't get this to work when MacOS region is set to Canada.