Concatenate value not saved in feature service

531
2
Jump to solution
04-15-2022 10:49 AM
AliciaShyu
Occasional Contributor

This is a follow-up question for this post https://community.esri.com/t5/arcgis-survey123-questions/extract-field-and-concatenate/td-p/1163997 

The formula in the calculation column of the URL field is correct 

concat(string('https://councildocs.dsm.city/rollcalls/')+${InitContrYrRollCallYr},'/'+${InitContrYrRollCallNbr}+str...'))

This is the preview in Connect's form

 InConnect.jpg

But when you view the data in the feature service, the data is different.

InFeatureClass.jpg

That's a text field with 255 characters.

Any ideas why it works in Connect but not in the webform?

Thanks.

 

0 Kudos
1 Solution

Accepted Solutions
DougBrowning
MVP Esteemed Contributor

You cannot use the + on strings in the web form.  You can only use concat.  No need for the string() part.

Just concat(string1, string1, ...)

View solution in original post

2 Replies
DougBrowning
MVP Esteemed Contributor

You cannot use the + on strings in the web form.  You can only use concat.  No need for the string() part.

Just concat(string1, string1, ...)

AliciaShyu
Occasional Contributor

That worked, thanks!