Select to view content in your preferred language

Survey 123 web editing data causing calculations to fire incorrectly after clicking submit button

390
1
09-30-2024 10:34 AM
ColetteCoiner
New Contributor

Using the ESRI FDAFoodInspection template I modified it to fit our inspectors need in Survey 123 Connect and published to ArcEnterprise.  The digital collection works perfectly.  The issue is when the inspector comes back to the office and adds notes and additional details to the inspection and click the submit button the all the fields that have conditional calculations such as if(contains(${q1_cosr}, 'COS')=true,"X","") or if(contains(${q1_cosr}, 'R')=true,"X","") are now marked with an X.  I took our form one step farther and have it entering a point loss if(contains(${q42_cosr}, 'R')=true,3,0) that are added up at the end of the section.

After the inspector does an edit in Survey123 web even if it is to add text to a photo caption and click the submit button.  The web form is filling in all fields that had originally been blank with and X and adding a point value instead of 0.

0 Kudos
1 Reply
DougBrowning
MVP Esteemed Contributor

I am not sure what you mean but if(contains(${q1_cosr}, 'COS')=true,"X","") is not a correct if statement.

It would be like this - you never say = true that is assumed.

if(contains(${q1_cosr}, 'COS'),"X","")

0 Kudos