topic Re: Survey123 Error with Calculation Bind Attached Unexpected Beginning in ArcGIS Survey123 Questions

Survey123 Error with Calculation Bind Attached Unexpected Beginning

BradGeorgic — Tue, 18 Feb 2020 18:39:10 GMT

Trying to use Survey123 XLSForm to do a calucation based on a few fields inside the form. I keep getting this error. I have all the bind:esrifieldtype set to double. the syntax for the p1distance field for the calculation is

(${EndPoint}-${StartPoint})/${Verticals}/2+${StartPoint}

Any help would be awesome!

Re: Survey123 Error with Calculation Bind Attached Unexpected Beginning

Anonymous User — Wed, 19 Feb 2020 11:54:21 GMT

Hi Brad,

Are you still having this error or did you resolve it? Can you share your xlsx file so we can take a closer look at the form design and calculations?

Regards,

Phil.

Re: Survey123 Error with Calculation Bind Attached Unexpected Beginning

BradGeorgic — Wed, 19 Feb 2020 13:18:55 GMT

Yes still having problems. Thank you and I attached is the xls. Any help is appreciated!

Re: Survey123 Error with Calculation Bind Attached Unexpected Beginning

JamesTedrick — Wed, 19 Feb 2020 21:35:27 GMT

Hi Brad,

A couple of things

- you may want to set the bind::type column of the calculate questions to ensure they have the appropriate data type while processing inside the form

- '/' is not the proper indicator for division in XLSForms; the appropriate keyword is 'div'

Re: Survey123 Error with Calculation Bind Attached Unexpected Beginning

Anonymous User — Thu, 20 Feb 2020 01:22:43 GMT

Hi Brad,

The problem is that the ${Verticals} question is a text question (by default all select one are text type even if they contain numeric values). You need to set the bind::type as int or decimal (depending on your numeric values in the field) and also in your calculation in ${p1 Distance} you can cast the values as int also.

Hope this helps.

Regards,

Phil.

Re: Survey123 Error with Calculation Bind Attached Unexpected Beginning

BradGeorgic — Thu, 20 Feb 2020 13:19:10 GMT

THANKS With a combination of these posts I got it