topic Re: validate column in survery123 in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/validate-column-in-survery123/m-p/784356#M6881 <HTML><HEAD></HEAD><BODY><P>Hi Malla,</P><P></P><P>Take a look at the following documentation</P><P><A class="link-titled" href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm" title="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm">Formulas—Survey123 for ArcGIS | ArcGIS</A>&nbsp;</P><P></P><P>I'm thinking you'll want to setup a calculation like this in the calculation column of your evaluation question.&nbsp;&nbsp;</P><P></P><P>&nbsp;if(${value}='100','True','False')</P><P></P><P>I have also attached an example XLSForm</P></BODY></HTML> Tue, 28 Aug 2018 04:16:44 GMT BrandonArmstrong 2018-08-28T04:16:44Z validate column in survery123 https://community.esri.com/t5/arcgis-survey123-questions/validate-column-in-survery123/m-p/784355#M6880 <HTML><HEAD></HEAD><BODY><P>I have two textboxes in survey123</P><P></P><P>when number 100 is filled in first textbox</P><P>second textbox should auto populate with&nbsp;value "true", other then 100 the value is " false"</P><P></P><P>Thanks</P></BODY></HTML> Mon, 27 Aug 2018 16:45:13 GMT https://community.esri.com/t5/arcgis-survey123-questions/validate-column-in-survery123/m-p/784355#M6880 Pa_Lotus 2018-08-27T16:45:13Z Re: validate column in survery123 https://community.esri.com/t5/arcgis-survey123-questions/validate-column-in-survery123/m-p/784356#M6881 <HTML><HEAD></HEAD><BODY><P>Hi Malla,</P><P></P><P>Take a look at the following documentation</P><P><A class="link-titled" href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm" title="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm">Formulas—Survey123 for ArcGIS | ArcGIS</A>&nbsp;</P><P></P><P>I'm thinking you'll want to setup a calculation like this in the calculation column of your evaluation question.&nbsp;&nbsp;</P><P></P><P>&nbsp;if(${value}='100','True','False')</P><P></P><P>I have also attached an example XLSForm</P></BODY></HTML> Tue, 28 Aug 2018 04:16:44 GMT https://community.esri.com/t5/arcgis-survey123-questions/validate-column-in-survery123/m-p/784356#M6881 BrandonArmstrong 2018-08-28T04:16:44Z