Jump to content

Recommended Posts

Posted

Good guys,

If my memory serves me, I recall that back in the Version 7 days, there was a dropdown for time, similar to a calendar (I'm not sure if it was only for Mac OS or both).

My issue is that when a user enters time, they have to enter the complete time.

I would not mind them entering 4.34 or 434 and displaying 4:34 AM or PM. The AM or PM would be determined by the current time on the workstation. Similarly, with the date they enter 9.29 or 929 and display 9/29/2025

I am trying to facilitate an easy way to enter time during data entry. Any ideas?

Thanks

JMart

Posted
4 hours ago, JMart said:

a dropdown for time, similar to a calendar

You could use a standard drop-down / popup with custom values. Or you might use 2 global fields, one for hour and one for minute, if you want a higher resolution without a huge value list.

Another option is a card widow containing an array of buttons with pre-programmed times (= "similar to a calendar").

 

4 hours ago, JMart said:

I would not mind them entering 4.34 or 434 and displaying 4:34 AM or PM.

That's certainly possible too, using an auto-entered calculation along the lines of:

Let (
entry = GetAsText ( Self ) 
;
Time ( Div ( entry ; 100 ) ; Mod ( entry ; 100 ) ; 0 ) 
)

or, to allow editing of existing values:

Let (
entry = GetAsText ( Self ) 
;
If ( PatternCount ( entry ; ":" ) ; 
Self ;
Time ( Div ( entry ; 100 ) ; Mod ( entry ; 100 ) ; 0 ) 
)
)

 

4 hours ago, JMart said:

The AM or PM would be determined by the current time on the workstation.

I am sure that's also possible but the rules would need to be defined more precisely.

 

 

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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