Select to view content in your preferred language

Survey 123 Connect -- Integer Format

428
1
Jump to solution
01-01-2024 08:02 AM
JeffSilberberg
Occasional Contributor III

Have a working 123 Connect Application - 

One Field is a Select one string, a second field is an Integer both are esriFieldType: NULL.  I want to combine these two for a resulting 6-character string that goes to Esri as a string.

So I added a hidden row and calculated the value of contact(${filed1}, string(${field2})).   This works great except for numeric values below 100.   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? 

TIA -- 

 

 

 

0 Kudos
1 Solution

Accepted Solutions
JeffSilberberg
Occasional Contributor III

 

Found a solution -- Value + 1000 convert to string then substr(value, 1, 4)  

 

View solution in original post

0 Kudos
1 Reply
JeffSilberberg
Occasional Contributor III

 

Found a solution -- Value + 1000 convert to string then substr(value, 1, 4)  

 

0 Kudos