Using lookup table to trigger a Boolean response?

227
4
08-20-2018 01:43 PM
New Contributor

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

Tags (1)
Reply
0 Kudos
4 Replies
Esri Esteemed Contributor

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-da... 

New Contributor

Thanks! I will look into this too.

Reply
0 Kudos
New Contributor

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

Reply
0 Kudos
New Contributor

Figured out a way using cascading choice filters!

Reply
0 Kudos