topic Re: Arcade IIF statement not working in ArcGIS Field Maps Questions

Arcade IIF statement not working

tendtreesTC — Wed, 07 Jun 2023 10:02:43 GMT

Hi there,

I am trying to use an IIF calculation to determine whether a switch should be selected to 'yes' or 'no' based on a field in the parent data.

When I use the following calculation:

Features = FeatureSetByRelationshipName($feature, 'WCC_Hort_Site_Auditing_XV2X_inspection_audit');

the result is

However, when I try to input this into an IIF statement:

iif(FeatureSetByRelationshipName($feature, 'WCC_Hort_Site_Auditing_XV2X_inspection_audit',['bedding'])=='yes','yes','no')

it returns "no"

I imagine it is something to do with the return being a featureSet rather than a straight yes/no

Can anyone help me with this calculation?

Thank you

Re: Arcade IIF statement not working

KenBuja — Wed, 07 Jun 2023 13:04:07 GMT

You're correct in your thinking that it's a question of improperly evaluating a FeatureSet. You have to get a Feature from that FeatureSet to do that. If you're expecting only item to be in the FeatureSet, use First to get that feature and perform your evaluation.

var fs = FeatureSetByRelationshipName($feature, 'WCC_Hort_Site_Auditing_XV2X_inspection_audit'); var feat = First(fs); iif(feat['bedding']=='yes','yes','no');

Re: Arcade IIF statement not working

tendtreesTC — Thu, 08 Jun 2023 09:21:52 GMT

that worked great thank you