Hello all. I need help to write a script (I think a script is what I need) that enters a timestamp in a field and also records the user name when a specific field is modified.

I have 3 fields: (1)"Status_Choice" - where manager chooses either "approved" or "denied" by a radio button; (2) "Status_Date" - is a timestamp of when the "Status_Choice" field is modified; (3) "Status_User" - captures the name of the user when "Status_Choice" is modified. I want fields 2 & 3 to update ONLY when field 1 is modified (when a choice is made), not if any other field on the layout/record is modified.

Thank you in advance for any help B)

Hi Robin! Welcome to FM Forums!!

Attach an auto-enter calculation to your Status_Date with:

Case ( Status_Choice ; Get ( [color:red]CurrentTimeStamp ) ; Get [color:red]( CurrentTimeStamp ) )

... be sure you also do this: in the auto-enter tab below 'by calculation; you UNCHECK uncheck 'Do not Replace Existing Value...'. Also uncheck in calc box at bottom 'do not evaluate if all referenced fields are empty.'

The same would be for the Status_User field:

Case ( Status_Choice ; Get ( AccountName ) ; Get ( AccountName ) )

UPDATE: I originally had Get ( CurrentDate ) until I realized a timestamp was desired instead of date ...

LaRetta

Edited May 23, 200817 yr by Guest

Hi LaRetta!

Thank you so much for all the help! It worked beautifully and did exactly what I was looking for it to do.

Thank you again for the help. B)