ArcGIS Survey123 Connect: This survey cannot be published. Only one geometry field is allowed per table, (X number) found in (survey title)

Error Message

In ArcGIS Survey123 Connect, attempting to publish a single survey containing multiple geopoints fails and returns the following error message:

Error:   
This survey cannot be published. Only one geometry field is allowed per table, (X number) found in (survey title).

Cause

Survey123 Connect is limited to creating only one geometry record for each survey submitted.

Solution or Workaround

Use repeats

In Survey123 Connect 3.0 and later versions, multiple geopoints can be configured using repeats. Repeats create a related table that links to the main survey table to store additional geometry and add points on the map. This method is suitable for collecting employees' personal information, locating patients and respective emergency contacts, or gathering details of postgraduate students and corresponding field work locations.

In this example, two geopoints are configured in a single survey to determine the location of a patient and the location of the respective emergency contact. Submitting two surveys creates four points on the map. Use the following steps to create a survey with multiple geopoints using repeats:

1. In the XLSForm, add the preferred questions into a repeat group. Refer to Esri Community: Survey123 Tricks of the Trade: Repeats for more information.
2. In the begin_repeat row, in the repeat_count column, specify the count. In this example, Patient's Location is the geopoint outside of a repeat and the emergency contact's Location is the geopoint within a repeat. One repeat count means one additional point is plotted on the map to represent the geopoint within a repeat.

3. Click Save.
4. Publish the survey.

The survey below shows the repeated geopoint questions.

The map below shows the location of the two patients and the two respective emergency contacts.

Note:
Related tables can be viewed by clicking Show  in the attribute table. The image below is an example of a survey with a single related record.



When there are multiple repeats, each point representing each repeat creates a new row in the related table. It is not possible to store multiple point records in the same row.

Use null value(s) for subsequent geopoint(s)

In Survey123 Connect 2.4 and later versions, null values are supported in the bind::esri:fieldType column of the Excel form. Null values enable the configuration of multiple geopoints by storing subsequent geopoint(s) in x and y fields instead of as a geometry. This method is suitable for finding x and y data of multiple points in a survey. For example, the potential locations of treasure hunt stations, the positions of bus stops in a housing area, or the sites for an archaeological excavation.

In this example, three geopoints are configured in a single survey to determine the start, mid, and endpoint of a marathon route. Use the following steps to create a survey with multiple geopoints using null values:

1. In the XLSForm, configure the bind::esri:fieldType column of the preferred geopoint questions to null. In this example, the bind::esri:fieldType column for the Mid Point and End Point rows are set to null.

2. Configure the calculation column of the multiple decimal questions with the pulldata() function to extract the numbers of x and y fields.

3. Click Save.
4. Publish the survey.

The survey below shows the configured geopoint questions.

The map below shows the point plotted for the geopoint questions.