topic Re: Pass Global ID from Collector to G in ArcGIS Survey123 Questions

Pass Global ID from Collector to G

KevinKozak — Thu, 25 Jan 2018 15:24:01 GMT

Has anyone been able to pass the Global ID from a service in Collector to the related GUID in Survey123 using the URL method?

I have a database relationship of Bridges to Inspections. In addition, Inspections have related Elements. Since Survey123 can only go two deep in relationships I have a service for Bridges in Collector and the Inspections and Elements in Survey123. I have created the Survey123 from the Inspection and Element service.

Re: Pass Global ID from Collector to G

JamesTedrick — Fri, 26 Jan 2018 16:55:32 GMT

Hi Kevin,

What you're asking for is possible. You would need to configure the Bridges layer's pop-up to have a url that includes the GlobalID in the parameters; this is described in Integrate with other apps—Survey123 for ArcGIS | ArcGIS and https://community.esri.com/groups/survey123/blog/2016/07/30/understanding-survey123s-custom-url-scheme . This would go into a hidden field.

There is a known issue with Survey123 receiving the globalid value - it can't process the value if it already has curly braces ( { } ). To get around that, the survey should be designed with 2 fields to handle the globalid value:

The first field (let's cal it "incoming") should be a hidden field (or text, if you want to validate that it's receiving the value) that has a fieldType null (so it isn't submitted to the database. In your case, using an existing feature class, this would be added if you have Survey123 create a form based on the feature class
The second field (parentglobalid) will hold the value, minus any curly braces. This can be a calculate (or again, text for validation checks) question with a formula like:

if(regex(${incoming}, '^\{[\w\-]*\}$'), substr(${incoming},1, string-length(${incoming}) - 1), ${incoming})

The regex detects if the guid is formatted as {1080901b-c30d-411b-a485-151c8f6ad8e6}, if the braces are present, it extracts the portion between the braces, otherwise it passes the guid unaltered. The field type should by of esriFieldTypeGUID.

See the attached sheet for an example of this pattern.

Re: Pass Global ID from Collector to G

KevinKozak — Wed, 31 Jan 2018 20:44:36 GMT

Hello James,

I appreciate your response. I read the articles you provided, they were informative. Being an old GIS dog trying to learn new tricks, I still have some questions.

My goal is to maintain the relationship class between the Bridge service’s GlobalID and the Bridge GUID in the Inspection service. If I have created the survey by importing the Inspection service schema, which has the Bridge GUID already and cannot be seen in the survey as a question, how would I list this existing GUID as a question? Documentation says that reserved fields in a feature layer are not added to the XLSForm, which GloabalID is a reserved word. Adding such a field with the same name would seem to change the Inspection schema and create a new service. Your example calls this the “theguid” in the XLSForm.
How does a GlobalID and GUID work if the curly brackets are removed?

Below is my thought process based upon your suggestions.

Bridge feature service has GlobalID field.
Inspection feature service has a GlobalID and brdg_guid fields.
In the Survey123 form have the following questions added:
- brdg_guid_txt as type null
- brdg_guid as type esriFieldTypeGUID and the calculation for the regex statement
Have Collector Bridge popup as: arcgis-survey123://?itemID=fe06d025e41a4ceabdb3dd1ba15713c6&field: brdg_guid ={GlobalID}

Thank you for your help,

Kevin

Re: Pass Global ID from Collector to G

JamesTedrick — Wed, 31 Jan 2018 23:58:40 GMT

Hi Kevin,

When Survey123 creates a form based on an existing feature service, it omits the GlobalID and GUID fields as the form rendered (including bridges and inspections) would automatically manage the relationships. When switching to a URL-launched survey, we go from automatic management to manual management. You need to manually add the ParentGUID question manually to accommodate this.
From the question, are you planning to edit the Bridge layer when being launched by a hyperlink? This is currently not supported; opening the app by hyperlink is supported for add only (Inspection form)
Survey123 supports fields with a bind::Esri:fieldType of null - this means that a question will not be submitted and has no effect on the table schemas
The curly braces are added automatically by Survey123, which is why they need to be removed

The URL as you've specified looks to be appropriate for what you're describing.

Re: Pass Global ID from Collector to G

KevinKozak — Tue, 06 Feb 2018 16:44:27 GMT

Hello James,

I was able to implement your suggestions and it worked. Old dogs can learn new tricks. Below is the general outline I used in case someone needs to do the same type of function.

Create database in a file geodatabase with relationship class of Global ID to GUID.
Create ArcMap document with data layers and save as service in AGOL.
Set service to allow editing and share to editing group.
In Survey123 Connect, create new survey by importing service.
In XLS Form add a text question that has a Null field type for holding the related Global ID.
In XLS Form add a text question that has a GUID field type. For the question name, use the same name as the GUID in the service.
For the GUID question use the following calculation to remove the curly brackets from the Global ID. if(regex(${brdg_guid_txt}, '^\{[\w\-]*\}$'), substr(${brdg_guid_txt},1, string-length(${brdg_guid_txt}) - 1), ${brdg_guid_txt})
In AGOL create a web map with the related service to the one in Survey123. Use the following popup line. arcgis-survey123://?itemID=affe05ec8db8448daccb0688c9583ce8&field:brdg_guid_txt={GlobalID}

Thank you for your help. If you are every in Olympia, WA please let me know. I owe you a cup of coffee.

Kevin

Re: Pass Global ID from Collector to G

SuddhaGraves — Mon, 02 Apr 2018 14:05:38 GMT

Hi James,

I have a follow up question associated with this topic. I was able to successfully pass the GlobalID from Collector to Survey123 using the custom url. It works as expected when creating a new record. However, if I try to edit an existing record using the inbox in Survey123, I get a Code 400 send error. After much trial and error, I noticed the GUID field had the curly brackets added back into the value. If I went in and removed the curly brackets during the edit and resubmitted it would successfully update. Otherwise, I get a Code 400 send error. Any thoughts?

Suddha

Re: Pass Global ID from Collector to G

AliciaRitzenthaler — Mon, 02 Apr 2018 19:23:18 GMT

Closely related to the original question, I am trying to pass the GlobalID from Collector features into a Survey123 field called CollectorID.

When the CollectorID field is text this works. When the CollectorID field type is GUID however it appears to work (GlobalD passed, no brackets) but I cannot save the survey. I get the following message:

Any idea how to pass a GlobalID from Collector to a GUID field in Survey123? I am passing the GlobalID to a GUID field because I need to set up a relationship class between the Survey123 and the Collector features based on this passed GlobalID. If someone has an alternative way to get around this I'm also open to that.

Re: Pass Global ID from Collector to G

JamesTedrick — Tue, 03 Apr 2018 19:36:17 GMT

Hi Suddha,

See my comments in https://community.esri.com/message/761251-re-survey123-converting-characters-to-code?commentID=761251&et=watches.email.t… - for working with curly braces in globalids.

Re: Pass Global ID from Collector to G

SuddhaGraves — Tue, 03 Apr 2018 19:54:41 GMT

Hi James,

Thanks for the responding. I have read through the comment you suggested and I verified that I was following the instructions as noted in the comment. The process appears to work when submitting the initial record. However, the problem arises when I have to edit an existing record from the inbox. When editing an existing record, the curly braces are put back on the GUID field. Unless I manually remove the braces, I will receive an error when submitting. I am hoping there is another way to automatically remove the curly braces when editing an existing record.

Thanks,

Suddha

Re: Pass Global ID from Collector to G

JamesTedrick — Tue, 03 Apr 2018 20:01:09 GMT

Hi Suddha,

I would not use a form that takes in the globalid via URL parameters in conjunction with the Inbox - we do not support editing via URL currently. As I mentioned in the comment, the behavior of globalids and curly braces will be addressed in a future release of Survey123.

Re: Pass Global ID from Collector to G

SuddhaGraves — Tue, 03 Apr 2018 20:16:30 GMT

Hi James,

Just to clarify the workflow, I pass the URL from Collector to a new Survey Form. That part works fine. However, if there is ever a need to edit the data in the existing Survey Form, I had planned to allow the user to access it via the Inbox from Survey123. The user would not access the existing data using the custom URL, it would only be accessed via the Inbox.

I look forward to the future release where the behavior of GlobalIDs and curly braces are addressed.

Thanks!

Re: Pass Global ID from Collector to G

ChrisBlinn1 — Wed, 19 Sep 2018 12:24:57 GMT

Can the incoming and parentglobalid fields be hidden? When I set the type to hidden, it doesn't populate the parent GUID.

Re: Pass Global ID from Collector to G

JamesTedrick — Wed, 19 Sep 2018 15:29:07 GMT

Hi Christopher,

Yes the fields can be hidden. I will note that the workaround of having 2 different fields to normalize is no longer needed. Make sure the hidden parentglobalid question has an esrifieldtype of esriFieldTypeGUID.

Re: Pass Global ID from Collector to G

ChrisBlinn1 — Wed, 19 Sep 2018 15:55:55 GMT

So remove the regex as well?

Re: Pass Global ID from Collector to G

ChrisBlinn1 — Thu, 20 Sep 2018 19:16:07 GMT

Update: I was able to get this working with a hidden parentglobalid field - thanks James!

Re: Pass Global ID from Collector to G

ElliottPlack1 — Tue, 30 Oct 2018 03:06:30 GMT

Did you solve this? It is possible the incoming Global ID is not formatted correctly and James Tedrick‌'s answer above could work.

Re: Pass Global ID from Collector to G

ShanaGail1 — Tue, 06 Nov 2018 20:45:12 GMT

Oh nooo... I had totally missed this issue of not being able to edit an existing feature using Survey123. I had plans to incorporate this into the workflow for 2 different projects and need to come up a plan B quickly. We really wanted to have the field inspector fill out a Survey. Is there an elegant workaround? Is the functionality in a project plan?

Thanks,

Shana

Re: Pass Global ID from Collector to G

JamesTedrick — Thu, 08 Nov 2018 17:47:03 GMT

Hi Shana,

I'm a little unclear - Survey123 can edit an existing record via the Inbox. Are you asking about editing an existing feature via URL (somewhat implied by posting in this conversation)? If so, that is not currently possible. This is something that we do plan to support in the future.

Re: Pass Global ID from Collector to G

ShanaGail1 — Thu, 08 Nov 2018 19:26:08 GMT

Hi James,

Yes, I would like to edit an existing feature via URL. The workflow is that a user clicks on an existing electric conductor using Collector, which then opens a survey by which they change an attribute of that existing feature. The survey was created using that hosted feature service.

Since we can't do that, I have 2 questions -

* Do you have a workaround using a similar workflow?

* When is the functionality going to be supported?

Thanks,

Shana

Re: Pass Global ID from Collector to G

JosephGrossman — Fri, 01 Mar 2019 15:11:42 GMT

Hi James,

Thank you for all your advice throughout these forums. I am trying to create polygon, line or point features that collects a location and information in collector, than using the custom URL scheme pass the GlobalID and some information to a more detailed survey with repeats.

I wanted this Survey to publish data to the same feature service (different feature class and table) of the original feature so it can be related to the survey results in AGOL. I was able to make this work creating relationship files and publishing the Survey123. I was able to create the custom url and pass the global ID through to survey123 using the "if(regex(${incoming}, '^\{[\w\-]*\}$'), substr(${incoming},1, string-length(${incoming}) - 1), ${incoming})" formula.

My tests have shown that it works though the windows web interface and on IOS, but it will not pass the GlobalID though using Android. I am on Android 9 using the "Collector for ArcGIS" and Collector (BETA), as well as using Survey123 (4.1) as well as Survey123 (Classic). Any advice? Thanks! Joe