Displaying Comment Count on Card View and Ordering by Two Dates

[exerlanda]

Hi everyone,

I'm building an AppSheet app with two data sources:

• Notes: note_id, note_title, note_text, note_date
• Comments: comment_id, note_id, comment_text, comment_date

Notes are displayed in a card view.

I'd like to show the number of comments on each card and order the notes by both note_date and comment_date. I'm having trouble finding a solution. Is this possible?

[Suvrutt_Gurjar · Accepted solution]

---

@exerlanda wrote:

I'd like to show the number of comments on each card

---

In the Notes table you would have a column called say [Related Notes] .

Please add another virtual column in the Notes table called say [Comments_Count] with an expression something like COUNT([Related Notes]) .  [Comments_Count]  will capture the number of comments for that note. Display that column in the Notes card view.

---

@exerlanda wrote:

order the notes by both note_date and comment_date. I'm having trouble finding a solution. Is this possible?

---

---

@exerlanda wrote:

both note_date and comment_date.

---

Please add a virtual column called say [Latest_Comment_Date] in the Notes table with an expression something like 

MAX([Related Comments][Comment_Date])

where [Comment_Date] is the date column in the comments table.

Please create two card views

1. "Notes by Note date" . Use [Notes_Date] in the Notes table to sort descending that card view.

2. "Notes by Comment date" . Use [Latest_Comment_Date] in the Notes table to sort descending that card view.