Automatically save the Date

[The Mad Jammer]

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

[Lee Smith]

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

[LaRetta]

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

[The Mad Jammer]

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

[The Mad Jammer]

Thanks

The Mad Jammer

Edited August 21, 2007 by Guest