Discussion Database - Change Doc Owner?

I’ve been looking in Help, Forums, OpenNTF, Sandbox and IBM Support for help on a way to change the author, appended to a new Main Topic, in a Discussion database. For example: “04/21/2007 Policy Review (author’s name).”

Is there a way to change this? We use a Discussion DB for tracking progress on projects, assignments, upgrades, etc. Works great for us, and is just what we want, in that updates are signed and dated in response docs that show the steps taken. But sometimes the owner of the assignment changes, and in order to view the documents “By Author” we would need to change the author’s name on the Main Topic doc.

None of us are big scripters, so if anyone has an idea for a simple agent that would take care of this, it would be most helpful.

XP workstations, running 6.5.4, 6.5.5 clients. Standard Discussion DB template in use.

Thanks in advance.

Subject: Discussion Database - Change Doc Owner?

If you are using a standard LOtus Notes discussion database, it uses the field called “From” on the MainTopic Form , to store creator / author’s name …You can change the value of this field by using a simple formula agent … the code should be

x:= @Prompt([OkCancelEdit]; “New Author”; “Supply username you want to chane to, in abbreviated or canonical form”; “”);

Field From := @Name([Abbreviate]; x)

Agent Trigger : On Event - Action Menu selection

Target : Selected document

You may want to use

Subject: RE: Discussion Database - Change Doc Owner?

Brilliant! Vinit, that’s exactly what I needed. It works perfectly. Thank you so much for your help.

Subject: RE: Discussion Database - Change Doc Owner?

Thank you so much for your response. I will give this a try.