topic Re: Workforce Survey123 integration and date fields in ArcGIS Workforce Questions

Workforce Survey123 integration and date fields

Elizabeth_Burniston — Wed, 17 Nov 2021 23:08:40 GMT

I have successfully integrated Workforce and S123, and used Pro to do some further customization in the table of 'Assignment Integrations'. In this project, as well as others, any custom field I create passes through without fail, but the duedate field will not. I assume it has to do with the fact that it's a date field as opposed to a text field? (fyi- I name the fields in my survey the same as Workforce to keep track of what fields go to what). Below is my URL Template, the bold being my trouble spot.

I initially created the survey using web designer and subsequently noticed the field lengths were different. Thinking that was the problem, I moved the survey into Connect, created a new field, made the field lengths the same... didn't work. I just don't know. Is there something in the URL Template that needs to change? Any help is appreciated.

https://survey123.arcgis.app?itemID=5f3e8aff7bc246afab9f06d3178ea9c4&center=${assignment.latitude},${assignment.longitude}&field:location=${assignment.location}&field:workorderid=${assignment.workorderid}&field:description=${assignment.description}&field:duedate=${assignment.duedate}

Re: Workforce Survey123 integration and date fields

CraigGillgrass — Thu, 18 Nov 2021 14:56:01 GMT

Hi @Elizabeth_Burniston nothing jumps out to me after a quick look at your url scheme.

Can you elaborate on this comment though:
"assume it has to do with the fact that it's a date field as opposed to a text field?"

The "duedate" field in your survey a text field?

Also I'm assuming that the issue is, nothing is written to the "duedate" field in your survey, is that correct?

Re: Workforce Survey123 integration and date fields

Elizabeth_Burniston — Thu, 18 Nov 2021 23:30:47 GMT

Thank you for your reply, @CraigGillgrass . First, the "duedate" field in my survey is a date field. I only thought that something different may be required in the url scheme for attributes in a date field to pass over.

Next, I'm editing my initial response. I removed the integration and reestablished it with the same url as above. Now, it IS passing over a date/time but this is what it returns every time - 1/19/1970 6:00:00 PM.

We are using FME to populate all of the above Workforce fields from another application. The date field populates fine in the feature layer and shows up correct in the Workforce app, just not in S123.

Re: Workforce Survey123 integration and date fields

CraigGillgrass — Thu, 18 Nov 2021 23:42:08 GMT

Hi @Elizabeth_Burniston are you using an iOS or Android device? And what is the release of Workforce that you're using?

thanks, Craig

Re: Workforce Survey123 integration and date fields

Elizabeth_Burniston — Thu, 18 Nov 2021 23:55:53 GMT

iOS and Version 20.1.1

Re: Workforce Survey123 integration and date fields

CraigGillgrass — Fri, 19 Nov 2021 00:01:18 GMT

Thanks @Elizabeth_Burniston - I think you're running into a known bug that we just addressed on iOS with our latest release of 21.0.2 which is on the App Store. Upgrade to that release and please let me know if the issue still persists.

Craig

Re: Workforce Survey123 integration and date fields

Elizabeth_Burniston — Fri, 19 Nov 2021 00:15:33 GMT

Thanks @CraigGillgrass! That worked! Thank you so much for your time and assistance... it is greatly appreciated!