Okay, I'm really stumped on how to do this. Using FM7 on PC.
I would like to have a time field enter the time when an item in another
field is selected in a drop down list.
For example: I have one field labeled STATUS which consist of 10 values
from a drop down list, one of which is XX. I would like to have a field
labeled PROCEDURE Time automatically enter the time, when XX is selected
in the other (STATUS) field. For the life of me I just cant see it
after staring at the book for hours on end......any help appreciated.
Regards

Warren Grand wrote:

issue.

In article <jRXGe.10934$sf6.2056 (AT) fe08 (DOT) lga>, Warren Grand
<wgrand (AT) optonline (DOT) net> wrote:

Assuming you don't want to manually edit (or via a script) the
Procedure field at any stage, all you need is a simple Calculation
field which uses a Case statement to test the contents of Status.
ie.
Procedure Calculation, Time Result, Unstored
= Case( Status = "Option 1", "5:00",
Status = "Option 2", "3:20",
Status = "Option 3", "1:15",
...)

Obviously the "Option X" fields need to be replaced by the items from
your drop-down list (EXACTLY the same) and the times are whatever the
appropriate value Procedure should have for that option.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Warren Grand wrote:
I would use the Evaluate function for this. I am assuming you would like
the actual time the STATUS field was modified.

Make your PROCEDURE Time a calculation field using the following formula:

Evaluate ( "Get ( CurrentTime )"; STATUS )

& "¶" & PROCEDURE Time

Text result

This would give you a running account of every time the field was
modified, and look something like this:

12:39:45 AM
12:39:19 AM
12:32:59 AM

If you wanted, with some concatenation and the Quote function you could
further enhance the results, showing the date and who modified the data.

Michael Myett