How to show in a report if a comment is the first comment in a thread

[Seth-Patrick]

Hi All,

Trying to determine if there's a way within a note report or a proof report to see if a comment added to a document/proof is the first comment in the thread?  Looking to generate a column with this note report that shows if the comment listed is the first comment of thread. Ideally the column would be called "First Comment" and it would display either Yes or No in the row.

[skyehansen · Accepted solution]

I think probably the field that would show this would be the parent note ID. If this field is blank, then there is no parent (so it's the first comment). Probably the simplest thing for you to do would be to add it as a column and then use the column rules functionality to add additional formatting so that if that field isn't blank, you can add a little icon like red vs green dots or flags.

[Seth-Patrick]

Thanks Skye!  this is exactly what I was looking for.