I’m using a security filter so these records are only shown to the staff member who submitted the record - OR(IN(USEREMAIL(), Managers[Email]), USEREMAIL() = [User Email])
I’d also like to hide from this view all records with a Status of “CLOSED”.
Do I need to use the security filter for this, too, or is it done somewhere else?
Use slices
https://help.appsheet.com/data/slices/slices-the-essentials Slices: The Essentials help.appsheet.com
Thanks @Sdfaheemuddin. Could you help me with the row condition field? The Status column has 4 options - STARTED, RECEIVED, CLOSED, and FOLLOW UP. I only want to hide columns marked as CLOSED.
Thanks again! (fyi your comment was flagged as spam for some reason)
It’s weird
If you already using security filter, you could do this extra filtering as well and no slice is needed. AND(OR(IN(USEREMAIL(), Managers[Email]), USEREMAIL() = [User Email]),NOT([STATUS]=“Closed”))
Thanks @Aleksi_Alkio. I thought something like this might be possible but since I already used the slice and it’s working I’m going to leave it as is. I’ll keep this in mind for future projects though!
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |