topic Re: Concatenation of text, date and number fields in ArcGIS Survey123 Questions

Concatenation of text, date and number fields

Anonymous User — Wed, 23 Oct 2019 07:39:37 GMT

Is it possible to concatenate two or more fields with date, text and number types in Survy123. I havent seen any example.

DougBrowning — Wed, 23 Oct 2019 16:33:13 GMT

Did you try to cast it

string(question or value)

Converts to string. Conversion varies depending on data type.

string({$question_one})

Anonymous User — Wed, 23 Oct 2019 16:38:27 GMT

Hi Doug,

Not going to only cast, I have about 3 or 4 fields with different types, date, number and text and want to concatenate it into one field.

Thanks

DougBrowning — Wed, 23 Oct 2019 16:58:03 GMT

Yea that is what casting is.

string(${yournumberfield}) + ${yourstringfield} + string(${yourdatefield})

concat(string(${yournumberfield}), ${yourstringfield}, string(${yourdatefield}))

Anonymous User — Sun, 27 Oct 2019 06:48:42 GMT

Hi Doug,

Many thanks. but couldn't resolved date field. for the date field it gives a number like 1570347000000 and I want it in a format like 20191028.

I used string(${field_0}+${field_6}+${field_3}). the type for field_0 is date.

Thanks

DougBrowning — Mon, 28 Oct 2019 14:59:48 GMT

Check out this page for things like format-date(${WSDateTime},'%H:%M')