topic Re: Constraint if statement with two select multiple questions in ArcGIS Survey123 Questions

Constraint if statement with two select multiple questions

BradenWarns — Thu, 17 Mar 2022 21:48:07 GMT

Hello,

I am having trouble with creating an IF statement with two select multiple questions in the constraint field.

Here is what I need to happen:

Here is what I have for the if statement:

if(selected(${extrarequest}, 'Extra_96g_Garbage'), 'One_time_fee' and 'Monthly_fee',
if(selected(${extrarequest}, 'Extra_96g_Recycle'), 'No_fee',
if(selected(${extrarequest}, 'Extra_96g_Garbage') and selected(${extrarequest}, 'Extra_96g_Recycle'), 'One_time_fee' and 'Monthly_fee' and 'No_fee',
'Remove_Recycle')))

I don't get any errors however, the constraint is not wrong correctly. I am sure I am missing something.

Any help would be greatly appreciated! @JamesTedrick

Re: Constraint if statement with two select multiple questions

Katie_Clark — Thu, 17 Mar 2022 23:24:55 GMT

So, I'm not completely sure without testing it myself, but I believe select_multiple questions store the answer as a string, separated by commas. So instead of 'One_time_fee' and 'Monthly_fee', it would be 'One_time_fee, Monthly_fee'.

Re: Constraint if statement with two select multiple questions

BradenWarns — Fri, 18 Mar 2022 15:03:44 GMT

I tried your suggestion. I did not get an error, but it still is not functioning correctly. Thanks.

Re: Constraint if statement with two select multiple questions

Katie_Clark — Fri, 18 Mar 2022 15:13:49 GMT

Would you be able to share your XLS form?

Re: Constraint if statement with two select multiple questions

BradenWarns — Mon, 21 Mar 2022 18:12:43 GMT

I decided to change this section. I broke up the second multiple questions into single questions. Then used a simple selected function in the relevant field. Much easier to work with. Thanks for your help @Katie_Clark

Re: Constraint if statement with two select multiple questions

Katie_Clark — Mon, 21 Mar 2022 19:35:43 GMT

Happy to hear you found a workaround!