Considered we have a use case where the product technology doesn't allow edits of the same record at the same time (for example different users might be want to editing different parts of a customer record - credit rating, address, email, whatever).
Who should that be conveyed to editors of the records? The row could be locked in the database, but what should the user see and be told?
I was considering a red error icon on the table row in the UI with a tip or legend saying record in use. I would say prevention of the editing action is the safest way to go here, but what should the user be told about when the record is updated and enabled for editing again? "Record is being edited by another user. Try again later"?
But in how long...?..:) Maybe a contextual action on the record being edited, showing who has it in use and a dialog box option with instant message, email or click to dial to ask?
Another option might be to enable the attempting editing user to save a draft of their edits and then merge them back to the record when the row is unlocked for editing. Again a message that changes are saved, and changes can be reviewed before merging (and which changes) would be needed I guess.
Anyone got best practices, or examples they can share? Trying to eliminate any dirty data or duplicate record cleanup later.