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.
Solved! Go to Solution.
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
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?
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 | 11 | ||||||||||||||||||||||||
text | inspector | Inspector | property('email') | esriFieldTypeString | 100 | |||||||||||||||||||||||
dateTime | insp_date | Inspection Date | now() | esriFieldTypeDate | ||||||||||||||||||||||||
select_one Boolean | Inspected | Inspected | yes | horizontal-compact | esriFieldTypeString | 5 | ||||||||||||||||||||||
select_one Boolean | Leaking | Leaking or Running | yes | horizontal-compact | esriFieldTypeString | 5 | ||||||||||||||||||||||
select_one Connection | Connection | Connection | yes | horizontal | esriFieldTypeString | 10 | ||||||||||||||||||||||
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 | Collector_GlobalID | null | |||||||||||||||||||||||||
hidden | JoinID | JoinID | if(regex(${Collector_GlobalID}, '^\{[\w\-]*\}$'), substr(${Collector_GlobalID},1, string-length(${Collector_GlobalID}) - 1), ${Collector_GlobalID}) | esriFieldTypeGUID |
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)
Hi Carl,
How do you open the form and how does the Collector_GlobalID field get filled in (as it's a hidden question)?
Custom URL from Explorer
arcgis-survey123://?itemID=3515b4b4c63d4b62ae1794ec89b06e8b&field:UNITID={UNITID}&field:Collector_GlobalID={GlobalID}
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