topic Re: Create direct link to add related records in Field Maps in ArcGIS Field Maps Questions

Create direct link to add related records in Field Maps

ajohnson_wsb — Wed, 17 Apr 2024 14:24:43 GMT

I'm looking to simplify the way that users have to add related records in Field Maps. I know that on the parent asset, a user can click the related link at the bottom and then click Add, etc. but I am looking to give users a "button" or something so that they can directly open a new related record. The goal is to limit how many times users have to click through boxes when adding new related records

At the Dev Summit last month, Esri showed a way to do this with Arcade and HTML but the presentation missed pieces in the demo that showed all of the code in order to replicate. Recording of the presentation is below:

https://registration.esri.com/flow/esri/24epcdev/deveventportal/page/detailed-agenda/session/1699036863110001H9sB

If anyone has successfully done this please let me know. Thank you!

Re: Create direct link to add related records in Field Maps

ChristineTombleson1 — Wed, 17 Apr 2024 21:24:08 GMT

I have the same question! I have many related tables and would love to be able to create my own button instead of the user having to go in an use the Add button. I appreciate you sharing the Dev Summit link but unfortunately if you did not register to go to the Summit, you can't access it. I couldn't access it with just my ESRI username and password.

Re: Create direct link to add related records in Field Maps

Teresa_Blader — Fri, 19 Apr 2024 20:32:20 GMT

I think the main thing left out of the video is the rest of the URL parameter in the values variable as well as the HTML code for the button in the URL parameters. I think Kevin was going to do a blog at some point. I'm also working on this these days 🙂 But I haven't attempted yet.

@KevinBurke

Re: Create direct link to add related records in Field Maps

ajohnson_wsb — Fri, 31 May 2024 21:29:27 GMT

Video of Esri performing this workflow is now publicly available here: https://mediaspace.esri.com/media/t/1_v2ev8meu

Re: Create direct link to add related records in Field Maps

KeitherPerkinsWSB — Tue, 04 Jun 2024 21:18:31 GMT

I am also seeing some odd behavior with the HTML configuration for the button from this code. I replicated the HTML portion from this demo to add a button simply pointed at https://google.com for now. When the Arcade expression is present in the webmap it appears in my pop up and is functional. However, when trying to save the map I get the below error.

If I remove the Arcade Expression, the map saves. I cannot seem to find anything where this html code is not supported. Any insight here would be great.

It also presents itself as a 403 error in the F12 console where it looks like the map config cannot be written to the Portal Directory.

I have stripped everything out of the webmap except this single layer, and have the popup config to only have this arcade expression but same save error in a fresh map as well.

//Temp URL for testing button var url = "https://www.google.com" //HTML button to trigger url return{ type : 'text', text : ` <div style="padding: 0px 0px;"> <table style=" border-collapse: separate; border-spacing: 0px 0px; width: 100%; table-layout: fixed; margin-bottom: 8px;"> <tbody> <tr> <td style="text-align: center; width: 100%"> <a href="${URL}" target="_blank" style="background-color:#00304d;color:#FFFFFF;display:block;margin:0px auto;padding:10px;text-decoration:none;valign:center;width:220px;">MV Cable</a> </td> </tr> </tbody> </table> </div> ` }

Re: Create direct link to add related records in Field Maps

ajohnson_wsb — Wed, 24 Jul 2024 13:35:14 GMT

I was able to get a resolution for this workflow, many thanks to meeting with the Field Maps Team during the Esri UC. First this workflow is described on Field Maps documentation that I missed previously.

https://doc.arcgis.com/en/field-maps/latest/prepare-maps/deploy-your-map.htm#ESRI_SECTION1_F7DE2402BA8743E5BFC4A1241072960E:~:text=Add%20a%20related%20feature

Here is my final arcade expression that works. In my case, one issue I was having was the curly brackets of my GlobalID field were being "pushed" into the uuid field of my child record table and Field Maps adds those curly brackets already so the link failed without stripping the curly brackets as seen below.

var itemID = //item id of web map; var featureSourceURL = //feature service url of parent asset var featureID = Replace(Replace($feature.GlobalID, "{", ""), "}", "") //globalid field of parent asset, with stripping of curly brackets var foreignKeyField = 'GlobalID' //globalid field of parent asset var referenceContext = 'addRelatedFeature' var values = 'referenceContext='+referenceContext+'&itemID='+itemID+'&featureSourceURL='+featureSourceURL+'&featureID='+featureID+'&foreignKeyField='+foreignKeyField var url = "https://fieldmaps.arcgis.app/?" + values; return url

I was never able to get the html button to work like @KeitherPerkinsWSB described. I got the same error message of "Unable to add layer". To get around this and still have a clean button for staff (instead of the long url), I added a text box and created a hyperlink to the expression field.

Re: Create direct link to add related records in Field Maps

LeighStarr — Fri, 20 Dec 2024 22:28:38 GMT

I am getting an error: "The specified foreign key field couldn't be found".

I am a little confused... there isn't anything pointing to the child in the relationship. Everything points to the parent, including the source URL. I would have thought that the foreign key would point to the child, but the comments clearly state parent...

For the relate, both are branch versioned, with the Primary Key of the Parent feature class: 'GlobalID', and the Foreign key in related feature class: 'CAB_GUIID'

With the parent primary key as 'GlobalID' my entry into the expression builder is:

var featureID = Replace(Replace($feature.GlobalID, "{", ""), "}", "") //GlobalID field of parent asset

var foreignKeyField = 'GlobalID'; //GlobalID field of parent asset

On a somewhat related note, if I have multiple relates, how would it know which one to add?

What am I missing here?

Re: Create direct link to add related records in Field Maps

ahargreaves_FW — Fri, 31 Jan 2025 14:55:00 GMT

@ajohnson_wsb thanks for providing this!

Re: Create direct link to add related records in Field Maps

ZachBodenner — Thu, 20 Mar 2025 15:17:03 GMT

I've been able to get almost everything working except for my Field Maps to actually open up the related record add.

Using this code I'm able to pop open the correct map, with the correct feature selected and zoomed to, popup opened, but no related record add. No errors either, so I can't quite pin down the issue. Has anyone else run into that particular case?

Re: Create direct link to add related records in Field Maps

ChristopherCounsell — Sun, 27 Jul 2025 11:01:25 GMT

Hi @ZachBodenner , it's a bug

https://support.esri.com/en-us/bug/when-using-a-url-to-open-and-create-a-related-record-fo-bug-000175355

Doesn't occur in the beta for the big fall release.

Re: Create direct link to add related records in Field Maps

ZachBodenner — Mon, 28 Jul 2025 13:24:12 GMT

You're the best! I'll be looking forward to experimenting with it.

Re: Create direct link to add related records in Field Maps

dhertel — Thu, 20 Nov 2025 23:25:27 GMT

@LeighStarr Did you ever find an answer to this question? I also have multiple tables relating to my parent feature class, and I don't understand how this expression is supposed to know how to select any of the child tables to create a new record in. The URL generated by the expression doesn't do anything for me. I've tried using the specific FeatureID url's for for the related table, but that doesn't work either.

Re: Create direct link to add related records in Field Maps

GeorgeAtkins — Tue, 10 Feb 2026 22:27:57 GMT

Did anyone find a solution for when you have multiple relates? Seems crazy that no-one at Esri thought to allow a way to select with relation.