Hello, I want to use “@Name([CN];@Subset($UpdatedBy;-1))” to track who modify the document in one old database (the documents saved already), when I check the $UpdatedBy field, it shows the “Dom_Designer/CASOT” name instead of person’e name. I want to know the person’s name.
but, I used the same formula in another database, it works fine.
If this name is the last in $UpdatedBy, then the last modification has been carried out on behalf of that name. It usually means, that the document was modified by an agent that runs on behalf of that group. If so, there’s not much you can do about it.
No, $UpdatedBy is your only save bet. You could add your own form logic, but that would not track changes made through the backend.
Even if there is no agent in this database, it could still be that an agent which resides in any other db (like some admin tool?) is modifying documents.
Linda, even after your second posting it’s not clear to me, what your problem is.
Let’s repeat: $UpdatedBy did track all changes that have been made to the documents yet, unless the field has been truncated in the past (see database properties, last tab). Any past editor, who is not or no longer in $UpdatedBy, is lost. No way to recover this information.
From now on, everyone making a change to any document will be tracked (again, unless there is a limit set in database properties). So, if you just want to capture future changes, all you have to do is wait for the changes to occur.
Hi Harkpabst, Thank you so much for your patient and sorry for confusing you.
We have a telephone list database to keep each person’s information, such as telephone #, department,…it was created many years ago, recently, we found some of the documents modified, but don’t know who did. So my boss asked me to track the database finding who changed the document.
First of all, I was thinking using $UpdatedBy, when I tested it, I found $UpdatedBy field in all the documents is same with “Dom_designer”, so $UpdatedBy doesn’t work in this case.
Now I am trying to look for some way tracking (knowing) who is the last person edit the document.
O.K., so the main focus is not to see, who technically last saved a note, but who made changes to the document.
What you can do relatively easy (I say relatively, because I always found it to be fiddly) is to track a history of people who saved the document. With some clever logic, you can avoid double entries for the same person saving the document more than once a day and so on.
But as soon as you want to know if and what was actually changed, things get more complicated. Instead of coding something yourself, have a look at Chad Schelfhout’s OpenNTF project called Open Audit. I haven’t used it myself yet, but apparently it can do what you want and much more.