Auto-enter date when field activity

[Maxwell Morlay]

I have a field (EDIT METHOD) with a value list. When I enter or change a value in EDIT METHOD, I want todays date to auto-enter in the field, EDIT METHOD DATE.

Your help is always a lifesaver! Maxwell Morlay

[slstrother]

From Filemaker Knowledgebase, Article # 101645 . It describes a method that uses a related file.

[slstrother]

I was thinking that there had to be a way to do this without using another file. Here is what I came up with.

Create the following fields:

Last Item = calculation = indexed = GetField("Edit Method")

Last Mod Date = calculation = indexed = GetField("Edit Method Date")

In your Edit Method Date field use the following calc:

If(Edit Method = Last Item, Last Mod Date, Status(CurrentDate))

This worked in the limited testing that I did. I am attaching a sample file if you want to take a look.

Hope this helps

[slstrother]

oops, forgot to attach the file, here it is

Field Mod.zip