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
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...
Thanks! I will look into this too.
Thanks James. Perfect. Worked like a charm! : )
Figured out a way using cascading choice filters!