AnsweredAssumed Answered

Integer field is truncated when the survey is saved then edited

Question asked by grahamstobieSPEN on Feb 5, 2019
Latest reply on Feb 14, 2019 by dailya

Hi

 

I have an integer field in a survey that is used to store an 8-digit 'ID' field - e.g. 12345678. However if the user collects some values including the ID, closes the survey without sending, then re-opens it to edit/complete the survey, commas are added to the ID, the value is truncated, and the value shows as invalid - i.e. the ID above would be now show as 12,345,67 and would be in red text. (see attached).

 

I understand that this is because of the 9-character integer field limitation, but as far as I can tell this is new behaviour (or the survey team have changed their workflow...). Is there a way to stop this happening? We have already collected >1000 surveys using this form so I want to avoid changing the ID field to text if possible.

 

Thanks

Attachments

Outcomes