Corey-Troy Posted December 20, 2009 Posted December 20, 2009 I an creating a TimeSheet table, but have a question. If i set the start/finish time fields as TimeStamp, and use the DropDown Calendar, a Calc field set to Number, gives me the correct hours between the start and finish times[(Finish-Start)/3600]. However, as the Dropdown calendar exits the field when a date is selected, i need to re-select the field to manually enter the time. Is there a way to use a number field to enter the time as (0700 & 1500 etc) instead of having to re-select, and utilize a date in another field? If i choose a edit box instead of the dropdown calendar, i get a revert field alert, as there was no date entered. I am after a solution that a 24hour is manually entered, and the hour difference is calculated, but allows for the opportunity to enter a date if the hours run over between 2 days.
Ocean West Posted December 20, 2009 Posted December 20, 2009 perhaps add a script trigger to the field, and edit the value to what you want after exit?
Corey-Troy Posted January 4, 2010 Author Posted January 4, 2010 How do i go about setting up a script trigger? I have not dealt with them before.
Recommended Posts
This topic is 5507 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now