Jump to content

This topic is 2349 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

  • Like 2
Link to comment
Share on other sites

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" ) ;

 

Link to comment
Share on other sites

  • 6 months later...
  • 1 month later...
  • 1 year later...
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.