How to remove blank comments on Append Changes to Existing Text

Monday, January 24, 2011

I have one project that requires time stamp and name to be recorded on a multiple type of text type field whenever a user saves a comment. I tried using "Append Changes to Existing Text", be sure to turn on versioning or sharepoint won't allow you that option. The problem here is a user can save an item/task without putting a comment in the field and sharepoint will still put stamp on it with a blank comment! (fig.1)


fig 1. blank comments appear
  Now there is a solution I discovered to remove this blank comment. Just go to 

YourList -> Settings -> List Settings -> Comments (your field that you want to remove the blank comment)

Then after that choose "Plain text" under "Specify the type of text to allow"(fig.2)




fig.2
Just a note, any font, colors, formatting will be removed. And after that save the changes and view the item. (fig. 3)



fig. 3
And viola! the blank comment is gone =) Now who says "Shit happens"? Shit should be flushed.

Do you want to change the time zone / time stamp in the comment? continue HERE
3 Comments
Disqus
Fb Comments
Comments :

3 comments:

  1. I want the previously left blank column fields to be exported to excel with the latest comments even when users leave it blank.
    For example if a user leaves the multi line text blank and fills all other fields, I would want to retain the previous version comment which is not blank.
    Please let me know if this is possible.

    ReplyDelete
    Replies
    1. I think this might help:

      https://social.technet.microsoft.com/Forums/sharepoint/en-US/68150012-f7a9-4397-892d-25c2a60c2c8c/export-multiline-text-column-in-sharepoint-custom-list-to-excel?forum=sharepointgeneralprevious

      Delete
  2. You are the man! This was really bugging me. Sorted!

    ReplyDelete