topic Re: Arcade Expression in Pop-Up Error:15 in ArcGIS Field Maps Questions

Arcade Expression in Pop-Up Error:15

DanielWalsh — Fri, 15 Jan 2021 22:06:00 GMT

Hello,

We were very happy to see that Arcade expressions are supported in Field Maps and were hoping to use it to generate unique IDs in the field that can be referenced on reports, project documents. We developed an Arcade expression that does this and it works when loaded into the Beta Map viewer. However when opened in Field Maps we get an error code 15, Evaluation_error_code::unknown_function Line :20. I got the expression to work in Field Maps by removing many of the functions which unfortunately make it no longer meet our needs. Does anyone know if there is only a subset of the Arcade library that will work in Field Maps?

Thanks in advance for any help!

Below is the expression that has been developed:

var choices = {}; 
choices['1'] = 'BLD'; 
choices['2'] = 'STR'; 
choices['3'] = 'PAD'; 
choices['4'] = 'PIT'; 
choices['99'] = 'OTH'; 

function formatMulti(inField, d) { 
    var values = Split(inField, ','); 
    var labels = []; 
    for (var i in values){ 
        labels[i] = d[values[i]]; 
    } 
    var outText = Concatenate(labels, TextFormatting.NewLine); 
    return outText; 
} 
var park = IIf(IsEmpty($feature.SiteID), "UNK", Right(Left($feature.SiteID, 6), 3));
var yr = Text($feature.CreationDate, 'YY');
var tpe = formatMulti($feature.Type, choices);
var unique_val = $feature.Creator + $feature.CreationDate;
var hashed = Round(Sqrt(Hash(unique_val)), 0);
var new_id = park + "-" + yr + "-" + tpe+hashed;

return new_id

Re: Arcade Expression in Pop-Up Error:15

MikeSlattery — Sat, 16 Jan 2021 19:37:38 GMT

Interested to see what the answer is; I hope you get resolution.

ESRI team, things seem to be moving fast toward parity, but is there a chart that gives a matrix of supported arcade calls across products?

Multi support in Field Apps through to feature layer storage could be very interesting... I didn't know that had expanded past the xlsform world.

Re: Arcade Expression in Pop-Up Error:15

ChrisDunn1 — Thu, 21 Jan 2021 00:59:45 GMT

Hi Mike,

There is a version matrix you can use as a reference here: https://developers.arcgis.com/arcade/guide/version-matrix/. Field Maps is currently built on version 100.9 of the Runtime SDK, so it supports functions up to Arcade version 1.11, with the exception of a few specific functions outlined in footnote 4.

Re: Arcade Expression in Pop-Up Error:15

ChrisDunn1 — Thu, 21 Jan 2021 01:05:25 GMT

Hi Daniel,

It looks like the Hash function is what is tripping it up, it is not currently supported by the Runtime SDK as it was introduced in Arcade 1.12. It is supported by the Runtime version 100.10, The current release of Field Maps is at 100.8 of the Runtime SDK, but the next release should be on 100.10 so your code should work then. I hope that helps

Chris

Re: Arcade Expression in Pop-Up Error:15

DanielWalsh — Mon, 25 Jan 2021 16:59:44 GMT

This is fantastic Chris, exactly what I was looking for!

Re: Arcade Expression in Pop-Up Error:15

Anonymous User — Wed, 05 May 2021 12:41:03 GMT

Hi @ChrisDunn1 ,

I have a similar question. I have several Arcade expressions which use function "Count". It works fine in Web Map, however when I try to open pop-up in Field Maps I get an error:

Error Code:15

Error Description: Invalid call., Unable to evaluate arcade expression.

Evaluation_error_code::general_evaluation_error Line XX

Line number is always indicating the line with "Count" funcion that's why I suppose it is the one which is problematic. In version-matrix you sent it is stated that "Count" for FeatureSet is supported since version 1.5. If Field Maps supports functions up to Arcade version 1.11, I am not sure why it is not working. Do you have any suggestions?

Re: Arcade Expression in Pop-Up Error:15

ChrisDunn1 — Wed, 05 May 2021 14:37:53 GMT

Hi @Anonymous User ,

The Count function should work, so it's likely the problem is the object being passed into Count. Count will accept a feature set, an array, or a string, so make sure that is what's being counted and make sure it can't be null as I could see that causing an error, you could always add a check for null before the count statement.

You can get some more info by including a console statement, so if your count statement is something like;

Count(myObject)

Then just before that use;

Console(myObject)

And when you hit test switch to the Messages and you'll see what the object is that's being passed into Count.

If this doesn't help you track down the issue feel free to post the full expression if you can.

Re: Arcade Expression in Pop-Up Error:15

