So we're in the process of becoming SOX compliant. That means building audit trails for yours truly. While I have a number of things already being logged, I've run into a snag.
I currently have a number of common searches performed via scripts, but users still have the option to search directly from fields on the layouts. It's these freeform searches I need to log, but with 70+ fields in that table I only want to capture the field names they access and what is queried.
My first though was to set up a calculation field:
Calc_Field = Case(Field1 or Field2 or Field3...; Get(ActiveFieldName) & " | " & Get(ActiveFieldContents) &"¶"& Calc_Field)
Unfortunately, I never though about it not evaluating while in find mode. Ideally I'd like to be able to store that information directly in a related table instead of having to parse it out after the fact.