topic Re: select_one no duplicate in ArcGIS Survey123 Questions

select_one no duplicate

ReubenWilliams — Fri, 17 Jul 2020 05:24:40 GMT

Hi, I have 2 select_one questions in survey123 with the same list of choices (staff members), ${author} and ${reviewer}. I need to ensure that the choices are unique, or in other words the author cannot be the reviewer. I've tried various methods using the constraint field but unable to achieve the right outcome so far. How should I go about this?

Re: select_one no duplicate

JamesTedrick — Mon, 20 Jul 2020 17:05:13 GMT

Hi Reuben,

The calculation for the constraint should be:

${author} != ${reviewer}

Note that this can only be applied to 1 of the 2 fields - applying them to both results in a circular calculation error (i.e., question 1 is dependent on question 2's values, which dependent on question 1, which is...)

Re: select_one no duplicate

ReubenWilliams — Mon, 20 Jul 2020 21:34:13 GMT

Thanks James, this works. I had tried previously but I didn't test properly as I expected the error instantly on match, when in reality the constraint is only tested when the form is submitted.