Highlighting a cell (or row) when a comment has been left on it

Hi @abbieolson,

Not sure if you've figured out something already.

As you saw from this post I'm doing something similar to what you want to achieve, i.e. adding a small indicator with the number of comments available for that given row.

Here's my setup.

  1. I have a table in my database for comments. I store information as user who submitted the comment, which app, info about the object, etc. The important thing is that in your db your saving whatever Id you will use to then map it to your row.
  2. I use the comment thread event triggers to insert a new record
  3. I have a query to pull all records from this tble that runs both on page load and upon a new record being inserted from the comment thread
  4. Within the column where I want the icon to appear, I added a status indicator: see below example where getComments.data is the query mentioned in the number above

Hope this helps!