topic Re: Using an SQL Enterprise Geodatabase with Survey123 in ArcGIS Survey123 Questions

Using an SQL Enterprise Geodatabase with Survey123

BenjaminSperry1 — Mon, 09 Sep 2019 10:16:08 GMT

Hello,

I would like to use an SQL Enterprise Geo database registered with the Enterpise Server as the data source behind a Survey123 form.

When I try to do this I get an error message that my database needs a non-nullable unique identifier in order to be used with Survey123. How do I set up my database to include this? I created a GUID field in my feature but I guess it has to be something more than that.

Any guidance would be much appreciated.

Re: Using an SQL Enterprise Geodatabase with Survey123

MarisaClaggett — Mon, 09 Sep 2019 17:50:52 GMT

Hi Benjamin,

All of the information you need to prepare a service to be used with Survey123 can be found here. According to our documentation, if you plan to edit your surveys, ensure that either your feature service allows null values or your survey uses required fields. Survey123 uses null values in editing when an answer is deleted and is not replaced; consequently, Survey123 will not submit a survey from a feature service that doesn't permit null values.

Use Survey123 with existing feature services—Survey123 for ArcGIS | ArcGIS

Hope this helps!

Best,

Marisa

Re: Using an SQL Enterprise Geodatabase with Survey123

JamesTedrick — Mon, 09 Sep 2019 20:26:50 GMT

Hi Benjamin,

To amplify on Marisa's comment, make sure that GlobalIds have been enabled on the feature classes and if you use attachments, the relationships are based on GlobalIds. A GlobalId is a system-recognized GUID for the purposes of providing a unique identifier for a row (there are other contexts in which you can use a guid that will not be unique for a given row - for example, identifying another record in a 1:M or M:N relationship).