topic Re: Option to enter data in different unit field and calculate the other field in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/option-to-enter-data-in-different-unit-field-and/m-p/867871#M27425 <HTML><HEAD></HEAD><BODY><P>That sounds correct - you'll need one field to hold the values in metric, one to hold the values in imperial, and a field for your if/calculation statement.You could use a SelectOne to force your users to let you know what system they're using, and if they select imperial then you do the conversion.</P></BODY></HTML> Mon, 17 Sep 2018 18:50:14 GMT deleted-user-qpvAI3Fo0MKR 2018-09-17T18:50:14Z Option to enter data in different unit field and calculate the other field https://community.esri.com/t5/arcgis-survey123-questions/option-to-enter-data-in-different-unit-field-and/m-p/867868#M27422 <HTML><HEAD></HEAD><BODY><P>Is is possible to have the option to enter data in a field OR have it calculated from another field? Users can&nbsp; record measurements in inches or centimeters. If they enter it in the inches field I would like to it calculate centimeters and storage that in the centimeters field and vis versa. I know I can create cal field and store the data there, but I would&nbsp;rather only have the data in 2 fields if possible.&nbsp;</P></BODY></HTML> Mon, 17 Sep 2018 12:53:35 GMT https://community.esri.com/t5/arcgis-survey123-questions/option-to-enter-data-in-different-unit-field-and/m-p/867868#M27422 AJM 2018-09-17T12:53:35Z Re: Option to enter data in different unit field and calculate the other field https://community.esri.com/t5/arcgis-survey123-questions/option-to-enter-data-in-different-unit-field-and/m-p/867869#M27423 <HTML><HEAD></HEAD><BODY><P>The short answer is yes.&nbsp;You'll need to add a field called calculation to your questions sheet...<A href="http://xlsform.org/en/#calculation">xlsform.org/calculation</A></P></BODY></HTML> Mon, 17 Sep 2018 13:18:18 GMT https://community.esri.com/t5/arcgis-survey123-questions/option-to-enter-data-in-different-unit-field-and/m-p/867869#M27423 deleted-user-qpvAI3Fo0MKR 2018-09-17T13:18:18Z Re: Option to enter data in different unit field and calculate the other field https://community.esri.com/t5/arcgis-survey123-questions/option-to-enter-data-in-different-unit-field-and/m-p/867870#M27424 <HTML><HEAD></HEAD><BODY><P>I was not able to do it with only 2 fields but&nbsp;added a 3rd calculated field based&nbsp;on the select units field to hold the result</P><P></P><P>if(selected(${tape_units}, 'cm') ,${c_min_cm},(${c_min_in}*2.54))</P></BODY></HTML> Mon, 17 Sep 2018 17:18:38 GMT https://community.esri.com/t5/arcgis-survey123-questions/option-to-enter-data-in-different-unit-field-and/m-p/867870#M27424 AJM 2018-09-17T17:18:38Z Re: Option to enter data in different unit field and calculate the other field https://community.esri.com/t5/arcgis-survey123-questions/option-to-enter-data-in-different-unit-field-and/m-p/867871#M27425 <HTML><HEAD></HEAD><BODY><P>That sounds correct - you'll need one field to hold the values in metric, one to hold the values in imperial, and a field for your if/calculation statement.You could use a SelectOne to force your users to let you know what system they're using, and if they select imperial then you do the conversion.</P></BODY></HTML> Mon, 17 Sep 2018 18:50:14 GMT https://community.esri.com/t5/arcgis-survey123-questions/option-to-enter-data-in-different-unit-field-and/m-p/867871#M27425 deleted-user-qpvAI3Fo0MKR 2018-09-17T18:50:14Z