I am struggling with COUNT SELECT rows from another table

AppSheet AppSheet Q&A
1

I have a table/view CONTACTS
I am logging ISSUES tagged with Contact_ID against individual Contacts into my ISSUES table
I want to have a column [ISSUES] in my CONTACTS Table showing the numerical count of the ISSUES logged against each Contact

2

Hi @rjtroy

For future posts, please post in Q&A board, not Tips & Tricks :slightly_smiling_face:

  1. in ISSUES, set the column Contact_ID with type Ref, source table CONTACT

  2. you will see automatically the count of issues logged against each contact on the Contact detail view.

If you wish to see the count directly, you can add a virtual column and use this expression:

COUNT([Related ISSUES])

For reference:

Use virtual columns - AppSheet Help

3

Hello rjtroy,

If the column “Contact_Id” is a reference to the table “CONTACTS” in the table “ISSUES”, there should be a virtual column named “related ISSUESs” in the table CONTACTS.

So the formula for your new column will be

COUNT([related ISSUESs])

or

COUNT(FILTER("ISSUES",[Contact_Id]=[_thisrow]))

or

COUNT(SELECT(ISSUES[id],[Contact_Id]=[_thisrow]))
1 Like
4

Thank you, Aurelin,
This was my first HELP request - I have noted your comment for the future.
I will play with your suggestions and can I please come back to you for more guidance.
rjtroy

1 Like