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

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?

0 5 486
5 REPLIES 5

Use AND link AND(CONTAINS (โ€ฆ),NOT(CONTAINS(โ€ฆ)))

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

Then

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

Yilmaz_Kandis
Participant III

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

@Sdfaheemuddin

thank you it works perfectly

Top Labels in this Space