Skip to main content
J
jamie61880
Inspiring
August 20, 2015
Question

Calculations in form

  • August 20, 2015
  • 1 reply
  • 464 views

Hi. I am setting up a simple form that will do some calculations to determine the price of something that we are going to cut and sell. First, the user will choose a part number. Then they will type in the dimensions they want in the X_mm and Y_mm boxes. I have a formula in Excel that has other factors for determining the price for the part chosen. There is the cost of the item, the cutting cost we are charging and some other factor. The formula looks like this in Excel: =((E3/(ROUNDDOWN(50/B5, 0)*ROUNDDOWN(50/B6,0)))+E4)*E5

     I'm just wondering if I should do this calculation in Cold Fusion or SQL server management studio. We do not want the user to be able to see the formula either. Which way would be easier?

Andy

This topic has been closed for replies.

1 reply

M
mack_
Participating Frequently
August 20, 2015

I'm just wondering if I should do this calculation in Cold Fusion or

SQL server management studio. We do not want the user to be able to

see the formula either. Which way would be easier?

If you don't want the user to see the formula you have to send the

parameters to the server and calculate it there. I would use jQuery to

catch change and keypress events and send the parameters via ajax to the

server and display the response.

J
jamie61880Author
Inspiring
August 20, 2015

Thanks for the response. How do you send the parameters to the server and calculate everything there? I don't know how to use jQuery or ajax. Do you have an example I could look at?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices