Text Field Populated Using Javascript Calculation Works With Default Data But Not Fresh Data
The subject probably doesn't make a lot of sense, but I have a text field that uses a calculation involving a few Javascript scripts.
My form calculates whether a species is dominant in a wetland.
Possibly not relevant in finding a solution but thought I'd post this bit anyway, the steps for the test are to apply the 50/20 rule which is: select plant species from the list and rank in descending order of coverage until the cumulative coverage immediately exceeds 50% of the total cover. If two or more species are equal in cover, they should be selected as a group. Then add any other species that comprise at least 20% of the total cover. All these species are considered to be dominant.
In Connect, when I load up some default data, the calculation works as it should, i.e. flagging that the first 3 and the last species are dominant, however if I remove the default data from the XLSX and reload the survey then complete the survey using "fresh" data, the calculation does not update the field.
This snip shows data that has been entered in the default field, I have not altered anything following the form loading.
If I remove the default values from the XLSX, save it, then load the same values manually, the calculated field (Dominant Species) does not update.
Deleting the "calculated" value in the Dominant Species field and refreshing does not correct the response.
I'm using Connect Version 3.22.49, relevant files attached.
Thanks in advance
