Concat works in Survey123 but not in ArcGIS Online

[Niklasg]

Hi,

I have written a calculation in my Survey123 under the calculation coloumn looking like this: concat(${ChainageKilometer}, "+", ${ChainageHundred}, ${ChainageTen}, ${ChainageMeter})

It combines the integer questions and adds a "+" between them. The result is written to a text question. In the Survey123 app it works perfectly, and I can send the answer, however in the attributetable when the answer is submitted, the attribute is empty. Any suggestions to what I can change to make it work?

Picture: Setup in Excel

Picture: Look in the Survey123 app.

Picture: Empty attribute information when published to ArcGIS Online

Thank you,

Niklas

[jcarlson]

Just checking the obvious: "start koordinat" is a text field, right?

Can you turn on your browser's developer tools and watch the Network tab to see what the actual request is that's being sent?

[DougBrowning]

If you want the first 2 to add then you cannot put the + in quotes that is just text then.

I think you want this.  but it would be ugly with all 3 numbers just right next to each other.

concat(${ChainageKilometer} + ${ChainageHundred}, ${ChainageTen}, ${ChainageMeter})

Confused as to what you want now.

[jcarlson]

I would assume it's for some kind of road-related thing. "Distance along the road" in highway plans is often shown in that sort of format.

[DougBrowning · Accepted solution]

Oh so he wants the + in there.  I think the web is more picky  and will not auto convert int so I would try 

concat(string(${ChainageKilometer}), "+", string(${ChainageHundred}), string(${ChainageTen}), string(${ChainageMeter}))

hope that does it

[Niklasg]

Hi guys,

Thanks for your help.

Putting your suggested solution "concat(string(${ChainageKilometer}), "+", string(${ChainageHundred}), string(${ChainageTen}), string(${ChainageMeter}))" into the calculation field did the trick!

Best regards

Niklas