LinkedIn
Twitter
My expression is not working withe
USEREMAIL()
I have two tables:
First Table ( TASKS )
| NO | TASKS |
| 1 | Contact With AppSheet to Solve user's problem |
| 2 | Computer hardware request |
Second Table ( TASKS WITH )
| TASKS NO | ID | GMAIL |
| 2 | JOY | USER1@GMAIL.COM |
| 2 | IZZAT | USER2@GMAIL.COM |
| 2 | MOHMMAD | USER3@GMAIL.COM |
___________________________________________________________
In the slides, I used the following expression inside the row filter condition for the table (tasks), This is to show only the special tasks of the program user by e-mail
CONTAINS(USEREMAIL(),[Related TASKS WITHs][GMAIL])
Solved
1 ACCEPTED SOLUTION
I follow another way and work perfect, this my steps
- I create Slices name TASK WITH by table TASKS WITH with this expression
USEREMAIL()=[gmail]
- From Data>Columns in my table TASKS i use in the virtual column [Related TASKS WITHs] this expression
REF_ROWS("TASK WITH", "TASKS NO")
- From Element type details / Referenced table name i use my Slice name TASK WITH (Slice)
