I have a matrix question with the following answers: 0%, 25%, 50%, 75% and 100%
When the answers are sent through to google sheets, there is an apostrophe added to the start of the response value, e.g. ‘25%
Does anyone know why this happens? Is it to retain the percentage symbol and avoid google sheets auto converting it?
Thanks
Lewis
Best answer by john.desborough
@LewisK - looks like it’s capturing the data as a text field, a string and putting the apostrophe in there to denote that.
This is one of the reasons that i heard from support that getting the matrix questions to be accessible for logic is an issue: uncertainty over whether the data being passed in the answer is to be a text or numeric data element for, say, 25.
@LewisK - looks like it’s capturing the data as a text field, a string and putting the apostrophe in there to denote that.
This is one of the reasons that i heard from support that getting the matrix questions to be accessible for logic is an issue: uncertainty over whether the data being passed in the answer is to be a text or numeric data element for, say, 25.