topic Re: Ask about the Related table came from the repeat table in Survey123 for ArcGIS, How to show its data in pop-up?String fields or numeric,both! in ArcGIS Survey123 Questions

Ask about the Related table came from the repeat table in Survey123 for ArcGIS, How to show its data in pop-up?String fields or numeric,both!

AlainMunyaneza1 — Sun, 27 Oct 2019 10:33:00 GMT

Hello, I am called Alain Roland Munyaneza. I continue to have an issue with how to get the data from the related table came from the repeat table table in survey123. I tried to follow similar arcade expressions from questions that were asked here from GeoNet but I do not get the fields! In fact, I have two separate tables that I want to show in each table the data that are in. I have one table for owners and another for areas. I want all these data in pop-up. For the first table, I want to the Owner first name and the Owner Family Name. I tried to use the FeatureSetbyRelationshipName function but it doesn't give out. I tried to use too FeatureSetbyName and FeatureSetbyID but all I do not get. When I follow the example given here for arcade, I put ParentGlobalID for the parent layer and GlobalID for the table but it doesn't work. Does anyone guide me how to do this?

Re: Ask about the Related table came from the repeat table in Survey123 for ArcGIS, How to show its data in pop-up?String fields or numeric,both!

AlainMunyaneza1 — Sun, 27 Oct 2019 23:00:29 GMT

I used this label and it is showing in pop-up but not in dashboard. What is the problem?

var results = $feature["globalid"];

var sql = "parentglobalid = '{" + Upper(results) + "}'";

Console(sql);

var tbl = FeatureSetByName($map,"service_71239bb2bb8c4d13a46fa8f038cceec6 - Owners");

var related_data = Filter(tbl, sql);

var cnt = Count(related_data);

var result = cnt + " related records";

if (cnt > 0) {

for (var row in related_data) {

var line = TextFormatting.NewLine + row.OwnerFirstName + " " + row.OwnerFamilyName;

result += line;

}

} else {

result = "No related records:";

}

return result;

Re: Ask about the Related table came from the repeat table in Survey123 for ArcGIS, How to show its data in pop-up?String fields or numeric,both!

JamesTedrick — Mon, 28 Oct 2019 21:46:05 GMT

Hi Alain,

This might be better addressed by Operations Dashboard for ArcGIS‌

Re: Ask about the Related table came from the repeat table in Survey123 for ArcGIS, How to show its data in pop-up?String fields or numeric,both!

DougBrowning — Sun, 12 Dec 2021 10:19:25 GMT

It could you changing to upper case on the globalid? Not sure why that would be needed.

I would also check the name of the layer. Try remaming it in the map to a shorter name like just Owners.

You can also clean up the code a bit by writing this way.

var sql = "PlotKey = '" + $feature.PlotKey + "'";
var tbl = Filter(FeatureSetByName($map,"GAP"), sql);

var txt = ''
for (var f in OrderBy(tbl,"LineNumber")) {
    txt = txt + f.LineNumber + ' '
}
txt = Left(txt,Count(txt)-1)
if (txt != '1 2 3') {
    return "\n----Gap Line Number Issue! Found: " + txt
}
else {
    return ''
}
}
else {
    return ''
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The other option is to create a relationship class in your service between the two. Then the Pop up attribute box will have all the related records there for you automatically.

Hope that helps.

Re: Ask about the Related table came from the repeat table in Survey123 for ArcGIS, How to show its data in pop-up?String fields or numeric,both!

AlainMunyaneza1 — Wed, 30 Oct 2019 08:15:22 GMT

Hey, James & Doug,

It accepted after with another trial but Thanks all for your directions.

Re: Ask about the Related table came from the repeat table in Survey123 for ArcGIS, How to show its data in pop-up?String fields or numeric,both!

Amanda__Huber — Tue, 08 Dec 2020 20:05:59 GMT

var tbl = FeatureSetByName($map,"service_71239bb2bb8c4d13a46fa8f038cceec6 - Owners");

@AlainMunyaneza1 I think you need to use the $datastore global to pull S123 repeats/related records into your arcade. Similar to this:

Hopefully that helps and works for you too!