Display modified by in record view

Do you mean record's author/owner? Or any user who is allowed to edit the record?

I mean display the user name who last modified the record. (It's different from the author.)

danielbidala user name who last modified the record. (It's different from the author.)

I guess, this information is not stored with the record data.

AFAIK, you would have to enable Audit Log feature in your type. You may add only necessary event notifications i.e. "edit". Then you have to add a respective SQL query into your custom template. Quick and dirty logic:

• get user_id from
• table "js res audit log"
• where record_id = current record ID
• where event type is "2" (it is the edit event, I believe)
• order by ctime DESC (to get the latest event)
• limit to 1

Then...

• if no result, take Author name or display any other notice.

• if result, fetch user name with user_id from query. (with help of Cobalt CommunityHelper)

pepperstreet

danielbidala user name who last modified the record. (It's different from the author.)

I guess, this information is not stored with the record data.

@Sergey

Maybe this "editor" info could be part of the record table? I have seen there are also similar columns for "who repost", "reposted by". Or should it stay with Audit Log?

pepperstreet Or should it stay with Audit Log?

It i possible to add column for last editor to records table. May be even good, so you do тещ need to do any additional queries. But change is not for now.