I have a this situation
Column 1 is Enum Type
Column 2 is email type
(Column 1 Enum Values)
A
B
C
D
If ( C ) is selected Then I need Column 2 to be filed automatically with Useremail()
I would use the below:
IF ( [Column 1] = โCโ , USEREMAIL() , " " )
i got this error
Column Name โColumn 2โ in Schema โS_Req_Schemaโ of Column Type โEmailโ has an invalid data validation constraint โ=ifs( [Column 1]=โCโ, USERNAME() )โ.
Remove the โSโ from IFS, and provide the Else condition.
This:
ifs( [Column 1]=โCโ, USERNAME() )
is perfectly suitable.
is there a way to assign that usename() in other table [column]
Yes.
the other table name (S_Req_close) the column is [use_name]
Can you show how to do it
Or give example
Please describe what you want to do in a little more detail.
I hope the following figure illustrates the idea
Set the Initial value expression for the First User email column of the S_Req_close table to:
[Req No].[First User email]
See also:
I did not know this was possible , for some reason I though IFS always required multiple conditions!
If I had knew this, I would have saved lots of time in different occasions. Well, I have learnt something new today!
Put this expression in the columnโs Initial value rather than in Valid If.
The expression works only in (App formula)
and it works fine
ูAlso i need the Condition to work in (add and edit)
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 on table (S_Req) to show only if
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |