topic Sorting choice list with integers in ArcGIS Survey123 Questions

Sorting choice list with integers

StefanHaglund1 — Sun, 21 Feb 2021 11:25:28 GMT

Hello all!

I have a choice list with integers and want to do a calculation based on the given number. My list looks like this. 50, 55, 60, 65 … 95, 100, 105 etc.

If the user answers e.g. 70, I want to catch all the choices from 70 and above. So I tried: if(${integerquestion} >= '70', ‘1’, ‘0’).

This works well between 70 to 95 but it doesn’t give me anything above 100. One solution is to use:
if(${integerquestion} = '70' or ${integerquestion} = '75' … ${integerquestion} = '120'

This is very ineffective and surely there is better solution out there. Does anyone have a solution for this?

Re: Sorting choice list with integers

DavidPike — Sun, 21 Feb 2021 14:03:37 GMT

I don't use survey123 so this may not be applicable, but if the When function is available it may be easier to implement Logical Functions | ArcGIS for Developers

Re: Sorting choice list with integers

MichaelVolz — Sun, 21 Feb 2021 15:20:12 GMT

If its an integer why is it in quotes. Seems like it might be sorting based on an text field where 100 comes before 50. That's why text fields next to be cast as a numeric field before operating on it or using another field to calculate it to be a numeric field.

Re: Sorting choice list with integers

DougBrowning — Mon, 22 Feb 2021 16:52:44 GMT

2 ways

if(int(${integerquestion}) >= 70, 1, 0)

or set the bind type field to int.

Hope that helps