Interesting challenge! I never considered that, since text functions work on just the plain text, this could be an issue.
If you're looking for modified fields, though, could you use a modification timestamp?
If you don't want to check modifications to the whole record, but only to particular fields, you could define a timestamp with the auto-entry:
"Get ( CurrentHostTimestamp ) "
; [ monitorField1 ; monitorField2... ]
This would trigger only when one of your "monitorFields" got updated.
Caveat 1 is that if a script changes one of the fields, the auto-entry won't trigger, so your script would have to update the timestamp, as well.
Caveat 2 is that the timestamp will update if a user "modifies" the field, but sets it back to the original value. I'd imagine that erring on the side of too much updating is preferable to too little, though.
Could this help?
Meanwhile, I'm curious if anyone else knows how to catch the difference between text strings where the only difference is formatting.
Thanks Chris. Yes I've done lots of change log stuff. The problem in particular here is that I have people modifying both the hosted solution and a copy on several iPads and some people on Excel (the real problem). Edits are getting done in multiple places at one time and then merged all back together. Since I can't get a field by field timestamp on the excel changes it's really throwing a wrench in things.
What about comparing GetAsCSS ( Text )? This will have all formatting in it.
Just a thought.
That's why I love the discussion group. Rock on Jason, you've done skinned the cat.
Man I tried so many things this afternoon, knew that had to be some way to leverage something somewhere.