KaraUtter — Wed, 05 May 2021 22:00:14 GMT

Hi @DanielWalsh and @ChrisDunn1 - you say pop-up in the title of your submission but then you describe generating unique ID's - are you actually generating ID's in the attribute table as permanent data types through this method with Field Apps? I can't figure out how to get the pop-up information that is expressed through arcade configured in the pop-ups to pass into the Field Apps form to become actual data in the attribute table. Are you doing this?

Re: Arcade Expression in Pop-Up Error:15

DanielWalsh — Wed, 05 May 2021 23:00:46 GMT

Hi @KaraUtter, For me we are using the expression to display an ID for field staff to be able to add to their handwritten notes which they use when writing reports. Then once data is synced we have a tool run to write the expression to the dataset. I think field calculation in the app is coming soon though which will be a big help!

Re: Arcade Expression in Pop-Up Error:15

Anonymous User — Thu, 06 May 2021 08:49:26 GMT

Thank you for your answer @ChrisDunn1 !

Input of count is a feature set but it looks that the issue appears when it has no records. I use FeatureSetByName to get records from related table and for some objects there are no records. How can I add a check for null before the count statement? Tried to use IsEmpty function, but it returns 'False' when there are no records in my feature set.

Below you can find my code. As I wrote before - everything is working fine in Web Map i AGOL. When I try to use Field Maps, I get an error:

* for empty feature set the error refers to line with statement "var mycount = Count(utl_f)", so IsEmpty returns "false" for empty feature set

* for feature set with some objects, the Count function seems to be working, but error refers to line with the statement "var dismarray = Distinct(marray)". Are there also any special conditions for Distinct function to make it work in Field Maps?

var parsellnr = $feature.parsellid var utl = FeatureSetByName($map, 'utløpsgrøft - tilstand') var sql1 = "parsellid = '" + parsellnr + "' "; var sql2 = " AND tilstand = '2' " var sql = sql1 + sql2 var utl_f = Filter(utl, sql) if (!IsEmpty(utl_f)){ var mycount = Count(utl_f) } var marrayix = 0 var marray = [] var antunik = 0 if (mycount>0) { for (var c in utl_f){ var glid = c.utlopsgroft_ID marray[marrayix]= glid var dismarray = Distinct(marray) ++marrayix } var antunik = Count(dismarray) } return antunik

I really appreciate your help,

Aleksandra

Re: Arcade Expression in Pop-Up Error:15

KaraUtter — Thu, 06 May 2021 13:12:33 GMT

@DanielWalsh thank you for your response. I was afraid of that. I do hope field calculations with arcade expressions happens sooner than later but I bet it will be after our 2021 field season is already complete.

Re: Arcade Expression in Pop-Up Error:15

Anonymous User — Tue, 11 May 2021 18:50:39 GMT

@ChrisDunn1 can it be a general problem with Feature Set not validating when being empty?

I have tested couple of different checks for null values. The one presented in previous comment with IsEmpty() function which returns 'false' for empty dataset.

The other one which adds First() function before IsEmpty() function. It works fine, as then the value is 'true' in Web Map, however, it fails on this line in Field Maps apps.

var mycount = 0 if (!IsEmpty(First(utl_f))) { for (var i in utl_f){ mycount =+1 } }

I have also tried with common for loop, but Field Maps returns error for this one too.

var mycount = 0 for (var i in utl_f){ mycount =+1 }

I would love to hear about possibilities of adding a check for null as you suggested.

Re: Arcade Expression in Pop-Up Error:15

ChrisDunn1 — Mon, 17 May 2021 18:28:19 GMT

Hi @Anonymous User - sorry for the delay. I'm still digging into this but I have learned a few things.

IsEmpty will only return true for null and empty strings, if you use it with an empty array it will still return false which is why IsEmpty(utl_f) returned false but IsEmtpy(First(utl_f)) returns true. This snippet you posted above seems like it should work.

var mycount = 0 if (!IsEmpty(First(utl_f))) { for (var i in utl_f){ mycount =+1 } }

Which line exactly is it failing on in Field Maps?

Re: Arcade Expression in Pop-Up Error:15

Anonymous User — Tue, 18 May 2021 05:45:50 GMT

Hello @ChrisDunn1 and thank you for reply!

Yes, it looks like IsEmpty() is not meant to be used with arrays.

The behavior of First() is the same as for Count(). It validates for NOT empty Feature Sets, but error in Field Maps appears for Feature Set with no records. The line it fails is the one containing First(utl_f). Tried with the whole expression if(!IsEmpty(First(utl_f))) but also to write just First(utl_f) in a separate line and it is the one causing troubles. So it looks that First() also have some limitations.. I wonder if there are any other functions I could use here?