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

[Siew_WeiGoh2]

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

SW

[Anonymous User]

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.