I’m looking to assist a client. They want to add a form that submits into mondaydotcom. They’ve asked that, throughout the form, they change certain dropdowns and add certain numbers.
Towards the end of the form, this calculates a total. If the total is below a certain amount, they don’t want the user to be able to submit the form. Is this possible?
Answered
Restriction of Form Submission unless Calculation above a threshold?
Best answer by john.desborough
- create variable called v_threshold
- logic rules:
- if “cost answer’ is greater than 0 then add ‘cost answer to to v_threshold
- if ‘cost answer’ is greater than 0 then divide v_threshold by 2 (to get your 50% value)
- if v_threshold is less than 500 (or what ever amount is your cutoff) then go to statement page X
- on this statement page you have the message that they are too low and need to go back and do it again AND your logic rule need to ‘always go to’ the question to try again
des
+5Hi
Liz wrote:
Hi
That might work
We do want them to change their answers - imagine it like a quote. Say they put £1000 in. Down the form, they select ‘10% discount’ and a maybe ‘payment plan 4’. If this puts the figure down to £500, they want the person to either not submit the form or have a pop up saying ‘amount too low, please return to your advisor’ or something to that effect. Is this possible?
1 person likes this
+5Hi
Liz wrote:
Hi
Hi Liz,
It could be, yeah. Perhaps in the question about the budget. Let me give it a go!
Put in 1000 cost.
Ask them if discount.
Yes say yes.
Ask them how much.
For example, they say 50%.
Can I get a logic hook to go ‘50% of 1000 is 500, that number is below what is acceptable, send them back to a previous question’?
I can’t seem to use a calculation as a condition in logic.
+6- Certified Partner & Champion
- 5271 replies
- Answer
- create variable called v_threshold
- logic rules:
- if “cost answer’ is greater than 0 then add ‘cost answer to to v_threshold
- if ‘cost answer’ is greater than 0 then divide v_threshold by 2 (to get your 50% value)
- if v_threshold is less than 500 (or what ever amount is your cutoff) then go to statement page X
- on this statement page you have the message that they are too low and need to go back and do it again AND your logic rule need to ‘always go to’ the question to try again
des
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
1 person likes this
john.desborough wrote:
- create variable called v_threshold
- logic rules:
- if “cost answer’ is greater than 0 then add ‘cost answer to to v_threshold
- if ‘cost answer’ is greater than 0 then divide v_threshold by 2 (to get your 50% value)
- if v_threshold is less than 500 (or what ever amount is your cutoff) then go to statement page X
- on this statement page you have the message that they are too low and need to go back and do it again AND your logic rule need to ‘always go to’ the question to try again
des
But the v_threshold is always a set number. So “if v_threshold is less than 500 (or what ever amount is your cutoff) then go to statement page X” wouldn’t make sense because I don’t need type form to look at a static number. I need it to look at a calculated one.
v_threhold=600
Question 1: Cost?
A: 1000
Question 2: Discount?
A: Yes
Question 3: How much?
A: 50%
Calculation: Q1/1000*Q3
If “Calculation”<v_threshold, send back to previous question.
Is that possible?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.