If edit expression

If I have table X with a column “X1” which equal to USEREMAIL()

and I have Table Y with a column Y1

and I have Table Z with a column Z1

I need to make expression as if edit … in column Z1 where it allows edit if the value of X1 is equal to a value of the listed emails in Y1

0 6 174
  • UX
6 REPLIES 6

Maybe

IN( USEREMAIL() , Y[Y1] )

Perfect it working…

Now if in table Y I have column Y2 which have items A, B, C

ie Y1 are emails each one has value in Y2 different

so that the condition is the user name from Y1 and has a value say A

My understanding it will be AND expression

AND((IN( USEREMAIL() , Y[Y1] ),Y[Y2]=“A”)

I am receiving a message Cannot compare List with Text in (Y[Y2] = “A”)

Please advise, may it require this row …

I can’t understand what you’re trying to achieve with your description. Perhaps providing real data examples will help.

Know that any expression of Table[Column] (such as Y[Y2]) is going to return a list of all Column contents in the entire table. As Hugo suggested, you’ll possibly need to use SELECT().

To make it clear

3X_0_4_042d0b964d7c2bf5922bec7359e9fbf79e0375a2.png

I need to write an expression which to allow if the USEREMAIL is one of the listed emails in table Y,

Column Y1, and is matching with say item “C” in column Y2, this edit shall be allowed

The expression is to be written for edit if for column in table X

Try:

LOOKUP( USEREMAIL() , “Y” , “Y1” , “Y2” ) = “C”

Hugo_Serrano
Participant II

try use IF() and SELECT() functions for filter data

Top Labels in this Space