December 4, 201510 yr 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
December 5, 201510 yr 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" ) ;
June 10, 20169 yr Hello rivet, Once time has been entered and then deleted, the field defaults 12:00 PM. Is there any way to change this? Greg
August 10, 20169 yr Author Here is the update that allows clearing of the field. RIVET rapid time entry_v2.zip
September 29, 20178 yr Author Help, for some reason I can't get this to work when MacOS region is set to Canada.
Create an account or sign in to comment