topic Re: Adding custom business logic to Field Maps in ArcGIS Field Maps Questions

Adding custom business logic to Field Maps

BrianBulla — Fri, 03 Nov 2023 18:41:17 GMT

Hi,

I'm just wondering if it's possible to add any logic to field maps. For example, we have features that get yearly inspections so we have a related INSPECTION table to the feature. Each time an inspection happens:

- if this, this and this come up in the inspection, then the STATUS field on the feature needs to be INSPECTED

- or if this, this and this come up in the inspection, then the STATUS field on the feature needs to be WORK REQUIRED

- etc.

Basically, we need to update fields on the feature, based on what fields are filled out on the inspection form. Is it possible to do this??

Currently we are look at VertiGIS Mobile, since it seems to be impossible to get FieldMaps to do this, but I would much prefer to stick with FieldMaps.

Re: Adding custom business logic to Field Maps

KPyne — Fri, 03 Nov 2023 18:56:07 GMT

You cannot perform edits on features outside of the Field Map form (as far as I am aware).

However, I do this exact workflow using Field Maps and webhooks. When our related tables are edited (or created) a webhook trigger pushes an update to the related parent feature. It is not the most straightforward process and I wish Field Maps supported editing parent records out of the box but it is functional for now.

ESRI has a decent guide here

Re: Adding custom business logic to Field Maps

BrianBulla — Fri, 03 Nov 2023 19:00:22 GMT

Great....thanks @KPyne . I never even thought of that. At the Dev Summit I talked to some esri guys about possibly using attribute rules for this but not sure if Field Maps supports that yet or not.

I'll check out that link.

Thanks!!

Re: Adding custom business logic to Field Maps

KPyne — Fri, 03 Nov 2023 19:04:19 GMT

So I think your right about Attribute Rules, but it has to be in an Enterprise/Portal environment (and always connected)? - don't quote me on that, hopefully someone can chime in.

Re: Adding custom business logic to Field Maps

gis_KIWI4 — Mon, 06 Nov 2023 21:52:26 GMT

@KPyne is right. Attribute rules won't help unless we are talking about desktop (ArcGIS Pro) / Enterprise environment. We have struggled with this exact problem too.

The updates in the related table do not trigger a calculated expression in the parent table.
We use FME to write the calculated result back into the parent table.

Re: Adding custom business logic to Field Maps

BrianBulla — Tue, 07 Nov 2023 13:34:42 GMT

Back sometime in the summer some folks from esri did a Webinar on FieldMaps and mentioned how the Attribute Rules functionality was in an upcoming release. They were a little fuzzy on details though like working when disconnected, etc.

With the webhooks what sort of issues have you come across? What sort of backend setup do you need for it to work properly? I believe we are still at Enterprise 10.8, and I was hoping to get this to work in our Portal, not AGOL.

Re: Adding custom business logic to Field Maps

BrianBulla — Tue, 07 Nov 2023 14:04:43 GMT

Hi....so I'm just working through the webhooks sample in the blog. From what I'm reading, as soon as I enable the Editing tracking on the FeatureService, I should be able to see the "WebHooks" option when viewing the feature services URL.....but I don't see that. Can anyone explain how to get "WebHooks" enabled on the feature service??

I'm going through the tutorial here: https://www.esri.com/arcgis-blog/products/field-maps/field-mobility/use-webhooks-to-automate-workflows-in-arcgis-field-maps/

Re: Adding custom business logic to Field Maps

KPyne — Tue, 07 Nov 2023 14:47:16 GMT

You are close. You have to open that page in Admin mode, which ESRI added a convenient button for at the top right of the page. Should just be able to click it and it will refresh the page

Re: Adding custom business logic to Field Maps

KPyne — Tue, 07 Nov 2023 14:56:13 GMT

I am pretty sure webhooks are possible in Portal - but I do not know the pros/cons and only have experience setting them up in AGOL.

Once they are setup we use Make.com or Power Automate to build triggers against them

Re: Adding custom business logic to Field Maps

BrianBulla — Tue, 07 Nov 2023 16:10:04 GMT

Thanks....so for the Authorize URI and the Token URI, where do I find this information?? I am in my developer account, and see the App ID and App Secret, but not sure where to find these URIs.

Re: Adding custom business logic to Field Maps

BrianBulla — Tue, 07 Nov 2023 16:11:25 GMT

I've setup a Make.com account, so just working through the tutorial. Thanks for your help with this!

Re: Adding custom business logic to Field Maps

DougBrowning — Tue, 07 Nov 2023 16:28:10 GMT

No you cannot symbolize by a related table using Arcade since it gets to slow. For me I have had luck making the related table a feature class instead. Then I can just map the inspections instead with them on top of the other points. We even use little check marks sometimes. It also shows us cases where the inspector picked the wrong parent and spatial collection on the child shows us this right away. No real advantage to have it a table so make it a feature class.

Other option is old school Python script that runs on a schedule and clacs the parent fields. So basically attribute rules on a timer.

Hope that helps.