topic Re: Link from ArcMap to a submitted Survey123 form in ArcGIS Survey123 Questions

Link from ArcMap to a submitted Survey123 form

JasonCyphers — Thu, 22 Apr 2021 13:44:36 GMT

Is there a way to hyperlink to an already submitted Survey123 form, from ArcMap, so that edits can be made to the survey form?

Field users use Survey123 to submit a request to engineering to review something, which places a point in ArcMap. Once Engineering reviews the point in ArcMap, I'd like to include a hyperlink script that would allow ArcMap users to utilize the hyperlink tool to reopen the already submitted Survey123 form, to be able to enter a response... similar to how one would open a survey from 'Sent' or 'Inbox' in the Survey123 app.

Re: Link from ArcMap to a submitted Survey123 form

Andrew-Bowne — Thu, 22 Apr 2021 15:21:59 GMT

Sure, you can link out to a webform for the submitted response. Check out this blog:

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-web-form-url-parameters/ba-p/894722

The section: "Edit existing records and opening surveys in view-only mode (mode)" will be most relevant for you.

Re: Link from ArcMap to a submitted Survey123 form

JasonCyphers — Thu, 22 Apr 2021 17:03:27 GMT

Great, thanks!

I entered to following into the hyperlink script of the feature in ArcMap:

Function OpenLink ([globalid])
Dim path
Dim objShell
path = "https://survey123.arcgis.com/share/surveyid?portalUrl=https://my_company's_portal_website&mode=edit&globalid="&[globalid]
Set objShell = CreateObject("Shell.Application")
objShell.ShellExecute path, "", "", "open", 1
End Function

Finally got it to open the Survey123 web form; however, when that link opens, I get:

and none of the attribute information submitted by the previous person is populated.

Looking at the URL in the web browser, it appears correct. The record's globalid is, in fact, at the end of the URL string.

Re: Link from ArcMap to a submitted Survey123 form

Andrew-Bowne — Thu, 22 Apr 2021 17:06:59 GMT

Check your syntax in your URL - I believe it is cAsE SeNsItiVE....

you have "globalid=". I think it needs to be: "globalId=" (Capital "I" in "Id")

Re: Link from ArcMap to a submitted Survey123 form

JasonCyphers — Thu, 22 Apr 2021 17:19:24 GMT

That did it!

Getting closer, but now I'm getting an error:

and the field name and value that its supposed to contain is listed.

And, every field after that one is blank as well (almost like Survey123 went field by field, populating it with the values previously entered; but, when it got to that field, it errored out and just stopped.

Re: Link from ArcMap to a submitted Survey123 form

Andrew-Bowne — Thu, 22 Apr 2021 17:26:16 GMT

Does that happen with every one of your survey responses (the points collected) or just one in particular? It sounds like maybe the value does not fit the field length or maybe it has the wrong datatype?

Re: Link from ArcMap to a submitted Survey123 form

JasonCyphers — Thu, 22 Apr 2021 17:28:59 GMT

Half of the fields get populated.

The field that has the error is a 256 character string field, and the value is 3/4"; so, wouldn't think it's a formatting issue. There is another 256 character string field that has that same value in it, and it loads & populates without issues.

Re: Link from ArcMap to a submitted Survey123 form

Andrew-Bowne — Thu, 22 Apr 2021 17:32:26 GMT

Is the problematic field name a reserved word? You could try removing that field from your survey for testing purposes and see if that fixes the problem.

Re: Link from ArcMap to a submitted Survey123 form

JasonCyphers — Thu, 22 Apr 2021 17:41:08 GMT

the attribute field with the error is called "bypass_size". I deleted the field and everything worked fine. I created a new field called "size_of_bypass", and it caused the same error. I even tried entering a value other than 3/4", and it still caused an error.

Re: Link from ArcMap to a submitted Survey123 form

Andrew-Bowne — Thu, 22 Apr 2021 17:44:19 GMT

try creating two new fields "BP_SIZE" and "BYPASS_SZ". See if either or both of them work. I wonder if that is somehow a reserved word. This might help determine that.

Re: Link from ArcMap to a submitted Survey123 form

JasonCyphers — Thu, 22 Apr 2021 17:46:06 GMT

Oddly enough, the field type, in Survey123, was select_one. I changed it to a text field and manually typed 3/4" in, and it didn't have any errors. I then changed it to a select_multiple field, and that worked as well.

Really confused as to why select_one will not work.

Re: Link from ArcMap to a submitted Survey123 form

Andrew-Bowne — Thu, 22 Apr 2021 17:50:23 GMT

select_one should provide a choice list. select_multiple should as well. Do you have a list you are choosing from?

Odd that one works and not the other. You might want to open a ticket with Esri Support and I bet they will be able to troubleshoot further with you.

Re: Link from ArcMap to a submitted Survey123 form

JasonCyphers — Thu, 22 Apr 2021 17:54:23 GMT

Correct. Both the select_one and select_multiple are looking at the exact same list choices.

I have another select_multiple question in the survey that is looking at the same list choices as well. Never had any issues with that one, which is what made me try to change the select_one I was having issues with.