I want to automatically save today's date in a sparate field if my user clicks the appropriate checkbox (and reset it if the checkbox is cleared).

How do I do that in an older version of FMP?

Thanks

Jammer

Do a search for [color:blue]+Field +Modification or [color:blue]+Audit +File and you will find several Topics about this. There is an example file the Sample File Topic, and if you go to www.databasepros.com >> Resources >> and search for Field Modification or http://www.nightwing.com.au/FileMaker/demos.html and look for Audit.

Lee

I'm not particularly seeing this as an audit question, but rather you want to know the date when the checkbox was selected but have the date blank when the checkbox is blanked again.

You might try this: Create a calculation (result is date) with:

[color:blue]Case ( not IsEmpty ( checkbox ) , Status ( CurrentDate ) , DateToText ( "" ) )

Since the calculation will be indexable (leave unchecked the Storage Option 'Do not Store calculation results'), it won't update with the current date each day. It will only change when the checkbox has been changed.

It will blank the date when the checkbox is cleared but always insert the current date when the checkbox is checked.

LaRetta

Lovely,

Thank you for the that little snippet of code. It's been quite awhile since I've used FileMaker and I've lost some proficiency with it.

Jammer

Thanks

The Mad Jammer

Edited August 21, 200718 yr by Guest