display data another table

[SyDyJo]

hello, 

I'm having trouble manipulating data in appsheet.

I have three tables : 

• activities
• participations
• members

In members table i have member type column which can have parent or chill value

I want to display type of member in view activity

exemple : for the activity 1 i have 3 parents and 6 children

[TeeSee1]

Assuming the Participants is a child table of the Activities, Participants have a ref to the Members, then create a VC in Activities with an expression like

"Parents: " & 
COUNT(
 FILTER(
  "members",
  AND(
   IN(
    [id col],
    SELECT(participants[member], IN([id col],[_THISROW].[Related participantss]))
   ),
   [type]="parent"
  )
 )
) & " " &
"Children: " &
COUNT(
 FILTER(
  "members",
  AND(
   IN(
    [id col],
    SELECT(participants[member], IN([id col],[_THISROW].[Related participantss]))
   ),
   [type]="child"
  )
 )
)

Just as an option if you have a VC in the Participants as [member].[type], then the above expression can be simplified.