nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcade Expression Cannot read property 'length' of undefined error

PaulSweeney3

Hi All

See Acade expression

Var polesLayer =  FeatureSetByPortalItem(Portal('myportal'), 'xyz')
var chambers  = FeatureSetByPortalItem(Portal(''my portal'), 'xyz')
Var buff = buffer($feature,1,'meters')
Var poles = Intersects(buff,polesLayer)
Var chambers  = Intersects(buff,chambers)
var cnt = count(poles)
var cntchambers = count(chambers) 
var popupResult = ''
for (var f in poles) {

popupResult += f.barcode + " to pole " 

}var ChambResult = ''
for (var f in chambers) {

ChambResult += f.label + " to chamber " 

}
var strLenght = count(popupResult)-8
var note = left(popupResult,strLenght)
var strLenght2 = count(ChambResult)-15
var note2 = left(ChambResult,strLenght2)
var popup = IIf(cnt==1, replace(("install subduct " + DomainName($feature,"sub_size")+ " from pole " +text(note)),'to pole',''), ("install subduct " + DomainName($feature,"sub_size")+ " from pole " +text(note)))
var popup2 = IIf(cntchambers==1, replace(("install subduct " + DomainName($feature,"sub_size")+ " from chamber " +text(note2)),'to chamber',''), ("install subduct " + DomainName($feature,"sub_size")+ " from chamber " +text(note2)))
var popup3 = "install subduct " + DomainName($feature,"sub_size")+" from the chamber "+ChambResult+" to the pole "+popupResult
var popup3 = replace(popup3,' to pole ',"")
var popup3 = replace(popup3,' to chamber ',"")
var finalresult = when(cnt <= 2 && cntchambers==0,popup,cnt == 0 && cntchambers==2, popup2,cnt == 1 && cntchambers==1, popup3,'n/a')
return finalresult‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

i am using this expression to check if a line is intersecting two point feature layers and return an expression to run a specific type of subduct between each feature. the expression works as expected in the pop up but when i try to run it in the field calculator it fails with the expression

"Cannot read property 'length' of undefined error"

Encontre mais publicações marcadas com

Accepted answers

XanderBakker

Hi Paul Sweeney ,

Sorry for the late reply but I was attending the IMGIS conference and yesterday was a national holiday.

I just changed your code slightly, but it is still not very convincing. A couple of comments:

In your code do you have the layerID when you use FeatureSetByPortalItem for poles and chambers?
The validation of the count is before you do the loop for both poles and chambers
I am not convinced with the final When, since there are a number of cases that in theory can occur that are probably not accounted for. See lines 88 to 98 in the code below. Are those correct?

<SPAN class="comment token">// does you code include the layerID for poles?</SPAN>
<SPAN class="keyword token">var</SPAN> LayerIdPoles <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// what is the layerID for poles?</SPAN>
<SPAN class="keyword token">var</SPAN> polesLayer <SPAN class="operator token">=</SPAN>  <SPAN class="token function">FeatureSetByPortalItem</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Portal</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'my portal'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN> LayerIdPoles<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'polesLayer '</SPAN> <SPAN class="operator token">+</SPAN> polesLayer<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// does you code include the layerID for chambers?</SPAN>
<SPAN class="keyword token">var</SPAN> LayerIdChambers <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// what is the layerID for chambers?</SPAN>
<SPAN class="keyword token">var</SPAN> chambers  <SPAN class="operator token">=</SPAN> <SPAN class="token function">FeatureSetByPortalItem</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Portal</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'my portal'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN> LayerIdChambers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'chambers  '</SPAN> <SPAN class="operator token">+</SPAN> chambers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// create buffer around feature of 0.1 meter</SPAN>
<SPAN class="keyword token">var</SPAN> buff <SPAN class="operator token">=</SPAN> <SPAN class="token function">Buffer</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'meters'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// intersect buffer with poles</SPAN>
<SPAN class="keyword token">var</SPAN> poles <SPAN class="operator token">=</SPAN> <SPAN class="token function">Intersects</SPAN><SPAN class="punctuation token">(</SPAN>buff<SPAN class="punctuation token">,</SPAN> polesLayer<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>poles<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'cnt '</SPAN> <SPAN class="operator token">+</SPAN> cnt<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// intersect buffer with chambers</SPAN>
<SPAN class="keyword token">var</SPAN> chambers <SPAN class="operator token">=</SPAN> <SPAN class="token function">Intersects</SPAN><SPAN class="punctuation token">(</SPAN>buff<SPAN class="punctuation token">,</SPAN> chambers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cntchambers <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>chambers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'cntchambers'</SPAN> <SPAN class="operator token">+</SPAN> cntchambers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> popupResult <SPAN class="operator token">=</SPAN> <SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// why is this an underscore?</SPAN>
<SPAN class="comment token">// validate count before the loop</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt<SPAN class="operator token">></SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> f <SPAN class="keyword token">in</SPAN> poles<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        popupResult <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">.</SPAN>barcode <SPAN class="operator token">+</SPAN> <SPAN class="string token">" to pole "</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>
    <SPAN class="comment token">// only if you have poles, the following is relevant</SPAN>
    <SPAN class="keyword token">var</SPAN> strLenght <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>popupResult<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'strLenght '</SPAN> <SPAN class="operator token">+</SPAN> strLenght<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> note <SPAN class="operator token">=</SPAN> <SPAN class="token function">Left</SPAN><SPAN class="punctuation token">(</SPAN>popupResult<SPAN class="punctuation token">,</SPAN> strLenght<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'note '</SPAN> <SPAN class="operator token">+</SPAN> note<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">var</SPAN> popup <SPAN class="operator token">=</SPAN> <SPAN class="token function">IIf</SPAN><SPAN class="punctuation token">(</SPAN>cnt<SPAN class="operator token">==</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> 
                    <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>
                        <SPAN class="string token">"install subduct "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sub_size"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" from pole "</SPAN> <SPAN class="operator token">+</SPAN> note<SPAN class="punctuation token">,</SPAN> 
                        <SPAN class="string token">'to pole'</SPAN><SPAN class="punctuation token">,</SPAN>
                        <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> 
                    <SPAN class="string token">"install subduct "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sub_size"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" from pole "</SPAN> <SPAN class="operator token">+</SPAN> note<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popup '</SPAN><SPAN class="operator token">+</SPAN>popup<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    popupResult <SPAN class="operator token">=</SPAN> <SPAN class="string token">"There is no Link required here"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> popup <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popupresult '</SPAN> <SPAN class="operator token">+</SPAN> popupResult<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> ChambResult <SPAN class="operator token">=</SPAN> <SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cntchambers<SPAN class="operator token">></SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> f <SPAN class="keyword token">in</SPAN> chambers<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        ChambResult <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">.</SPAN>label <SPAN class="operator token">+</SPAN> <SPAN class="string token">" to chamber "</SPAN> <SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>
    <SPAN class="comment token">// only if you have chambers, the following is relevant</SPAN>
    <SPAN class="keyword token">var</SPAN> strLenght2 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>ChambResult<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> <SPAN class="number token">15</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'strLenght2 '</SPAN> <SPAN class="operator token">+</SPAN> strLenght<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> note2 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Left</SPAN><SPAN class="punctuation token">(</SPAN>ChambResult<SPAN class="punctuation token">,</SPAN>strLenght2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'note2 '</SPAN><SPAN class="operator token">+</SPAN>note2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> popup2 <SPAN class="operator token">=</SPAN> <SPAN class="token function">IIf</SPAN><SPAN class="punctuation token">(</SPAN>cntchambers<SPAN class="operator token">==</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> 
                    <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>
                        <SPAN class="string token">"install subduct "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"sub_size"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN> <SPAN class="string token">" from chamber "</SPAN> <SPAN class="operator token">+</SPAN> note2<SPAN class="punctuation token">,</SPAN>
                        <SPAN class="string token">'to chamber'</SPAN><SPAN class="punctuation token">,</SPAN>
                        <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> 
                    <SPAN class="string token">"install subduct "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"sub_size"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" from chamber "</SPAN> <SPAN class="operator token">+</SPAN> note2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popup2 '</SPAN> <SPAN class="operator token">+</SPAN> popup2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    ChambResult <SPAN class="operator token">=</SPAN> <SPAN class="string token">"There is no Link required here"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> popup2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ChambResult '</SPAN> <SPAN class="operator token">+</SPAN> ChambResult<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>


<SPAN class="keyword token">var</SPAN> popup3 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"install subduct "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"sub_size"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> 
             <SPAN class="string token">" from the chamber "</SPAN> <SPAN class="operator token">+</SPAN> ChambResult <SPAN class="operator token">+</SPAN> <SPAN class="string token">" to the pole "</SPAN> <SPAN class="operator token">+</SPAN> popupResult<SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popup3 '</SPAN> <SPAN class="operator token">+</SPAN> popup3<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> popup3 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>popup3<SPAN class="punctuation token">,</SPAN><SPAN class="string token">' to pole '</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popup3 '</SPAN> <SPAN class="operator token">+</SPAN> popup3<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> popup3 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>popup3<SPAN class="punctuation token">,</SPAN><SPAN class="string token">' to chamber '</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popup3 '</SPAN><SPAN class="operator token">+</SPAN>popup3<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> finalresult <SPAN class="operator token">=</SPAN> <SPAN class="token function">When</SPAN><SPAN class="punctuation token">(</SPAN>cnt <SPAN class="operator token"><=</SPAN> <SPAN class="number token">2</SPAN> <SPAN class="operator token">&&</SPAN> cntchambers<SPAN class="operator token">==</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> popup<SPAN class="punctuation token">,</SPAN>
                       cnt <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="operator token">&&</SPAN> cntchambers<SPAN class="operator token">==</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> popup2<SPAN class="punctuation token">,</SPAN>
                       cnt <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">&&</SPAN> cntchambers<SPAN class="operator token">==</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> popup3<SPAN class="punctuation token">,</SPAN>
                       <SPAN class="string token">'n/a'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'finalresult '</SPAN> <SPAN class="operator token">+</SPAN> finalresult<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">return</SPAN> finalresult<SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// 0 poles and 0 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 1 pole and 0 chambers -> popup</SPAN>
<SPAN class="comment token">// 2 poles and 0 chambers -> popup</SPAN>
<SPAN class="comment token">// 3 poles and 0 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 0 poles and 1 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 0 poles and 2 chambers -> popup2</SPAN>
<SPAN class="comment token">// 0 poles and 3 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 1 pole and 1 chambers -> popup3</SPAN>
<SPAN class="comment token">// 1 pole and 2 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 2 poles and 1 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 2 poles and 2 chambers -> 'n/a'</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

It is strange that if you only have a single feature, the expression works correctly but the field calculation fails. how are you filtering the featureset? Did you create a new source? It is possible that the pop-up validator is more forgiving than the one used in the field calculation...

All comments

XanderBakker

Hi @PaulSweeney3 ,

I will give it a shot later on and post back any results.

PaulSweeney3

HI @XanderBakker

The field in question is "Test_Note , feel free to try, i tried previously in Pro but could not get it to work either.

XanderBakker

Hi @PaulSweeney3 ,

Let me validate if I can perform the field calculation in ArcGIS Online. Can you confirm the output field name that should be filled with the result? If it does not work on ArcGIS Online, I can give it a shot and try to connect with ArcGIS Pro and perform the field calculation in Pro. Not sure if you have tried this already?

PaulSweeney3

Hi @XanderBakker yes this is expected it works for me in the pop up as well however when i try to calculate a field with the same expression it doesn't work. i shared the test map in there now but i understand you do not have the ability to calculate fields via arcade

XanderBakker

Hi @PaulSweeney3 ,

Thanks for sharing the data. I noticed that you didn't include the web map so I don't have access to any other Arcade expression configured in the pop-up. I used the code I posted earlier and just changed to way to access the poles and chambers and this is returned in the pop-up:

Can you indicate what should be changed?

PaulSweeney3

@XanderBakker

@XanderBakker Again apologies for the delayed response i have set up a group and added you with the layers and a map with the expression included. Please feel free to investigate if you have an opportunity , thanks for your help on this .

PaulSweeney3

Hi @XanderBakker

My turn to apologise for the late response , i have tried you expression and i am still getting the same error unfortunately . Just in response to some of your comments

The when statement , in theory there should only be 2 features intersecting the line at either end and it should be a pole or a chamber so 5 potential scenarios. Would this account for the error ? where it is only 1 pole or chamber i don't need a value i thought this would return just 'n/a'

1 pole 1Pole (cnt <= 2 && cntchambers==0)
1 Pole 'n/a'
1 Pole 1 chamber (cnt == 1 && cntchambers==1)
1 chamber 1chamber (cnt == 0 && cntchambers==2)
1 chamber 'n/a'

// does you code include the layerID for poles?

Yes my code contains the layer ID for the poles and chambers

why is this an underscore?

No major reason had it as a blank but then i thought perhaps the blank value was creating the issue so i just tried it with an underscore

I filtered it down to one objectid i knew worked with the pop up?

A new source? do you mean re publish the feature layers ?

Thanks for your help on this

Regards

XanderBakker

Hi Paul Sweeney ,

Sorry for the late reply but I was attending the IMGIS conference and yesterday was a national holiday.

I just changed your code slightly, but it is still not very convincing. A couple of comments:

In your code do you have the layerID when you use FeatureSetByPortalItem for poles and chambers?
The validation of the count is before you do the loop for both poles and chambers
I am not convinced with the final When, since there are a number of cases that in theory can occur that are probably not accounted for. See lines 88 to 98 in the code below. Are those correct?

<SPAN class="comment token">// does you code include the layerID for poles?</SPAN>
<SPAN class="keyword token">var</SPAN> LayerIdPoles <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// what is the layerID for poles?</SPAN>
<SPAN class="keyword token">var</SPAN> polesLayer <SPAN class="operator token">=</SPAN>  <SPAN class="token function">FeatureSetByPortalItem</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Portal</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'my portal'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN> LayerIdPoles<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'polesLayer '</SPAN> <SPAN class="operator token">+</SPAN> polesLayer<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// does you code include the layerID for chambers?</SPAN>
<SPAN class="keyword token">var</SPAN> LayerIdChambers <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// what is the layerID for chambers?</SPAN>
<SPAN class="keyword token">var</SPAN> chambers  <SPAN class="operator token">=</SPAN> <SPAN class="token function">FeatureSetByPortalItem</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Portal</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'my portal'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN> LayerIdChambers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'chambers  '</SPAN> <SPAN class="operator token">+</SPAN> chambers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// create buffer around feature of 0.1 meter</SPAN>
<SPAN class="keyword token">var</SPAN> buff <SPAN class="operator token">=</SPAN> <SPAN class="token function">Buffer</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'meters'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// intersect buffer with poles</SPAN>
<SPAN class="keyword token">var</SPAN> poles <SPAN class="operator token">=</SPAN> <SPAN class="token function">Intersects</SPAN><SPAN class="punctuation token">(</SPAN>buff<SPAN class="punctuation token">,</SPAN> polesLayer<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>poles<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'cnt '</SPAN> <SPAN class="operator token">+</SPAN> cnt<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// intersect buffer with chambers</SPAN>
<SPAN class="keyword token">var</SPAN> chambers <SPAN class="operator token">=</SPAN> <SPAN class="token function">Intersects</SPAN><SPAN class="punctuation token">(</SPAN>buff<SPAN class="punctuation token">,</SPAN> chambers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cntchambers <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>chambers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'cntchambers'</SPAN> <SPAN class="operator token">+</SPAN> cntchambers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> popupResult <SPAN class="operator token">=</SPAN> <SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// why is this an underscore?</SPAN>
<SPAN class="comment token">// validate count before the loop</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt<SPAN class="operator token">></SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> f <SPAN class="keyword token">in</SPAN> poles<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        popupResult <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">.</SPAN>barcode <SPAN class="operator token">+</SPAN> <SPAN class="string token">" to pole "</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>
    <SPAN class="comment token">// only if you have poles, the following is relevant</SPAN>
    <SPAN class="keyword token">var</SPAN> strLenght <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>popupResult<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'strLenght '</SPAN> <SPAN class="operator token">+</SPAN> strLenght<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> note <SPAN class="operator token">=</SPAN> <SPAN class="token function">Left</SPAN><SPAN class="punctuation token">(</SPAN>popupResult<SPAN class="punctuation token">,</SPAN> strLenght<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'note '</SPAN> <SPAN class="operator token">+</SPAN> note<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">var</SPAN> popup <SPAN class="operator token">=</SPAN> <SPAN class="token function">IIf</SPAN><SPAN class="punctuation token">(</SPAN>cnt<SPAN class="operator token">==</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> 
                    <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>
                        <SPAN class="string token">"install subduct "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sub_size"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" from pole "</SPAN> <SPAN class="operator token">+</SPAN> note<SPAN class="punctuation token">,</SPAN> 
                        <SPAN class="string token">'to pole'</SPAN><SPAN class="punctuation token">,</SPAN>
                        <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> 
                    <SPAN class="string token">"install subduct "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sub_size"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" from pole "</SPAN> <SPAN class="operator token">+</SPAN> note<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popup '</SPAN><SPAN class="operator token">+</SPAN>popup<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    popupResult <SPAN class="operator token">=</SPAN> <SPAN class="string token">"There is no Link required here"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> popup <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popupresult '</SPAN> <SPAN class="operator token">+</SPAN> popupResult<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> ChambResult <SPAN class="operator token">=</SPAN> <SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cntchambers<SPAN class="operator token">></SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> f <SPAN class="keyword token">in</SPAN> chambers<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        ChambResult <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">.</SPAN>label <SPAN class="operator token">+</SPAN> <SPAN class="string token">" to chamber "</SPAN> <SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>
    <SPAN class="comment token">// only if you have chambers, the following is relevant</SPAN>
    <SPAN class="keyword token">var</SPAN> strLenght2 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>ChambResult<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> <SPAN class="number token">15</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'strLenght2 '</SPAN> <SPAN class="operator token">+</SPAN> strLenght<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> note2 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Left</SPAN><SPAN class="punctuation token">(</SPAN>ChambResult<SPAN class="punctuation token">,</SPAN>strLenght2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'note2 '</SPAN><SPAN class="operator token">+</SPAN>note2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> popup2 <SPAN class="operator token">=</SPAN> <SPAN class="token function">IIf</SPAN><SPAN class="punctuation token">(</SPAN>cntchambers<SPAN class="operator token">==</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> 
                    <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>
                        <SPAN class="string token">"install subduct "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"sub_size"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN> <SPAN class="string token">" from chamber "</SPAN> <SPAN class="operator token">+</SPAN> note2<SPAN class="punctuation token">,</SPAN>
                        <SPAN class="string token">'to chamber'</SPAN><SPAN class="punctuation token">,</SPAN>
                        <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> 
                    <SPAN class="string token">"install subduct "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"sub_size"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" from chamber "</SPAN> <SPAN class="operator token">+</SPAN> note2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popup2 '</SPAN> <SPAN class="operator token">+</SPAN> popup2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    ChambResult <SPAN class="operator token">=</SPAN> <SPAN class="string token">"There is no Link required here"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> popup2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ChambResult '</SPAN> <SPAN class="operator token">+</SPAN> ChambResult<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>


<SPAN class="keyword token">var</SPAN> popup3 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"install subduct "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">DomainName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"sub_size"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> 
             <SPAN class="string token">" from the chamber "</SPAN> <SPAN class="operator token">+</SPAN> ChambResult <SPAN class="operator token">+</SPAN> <SPAN class="string token">" to the pole "</SPAN> <SPAN class="operator token">+</SPAN> popupResult<SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popup3 '</SPAN> <SPAN class="operator token">+</SPAN> popup3<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> popup3 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>popup3<SPAN class="punctuation token">,</SPAN><SPAN class="string token">' to pole '</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popup3 '</SPAN> <SPAN class="operator token">+</SPAN> popup3<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> popup3 <SPAN class="operator token">=</SPAN> <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>popup3<SPAN class="punctuation token">,</SPAN><SPAN class="string token">' to chamber '</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'popup3 '</SPAN><SPAN class="operator token">+</SPAN>popup3<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> finalresult <SPAN class="operator token">=</SPAN> <SPAN class="token function">When</SPAN><SPAN class="punctuation token">(</SPAN>cnt <SPAN class="operator token"><=</SPAN> <SPAN class="number token">2</SPAN> <SPAN class="operator token">&&</SPAN> cntchambers<SPAN class="operator token">==</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> popup<SPAN class="punctuation token">,</SPAN>
                       cnt <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="operator token">&&</SPAN> cntchambers<SPAN class="operator token">==</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> popup2<SPAN class="punctuation token">,</SPAN>
                       cnt <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">&&</SPAN> cntchambers<SPAN class="operator token">==</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> popup3<SPAN class="punctuation token">,</SPAN>
                       <SPAN class="string token">'n/a'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'finalresult '</SPAN> <SPAN class="operator token">+</SPAN> finalresult<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">return</SPAN> finalresult<SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// 0 poles and 0 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 1 pole and 0 chambers -> popup</SPAN>
<SPAN class="comment token">// 2 poles and 0 chambers -> popup</SPAN>
<SPAN class="comment token">// 3 poles and 0 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 0 poles and 1 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 0 poles and 2 chambers -> popup2</SPAN>
<SPAN class="comment token">// 0 poles and 3 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 1 pole and 1 chambers -> popup3</SPAN>
<SPAN class="comment token">// 1 pole and 2 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 2 poles and 1 chambers -> 'n/a'</SPAN>
<SPAN class="comment token">// 2 poles and 2 chambers -> 'n/a'</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

PaulSweeney3

Hi Xander Bakker‌

Thanks for your comments , i have added console messages to the expression and everything returns the expected results including counts in line 6 and 7 . Is it the fact that if it returns a zero in some instances that is causing the error? i have updated the expression to return a value if the count is zero. I have also filtered that table down to one feature and it is still not working on that feature even though the pop up returns the expected result. What would count as an invalid feature ?

Var polesLayer =  FeatureSetByPortalItem(Portal('my portal'), 'xyz')
console('polesLayer '+polesLayer )
var chambers  = FeatureSetByPortalItem(Portal('my portal'), 'xyz')
console('chamnbers  '+chambers )

Var buff = buffer($feature,.1,'meters')
console('buff '+buff)

Var poles = Intersects(buff,polesLayer)
console('poles  '+poles )

Var chambers  = Intersects(buff,chambers)
var cnt = count(poles)
console('cnt '+cnt)
var cntchambers = count(chambers)
console('cntchambers'+cntchambers)
var popupResult = '_'
for (var f in poles) {
    if (cnt>0) {
        popupResult += f.barcode + " to pole " ;
    } else {
            popupResult = "There is no Link required here";
        }
}
console('popupresult '+popupResult)
var ChambResult = '_'
for (var f in chambers) {
    if (cntchambers>0) {
        ChambResult += f.label + " to chamber " ;
    } else {
            ChambResult = "There is no Link required here";
        }
}
console('ChambResult '+ChambResult)
var strLenght = count(popupResult)-8
console('strLenght '+strLenght)
var note = left(popupResult,strLenght)
console('note '+note)
var strLenght2 = count(ChambResult)-15
console('strLenght2 '+strLenght)
var note2 = left(ChambResult,strLenght2)
console('note2 '+note2)
var popup = IIf(cnt==1, replace(("install subduct " + DomainName($feature,"sub_size")+ " from pole " +text(note)),'to pole',''), ("install subduct " + DomainName($feature,"sub_size")+ " from pole " +text(note)))
console('popup '+popup)
var popup2 = IIf(cntchambers==1, replace(("install subduct " + DomainName($feature,"sub_size")+ " from chamber " +text(note2)),'to chamber',''), ("install subduct " + DomainName($feature,"sub_size")+ " from chamber " +text(note2)))
console('popup2 '+popup2)
var popup3 = "install subduct " + DomainName($feature,"sub_size")+" from the chamber "+ChambResult+" to the pole "+popupResult
console('popup3 '+popup3)
var popup3 = replace(popup3,' to pole ',"")
console('popup3 '+popup3)
var popup3 = replace(popup3,' to chamber ',"")
console('popup3 '+popup3)
var finalresult = when(cnt <= 2 && cntchambers==0,popup,cnt == 0 && cntchambers==2, popup2,cnt == 1 && cntchambers==1, popup3,'n/a')
console('finalresult '+finalresult)
return finalresult‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

XanderBakker

Hi Paul Sweeney ,

This type of error is bound to happen if you don't include validations to see if you have a result to work with. It probably refers to the count executed on line 6 or 7. Make sure that you have access to the two layers you retrieve using FeatureSetByPortalItem on lines 1 and 2 and that you actually have valid poles and chambers.

In the pop-up it will execute only 1 example to show the result, but maybe somewhere in your data you may have an invalid feature that causes the error.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.