Using data from answers to create calculations and logic | Community
Skip to main content
Answered

Using data from answers to create calculations and logic

  • February 2, 2023
  • 6 replies
  • 112 views
L

Hello, 

 

I am building a form for home sellers to fill out if they are looking to sell their home.  I have some question answers that need to be added up and then multiplied by another figure.  Please see below

 

Question:

Is that the *absolute best* you could do on the *price*? Please enter your *absolute BEST price* you could give us:  Answer will be a $.  E.g. $100,000

 

Question:

How much do you think it would *cost in repairs* to put the house *in tip top shape 100% retail ready?*

Answer will be a $. E.g. $20,000

 

Question:

What price do you think *we could re-sell the house for* if we put it in tip top shape after we buy it from you?

Answer will be a $. E.g. $300,000

 

The calculation I need done is  IF $20,000 + $100,000 < $300,000 X .65 it takes them to 

QUESTION

*Good news! Looks like we can make an offer on your house.*

 

*Let me ask you... if we could pay in the range of your asking price ALL CASH and AS-IS, are you ready to start the paperwork to get your house sold?*

 

IF $20,000 + $100,000 > $300,000 X .65 it takes them to 

Unfortunately *your asking price is too high* for us to consider for an all-cash offer.

 

Can anyone help?

 

Thank you 

Best answer by john.desborough

@lewisfisk4 - you would need to create some variables to hold the values and use logic rules something like this - i would have created these variables already before creating these logic rule-ish things below:

  • q1 answer (absolute best) - if q1 greater than 0 then add q1 to v_base
  • q2 answer (cost of renos)  - if q2 greater than 0 then add q2 to v_base
  • q3 answer (re-sell value) - if q3 greater than 0 then add q3 to v_multiplier
    • if q3 greater than 0 then multiply v_multiplier by .65 (you might have to multiply by 65 and then divide by 100 if it won’t let you use the two decimal multiplier value)
    • now the logic for the routing to pages:
      • if q3 greater than 0 then subtract v_base from v_multiplier 
      • if v_multiplier is greater than 0 go the we can make an offer page
      • if v_multiplier if less than 0 then go to the sorry we can’t sell this place”

that should get you to where you want to go.. 

hopefully…

 

des

View original

6 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 15008 replies
  • February 2, 2023

Hi @lewisfisk4 happy little friday!

@john.desborough is a wiz with these kinds of calculations! 😀

Life is a series of awkward moments separated by snacks.
L
  • lewisfisk4
  • Author
  • Explorer
  • 3 replies
  • February 2, 2023

@john.desborough Would love your advice!  

john.desborough
Forum|alt.badge.img+6
  • john.desboroughCertified Partner
  • Certified Partner & Champion
  • 5304 replies
  • Answer
  • February 3, 2023

@lewisfisk4 - you would need to create some variables to hold the values and use logic rules something like this - i would have created these variables already before creating these logic rule-ish things below:

  • q1 answer (absolute best) - if q1 greater than 0 then add q1 to v_base
  • q2 answer (cost of renos)  - if q2 greater than 0 then add q2 to v_base
  • q3 answer (re-sell value) - if q3 greater than 0 then add q3 to v_multiplier
    • if q3 greater than 0 then multiply v_multiplier by .65 (you might have to multiply by 65 and then divide by 100 if it won’t let you use the two decimal multiplier value)
    • now the logic for the routing to pages:
      • if q3 greater than 0 then subtract v_base from v_multiplier 
      • if v_multiplier is greater than 0 go the we can make an offer page
      • if v_multiplier if less than 0 then go to the sorry we can’t sell this place”

that should get you to where you want to go.. 

hopefully…

 

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Grace
L
2 people like this
  • Grace
    Grace
  • L
    lewisfisk4
L
  • lewisfisk4
  • Author
  • Explorer
  • 3 replies
  • February 3, 2023

Thank you @john.desborough this is starting to make sense.  

I dont suppose there is a way that we could hop on a zoom and do this together.  I am a bit lost with it to be honest.  Please could you email me so that we could work something out? lewis@drivebyhomebuyers.com

john.desborough
1 person likes this
  • john.desborough
    john.desborough
john.desborough
Forum|alt.badge.img+6
  • john.desboroughCertified Partner
  • Certified Partner & Champion
  • 5304 replies
  • February 3, 2023

@lewisfisk4 - sorry I can’t do that - other clients and the work associated would keep from doing that from a time perspective.. and i have no bandwidth through till end of Feb to look at an new client take on work..

 

apologies… des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
L
  • lewisfisk4
  • Author
  • Explorer
  • 3 replies
  • February 6, 2023

@john.desborough No worries thank you for the advice.  

Do you know if the variable has to be a fixed number or can it be dynamic?

 

Thank you

Lewis

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs