Is there a way to edit the foreign key field in a related table in Field Maps?

WilliamMertens — Fri, 05 Nov 2021 01:13:28 GMT

Hi all,

I have a set of points with a related standalone table for tracking inventory items (laptops, furniture, etc.) in a school at the room level. In this case, UNIT_ID (per the ArcIndoors data model) serves as the key.

I'm intending for the staff members to use Field Maps to create and update item records, but reassigning an item to another room requires editing the foreign key. Field Maps, at least how I currently have it set up, does not allow you to edit the foreign key in a related table.

I would just create a duplicate field then update the foreign key using an attribute rule, but but my understanding is attribute rules aren't supported in AGOL (yet). The only workaround I can think of is to use a Notebook task to copy over a duplicate field, which is not ideal.

Is anyone aware of a solution to this or another workaround? I'd really like for the entire functionality of this system to work on mobile.

Re: Is there a way to edit the foreign key field in a related table in Field Maps?

CAkoth — Tue, 21 Feb 2023 13:24:23 GMT

Hello, I'm currently experiencing this challenge. Did you find a solution?

Re: Is there a way to edit the foreign key field in a related table in Field Maps?

AHand — Tue, 07 Mar 2023 17:10:40 GMT

I did some more digging after asking this question and found that Field Maps does not support changing the foreign key. You can change it in a web app if that workflow would work for you.

topic Re: Is there a way to edit the foreign key field in a related table in Field Maps? in ArcGIS Field Maps Questions

Is there a way to edit the foreign key field in a related table in Field Maps?

Re: Is there a way to edit the foreign key field in a related table in Field Maps?

Re: Is there a way to edit the foreign key field in a related table in Field Maps?