- kranaiAsked on February 19, 2016 at 12:20 PM2. in my cost field I have a condition based on what seminar is selected I want the cost field to reflect the cost for that seminar. I want the cost for "Master Your Mind" to be $300.00 but each time I see on the preview I get $3000.00. Can u please check if I have done the maths calculation correctly. (is this the best way to do it or is there a better way to do it?)
- BorisAnswered on February 19, 2016 at 01:41 PM
I believe this question is still about your form 60454628430453, named InSight Academy Registration Form.
The reason why you are seeing the wrong price of 3000, is the way that your condition is set up - it is set to insert value of "Cost of Event" field plus 300 into that same field, which creates a loop. That condition would normally never finish, because if "Cost of Event" is zero, the condition tries to enter 300 as its value. Immediately, the value is now 300, so the condition tries to set it to 600. Now the value is 600, and the condition automatically changes it to 900...
Our system is designed to give up after 10 tries, and go out of the loop, so that your form remains functional (10 times adding +300 results in 3000 as the calculated value).
What the condition should have been set to would be just 300:
The above is how you could fix this that condition. However, I believe you are looking to both calculate and then forward your calculated price to the payment tool for your users to pay that amount, so I would recommend a completely different way of setting up your prices.
1. I would recommend that you first assign calculation values to the options in your Drop Down field for "Seminar/Workshop Title". Because a Drop Down field also has the initial blank option (when nothing is yet selected), the first assigned value must be zero, and only the second assigned value will correspond to the first available option (Master Your Mind).
In other words, for Master Your Mind to have assigned value of 300, you should assign calculation values as:
where 0 is for the first blank option above the Master Your Mind option.
2. After assigning calculation values, you can use a Form Calculation field to calculate the value of the option selected in the "Seminar/Workshop Title" Drop Down field.
3. Finally, we need to pass the calculated value to your payment tool for payment.
Please let us know how it goes.
- JotForm SupportdavidAnswered on February 22, 2016 at 02:32 PM
The values appear to be correctly assigned. This is what the calculation is producing:
master your mind : $300.00
Data protection policy : $500.00
Leadership : $600.00
If those are the values you are trying to assign, you should be all set.
- kranaiAnswered on February 23, 2016 at 10:37 AM
Thanks for your feedback. Now to fine tune it further when we select the seminar and the cost of event displays say 300 ....is there anyway we can display as $300.00 or $300 with '$" sign? Or do I have to insert the '$' as part of the label as "Cost of Event $"
Please let me know
- JotForm SupportdavidAnswered on February 23, 2016 at 11:44 AM
To add a dollar sign in front of the value, add the "$" character in front of your equation:
Here is what the form would look like with the change:
- kranaiAnswered on February 27, 2016 at 10:21 AM
Now if I want to give a early bird discount to the buyer based on below logic:
The event date is 9th April 2016 if anyone registers before 15th Mar 2016 will get say a 20% discount.
This means the Calculated field display = 300 x 0.8 = $240. Any registration after 15th Mar will be the full price of $300
How do I do this ? How do I do the date test before I do the calculation.
- BorisAnswered on February 27, 2016 at 12:06 PM
We can do that as well, by using a bit of conditional logic.
In the first step, we will add a new Number field on your form, set its default value to 1, and make this field hidden:
Second step, we will need to use a DateTime field to have a "today" of the time when submission is being made, to compare with 2016-03-15. This field should be set to have a default time "today", and should also be made hidden:
Third step is to use an "Update/Calculate field" condition:
And set this condition to change the value of our number field with 0.8 if the date in "Today" is before 2016-03-16:
Now we have all ingredients set in place for the fourth step, which is to slightly adjust your calculation of Cost of Event. Instead of calculating it as it is now:
$ seminarworkshopTitle + 0
We should place brackets around your sum operation, and multiply it with the "Discount Number" field we have created in step one:
As the Discount number field is conditionally changed depending on the date, it will produce either the same total cost if the date is after 2016-03-15, or calculate total cost of 80% from its usual value if the date is before that date:
Please take a look at the images depicting each of these steps, as they should make it a bit clearer on how to set it up. If you run into any issues along the way, please let us know and we will be happy to help.
- kranaiAnswered on February 27, 2016 at 12:14 PM
Thank you very much for all the steps...absolutely Magic! I wasn't expecting an answer today being a weekend...man you are on the ball....great I will try this and revert if I have any issues. Looking at your steps looks quite straight forward. Thanks alot
- BorisAnswered on February 27, 2016 at 01:22 PM
You are most welcome, please keep us updated on how it goes.
We are here 24/7, and the speed of our replies depends solely on how many support tickets are opened by our customers - on a busy day, it may take us a little more time to get to each of them. Luckily, this is more of a slow weekend.
- kranaiAnswered on February 27, 2016 at 09:31 PM
Okay thanks it works as your instructions.
One point of observation the panel for the Calculation wizard on my screen was totally different from what you gave in the image above. I had a list showing all the maths functions etc..nevertheless I managed to setup the expression as you suggested. No issue here just an observation.
- JotForm SupportKevin_GAnswered on February 27, 2016 at 11:28 PM
First of all, on behalf of my colleagues that helped here, you're welcome.
You see that difference because we are updating our interface/layout, and this update is for steps so it is not available for all our users at the same time, it is gradual and soon you will have this interface as well, it is also great to know that you were able to achieve what you wanted.
Please do not hesitate to contact us if you need further assistance, we will be glad to help you.