Latest Contributions by GeraldSneary

Xander Bakker, I got my if-else statement to work. Now am I able to use <CLR> or something else to change the color of - Round(aggAcreage,2) ? var intersectingAggDiss = Intersects(FeatureSetByName($map,"COS Aggregated Vacant Parcels - No Structure"), $feature); var aggAcreage = 0; for (var aggacre in intersectingAggDiss) { aggAcreage += aggacre.Acreage; } if (aggAcreage == 0){ aggAcreage = ''; } else { 'The aggregate acreage is: ' + Round(aggAcreage,2); }‍‍‍‍‍‍‍‍‍‍ ... View more

Hi Xander, Am I understanding correctly that you can't use formatting tags in AGOL? I am having two issues: I can't get the iif statement to work and Am I able to change the color of just the acreage number? - Round(aggAcreage,2) (I know how to change the color of the entire expression) var intersectingAggDiss = Intersects(FeatureSetByName($map,"COS Aggregated Vacant Parcels - No Structure"), $feature); var aggAcreage = 0; for (var aggacre in intersectingAggDiss) { aggAcreage += aggacre.Acreage; } iif (aggAcreage = 0, '', 'The aggregate acreage is: ' + Round(aggAcreage,2)); //return 'The aggregate acreage is: ' + Round(aggAcreage,2);‍‍‍‍‍‍‍ ... View more

Xander you are a lifesaver. Thank you so much! My hunch was right a list was needed. I just started learning code a month ago. I was about to break out LP3THW and start looking at lists. But I know I wouldn't have come up with your syntax. Too bad you don't live closer I'd take you out for a few beers. ... View more

Xander Bakker Xander Bakker Kevin Milton Ken Buja  I can write one-off conditional expressions but how do you combine multiple conditional expressions for different fields? In the example below Field 1 & 2 are from one layer and Field 3 is from the popup layer. I want to only return a value and if it is null do not return an empty space. I can write an expression for each field that is null and only return the other 2 or all 3 if all values are present but not how to combine all expressions.   Field1       Field1  or  Field2  or Field1  or Field3 and so on Field2       Field2       Field3      Field3 Field3    I know how to return all fields even if it's null but it leaves a space/s.     This is my expression: var buildn = FeatureSetByName($map,"NLCOG Buildings",["BUILDING_N"]) var fsIntersectbuild = Intersects(buildn, $feature) var fbuildn = first(fsIntersectbuild) var buildu = FeatureSetByName($map,"NLCOG Buildings",["USAGE_"]) var fIntersectbuild = Intersects(buildu, $feature) var fusage = first(fIntersectbuild) var occp = $feature.OCCUPANCY iif (fbuildn.BUILDING_N == null, fusage.USAGE_ + TextFormatting.NewLine + occp, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp) //iif (fusage.USAGE_ == null, fbuildn.BUILDING_N + TextFormatting.NewLine + occp, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp) //iif (occp == null || occp == 'SINGLEF', fusage.USAGE_ + TextFormatting.NewLine + fbuildn.BUILDING_N, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp)‍‍‍‍‍‍‍‍‍‍‍‍‍ Each one of the iif statements works independently. I've tried using the When function but each field is different so it doesn't work or not the way that I wrote it. Any help would be appreciated. ... View more

Kelly Gerrow Xander Bakker Kevin MacLeod Robert Scheitlin, GISP  I can write one-off conditional expressions but how do you combine multiple conditional expressions for different fields? I have 3 fields I want to return to a new line but only if there is a value to return. Example: Field1  or  Field1  or  Field2  or Field1  or Field3 and so on Field2       Field2       Field3      Field3 Field3  I know how to return all fields even if it's null but it leaves an empty space. Field1 Field3 This is my expression: var buildn = FeatureSetByName($map,"NLCOG Buildings",["BUILDING_N"]) var fsIntersectbuild = Intersects(buildn, $feature) var fbuildn = first(fsIntersectbuild) var buildu = FeatureSetByName($map,"NLCOG Buildings",["USAGE_"]) var fIntersectbuild = Intersects(buildu, $feature) var fusage = first(fIntersectbuild) var occp = $feature.OCCUPANCY iif (fbuildn.BUILDING_N == null, fusage.USAGE_ + TextFormatting.NewLine + occp, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp) //iif (fusage.USAGE_ == null, fbuildn.BUILDING_N + TextFormatting.NewLine + occp, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp) //iif (occp == null || occp == 'SINGLEF', fusage.USAGE_ + TextFormatting.NewLine + fbuildn.BUILDING_N, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Each one of the iif statements works independently. I've tried using the When function but each field is different so it doesn't work or not the way that I wrote it. Any help would be appreciated. ... View more