topic Re: Auto-populate select_one using conditional if( with calculation in Survey123 in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/auto-populate-select-one-using-conditional-if-with/m-p/840023#M20646 <HTML><HEAD></HEAD><BODY><P>I think you need to make a slight update to the if statements.&nbsp;Assuming the values fs1, fs2, and tw1 are text, they should have quotes so that they are not read as variables. I think it should be something like the following:</P><P>if(${locationID}='FS1','fs1',if(${locationID}='FS2','fs2',if(${locationID}='TW1','tw1','')))</P></BODY></HTML> Fri, 23 Aug 2019 16:13:33 GMT BrittneyGibbons1 2019-08-23T16:13:33Z Auto-populate select_one using conditional if( with calculation in Survey123 https://community.esri.com/t5/arcgis-survey123-questions/auto-populate-select-one-using-conditional-if-with/m-p/840022#M20645 <HTML><HEAD></HEAD><BODY><P>I am trying to auto-populate a select_one type (place) list by using if statement in calculate field based on geopoint location in geofence with data attributes successfully extracted from the polygon using Survey123 Connect. I am using the following conditions in an if statement within calculation column for select_one to try to auto-populate a selection based on locationID attribute&nbsp;but it has been unsuccessful thus far. I have attached a snips of select_one place calculation and place choice list from the spreadsheet. Please let me know what I am missing, Thanks!</P></BODY></HTML> Thu, 22 Aug 2019 19:54:31 GMT https://community.esri.com/t5/arcgis-survey123-questions/auto-populate-select-one-using-conditional-if-with/m-p/840022#M20645 GreggGreer 2019-08-22T19:54:31Z Re: Auto-populate select_one using conditional if( with calculation in Survey123 https://community.esri.com/t5/arcgis-survey123-questions/auto-populate-select-one-using-conditional-if-with/m-p/840023#M20646 <HTML><HEAD></HEAD><BODY><P>I think you need to make a slight update to the if statements.&nbsp;Assuming the values fs1, fs2, and tw1 are text, they should have quotes so that they are not read as variables. I think it should be something like the following:</P><P>if(${locationID}='FS1','fs1',if(${locationID}='FS2','fs2',if(${locationID}='TW1','tw1','')))</P></BODY></HTML> Fri, 23 Aug 2019 16:13:33 GMT https://community.esri.com/t5/arcgis-survey123-questions/auto-populate-select-one-using-conditional-if-with/m-p/840023#M20646 BrittneyGibbons1 2019-08-23T16:13:33Z Re: Auto-populate select_one using conditional if( with calculation in Survey123 https://community.esri.com/t5/arcgis-survey123-questions/auto-populate-select-one-using-conditional-if-with/m-p/840024#M20647 <HTML><HEAD></HEAD><BODY><P>Yes values are text and I did miss adding quotes, thank you for catching it and for your assistance! <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 23 Aug 2019 22:20:32 GMT https://community.esri.com/t5/arcgis-survey123-questions/auto-populate-select-one-using-conditional-if-with/m-p/840024#M20647 GreggGreer 2019-08-23T22:20:32Z