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 |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |