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)))
But Appsheet doesn’t allow me to create IF formulas with different types, like List and Yes / no.
How can I do?
Solved! Go to Solution.
You can move your List-returning expression from valid_if to Suggested Values. Then enter your Y/N expression into valid_if.
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.
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |