Can someone help me out please. 

 

I am looking for an automatic way to mark newly created records and records that have had any modifications made.

 

My plan was to write a script that would check a check box and then attached that script to the records fields with a script trigger so that if a field was changed the check box would be checked. I was unable to get a script to check a check box.

 

Is there a simple way to do this? How would I mark newly created records? 

 

Thanks

 

 

 

 

A timestamp field that auto-enters the creation timestamp and another that auto-enters the modification timestamp is all you need.

The easiest way is to display Raybaudi's two suggested fields.

 

If you're married to the checkbox schema

 

Modified checkbox:

 

After creating the two timestamp fields, create a calculation field isModified = (ModTSfield ≠ CreationTSfield).  Create a value list with only the value 1 and call it isTrue.   Format your calculation field as a checkbox set using values from isTrue.

 

For new records, it depends on the definition of "new".  Created today? Created in the last n days? Created since noon?