topic Re: FeatureSet not working offline in Field Maps in ArcGIS Field Maps Questions

FeatureSet not working offline in Field Maps

Scott_Sambell — Sun, 10 Apr 2022 21:00:52 GMT

We added calculated expressions to several of our clients' Field Maps after promising that they would have all the functionality now in smart forms that we have been raving about. Everything works perfect using Field Maps online but when we did the final test (download an offline area and sync test) we discovered that the FeatureSet function does not work offline. We tried it on several different Android and iOS devices on several different webmaps. This is an absolute showstopper for us. Is this a bug or a known limitation? We need to know asap so we can explain to the clients why they aren't getting what we promised

Here is an example of how we use FeatureSetByName:

var tblparent = FeatureSetByName($map, "Trap locations",['OBJECTID','Easting_Northing','GlobalID'],False);

Maybe other FeatureSet functions work but FeatureSetByName($Map,...... doesn't? Any explantation i could get would be much appreciated.

Thanks!

@JeffShaner

Re: FeatureSet not working offline in Field Maps

Anonymous User — Tue, 12 Apr 2022 00:58:46 GMT

We reproduced this in-house and have opened an issue to investigate further.

Re: FeatureSet not working offline in Field Maps

Scott_Sambell — Tue, 12 Apr 2022 02:36:39 GMT

Thanks Aaron!

Re: FeatureSet not working offline in Field Maps

Anonymous User — Wed, 20 Apr 2022 17:24:48 GMT

@Scott_Sambell While we investigate a full fix, there's a potential workaround. The issue appears to be related to case sensitive GUID value comparisons. If you cast your foreign key (the GUID) to upper, it should work.

I tested this in my own map and it seemed to work.

Re: FeatureSet not working offline in Field Maps

Scott_Sambell — Wed, 20 Apr 2022 18:53:00 GMT

Thanks Aaron this is going to be amazing if it works. We'll give it a go today and let you know how we go.

thanks so much!

Re: FeatureSet not working offline in Field Maps

Scott_Sambell — Wed, 20 Apr 2022 19:13:12 GMT

@WillyG Try this.

Re: FeatureSet not working offline in Field Maps

Scott_Sambell — Wed, 20 Apr 2022 21:12:15 GMT

Looks like you've done it Aaron! Its working offline and syncing.

Thanks so much, you are a legend. Can't wait to get it out there and start using it!

Re: FeatureSet not working offline in Field Maps

KelseySmuczynski — Wed, 27 Apr 2022 20:28:36 GMT

Hi Aaron,

I also have the issue of my calculated expression not working in offline mode. I updated my expression by casting my GUID as you suggested, but when I tested it I received an error message, Execution Error: Error. Below is my code (with the casted GUID) that threw the error. Also attached is a screenshot with the error message.

var ref_guid= upper ($feature.GUID) if(ref_guid == null) { return null } var wells_fs=FeatureSetByName($map,"Wellsites2") var wells_filter = Filter(wells_fs, "GlobalID = @ref_guid") var well = First(wells_filter) if (well == null) { return null } return well.Well_Name

Any suggestions on how best to resolve or work around this issue?

Re: FeatureSet not working offline in Field Maps

RhettZufelt — Wed, 27 Apr 2022 21:10:11 GMT

Testing == null does not seem to catch null/empty values.

What happens if you replace the two if statements with similar code as below (and in Aarons post above):

if (variable == null){ with if (IsEmpty(variable )) {

Also, look at your filter statement. It appears as if you are just filtering for "GlobalID = @ref_guid" which would only match if the value of that cell = "@ref_guid" and not substituting the variable value.

Suspect it is looking for something more like the previous examples in this post:

var subset = filter(wells_fs,`GlobalID = '${ref_guid}'`);

Re: FeatureSet not working offline in Field Maps

KelseySmuczynski — Wed, 27 Apr 2022 23:06:35 GMT

Hey Rhett,

Thanks for the quick reply. I tried your suggestion (code below), but still received the same error.

var ref_guid= upper ($feature.GUID) if(ref_guid == null) { return null } var wells_fs=FeatureSetByName($map,"Wellsites2") var wells_filter = Filter(wells_fs, `GlobalID = '${ref_guid}'`) var well = First(wells_filter) if (IsEmpty(well)){ return null } return well.Well_Name

Also, just to clarify, my initial code (below, just in case) was successfully populating fields in my inspection form with info from my related feature class. It stopped working when I created and used an offline map for data collection.

//Initial code that was successful in non-offline mode. var ref_guid= $feature.GUID // <---No upper casting if(ref_guid == null) { return null } var wells_fs=FeatureSetByName($map,"Wellsites2") var wells_filter = Filter(wells_fs, "GlobalID = @ref_guid") var well = First(wells_filter) if (well == null) { return null } return well.Well_Name

Kelsey

Re: FeatureSet not working offline in Field Maps

KelseySmuczynski — Thu, 28 Apr 2022 00:07:24 GMT

Oops, looks like I missed applying the IsEmpty function to the ref_guid in line 3. I updated my code as shown below and it tested without issues. I'll still need to see if the changes applied to my offline maps, but will report back soon.

UPDATE: IT WORKED!

Thanks, @RhettZufelt and @Anonymous User . You guys are rock stars.

var ref_guid= upper ($feature.GUID) if(IsEmpty(ref_guid)) { //<-- applied IsEmpty()here return null } var wells_fs=FeatureSetByName($map,"Wellsites2") var wells_filter = Filter(wells_fs, `GlobalID = '${ref_guid}'`) var well = First(wells_filter) if (IsEmpty(well)){ return null } return well.Well_Name

Re: FeatureSet not working offline in Field Maps

AnthonyJonesRSK — Mon, 03 Oct 2022 09:09:03 GMT

Hi Aaron,

Just wanted to say a big thank you for this suggestion as it has helped me immensely. Last week I was pulling my hair out as I've been trying to pass globalids to the parentglobalid field in another feature using the intersection function so I could create relationships between the two features if they intersect (save the user having to add related records manually). I kept finding that the globalid would calculate sporadically and couldn't work out what the issue was. In my case I found that using the Lower() function on my globalid has solved it so again big thanks for this, it's been a life saver!

Thanks

Anthony

Re: FeatureSet not working offline in Field Maps

Samuel_McAuley — Fri, 31 May 2024 00:52:47 GMT

I am experiencing a similar issue with FeatureSetByName not working offline. In this example, I am attempting to use the user property 'username' to lookup a staff ID number in a standalone lookup table within the map. I know that only certain user properties are available offline using GetUser($layer), but username is definitely one of them as I can return that no problem. The issue is when I try to filter the lookup table using that property. Online it executes without a hitch, however offline it is returening 0 records. I have tried returning the staff ID and also just the count of records returned from the filter function. The count consistently returns 0 when offline and 1 when online.

Below is my code snippet.

var me = GetUser($layer).username
var lut = FeatureSetByName($map,"staff_LUT")
var filtered = Filter(lut, 'label2 = @me')
return First(filtered).name

In addition to this, I tried to just reference the table and return the count of records in it (see below), and when online it returned 184 as expected, however offline it returned 0.

return count(FeatureSetByName($map,"staff_LUT"))

Any advice would be greatly appreciated

Re: FeatureSet not working offline in Field Maps

RhettZufelt — Fri, 31 May 2024 18:48:33 GMT

there are some issues with GetUser() in Field Maps app. Try this to see if it gets the username for you:

var me = GetUser(FeatureSetByName($map,"staff_LUT")).username var filtered = Filter(lut, `label2 = '${me}'`)

Also, remember that if offline, a count (or any other operation) will only work on the features that are currently 'downloaded' into you offline area. Is it possible that the offline are you are testing is outside of the 184 points in the data?