We initially collected 100 datasets using the first version (v1) of a survey form, which included a field for recording temperature measurements. The data validation for this field was set to accept temperatures up to two decimal places. However, after completing these 100 surveys, we discovered that the thermometers used actually measured temperatures to three decimal places. To accommodate this, we adjusted the data validation to allow three decimal places and redeployed the form as version 2 (v2). Our intention was to correct the data for the initial 100 surveys by referring to photos taken during the surveys.
However, after redeployment, we found that the original data collected is no longer editable. Additionally, when exporting the survey records as PDFs, the original data entries appear blank in all cells.
Can you provide more details what you exactly changed how, please? How is the constraint now and how was it before? Did you change something else exept the constraint? What is the type of the variable?
Maybe you could share a short extract of your form?
Did you export with all versions included option?
The only modification I did was to change the validation criteria from regex(.,’^(\d{0,3})(.[0-9]{0,2})?$') to regex(.,’^(\d{0,3})(.[0-9]{0,3})?$') in 4 of the questions that were intended to record the temperature. Also the excel data is exportable as a spreadsheet, no issues here. The only thing is that the individual reports in pdf are no longer exportable/printable as it shows a blank form with all the entries recorded previously missing.
