https://community.esri.com/t5/arcgis-survey123-questions/text-line-not-showing-up-with-different-versions/m-p/1069213#M35308 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/477677">@KatieRassmussen</a>,</P><P>I had a quick look at your XLSForm and believe the problem is related to the comma being used in your choice list. If you remove the commas from your choice list name values, the expression will work as expected.</P><P>This is likely due to improvements to the way we handle choice lists and loading values in the database which were introduced in version 3.12. It is good practice not to use special characters or punctuation in names of questions or choice lists. The comma is a specical case also, where it is used in CSV files (comma seperated values) to denote the columns of data. Therefore when you use a comma in the data and it is not wrapped in quotes, the comma will cause the string to be seperated into different columns in the database. The same can occur when the commas are in expressions, such as the relevant expression.</P><P>Please refer to documentation regarding special characters:&nbsp;<A href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/quickreferencecreatesurveys.htm#ESRI_SECTION1_8ED1E0D010424885A425D6BEB893216A" target="_blank">https://doc.arcgis.com/en/survey123/desktop/create-surveys/quickreferencecreatesurveys.htm#ESRI_SECTION1_8ED1E0D010424885A425D6BEB893216A</A></P><P>Also refer to this blog:&nbsp;<A href="https://community.esri.com/t5/arcgis-survey123-blog/what-s-new-in-arcgis-survey123-february-2021/ba-p/1030586" target="_blank">https://community.esri.com/t5/arcgis-survey123-blog/what-s-new-in-arcgis-survey123-february-2021/ba-p/1030586</A></P><P>Regards,</P><P>Phil.</P> Thu, 17 Jun 2021 05:23:25 GMT Anonymous User 2021-06-17T05:23:25Z https://community.esri.com/t5/arcgis-survey123-questions/text-line-not-showing-up-with-different-versions/m-p/1069180#M35307 <P>See attachment. The text field (row 18) is supposed to show up so that a user can manually type their name, if their name wasn't available from a list. If "Not Listed" is chosen from the 'select_one Staff' (row 17) choice list, then row 18 should appear. This option works just fine as expected in Survey123 version 3.5.164 (older) but does NOT appear in Survey123 version 3.12.277. Please help me figure out this annoying quirk. Thank you!!</P> Thu, 17 Jun 2021 00:37:40 GMT https://community.esri.com/t5/arcgis-survey123-questions/text-line-not-showing-up-with-different-versions/m-p/1069180#M35307 KatieRassmussen 2021-06-17T00:37:40Z https://community.esri.com/t5/arcgis-survey123-questions/text-line-not-showing-up-with-different-versions/m-p/1069213#M35308 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/477677">@KatieRassmussen</a>,</P><P>I had a quick look at your XLSForm and believe the problem is related to the comma being used in your choice list. If you remove the commas from your choice list name values, the expression will work as expected.</P><P>This is likely due to improvements to the way we handle choice lists and loading values in the database which were introduced in version 3.12. It is good practice not to use special characters or punctuation in names of questions or choice lists. The comma is a specical case also, where it is used in CSV files (comma seperated values) to denote the columns of data. Therefore when you use a comma in the data and it is not wrapped in quotes, the comma will cause the string to be seperated into different columns in the database. The same can occur when the commas are in expressions, such as the relevant expression.</P><P>Please refer to documentation regarding special characters:&nbsp;<A href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/quickreferencecreatesurveys.htm#ESRI_SECTION1_8ED1E0D010424885A425D6BEB893216A" target="_blank">https://doc.arcgis.com/en/survey123/desktop/create-surveys/quickreferencecreatesurveys.htm#ESRI_SECTION1_8ED1E0D010424885A425D6BEB893216A</A></P><P>Also refer to this blog:&nbsp;<A href="https://community.esri.com/t5/arcgis-survey123-blog/what-s-new-in-arcgis-survey123-february-2021/ba-p/1030586" target="_blank">https://community.esri.com/t5/arcgis-survey123-blog/what-s-new-in-arcgis-survey123-february-2021/ba-p/1030586</A></P><P>Regards,</P><P>Phil.</P> Thu, 17 Jun 2021 05:23:25 GMT https://community.esri.com/t5/arcgis-survey123-questions/text-line-not-showing-up-with-different-versions/m-p/1069213#M35308 Anonymous User 2021-06-17T05:23:25Z