Combine List and Yes / No type into Valid_if

Hi, I have a dropdown list where I filtered the values with a formula in valid_if.
Example: Enum{A,B,C,D,E,F}
IF ([1.] = “Xy”; {A, B, C, D}; if ([2.] = “Zk”; {A,B,E,F}; {B, C, D,E,F}))

However, if [2.] is false I would not want to remove the value A from the list, but I would like it to give an error message when it is selected, because if A did not appear, the user would not understand what was wrong.

Example:
IF ([1.] = “Xy”; {A, B, C, D}; if ([2.] = “Zk”; {A, B, C, E, F}; IF ([_ this] = “A”; error; it’s ok)))

  • IF ([_ this] = “A”; error; it’s ok) * I know this doesn’t make sense, but it’s to explain what I want

But Appsheet doesn’t allow me to create IF formulas with different types, like List and Yes / no.
How can I do?

Solved Solved
0 2 265
1 ACCEPTED SOLUTION

You can move your List-returning expression from valid_if to Suggested Values. Then enter your Y/N expression into valid_if.

View solution in original post

2 REPLIES 2

You can move your List-returning expression from valid_if to Suggested Values. Then enter your Y/N expression into valid_if.

This is exactly the kind of thing i have been looking for , thanks @Marc_Dillon this was really helpful. 

Top Labels in this Space