Answered

Apostrophe being added to Google sheets responses

  • 8 February 2022
  • 2 replies
  • 122 views
L
Userlevel 3
Badge +2

Hello,

I’ve connected my typeform to Google Sheets.

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

 

icon

Best answer by john.desborough 9 February 2022, 05:39

View original

2 replies

Liz
Rank
Userlevel 7
Badge +5

Hi @LewisK I can’t say I’ve heard of this issue, but I’m going to ask our technical team if they’ve heard of this/know a solution. 

Life is a series of awkward moments separated by snacks.
john.desborough
Userlevel 7
Badge +6

@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. 

just a thought.. 

 

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs