Answered

Results calculations

I

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!

icon

Best answer by john.desborough 7 July 2022, 20:28

View original

3 replies

Liz
Rank
Userlevel 7
Badge +5

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!

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

@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

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Liz
Rank
Userlevel 7
Badge +5

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

Life is a series of awkward moments separated by snacks.

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs