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

[abbieolson]

I'm really trying to figure out how to highlight a cell when a comment is left on a table with a Comment Thread. So far, I have this code chunk in my comment block's Thread ID. It allows me to make comments, but I'm not figuring out how to actually highlight a cell so I can quickly glance over a table and know when someone leaves a comment. There is very little guidance on how to manipulate the Comment Thread option since it's so new. Any guidance would be so so appreciated. Thank you!

{{ `${tableCompanyInfo.selectedRow.uuid}_${tableCompanyInfo.selectedCell.columnName}` }}

For example, I've left a comment on this cell and I want to do something to make it obvious that there's a comment on it (ie highlight it, frame it).

[MiguelOrtiz]

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!

[abbieolson]

Hey, @MiguelOrtiz! This is awesome, thank you! I still haven't resolved the issue. Are you willing to share a working example of this with me?

[abbieolson]

I also connected with @Darren about this topic.

Selecting Cells (for Comment Thread)

Ah I think that might be a bit challenging for a few different reasons. To start, the table component provides various utilities for selecting and styling individual rows, but doesn't do the the same for individual cells. I often recommend custom CSS as a workaround for certain styling issues, but there isn't an easy way to write the necessary selector rules. The other challenge is twofold - "pushing" notifications out to end users and then keeping track of which users have seen those new comm…

[MiguelOrtiz]

Hi @abbieolson,

I just made a Tutorial on this which you can find here:

Retool Tutorial: Adding a thread box in less than 10 mins! Discover Retool's CommentThread component

Hope this helps!

[abbieolson]

This is wonderful! Thank you, @MiguelOrtiz!