Time/Date Stamps for field changes

[lolitafontaine]

I know how to create a time/date stamp field which will track changes to a record, but how about a way to track changes to a field? I have a list of "tasks" that need to be accomplished for each person who has a record. Each task is formatted as a simple "yes" only checkbox, and I'd like a stamp to record when that "yes" was checked off. However, sometimes tasks need to be done again (committee chair dies, so a new one needs to be appointed -- happens all the time), so I need the stamp to go blank if the "yes" is unchecked, and then record the new time/date when the task is checked off again. Any ideas?

Thanks! Lisa

[LaRetta]

Hi Lisa,

Create a timestamp field and use Auto-Enter calculation. Leave CHECKED 'Do Not Replace Existing Value for Field (if any). Calculation (let's call it TS1 ) would be:

Case ( checkBoxField1 = "Yes" ; Get ( CurrentTimeStamp ) )

If the Yes is unchecked, the value will blank out but will insert the current timestamp when the field is clicked to yes.

But I question whether this is the best approach. It might be important to track the date as each assignment is made and completed. If you use this method, you will lose any 'trail' of the prior dates. I just thought I'd point that out ... it may not be important. But these kinds of things can bite you later when Management askes the date of the PRIOR yes. It seems that having a table - so each assignment can be tracked (and final date inserted which would CLOSE that assignment) might work better for you.

LaRetta

[mr_vodka]

Hi Laretta. I had originally posted the same kind of solution but then saw she was on FM6 so I axed my post. lol.

Anyway, here is a link to an older solution from Ray that she can tweak.

Older solution

[LaRetta]

Ooooops. :

Dang! I usually look for version too!

[comment]

How about something simple?

simple.fp3.zip

[LaRetta]

Ya gotta love those webdings. Nice and simple indeed. :smirk:

[Lee Smith]

committee chair dies, so a new one needs to be appointed -- happens all the time) Lisa

I will not seek, nor will I run if nominated.

Lee

[lolitafontaine]

Well thanks so much, folks! This has been INCREDIBLY helpful.

[lolitafontaine]

Hey! I'm working with your ("Comment's") simple solution, and think I've figured it out, except how did you get the webding to display only that little checkmark? Other than that bit, this is perfect!

Thanks again! Lisa

Edited January 12, 2007 by Guest

[mr_vodka]

Right Click on the field and go to 'Date Format'. Comment has it setup to format it as 'a' which is the equivalent of the checkmark in the Webdings