SyDyJo
February 13, 2023, 10:20am
1
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
February 13, 2023, 12:34pm
2
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.
1 Like