I'm using a security filter so these records ...

(Preston Moore) #1

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?

(Syed Faheemuddin) #2

Use slices

https://help.appsheet.com/data/slices/slices-the-essentials Slices: The Essentials help.appsheet.com

(Preston Moore) #3

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.

(Preston Moore) #4

Thanks again! (fyi your comment was flagged as spam for some reason)

(Syed Faheemuddin) #5

It’s weird

(Aleksi Alkio) #6

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”))

(Preston Moore) #7

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!