I have an audit log that automatically records every change made to certain fields. Because some of the changes may be quite subtle, I have a field that tells us what field(s) changed, rather than trying to search in the report to see what generated the log entry.
Right now that is this formula:
List("\n"
If( [Old Name]=[New Name], "" , "Project Name"),
If( [Old Type]=[New Type], "", "Project Type"),
...)
The underlined parts are the names of the fields that have changed, but they're obviously hardcoded text. There are 11 of these, and for corporate stupidity that is not worth getting into, the names of the fields change with far too much frequency.
So is there a way to get the field name from the field ID? Basically, I'd love if we could use the new getfieldproperty formula. I'd envision it like this:
GetFieldProperty(6, "Field Label")
Otherwise, it is another step for something I need to edit each time we get a new exec who decides that "Project Type" should really be called "Project Category" and that it is a critical priority to get it changed over.
------------------------------
mtn mtn
------------------------------