I am working on a app that collects information. I a Enum list that effects what other questions your see moving forward. I would like the change that to Enumlist so multiple options can be selected. When I make the change to Enumlist I get an error message for he questions that are depending on the answers from that question-see below. Is there a way to use Enumlist when future questions are based on the answer(s).
โColumn Name โJob Typeโ in Schema โSheet1_Schemaโ of Column Type โEnumListโ has an invalid show_if constraint โ=NOT([Job Type] = โOTCโ)โ. Cannot compare List with Text in ([Job Type] = โOTCโ)โ
Thanks as always to those much smarter than me with AppSheet.
Foster
Hello!
Your formula should look like this
NOT(
IN(
"OTC",
SPLIT(
[Job Type],
","
)
)
)
You saved me with this one !
Sorry for the mix up. I didnโt notice that one error message had the NOT statement. That was my mistake. I should have shown the error message below. Every one of my questions about 60 will be dependent on the previous answer in โJob Typeโ. Some question will apply with multiple answers. The multiple answers condition is where my problem arises.
Column Name โCurrent Interior Colorโ in Schema โSheet1_Schemaโ of Column Type โTextโ has an invalid show_if constraint โ=[Job Type]=โLeatherโโ. Cannot compare List with Text in ([Job Type] = โLeatherโ)
User | Count |
---|---|
40 | |
26 | |
22 | |
20 | |
15 |