topic Re: Using lookup table to trigger a Boolean response? in ArcGIS Survey123 Questions

Using lookup table to trigger a Boolean response?

KarenTuerk2 — Mon, 20 Aug 2018 20:43:28 GMT

Greeting all,

I have a choice list of "plants" in a survey. The chosen plant species code is added to a field. But then I want to capture whether that species is native or not in another field (0 or 1). How can I use the selected plant code to trigger a lookup on another 'native' choice list. If the species is in that native list, the field will be populated with a 1, if not, a 0.

Trying to avoid very long if/then statements in the form body.

Is this even possible?

Thank you!
Karen

Re: Using lookup table to trigger a Boolean response?

JamesTedrick — Mon, 20 Aug 2018 21:10:11 GMT

Hi Karen,

The easiest method would be to have a CSV file with plant codes and their native/non-native status attached to the survey; you can then use the pulldata() function to look up information. See Formulas—Survey123 for ArcGIS | ArcGIS and https://community.esri.com/groups/survey123/blog/2016/10/27/the-pulldata-function-access-external-data

Re: Using lookup table to trigger a Boolean response?

KarenTuerk2 — Mon, 20 Aug 2018 21:51:22 GMT

Figured out a way using cascading choice filters!

Re: Using lookup table to trigger a Boolean response?

KarenTuerk2 — Mon, 20 Aug 2018 21:52:03 GMT

Thanks! I will look into this too.

Re: Using lookup table to trigger a Boolean response?

KarenTuerk2 — Tue, 21 Aug 2018 22:21:19 GMT

Thanks James. Perfect. Worked like a charm! : )