Jump to content

Automatically save the Date


This topic is 6141 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 weeks later...

This topic is 6141 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.