Survey123 - Auto Calculation works in Connect and the Survey123 App but not in the Web Broswer version of the form

943
3
Jump to solution
12-15-2021 02:34 PM
RickeyFight
MVP Regular Contributor

I have a form to add two text questions together. I have the First and Last name in one question and address in another. 

The calculation I am using is  ${prop_owner_name1}+", "+${project_address}

This calculation works as expected in both Survery123 Connect and the ArcGIS Survey123 app however if I were to open the survey in a web browser, the answer gives a NaN. 

I am using Survey123 connect 3.13.251

1 Solution

Accepted Solutions
DougBrowning
MVP Esteemed Contributor

No cannot use the + at all.  Just comma separated list.

concat(${prop_owner_name1}, ", ", ${project_address})

Bookmark this page as your new bible 🙂

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm 

View solution in original post

3 Replies
DougBrowning
MVP Esteemed Contributor

for strings you have to use concat() for the web browser.

0 Kudos
RickeyFight
MVP Regular Contributor

@DougBrowning 

Thank you for the quick reply. Am I doing this wrong 

concat(${prop_owner_name1}+", "+${project_address})
 
I tried this and it did not work. 
0 Kudos
DougBrowning
MVP Esteemed Contributor

No cannot use the + at all.  Just comma separated list.

concat(${prop_owner_name1}, ", ", ${project_address})

Bookmark this page as your new bible 🙂

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm