![]() ![]() The first problem that needs fixing is that you have the calculate fields running off fields that have relevant conditions.įor example, your calculation for row 57 (clustered_monarchs) is: $+null+null can't yield a valid integer result, so it returns a null - the empty field that you are seeing. I meant to say that the 2 calculated fields are showing up as blank in the field app (in the vid I had highlighted the 1st cluster total, rather than the "# Clustered Monarchs (total)"). * VIDEO CORRECTION - at min 5:20 I accidentally highlighted the wrong field. And, as before, the calculated field values do not show up in the "Data" table.Ĭan anyone help? Is there an error I can correct or a setting I can change? Or, is this a glitch? However, once I submit the form (successfully, no notes or warnings), the calculated field values do not show up in the "Data" table.Īdditionally, when I am testing out my form in the Survey123 Field App, I cannot see the two auto-calculating values (they do not populate/function in the app) prior to submitting. When I am in the "Preview" view of "Design" mode and when I select "open in browser" to test out my form, I can see the correct auto-calculated values populating the two calculated fields prior to submitting. The fields referenced in both calculations have default values of 0, and are all conditional questions. this field is NOT conditional, but all the fields referenced in the calculation are.īoth of these fields are set to "Read-only" and have default values of 0.GRAND TOTAL: Monarch Butterflies ->Sum of all monarch butterflies to produce "grand total" (sum of clustered butterflies from calculation above + fliers + sunners + loners + grounders fields).this field is conditional and shows only if someone marks that they observed clustered monarchs, and all the fields referenced in the calculation are conditional.# Clustered Monarchs (total) -> Sum of "clustered" monarch butterflies.There are 2 fields with calculations in the form: I've attached a video, and also tried to describe below. I am unsure what to do since the calculations clearly CAN function properly, but aren't. I've created a form with related "sum" calculation fields in Survey123 Web Designer, but the calculations are not registering/showing up in the data table once the form is submitted despite the *pre-submitted* calculation values being visible.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |