topic Re: Using multiple pulldata functions in a calculate field in ArcGIS Survey123 Questions

Using multiple pulldata functions in a calculate field

JohnMarra — Thu, 29 Mar 2018 22:18:41 GMT

I can't seem to get the calculation to work correctly when I use multiple pulldata functions. For example.

3 * pulldata('tubing', 'vol', 'dia', ${field_7}) * ${field_19})

works fine, but

3 * pulldata('tubing', 'vol', 'dia', ${field_7}) * ${field_19}) + pulldata('flow', 'vol', 'size', ${field_21}

does not work. It gives me no answer at all.

EDIT: As a workaround, I can assign the 2nd pulldata function to a decimal field and use the decimal field in the place of the 2nd pull data function. I just don't want to have to see the decimal field in the survey.

Re: Using multiple pulldata functions in a calculate field

SMauri — Fri, 30 Mar 2018 07:55:46 GMT

I will try something like this...

type	name	calculation
calculation	question1	pulldata('tubing', 'vol', 'dia', ${field_7})
calculation	question2	pulldata('flow', 'vol', 'size', ${field_21}
calculation	question3	3 * ${question1} * ${field_19}) + ${question2}

Cheers

Stefano

Re: Using multiple pulldata functions in a calculate field

JohnMarra — Fri, 30 Mar 2018 22:32:30 GMT

Got it. That makes sense. Thank you.

Re: Using multiple pulldata functions in a calculate field

SMauri — Tue, 03 Apr 2018 07:07:57 GMT

...and don't forget to mark question as solved

Re: Using multiple pulldata functions in a calculate field

JohnMarra — Sat, 07 Apr 2018 01:46:36 GMT

This solution no longer works in version 2.7.72???

What is up with this update?

Re: Using multiple pulldata functions in a calculate field

JamesTedrick — Mon, 09 Apr 2018 17:47:49 GMT

Hi John,

I do not believe that the issue you are experiencing is 2.7 specific. The XLSform translator (the software that translates the XLS file to the form XML file), does not recognize pulldata functions when they do not begin a line - the procedure you mentioned (dedicating a line to receive a pulldata value, then using it in a calculation) is the preferred form authoring pattern.