topic Re: Error: Failed to Submit - Cannot insert the value NULL into column 'ItemType' in ArcGIS Survey123 Questions

Error: Failed to Submit - Cannot insert the value NULL into column 'ItemType'

dwold — Wed, 01 Nov 2023 18:58:53 GMT

Has anyone seen this error before and/or know what the solution is?

Re: Error: Failed to Submit - Cannot insert the value NULL into column 'ItemType'

ZacharySutherby — Fri, 12 Jan 2024 01:51:53 GMT

If you navigate to the CLSS_DATATABLES_TEST_ITEM2 feature service in your ArcGIS content and select the Data tab -> Fields, is there a field called ItemType in the list of fields? If so and you select it is "Allows Null Values" set to Yes ?

If not, the question in your survey that references the ItemType field needs to be required and/or have a default value.

Re: Error: Failed to Submit - Cannot insert the value NULL into column 'ItemType'

dwold — Wed, 14 Feb 2024 17:28:29 GMT

thank you @ZacharySutherby !!