Dynamic show_if based on enum list

[alhazen]

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.

[Suvrutt_Gurjar · Accepted solution]

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

[alhazen]

Thank you. i used this formula CONTAINS([optional_question],"question_1")

[Suvrutt_Gurjar]

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

[alhazen]

Thank you for your explaination.