Vbulletin.gets.owned
New Member
Hi i need this excel kind of functionality in my application. The entire web page you can find it in below link.
http://jsbin.com/upoxex/1/editWrite now in the above link i put all the static ones. Now i explain what kind of functionality i need in that. There are three fields called working hours, rate/hour and price. Now when ever user changes rate/hour value in text field against one product. I want to change price against that product automatically without redirecting it like excel. When ever there is a change in certain cell out of 10 cells which you are adding in 11 th cell. Automatically 11th cell value changes.Same like above when there is change in price text field automatically it should reflect in rate/hour.The formulas for both price and rate/hour are below.\[code\] price = working hours * rate/hour rate/hour = working hours/ price\[/code\]When ever there is change in price of the product total price of the whole customer should also change because that is sum of all the product prices.Like above all when ever there is change in total price for the customer. Automatically customer final price also should change instantly.formula for final price is \[code\] final price = total price- (total price * discount)\[/code\]I tried like this using Javascript. I write function below to calculate price from working hours and rate/hour.\[code\] onkeyup = "find_price(product_id,price_id,working hours)"\[/code\]In between script tags i defined this function and calculated price....but i am not able to go forward i want to know how can i do it.
http://jsbin.com/upoxex/1/editWrite now in the above link i put all the static ones. Now i explain what kind of functionality i need in that. There are three fields called working hours, rate/hour and price. Now when ever user changes rate/hour value in text field against one product. I want to change price against that product automatically without redirecting it like excel. When ever there is a change in certain cell out of 10 cells which you are adding in 11 th cell. Automatically 11th cell value changes.Same like above when there is change in price text field automatically it should reflect in rate/hour.The formulas for both price and rate/hour are below.\[code\] price = working hours * rate/hour rate/hour = working hours/ price\[/code\]When ever there is change in price of the product total price of the whole customer should also change because that is sum of all the product prices.Like above all when ever there is change in total price for the customer. Automatically customer final price also should change instantly.formula for final price is \[code\] final price = total price- (total price * discount)\[/code\]I tried like this using Javascript. I write function below to calculate price from working hours and rate/hour.\[code\] onkeyup = "find_price(product_id,price_id,working hours)"\[/code\]In between script tags i defined this function and calculated price....but i am not able to go forward i want to know how can i do it.