topic If statements and Syntax Error: Expected token ';' in ArcGIS Survey123 Questions

If statements and Syntax Error: Expected token ';'

BlytheSpendlove2 — Wed, 26 Sep 2018 17:21:38 GMT

I am trying to do an if statement in a calculate field in Survey123 Connect but I keep getting the error "Syntax Error: Expected token ';'

Does anyone have any ideas what I am doing wrong?

My survey has the following parameters:

QA field type: text

QB field type: text

Q1 field type: select yes_no

Q2 field type: text

Q2 calculation column entry: if(${Q1} = 'yes', ${QA}, ${QB})

I want the answer to Q2 to equal QA if Q1 = yes, and to equal QB if Q1 = no.

Anyone else have experience with this syntax error? I also get the syntax error if I try and replace ${QA} and ${QB} in the calculation field with integers.

Thanks,

Blythe

James Tedrick‌

Re: If statements and Syntax Error: Expected token ';'

BrandonArmstrong — Wed, 26 Sep 2018 20:09:09 GMT

Hi Blythe,

The calculation syntax that you entered looks correct, but it may be due to spacing of some sort. Please take a look at the attached example to compare to yours. If it does not help, please attach your XLSForm to this thread.

Best,

Brandon

Re: If statements and Syntax Error: Expected token ';'

BlytheSpendlove2 — Thu, 27 Sep 2018 15:18:16 GMT

Thank you Brandon, you were right! It was my spacing that was giving me problems. I had a space in between "if" and the first parenthesis.

Thanks again!

Blythe