https://community.esri.com/t5/arcgis-survey123-questions/survey-123-connect-integer-format/m-p/1365241#M53692 <P>Have a working 123 Connect Application -&nbsp;</P><P>One Field is a Select one string, a second field is an Integer both are esriFieldType: NULL.&nbsp; I want to combine these two for a resulting 6-character string that goes to Esri as a string.</P><P>So I added a hidden row and calculated the value of contact(${filed1}, string(${field2})).&nbsp; &nbsp;This works great except for numeric values below 100.&nbsp; &nbsp;Can anyone tell me how I force a mask of ### so that 5 is 005 and 50 is 050 in the resulting string and the full value will be 6-characters ABC005?&nbsp;</P><P>TIA --&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 01 Jan 2024 16:02:42 GMT JeffSilberberg 2024-01-01T16:02:42Z https://community.esri.com/t5/arcgis-survey123-questions/survey-123-connect-integer-format/m-p/1365241#M53692 <P>Have a working 123 Connect Application -&nbsp;</P><P>One Field is a Select one string, a second field is an Integer both are esriFieldType: NULL.&nbsp; I want to combine these two for a resulting 6-character string that goes to Esri as a string.</P><P>So I added a hidden row and calculated the value of contact(${filed1}, string(${field2})).&nbsp; &nbsp;This works great except for numeric values below 100.&nbsp; &nbsp;Can anyone tell me how I force a mask of ### so that 5 is 005 and 50 is 050 in the resulting string and the full value will be 6-characters ABC005?&nbsp;</P><P>TIA --&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 01 Jan 2024 16:02:42 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey-123-connect-integer-format/m-p/1365241#M53692 JeffSilberberg 2024-01-01T16:02:42Z https://community.esri.com/t5/arcgis-survey123-questions/survey-123-connect-integer-format/m-p/1365248#M53695 <P>&nbsp;</P><P>Found a solution -- Value + 1000 convert to string then substr(value, 1, 4)&nbsp;&nbsp;</P><P>&nbsp;</P> Mon, 01 Jan 2024 21:19:29 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey-123-connect-integer-format/m-p/1365248#M53695 JeffSilberberg 2024-01-01T21:19:29Z