https://community.esri.com/t5/arcgis-survey123-questions/null-results-following-cascade-of-select-multi/m-p/1368286#M53886 <P>&nbsp;</P><P>In order to try and keep my form simple I have a select multiple list (7 options) followed by integer questions that have appearance of numbers,&nbsp; the integer questions are only relevant following being selected in the select multiple question.&nbsp;</P><P>If an option is selected&nbsp; and the number is added the data is stored and exported as a number. However when an option is not selected the integer number is not recorded and the exported spread sheet cell contains no data.</P><P>I have 0 set as a default in S123 and if I remove the relevant requirement for the integer question the default value is recorded as 0.</P><P>To save team members filling in zeros is there a way to force an default output of zero in this cascade of question?</P><P>Thanks for any help!</P> Wed, 10 Jan 2024 11:59:03 GMT EW13 2024-01-10T11:59:03Z https://community.esri.com/t5/arcgis-survey123-questions/null-results-following-cascade-of-select-multi/m-p/1368286#M53886 <P>&nbsp;</P><P>In order to try and keep my form simple I have a select multiple list (7 options) followed by integer questions that have appearance of numbers,&nbsp; the integer questions are only relevant following being selected in the select multiple question.&nbsp;</P><P>If an option is selected&nbsp; and the number is added the data is stored and exported as a number. However when an option is not selected the integer number is not recorded and the exported spread sheet cell contains no data.</P><P>I have 0 set as a default in S123 and if I remove the relevant requirement for the integer question the default value is recorded as 0.</P><P>To save team members filling in zeros is there a way to force an default output of zero in this cascade of question?</P><P>Thanks for any help!</P> Wed, 10 Jan 2024 11:59:03 GMT https://community.esri.com/t5/arcgis-survey123-questions/null-results-following-cascade-of-select-multi/m-p/1368286#M53886 EW13 2024-01-10T11:59:03Z https://community.esri.com/t5/arcgis-survey123-questions/null-results-following-cascade-of-select-multi/m-p/1368353#M53888 <P>If a question is not relevant, no calculations or defaults are applied to it. If you want a question to not appear to the user in certain situations but still apply defaults and calculations when it is hidden you need to use the&nbsp;body::esri:visible column instead of the relevant column.&nbsp;</P><P><A href="https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-hidden-relevant-and/ba-p/1165842" target="_self">Survey123 Tricks of the Trade: hidden, relevant, and body::esri:visible</A></P> Wed, 10 Jan 2024 15:11:26 GMT https://community.esri.com/t5/arcgis-survey123-questions/null-results-following-cascade-of-select-multi/m-p/1368353#M53888 JenniferAcunto 2024-01-10T15:11:26Z