Concat() function: Do not display concatenated values until prequel data has been entered

Siew_WeiGoh2 — Sun, 05 Nov 2017 11:59:07 GMT

In using the concat() function involving using fixed terms, such as 'and' shown in the example, in between referenced values, the term 'and' would be shown in the field as a default.

For example, I had used the functions as below to returns two result into one field:

In the Survey123 form, I will get '()' as a default:

It works well once the prequel fields are selected:

However, I do not want the "()" or any other fixed character/s to be showing until the prequel information has been selected. How do I set it so it shows an empty field on default?

Thank you

Re: Concat() function: Do not display concatenated values until prequel data has been entered

Anonymous User — Sun, 05 Nov 2017 23:43:43 GMT

Hi Siew,

You can use an IF statement with an OR on both the input fields as follows:

if((${calPullroadNm}='' or ${calPullroadType}=''),'',(concat(${calPullroadNm},'(',${calPullroadType},')')))

Hope that helps.

Phil.

topic Re: Concat() function: Do not display concatenated values until prequel data has been entered in ArcGIS Survey123 Questions

Concat() function: Do not display concatenated values until prequel data has been entered

Re: Concat() function: Do not display concatenated values until prequel data has been entered