Can someone help

[AL_Shaikh_Real_]

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

[Alejandra_Petro]

I would use the below:

IF ( [Column 1] = “C” , USEREMAIL() , " " )

[AL_Shaikh_Real_]

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() )’.

[Alejandra_Petro]

Remove the “S” from IFS, and provide the Else condition.

help.appsheet.com

IF()

Either/or conditional evaluation

Yes/No Expressions | AppSheet Help Center.

[Steve]

This:

ifs( [Column 1]=“C”, USERNAME() )

is perfectly suitable.

[AL_Shaikh_Real_]

is there a way to assign that usename() in other table [column]

[Steve]

Yes.

[AL_Shaikh_Real_]

the other table name (S_Req_close) the column is [use_name]

[Callkhalid]

Can you show how to do it

Or give example

[Steve]

Please describe what you want to do in a little more detail.

[AL_Shaikh_Real_]

I hope the following figure illustrates the idea

[Steve]

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:

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

[Alejandra_Petro]

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!

[Steve]

Put this expression in the column’s Initial value rather than in Valid If.

[AL_Shaikh_Real_]

The expression works only in (App formula)

and it works fine

[AL_Shaikh_Real_]

ِAlso i need the Condition to work in (add and edit)

[AL_Shaikh_Real_]

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

• [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