topic Re: Related Tables in ArcGIS Workforce Questions

Related Tables

MichelleDuncan2 — Wed, 18 Dec 2019 18:56:00 GMT

Is there a way to view related tables/info in Workforce? I can see the table in the AGOL Dispatcher/Worker maps but I don't see the table when viewing the map through the Workforce web/mobile app.

Thanks,
Michelle

Re: Related Tables

CraigGillgrass — Tue, 07 Jan 2020 21:51:37 GMT

Michelle,

This is not currently supported.

It will be supported in the next release in the Workforce mobile app; but we don't have any plans to add it to the web app.

Craig

Re: Related Tables

MichelleDuncan2 — Wed, 08 Jan 2020 16:30:15 GMT

That's unfortunate since some of our users/dispatchers are only using this Workforce platform for their GIS needs. These people are not GIS savvy and asking them to go to other platforms is frustrating to them and not an option.

Re: Related Tables

CraigGillgrass — Wed, 08 Jan 2020 17:32:47 GMT

Hi Michelle,

Can you go into some detail on the use case for a Dispatcher to be able to view the related records for features within the web app? This isn't a request we've really heard much demand for, understanding why your dispatchers need it will help with this.

Craig

Re: Related Tables

MichelleDuncan2 — Wed, 08 Jan 2020 17:46:00 GMT

Our Gas/Light meters, transformers, etc all have related tables for each individual unit. For example, a meter setting (geographic location) with a meter unit related to that location. For apt complexes there can be quite a few meters related to that one point. In order to see what meter is there they have to go to another web map or desktop to see where to place the Workforce assignment. The field crews also have to switch to Collector to see the meter unit info. It would be much easier to have all that info in one platform, the Workforce desktop/mobile app.

Re: Related Tables

CraigGillgrass — Wed, 08 Jan 2020 21:23:42 GMT

Thanks Michelle,

For Workforce mobile, we'll be launching the Beta for the new Workforce release tomorrow. It will include support for related tables in the mobile app. Would love to hear if it meets your needs.

For the Workforce web app, is it correct that, the reason the Dispatcher needs to see what meter is there is so they can create an assignment referencing that meter information?

Craig

Re: Related Tables

MichelleDuncan2 — Wed, 08 Jan 2020 21:36:54 GMT

Yes the individual meter serial #, manufacturer, size, meter read, install date, location or apt #, etc will be in the related meter unit table.

Re: Related Tables

TimFlynn — Wed, 26 Feb 2020 20:08:40 GMT

I'd also like to see this capability implemented. I'm currently working on a storage tank inspection workflow. Currently, I've created a web app with Web App Builder where a field worker can tap on a storage tank point and then there are 3-6 different inspections that are linked. The inspections are performed with Survey123 and that data is written into related tables. Different inspections are performed monthly, quarterly, or annually. Currently, there's no way for me to symbolize if a tank needs to be inspected without having the user also update a field in the tank location layer. If I could use workforce to create work orders for inspections that are coming due, that would be great.

Re: Related Tables

AnthonyRyan — Wed, 09 Sep 2020 15:33:36 GMT

I would also like this implemented for the web application. I am currently working on a Complaint Tracker. We are looking to have complaints possibly submitted via Survey123. I was hoping to use Workforce for one or a small few personnel to assign the complaints to which ever specific division or divisions they need to go to. The dispatcher role looked great for this, until I found out it does not work with related tables. Our current structure would be the complaint is a feature class. The information about who it is assigned to, along with status and completion date, is in a related table. Any one complaint could have multiple divisions to work on them, along with different sub complaints or remediation, which would be in a related table. So far, I have not found another Esri platform to do this via web.

Re: Related Tables

MDuncan — Wed, 16 Dec 2020 23:43:08 GMT

Did this ever get implemented? I'm not seeing this function in either of the workforce mobile apps?

Re: Related Tables

April_Kibby — Tue, 02 Mar 2021 14:43:26 GMT

I would also love to be able to access data in a related table viewable in the Dispatched Web App. We have setup workforce for a handful of waste water treatment plants and most of the wwtp asset data is stored on the related table level. Larger assets and system processes make up the features on the map. We currently are using the assignment name to populate the related asset list and the description for the assignment to list the assignment. Really isn't ideal and leaves no room for creating a list of tasks within the description.

Re: Related Tables

KellyArmstrong — Thu, 15 Apr 2021 20:29:37 GMT

We store all of our maintenance / inspection data in a feature's related table.

It's more than frustrating that in Workforce, there is no way to point Workforce to save all of this assignment/maintenance/service data in the related tables. It just creates another feature service with all the data......

Re: Related Tables

KellyArmstrong — Thu, 15 Apr 2021 21:30:36 GMT

Craig,

Workforce has one MAJOR downfall, related to related tables:

As a city, we store all of our maintenance / inspection / service data in a feature's related table.

It's more than frustrating that there is no way to point Workforce to save all of this assignment/maintenance/service data in the related tables. It just creates another feature service with all the data. We already have a feature service, which we used to create the assignments - by selecting the features. Why would we need another one?