topic Re: Decimal conditional constraint not working in ArcGIS Survey123 Questions

Decimal conditional constraint not working

MPach — Tue, 19 Mar 2024 13:20:17 GMT

I have a conditional constraint that is not working. The constraint is on a decimal type field and the appearance for the field is "numbers", which is like the calculator option to enter the values. The field has a default value of 2.5. I'm trying to put a constraint on the field so the value entered into the field can't be smaller than 2.5 and if it is lower than 2.5 it's supposed to show a constraint message. The constraint itself looks as follows

. >= 2.5

Based on what I've read that should take the current value enter (.) and make sure that it's greater or equal to 2.5.

Thank you for any help you can provide.

Re: Decimal conditional constraint not working

DougBrowning — Tue, 19 Mar 2024 13:39:53 GMT

Occasionally it confuses . >= with html. Just write out the full field name instead and it should to work.

${fieldname} >= 2.5

Hope that does it.

Re: Decimal conditional constraint not working

MPach — Tue, 19 Mar 2024 13:51:32 GMT

Still doesn't appear to be working. I had tried that before too because I thought there might be a problem with the . notation.

Re: Decimal conditional constraint not working

DougBrowning — Tue, 19 Mar 2024 14:06:38 GMT

Ok my other guess is the bind. Try setting the bind::type column to decimal. If that does not work then something else is up so post the whole form.

Re: Decimal conditional constraint not working

abureaux — Tue, 19 Mar 2024 14:37:50 GMT

What app is this in? And what versions?

A quick test in Connect shows that this appears to be working (.>=2.5)

Re: Decimal conditional constraint not working

MPach — Tue, 19 Mar 2024 14:43:42 GMT

It's in Connect version 3.18.124.

Re: Decimal conditional constraint not working

MPach — Tue, 19 Mar 2024 14:44:27 GMT

I tried that and it didn't seem to help. I put in a ticket with ESRI. I'm not sure what the issue is. I suppose I could try creating a new sheet.

Re: Decimal conditional constraint not working

DougBrowning — Tue, 19 Mar 2024 14:45:53 GMT

Yea something else is up then. Maybe a reserved word or something. Post the form.

Re: Decimal conditional constraint not working

MPach — Tue, 19 Mar 2024 15:02:38 GMT

See attached for the form. Row 35

Re: Decimal conditional constraint not working

DougBrowning — Tue, 19 Mar 2024 15:18:32 GMT

It seems to work fine for me. I am on 3.19 but should still work.

Re: Decimal conditional constraint not working

abureaux — Tue, 19 Mar 2024 15:38:02 GMT

Same as Doug. This works for me (I am also using Connect 3.19.x).

The only thing of note is that the XLSX template is out of date.

Re: Decimal conditional constraint not working

MPach — Tue, 19 Mar 2024 15:44:19 GMT

@DougBrowning @abureaux Thank you both. Seems like I need to update my software and XLSX template and see what happens. Much appreciated!

Re: Decimal conditional constraint not working

MPach — Tue, 19 Mar 2024 15:51:56 GMT

All updated and still not working 😵

Re: Decimal conditional constraint not working

MPach — Tue, 19 Mar 2024 16:01:56 GMT

@abureaux @DougBrowning How did you both add the form I sent to your Survey123 Connect to test it?

I'm assuming you chose from File on the New Survey window!

I'm trying to eliminate possible issues.

Thanks

Re: Decimal conditional constraint not working

abureaux — Tue, 19 Mar 2024 16:06:43 GMT

When you want to use an XLSX:

Re: Decimal conditional constraint not working

MPach — Tue, 19 Mar 2024 16:10:58 GMT

Yep, just checking that's what you did. I know the screen shot I sent was confusing because I had the Blank radio button selected. I was trying to see if I needed to try a blank form or not. Anyway, I did that too and still no luck. I'm going to let ESRI tell me what the problem is now because I'm at a loss.

Again, thank you for your help.

Re: Decimal conditional constraint not working

DougBrowning — Tue, 19 Mar 2024 16:14:11 GMT

Yes file option

Re: Decimal conditional constraint not working

abureaux — Tue, 19 Mar 2024 16:15:25 GMT

I assume you updated Connect.

The next step I take when things are really acting strange is do a fresh copy:

In Connect, start a new blank project
Once the survey is generated, go into the old XLSX and copy the file contents
Paste the file contents as text only into the new XLSX

The end result is a clean document (e.g., no copy-paste shenanigans). To be extra safe, I'd also recommend running Analyze Survey to check for any anomalies (unlikely to help in this particular case though as I already did that).

Re: Decimal conditional constraint not working

MPach — Tue, 19 Mar 2024 16:58:12 GMT

I tried that too, lol, no luck!

Re: Decimal conditional constraint not working

MPach — Mon, 25 Mar 2024 14:05:37 GMT

My eye roll emoji for my profile pic is there for a reason and it really didn't fail me this time. I really really over thought this one.

My problem was in understanding how the constraint was supposed to work. I thought it was supposed to throw the message immediately after a number less than 2.5 was entered. Now I know that’s not the case and you need to submit the form before the message is thrown. 🙄 🤣 UGGGGHHHH! So so silly!