Latest Contributions by AJM

@XanderBakker  I am trying to do something similar and calculate the the change in lake level from the most recent reading to the previous reading. I tried the code and just changed the feature and date fields to start with and get and error at the ; at the end.  Test execution error: Unexpected token '${value}'.. Verify test data.   // get related records var fs = FeatureSetByRelationshipName($feature, 'lake_level'); // sort the related records and get top 2 fs = Top(OrderBy(fs, '_date DES'), 2); // get the latest and previous features var result = Null; if (Count(fs)==2) { var cnt = 0; for (var f in fs) { cnt += 1; if (cnt == 1) { var f_latest = f; } else if (cnt == 2) { var f_prev = f; } } // determine NewCasesToday and calculate increment var cases_latest = f_latest.NewCasesToday; var cases_prev = f_prev.NewCasesToday; result = cases_latest - cases_prev; } // return the result return result;     Any help would be appreciated. Thanks ... View more

Unfortunately not yet.  ... View more

How are you copying it? If you try to copy and past the excel file you will run into issues. You can save a copy from the the Connect app by click on the 3 dots.    https://doc.arcgis.com/en/survey123/browser/create-surveys/createsurveys.htm ... View more

Here is the expression : // first read out the ID of the selected feature (the primary key of the relationship in the parent layer, in this case "globalid") var id = $feature.globalid; // access the related table (in this example "relatedtable" is the name of the related table/layer on the map) var tbl = FeatureSetByName($map, "SCCF_Wildlife_Sightings_view_for_web - observations"); // create a sql expression to query related records based on the primary key and the foreign key for the relationship (in this case, "globalid" from the parent layer, and the "parnetglobalid" from the related layer/table) var sql = "parentglobalid = '" + id + "'"; // filter the table using the sql expression var related_data = Filter(tbl, sql); // return an attribute value from the related record (objectid and id of the first attachment) for (var row in related_data) { var reloid = row.objectid;} var AttachID = First(Attachments(row)).ID // other url parameters (Part1 is the REST URL of the hosted feature layer var Part1 = "https://services8.arcgis.com/7G8krbiqT95v3p7f/arcgis/rest/services/SCCF_Wildlife_Sightings_view_for_web/FeatureServer/1/" var Part2 = "/attachments/" //construct the attachment url var url = Part1 + reloid + Part2 + AttachID //return the url for the attachment return url Here is a link it returns: https://services8.arcgis.com/7G8krbiqT95v3p7f/arcgis/rest/services/SCCF_Wildlife_Sightings_view_for_web/FeatureServer/1/8/attachments/1   That is the correct URL and if I click on it from the attribute table it opens with a token at the end. I have shared the featured class publicly so I don't know why it does not work without the token.   Thanks ... View more

If you make a join and check the box to" Create results as hosted feature layer view" it should update when new data is entered. ... View more

No, I have not made the upgrade yet, so I have not try to get it to work.  ... View more

I spent over 3 hours trying to figure this same problem out, until I found your post. Hopefully they will get it fixed soon ! Thanks! ... View more

@Robert_LeClair Any update on this feature for ArcGIS Pro? I see that it has been implemented for the Online maps.  Thanks ... View more