Counting the number of rows in another table (COUNTIF)

Queries and Resources
1

Hello there

I have twk tables (TASKS, and COMMENTS)

They share a key (which is ID).

I want to have a custom column counting the number of comments for every task row.

For now I only manage to count all rows from COMMENTS, i miss the IF ID.

Is that doable ?

Thanks

Capture d’écran 2022-07-30 à 03.04.13
Capture d’écran 2022-07-30 à 03.04.131644×390 48.8 KB

2

Hey @webloomers!

If you'd like to add a filter you can try something like {{ comments.data.filter(row => row.id === currentRow.id).length }}. The currentRow value will automatically be interpolated with the data of whatever row it's being interpreted in, that'll let you compare its id value to the ones in the comments table.

Can you let me know if that works?

3

Thanks it works like a charm !