Results calculations | Community
Skip to main content
Answered

Results calculations


Good evening Typeform Community!

 

We currently have the answers to our questions posting to a Google Sheet. 

 

We would like to multiply the answers that are provided prior to posting to our Google Sheet.

 

For example, if an answer of $5,000 is entered by a user of our form, we would like to calculate 75% of that prior to posting to our Google Sheet.

 

How can we accomplish that?

 

Thanks so much in advance all!

Best answer by john.desborough

@Impact Legacy Group - you could create a variable in your typeform (for each number you want to multiply) and then ADD the answer from the question to the variable in a logic rule and then in the next logic rule you multiply the variable by .75 (or by 75 and then divide the variable by 100) 

the variable will also be pushed over to the google sheet.. you can then set up a ‘check sum’-ish column to show that the full price and the 75% price are properly calculated/referential. 

 

des

View original

3 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14971 replies
  • July 7, 2022

Hi @Impact Legacy Group Happy little Friday! It sounds like you’ll need to set up calculations on your Google Sheet. 

@john.desborough or @ValdemarQ might be able to help you with this one!


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5300 replies
  • Answer
  • July 7, 2022

@Impact Legacy Group - you could create a variable in your typeform (for each number you want to multiply) and then ADD the answer from the question to the variable in a logic rule and then in the next logic rule you multiply the variable by .75 (or by 75 and then divide the variable by 100) 

the variable will also be pushed over to the google sheet.. you can then set up a ‘check sum’-ish column to show that the full price and the 75% price are properly calculated/referential. 

 

des


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14971 replies
  • July 12, 2022

Hi @Impact Legacy Group did the suggestions above help? 😁