topic Re: Constraint on an integer field works when using a web browser but not when using the Survey123 mobile app in ArcGIS Survey123 Questions

Constraint on an integer field works when using a web browser but not when using the Survey123 mobile app

OregonStateMarineBoard — Wed, 22 Nov 2023 17:56:09 GMT

Hello,

I'm trying to establish a constraint in Survey123 to restrict the allowable values in an integer field to only allow multiples of 0.25. The purpose of the field is for users to enter how much time they spent on an activity and we want it to be in 15 minute increments. I was able to get some different expressions to work on a browser but none of them worked using the survey123 app. Using a constraint would prevent any and all values from being accepted in the mobile app. Any value entered would result in a constraint violation in the survey123 mobile app.

Here are some of the different options I tried:

1) .25 * round(${mpHOURS} * 4) = ${mpHOURS}

2) (${mpHOURS}*4 - floor(${mpHOURS}*4)) = 0

3) regex(string(${mpHOURS}), '^\d+ (\.00|\.25|\.50|\.75)?$')

4) Javascript function

function isMultipleOfQuarter(value) {

var multiplied = value * 4;

return multiplied ===

Math.floor(multiplied);}

Additional Information:

Field type is decimal

published in Survey123 Connect version 3.18.123

Thank you!

Re: Constraint on an integer field works when using a web browser but not when using the Survey123 mobile app

abureaux — Wed, 22 Nov 2023 18:51:01 GMT

Not the best at JS, but this should work:

function isMultipleOfQuarter(var1) { var var1 = var1/0.25; var1 = var1 - Math.floor(var1) return var1; }

Not a multiple of 0.25:

Multiple of 0.25:

Re: Constraint on an integer field works when using a web browser but not when using the Survey123 mobile app

DougBrowning — Wed, 22 Nov 2023 18:59:15 GMT

First thing I always check on these is the bind::type column. Make sure to set that or it can be treated as string.

Re: Constraint on an integer field works when using a web browser but not when using the Survey123 mobile app

OregonStateMarineBoard — Mon, 27 Nov 2023 16:13:57 GMT

*UPDATE* I added some additional constraints to be a value between 0 and 24 and added the 15 minute interval as a modulo operation and the constraint seems to be working now in browsers and mobile apps.

. and ${TimeField} <=24 and ${TimeField} >= 0 and (${TimeField} *100) mod 25 = 0