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.
thank you in advance.