CONTAINS([RAMPA],LOOKUP(USEREMAIL(),RAMPE,EMA...

security
(francesco cannone) #1

CONTAINS([RAMPA],LOOKUP(USEREMAIL(),RAMPE,EMAIL,UTENTI))

hi I use this formula as a security filter in a table called CENTRAGGIO what I would like to do is that when a data is inserted in the SBLOCK column The user no longer has access to the data. can you implement the formula?

(Syed Faheemuddin) #2

Use AND link AND(CONTAINS (…),NOT(CONTAINS(…)))

(francesco cannone) #3

I did not specify that the data that I insert in the SBLOCK column is time value therefore always different. I would like the formula to work when the SBLOCk column is populated

(Syed Faheemuddin) #4

Then

AND(CONTAINS([RAMPA],LOOKUP(USEREMAIL(),RAMPE,EMAIL,UTENTI)), ISBLANK([SBLOCK]))

(Yılmaz Kandiş) #5

Try combining your formula with NOT(ISBLANK([SBLOCK]))

(francesco cannone) #6

@Sdfaheemuddin

thank you it works perfectly