I need the text in any of a certain set of fields to appear red if the field has been modified after a given date. Every two weeks or so, the formatting is wiped and all text returns to normal, and the tracking begins anew.

Currently, I've accomplished this (in FM8) using an audit trail that tracks which fields have been changed. Each field has a corresponding calculation field, and if the name of the field is found in the audit trail, this display field changes color. This works perfectly, but now that we've finally upgraded to FM11, I'd love to know if there's a better way to do this without hard coding the field names and/or needing to have the slew of corresponding fields.

Is there a way to reference the name of a field in a conditional formatting calculation without having to hard code it? Or, is there some other way to go about this that I'm overlooking? Thanks!

Is there a way to reference the name of a field in a conditional formatting calculation without having to hard code it?

GetFieldName ( Self ) will return the fully qualified name of the field.

You could also use script triggers.