Apostrophe being added to Google sheets responses | Community
Skip to main content
Answered

Apostrophe being added to Google sheets responses

  • February 8, 2022
  • 2 replies
  • 201 views

Forum|alt.badge.img+2
  • Sharing wisdom
  • 18 replies

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

 

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. 

just a thought.. 

 

des

View original

2 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 15035 replies
  • February 9, 2022

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. 


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5328 replies
  • Answer
  • February 9, 2022

@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


Reply