URL link from related table in popup?

oakmn

I have a related table with a URL field.  I have tried in Arcade to pull those related links and place them in the popup, with no success.  The reason I am trying to do this instead of clicking on the "show related records"  in the popup - is that having crews use this route, is two less clicks for them to navigate out in the field.  They would like the fastest route to be able to click on the URL link.

Any help would be greatly appreciated.

I have attached a screenshot of my related table with fields:

related_table.PNG

Screenshot 2024-05-20 130129.png

jcarlson

You can have Arcade generate a linkable URL, but you can't do it in a list.

If your popup is a field list, an expression that evaluates to a URL will show as a list. If your popup is a custom arrangement of HTML, there's no way to return a list of URLs as interactive links, as the expression will evaluate as text.

A workaround (though not an ideal one) is to have a series of expressions that look for "related record X" and return a URL if a record exists at the index value X, otherwise return nothing. In a custom attribute display, you could have all of your expressions appear one after the other.

The big issue with that workaround is that a FeatureSet cannot be sliced by an index the same way an array can. The following code is not pretty, but it works.

var rel = FeatureSetByRelationshipName($feature,"relationshipname", ['url_field'], false)

function get_index(x, fs){
    if(Count(fs) > x){
        var i = 0
        for(var f in fs){
            if(i == x){
                return f['url_field']
            }
            i ++
        }
    }
}

get_index(0, rel)

And you could create a series of expressions, just changing the number in the final get_index function each time.

Set the text and the URL to the same thing. That way, the link simply won't appear if there is no record at that position.

Create a long string of expressions in the custom display.

a feature with two related records

a feature with a single related record

I didn't have a URL field, so I just appended the ObjectID to "google.com" to test, but it should work the same.