topic Bug in Advanced Connect Template in bind::type Validation in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/bug-in-advanced-connect-template-in-bind-type/m-p/878337#M29815 <HTML><HEAD></HEAD><BODY><P>The Advanced template that appears in Connect v3.3.51 has a bug in the data validation for the <EM>bind::type</EM> column. The data validation cell references are off by two, probably due to some insertion on&nbsp;<EM>types</EM> sheet. The first image below show the issue. The second shows the root cause. The third shows the cells referenced in the second one. You can see that cell A182 (1) should not appear in the dropdown.</P><P></P><P><EM>Source</EM>&nbsp;in the data validation window should be&nbsp;the following:</P><PRE>=types!$A$185:$A$190</PRE><P></P><P><IMG __jive_id="443944" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/443944_pastedImage_3.png" /><IMG __jive_id="443946" class="image-3 jive-image" src="https://community.esri.com/legacyfs/online/443946_pastedImage_5.png" /><IMG __jive_id="443945" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/443945_pastedImage_4.png" /></P></BODY></HTML> Thu, 25 Apr 2019 17:11:54 GMT ElliottPlack__SHA_ 2019-04-25T17:11:54Z Bug in Advanced Connect Template in bind::type Validation https://community.esri.com/t5/arcgis-survey123-questions/bug-in-advanced-connect-template-in-bind-type/m-p/878337#M29815 <HTML><HEAD></HEAD><BODY><P>The Advanced template that appears in Connect v3.3.51 has a bug in the data validation for the <EM>bind::type</EM> column. The data validation cell references are off by two, probably due to some insertion on&nbsp;<EM>types</EM> sheet. The first image below show the issue. The second shows the root cause. The third shows the cells referenced in the second one. You can see that cell A182 (1) should not appear in the dropdown.</P><P></P><P><EM>Source</EM>&nbsp;in the data validation window should be&nbsp;the following:</P><PRE>=types!$A$185:$A$190</PRE><P></P><P><IMG __jive_id="443944" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/443944_pastedImage_3.png" /><IMG __jive_id="443946" class="image-3 jive-image" src="https://community.esri.com/legacyfs/online/443946_pastedImage_5.png" /><IMG __jive_id="443945" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/443945_pastedImage_4.png" /></P></BODY></HTML> Thu, 25 Apr 2019 17:11:54 GMT https://community.esri.com/t5/arcgis-survey123-questions/bug-in-advanced-connect-template-in-bind-type/m-p/878337#M29815 ElliottPlack__SHA_ 2019-04-25T17:11:54Z Re: Bug in Advanced Connect Template in bind::type Validation https://community.esri.com/t5/arcgis-survey123-questions/bug-in-advanced-connect-template-in-bind-type/m-p/878338#M29816 <HTML><HEAD></HEAD><BODY><P>Hi Elliott,</P><P></P><P>Thanks! The validation range will be fixed in the next release of Survey123.</P></BODY></HTML> Thu, 25 Apr 2019 21:19:53 GMT https://community.esri.com/t5/arcgis-survey123-questions/bug-in-advanced-connect-template-in-bind-type/m-p/878338#M29816 JamesTedrick 2019-04-25T21:19:53Z