topic Re: Two way choice filter in ArcGIS Survey123 Questions

Two way choice filter

peterbrad2 — Wed, 20 Jun 2018 18:55:45 GMT

Hello,

Lets say I have two questions in my survey.

Select One: Species Scientific Name

Select One: Species Common Name

I would like to be able to select either question depending on my knowledge of the species and have the other populated with its corresponding name. For example, say I find a species while doing field work and I know its common name, but I cant recall its scientific name, it will automatically fill in the scientific name if I select the common name. I'd also like to be able to do it in reverse. For example, say I find a species while doing field work and I know its scientific name, but I can't recall its common name, it would automatically fill in the common name.

Is this possible?

Re: Two way choice filter

NickDierks1 — Mon, 25 Jun 2018 19:07:59 GMT

Have you looked into pulldata()? You can probably set up pulldata() calculations on both questions that look up the other's answer in a table and pick the correct corresponding names. Selecting a scientific name should look up and populate the common name, and vice versa.

pulldata('NamesTable', 'SciName', 'ComName', ${ComName})

This formula, used as a calculation in your Scientific Name field, would populate the scientific name based on the common name you enter. 'SciName' and 'ComName' are fields in a csv you set up (NamesTable.csv). To calculate your common named based on the scientific name, just flip it around:

pulldata('NamesTable', 'ComName', 'SciName', ${SciName})

And if, for some reason, the two questions and their calculations don't play nice with eachother (you should be able to calculate select_one questions as of 2.7, but I haven't tried this yet myself), then you can try a workaround where your initial name selection questions are fieldType NULL, and pulldata() is used to populate two read-only text fields that are then passed on in the schema.

type	name	calculation	bind::esri:fieldType
select_one SciNames	SciName		null
select_one ComNames	ComName		null
text	SciNameText	pulldata('NamesTable', 'SciName', 'ComName', ${ComName})
text	ComNameText	pulldata('NamesTable', 'ComName', 'SciName', ${SciName})

Re: Two way choice filter

DougBrowning — Mon, 25 Jun 2018 20:34:46 GMT

In my project I did my labels like this since while using the autocomplete style Survey123 will find string combos in the code or name just fine.

Typing in ABL or Hook would get you the first one on this list.

label

ABLA Abies lasiocarpa (Hook.) Nutt. subalpine fir

ACGL Acer glabrum Torr. Rocky Mountain maple

ACMI2 Achillea millefolium L. common yarrow

ACHY Achnatherum hymenoides (Roem. & Schult.) Barkworth Indian ricegrass

ACNE9 Achnatherum nelsonii (Scribn.) Barkworth Columbia needlegrass

ACRI8 Achnatherum richardsonii (Link) Barkworth Richardson's needlegrass

Re: Two way choice filter

peterbrad2 — Wed, 27 Jun 2018 17:32:18 GMT

Doug,

This is exactly how I set it up as an interim solution. Thanks for the reply!

-pete

Re: Two way choice filter

peterbrad2 — Wed, 27 Jun 2018 17:32:49 GMT

Nick,

I might give this a try. Thanks for the reply!

-pete