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?
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]))
Try combining your formula with NOT(ISBLANK([SBLOCK]))
thank you it works perfectly
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |