topic Editing existing records for a new question added to survey in ArcGIS Survey123 Questions

Editing existing records for a new question added to survey

JevaughnHenry — Wed, 10 Oct 2018 16:44:54 GMT

I'm trying to add a new hidden question to an existing survey using Survey123 Connect. I have an if statement in the calculation attribute of the new question:

if(${PaD_PC}<100, 'Planning and Design', if(${Proc_PC}<100, 'Procurement', if(${Imp_PC}<100, 'Implementation', 'Project Closure')))

The if statement works on new entries into the survey, however, when I try to edit the existing records in the Map Viewer on the Survey123 Website to display the required answer for the new question, the answer disappears and the edit is not allowed.

What could be causing this problem? Or how could the if statement from the new question be run on all the existing records?

Re: Editing existing records for a new question added to survey

JamesTedrick — Wed, 10 Oct 2018 18:24:51 GMT

Hi Jevaughn,

To 'back calculate' the value to existing records, I would recommend using the Calculate field values—ArcGIS Online Help | ArcGIS capability of ArcGIS Online - this would probably be easiest rewriting the if() statement in Arcade.

Re: Editing existing records for a new question added to survey

JevaughnHenry — Thu, 11 Oct 2018 13:52:07 GMT

I'll try this method instead. Thank you for the reply.