topic Re: Arcade code help. Add prefix, suffix, and new line and parse by comma in Developers Questions

Arcade code help. Add prefix, suffix, and new line and parse by comma

JohnDriessen — Fri, 17 Sep 2021 21:49:14 GMT

Hi folks, I have an Arcade attribute expression puzzler.

A bit of background, I've created an attribute expression to display "Permit Numbers" from a related table in the feature service pop-up. My only problem is that I need to add the URL prefix and suffix to those numbers to create the hyperlink as well as a NewLine.

//code sample

//Attempt 2
//join field id
var id = $feature.ParcelID;
var relatedtable = FeatureSetById($datastore, "1");
var filtereddata = Filter(relatedtable, "ParcelID = @id");
var permits = []
var index = 0;
for (var permit in filtereddata) {
permits[index] = permit["PermitNumber"];
index++;
}

return Concatenate(permits, ',')

//result pop-up

Permit Numbers

2013-MSS-SWR-00211,EXC120338,EXC02-1861,EXC052208,2016-MSS-SWR-00488,13928,21394,2013-MSS-EXC-00009,2013-MSS-EXC-00305,2016-MSS-EXC-00742,2016-MSS-EXC-00743

//new format needed

https://asbuilts.ci.missoula.mt.us/scards/2013-MSS-SWR-00211.pdf

https://asbuilts.ci.missoula.mt.us/scards/EXC120338.pdf

Re: Arcade code help. Add prefix, suffix, and new line and parse by comma

DavidPike — Sat, 18 Sep 2021 16:32:33 GMT

Not too sure on the newline. re prefix and suffix, I don't know if I'm missing something so apologies if I've misunderstood.

edit, maybe try just + '\n' also or '\r\n' or "\x0d\x0a" - Solved: Arcade Text Constant for TextFormatting.NewLine is... - Esri Community

permits[index] = 'https://asbuilts.ci.missoula.mt.us/scards/' + permit["PermitNumber"] + '.pdf'

Re: Arcade code help. Add prefix, suffix, and new line and parse by comma

JohannesLindner — Mon, 20 Sep 2021 06:19:39 GMT

var id = $feature.ParcelID; var relatedtable = FeatureSetById($datastore, "1"); var filtereddata = Filter(relatedtable, "ParcelID = @id"); var permits = [] var url_pre = "https://asbuilts.ci.missoula.mt.us/scards/" var url_post = ".pdf" for (var permit in filtereddata) { permits[Count(permits)] = url_pre + permit["PermitNumber"] + url_post // in ArcGIS Pro 2.8 or later you can do // Push(permits, url_pre + permit["PermitNumber"] + url_post) } // if you show the popup's normal attribute table, one of these should work return Concatenate(permits, TextFormatting.NewLine) return Concatenate(permits, "\n") // if you show custom HTML code, this should work return Concatenate(permits, "<br/>")

Note that there is currently no easy way for the popup to actually format those urls as links. Your users will have to copy/paste them.