How to show in a report if a comment is the first comment in a thread | Community
Skip to main content
New Participant
August 5, 2024
Solved

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

  • August 5, 2024
  • 1 reply
  • 743 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

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.

1 reply

skyehansen
skyehansenAccepted solution
New Participant
August 5, 2024

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.

New Participant
August 5, 2024

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