Extract number from Other option | Community
Skip to main content
Answered

Extract number from Other option

T
other option

Hello,

in my form i have a other option input in multiple choice questions.  So now I want to perform some mathematical calculation leveraging this input value. But the problem is this is in text format. 
So is there a way to extract number from this text and do this mathematical calculation? Is there any workaround? Or can i make the other option number only?

Secondly after calculation my variables value is 300000. now can i format this to 300,000 as in currency format when i use this to send email from TypeForm? 

Best answer by john.desborough

@Liz - not using variables but pushing to google sheets and parsing the data to ‘split’ the numeric from text components and converting text strings of numbers into numeric fields. 

 

not the greatest help, i know

 

des

View original

2 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 14923 replies
  • March 14, 2024

Hi @test4567 This is a really good question. @john.desborough have you done something like this using variables at all?

As for the question about currency formatting, we don’t have this feature, but you can follow along at the post below for any updates. Feel free to add your vote there, too!

 

Life is a series of awkward moments separated by snacks.
john.desborough
Forum|alt.badge.img+6
  • john.desboroughCertified Partner
  • Certified Partner & Champion
  • 5279 replies
  • Answer
  • March 14, 2024

@Liz - not using variables but pushing to google sheets and parsing the data to ‘split’ the numeric from text components and converting text strings of numbers into numeric fields. 

 

not the greatest help, i know

 

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Liz
1 person likes this
  • Liz
    Liz

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs