I would like to display history comments within an email event body, showcasing the history of all comments made by all users.
I created a smart object with properties ID(auto), Number(int) Date(date), User(string) and Comments(memo). I created a Create and GetList method accordingly.
In InfoPath I show two things, one multiline textbox for the current comment, and one repeating table for the history (accumulative) comments. I bind the GetList method to the repeating table and call the Create method on the submit of the form. This works like a charm, no problems.
When displaying this in the body of an email event, the text is not nicely structured below each other, i.e. I want to display it as is from the database (SO).
Each comment should be on a new line, showing the Date, User and Comments fields. I would like to do this in html formatting, because I also include
a link directly to the worklist url, thanks to maxpirate's help :-)
Can anyone shed some light?