Answered

Extract number from Other option

  • 14 March 2024
  • 2 replies
  • 27 views
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? 

icon

Best answer by john.desborough 14 March 2024, 18:12

View original

2 replies

Liz
Rank
Userlevel 7
Badge +5

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
Userlevel 7
Badge +6

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

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs