Hello guys,
I need your help
Is it possible to create dynamic show_if based on enum list selection?
Let’s say user select question_1, question_2, question_3 in [optional question] column, so the app only displays the columns [question_1], [question_2], [question_3].
Thank you very much for your help.
In general, yes, you can use IN() function.
IN() - AppSheet Help
For example , [question_1] column’s Show_if can be
IN(“Question_1”, [optional_question])
1 Like
Thank you. i used this formula CONTAINS([optional_question],“question_1”)
Great. Thank you for the update. While CONTAINS() will work in majority of such cases, I believe using IN() when searching an element in a list is more appropriate.
This is so because CONTAINS() by definition works with searching a fragment in a text whereas IN() specifically looks for an element in a list.
IN() - AppSheet Help
CONTAINS() - AppSheet Help
2 Likes
Thank you for your explaination.
2 Likes