Conditionnal value

AppSheet AppSheet Q&A
1

Hi !

I want to set the value “OUI” of a second question if the response of the first question is “OUI” but I want the user can choose between “OUI” or “NON” is the response of the first question is “NON”

Could you please help me ?

Many thanks :slightly_smiling_face:

OlivierCmar_0-1726755607340.png
OlivierCmar_0-1726755607340.png544×403 11.5 KB

2

In the Initial Value of the second question use an expression like…

IF([First Question] = "OUI",
   "OUI",
   [_THIS]
)

The qualifier [_THIS] simply leaves the column in the state it was in before. If it is blank, it will be blank after.

NOTE: If [Second Question] is ever set by the user FIRST, then its Initial Value expression will NOT execute any longer and will NOT respond to [First Question] being adjusted afterwards. So, it may be important to “guide” the user by hiding the second question until the first question is answered.

1 Like
3

Thank you for your help, but this doesnt work

4

Initial value:

IF(
  ("Oui" = [Previous question]),
  "Oui"
  ""
)

Valid if:

IF(
  ("Oui" = [Previous question]),
  {"Oui"},
  {"Non", "Oui"}
)