topic Re: Issue with Submission URL, submitted survey not showing as related in ArcGIS Survey123 Questions

Issue with Submission URL, submitted survey not showing as related

CarlHolt1 — Thu, 13 Jun 2019 14:47:34 GMT

Created a survey using an existing feature service. Followed the directions from previous thread

In Connect, go to New Survey, then select Feature Service and pick your feature service from the gallery. Once the XLSForm is loaded, eliminate the questions relative to the parent layer. Eliminate the rows with the begin and end repeat statemnts. Then change the FormID value in the Settings tab so it references the name of the related table you want to edit.

Settings tab in Connect:

Feature Service item details

The submitted test surveys are visible in the table, but when I click on the point in a map, it shows no related records.

Re: Issue with Submission URL, submitted survey not showing as related

JamesTedrick — Fri, 14 Jun 2019 18:34:08 GMT

Hi Carl,

Can you share the XLS Form? How are you populating the 'parentGlobalID' field, which is needed to link the inspections to the proper flush tank?

Re: Issue with Submission URL, submitted survey not showing as related

CarlHolt1 — Mon, 17 Jun 2019 18:51:51 GMT

type

name

label

hint

constraint

constraint_message

required

required_message

appearance

default

readonly

relevant

calculation

choice_filter

repeat_count

label::language1

hint::language1

media::audio

media::image

body::accuracyThreshold

bind::esri:fieldType

bind::esri:fieldLength

bind::esri:fieldAlias

body::esri:inputMask

bind::esri:parameters

bind::saveIncomplete

bind::type

bind::esri:warning

bind::esri:warning_message

text

UNITID

UNIT ID

esriFieldTypeString

text

inspector

Inspector

property('email')

esriFieldTypeString

100

dateTime

insp_date

Inspection Date

now()

esriFieldTypeDate

select_one Boolean

Inspected

yes

horizontal-compact

esriFieldTypeString

select_one Boolean

Leaking

Leaking or Running

yes

horizontal-compact

esriFieldTypeString

select_one Connection

Connection

yes

horizontal

esriFieldTypeString

text

Insp_Comment

Inpsection Comment

multiline

esriFieldTypeString

250

decimal

WO_DWKFTK

WO Num DWKFTK

esriFieldTypeSingle

image

flush_tank_image

Flush Take Image

yes

hidden

Collector_GlobalID

null

hidden

JoinID

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

esriFieldTypeGUID

Re: Issue with Submission URL, submitted survey not showing as related

CarlHolt1 — Tue, 18 Jun 2019 12:45:44 GMT

Here is are my steps for setting this up:

Set up data and schema
Feature class (Inventory)
Add GlobalID(data management tool)
Add Inspection Complete field (y/n) - will be updated in Collector
Table (Inspections)
Add fields corresponding to form (ensure Allow Null values is set when needed) - will be updated in Survey123
Add GlobalID(data management tool)
Add GUID field (used in relationship class to join table to FC) - JoinID
Allow Null values
Add GUID filed (used to store the incoming GlobalIDfrom Collector) - Collector_GlobalID
Allow Null values
Relationship class (1:M)
FC to Table (GlobalIDto JoinID)

Re: Issue with Submission URL, submitted survey not showing as related

JamesTedrick — Tue, 18 Jun 2019 22:40:35 GMT

Hi Carl,

How do you open the form and how does the Collector_GlobalID field get filled in (as it's a hidden question)?

Re: Issue with Submission URL, submitted survey not showing as related

CarlHolt1 — Wed, 19 Jun 2019 14:01:19 GMT

Custom URL from Explorer

arcgis-survey123://?itemID=3515b4b4c63d4b62ae1794ec89b06e8b&field:UNITID={UNITID}&field:Collector_GlobalID={GlobalID}

Re: Issue with Submission URL, submitted survey not showing as related

CarlHolt1 — Wed, 19 Jun 2019 20:34:17 GMT

The xlss file is attached.

I am trying to write the survey to the Flush_Tank_Inspection table. The fields in table match those in the form.

Re: Issue with Submission URL, submitted survey not showing as related

CarlHolt1 — Thu, 20 Jun 2019 15:14:31 GMT

The issue I believe is because I shared the feature service from ArcGIS Pro. After starting over in ArcMap 10.6.1, publishing a new feature, creating a new form from the feature service (removing fields, repeats and adding the hidden fields) and the custom URL. It finally worked.

Custom URL: arcgis-survey123://?itemID=cd09f873f02640f89270e5477b66d819&field:UNITID={UNITID}&field:Collector_GlobalID={GlobalID}

Attached is final xlsx file