hi guys,
im new in appsheet and i need some help on how to filter my SELECT result… i have this expression to check which members are under that Group
SELECT(Members[_ComputedName], ([Group ID] = [_THISROW].[GID]))
currently this populate 2 records for that specific group id. What im trying to achieve is to auto populate the value on the Group Servant field.
So i need to add a filter so that it will only display record from Members[Locale Designation] = “Group Servant” so that it will only give me 1 result but im not sure how can i integrate that condition in my SELECT expression… or maybe i need to use other expression… please help.
Here’s a screenshot of my sheet
Members : https://www.screencast.com/t/6K1EUjEse
Groups: https://www.screencast.com/t/WhzyqgNoI
thank you in advance.
God bless!
Solved! Go to Solution.
hi Steve,
I already solved my issue… so i just want to post it here might be helpful to others:
INDEX(
FILTER("Members",
AND(
ISNOTBLANK([Locale Designation]),
([Locale Designation] = "Group Servant"),
[Group ID] = [_THISROW].[GID]
)
),
1
)
thank you so much!
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |