![]() I'm also not a big fan of assigning "question" field types like 'integer' and then setting them to 'read only' as you have done for your Grand Total fields. It would also allow any number of observations, rather than being restricted to three. But unless there is a good reason not to use the repeat function, that would be far neater and less error prone. The three cascading relevant/visible fields for the various observations seems to be essentially a way to avoid using a repeat. That will probably solve the problem.įWIW, there are quite a few other things that have been done in this survey that I wouldn't recommend. Once you have made that change, let us know how it goes. Not sure how to do this is the web designer. That way the fields are hidden under the same conditions, but not set to null. In connect you just need to move all of those calculations to the column. So the first thing to do is change the fields from being relevant under those condition to being visible under those conditions. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |