We asked respondents to record their spend for several items.
We created a question that had data validation. The respondent could only give a whole number (no decimals, no negative values). We did not want respondents to give text answers, such as “we spent lots”, “five thousand dollars”, “don’t know” etc.
However, We did not anticipate respondents would insert their own $ symbol.
So – will Survey Gizmo sum all the responses? Will SG ignore all responses that include a $ symbol? Furthermore, if SG does not sum up all the data, can we edit the data or change settings that will allow SG to include all data in its standard report?
Brian (professional account level)
As a fellow community member, I am uncertain if SG will still calculate these values with the special character.
This will only allow numeric data inside the field. They can insert any number 0 – 100000000…. but they cannot insert any special characters or letters.
As to handle your old submissions, I would recommend exporting the data, cleaning it up and re-importing it to your surveys.
One suggestion is to read through that whole process before you start to do it. Although it may take sometime to get started, it is probably easier and faster then going into individual responses and editing one by one.
Thank you for your helpful suggestion – it works. We have not used Regex validation before.
By the way, would I be able to change the validation in the whilst my live survey is running? Or will Survey Gizmo object or corrupt the structure of the survey in any way.
Thanks – Brian