Time-range based field entry

[Booyah]

Hello and thanks!

When my file opens a script is run which creates a new blank record and populates a field with the Date of creation.

What I need is a second field to be populated a certain way based upon a time range from the date created field.

example:

If the record is created between 07:45 AM and 08:15 AM, then a field named "SHIFT" will be populated with text that says "Dayshift - 0800-1600".

Is this possible? Thanks again.

Edited May 12, 2009 by Guest

[stefangs]

there are probably any number of ways to do that and i'm sure someone here will come up with something really elegant.

if you just have a few of those shift slots, it might be easy to just use a second field which auto-enters the creation time. it doesn't need to be on the layout. then, in your script, you can have a case statement like this:

case (

timeIn > time (7,44,00) and timeIn < time (8,15,00, "Dayshift - 0800-1600"),

[similar expressions for more shifts],

NightSift - 2300-0800")

Edited May 12, 2009 by Guest

[Booyah]

Thanks so much for taking the time. I will try your idea. I actually have created the "Time created" field and it is not in the layout. I figured I would need to have it for the script but I am new enough to scripting that I don't know how to write it.

Thanks again. I will let you know.

B

[Booyah]

I guess I have a lot of learning to do yet. When I tried it, I got a popup message that said "The specified file cannot be found".

I'm lost.

Unless one of you can guide me through the actual process, I think I should do some more reading because I may have the cart before the horse.

Thaks again

B