Contains useremail()

[Izzat_Safrah]

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])

[perissf]

Do you want to show only the related tasks with GMAIL = USEREMAIL()?

SELECT(Related TASKS WITHs[KEY], USEREMAIL() = [GMAIL])

[Izzat_Safrah]

Hi @perissf

[Related TASKS WITHs] names of Columns in table names TASKS , it will not work with this expression

SELECT(Related TASKS WITHs[KEY], USEREMAIL() = [GMAIL])

[perissf]

Ah ok sorry I didn’t read carefully the question. It’s a slice filter condition.
This should work:

IN(USEREMAIL(), [Related TASK WITHs][GMAIL])

CONTAINS() checks in a string, while IN() checks in a list.

help.appsheet.com

IN()

Is item in list?

[Izzat_Safrah]

@perissf

I can not see any Tasks registered in my e-mail If i use your expression

IN(USEREMAIL(), [Related TASK WITHs][GMAIL])

[perissf]

I see the same problem in my test case as well.
@MultiTech_Visions since you have been here for a long time, can you explain this?
I see the filtered records correctly under Slice > View Data, and also in Test of the Row Filter Condition. But in the View there are no data.

[MultiTech]

This might be of help as well

Current_User (Slice) - How to conform your app around WHO is using the app Tips & Tricks 💡

One of the core basic functions, included in just about EVERY app I make, is the ability for the app to know WHO is using the app. If the app knows who’s using it, then I can easily control many different aspects of the app: Add/edit/delete permissions How data should be filtered What views are shown What buttons, or Actions, are visible Which workflows should fire off Which columns should be shown or editable etc. Requirements To accomplish this functionality in your app, you need the follo…

[Izzat_Safrah]

@MultiTech_Visions

I can’t find what i’m looking about for my app in your link

[MultiTech]

You’re running into a rare and esoteric bug - but it’s not really a bug, it’s just a difference between how formulas are evaluated.

I tried to find the post from back in the Google+ days where Praveen was talking about this, but I couldn’t find it.

---

It deals with the fact that the Expression Assistant (and the whole “test my formula” thing) works using one formula evaluation engine…

• and the actual app uses a different one.

While they’re nearly identical, there are some very rare instances where things don’t match up… like what you’re finding here.

Ultimately the solution is to change the formula you’re using

• You need to find another way of accomplishing the same thing.

---

In your case:

I would try the following:

IN(UserEmail(), SPLIT(CONCATENATE([Related TASKS WITHs][GMAIL]), " , "))

Many times when you’re using a list dereference, you have to apply some “formatting” to it in order for the system to understand it.

• (I imagine at some point this will be ironed out, but for now it’s necessary to make list dereferences work in some instances.)

If that doesn’t work…

Then what I would do is take your list dereference and make it an actual column - then use that column in your formula instead.

[perissf]

You are a genius!
Nasty bug!!!
And very elegant solution!

[Izzat_Safrah · Accepted solution]

MultiTech_Visions:

Ultimately the solution is to change the formula you’re using

• You need to find another way of accomplishing the same thing.

I follow another way and work perfect, this my steps

1. I create Slices name TASK WITH by table TASKS WITH with this expression USEREMAIL()=[gmail]

2. From Data>Columns in my table TASKS i use in the virtual column [Related TASKS WITHs] this expression REF_ROWS("TASK WITH", "TASKS NO")

3. From Element type details / Referenced table name i use my Slice name TASK WITH (Slice)

[Steve]

Outstanding solution write-up!

[MultiTech]

Okay… Now that I’ve read everything a couple of times, I get it now.

You only want to create a slice of a table, where the child records of that table contain the email of whoever is using the app.

Final Answer

Inside your Tasks table, create a virtual column that list dereferences all the emails out of the [Related TASKS WITHs]

• This way you have an actual list of emails on each task level.
  • Name: [Included_Emails]
  • Formula: [Related TASKS WITHs][GMAIL]
  • This should produce a list of emails

Then use that column inside your slice formula:

IN(USEREMAIL(), [Included_Emails])

[Izzat_Safrah]

@MultiTech_Visions
Really your a genius and im so happy for your help. i will try your idea now
@perissf Thank you for you help