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