Need help with slices please

AL_Shaikh_Real_ · 04-30-2021 11:20 AM

Table: Users

User_name	User_email
Oliver	Oliver1111@gmail.com
Khalid	Khalid2341@gmail.com
Yaom	Yaom2211@gmail.com

Table: S_Req

Req_id	First_user_name	Entery_Date	Offer_Status	Last_user_name	End_date
3d3464fe	Oliver	12-4-2021	available
75920828	Yaom	15-4-2021	In negotiation	Khalid	19-4-2021

Req_id UNIQUEID()

First_user_name SELECT( Users[User_name],([User_email] = useremail() ))

Entery_Date Today()

Offer_Status ENUM

Last_user_name ifs([Offer_Status]=" In negotiation",SELECT(Users[User_name],([User_email] = useremail() )))

End_date Today()

I need to have condition in the (Slices Source Table (S_Req)) to show only if

[Offer_Status] = “In negotiation”
Email of [Last_user_name] = useremail() ??? I need it to chick the email from the table Users because I’m having name in the field [Last Username] not an Email

AL_Shaikh_Real_

Can someone give a solution

khuslid

The slice should have:
AND(
[Offer_Status] = “In negotiation”,
[Last_user_name] = useremail()
)
If you need an email adress to click on that is not in your table, you can create a Viritual Column and REF to the table where the email adress is.
[Last_user_name].[Email]
Rememember to set it as type “Email”

AL_Shaikh_Real_

Thanks for your response

But I don’t think your solution works coz
The Field [Last_user_name] has name not email

Thast way I’m trying to use the table: users

khuslid

A bit hard to understand what you have and what you want, but you need a REF between your tables (I asume NAME is the column to REF) to connect the Email address to the table that doesn’t have this Email-column.

Aleksi

How about…

AND(
[Offer_Status] = “In negotiation”,
[Last_user_name] = LOOKUP(USEREMAIL(),“Users”,“Email”,“Last_User_Name”)
)

AL_Shaikh_Real_

Thanks Aleksi

I will test the code and hope it works

AL_Shaikh_Real_

Thanks Man

It’s working

you saved me