Calculation in widgets and editable grid



I would like to set some simple calculation in the form, and data as below: 1) Original Amount 2) Exchange Rate 3) Local Amount Which Local Amount = Original Amount * Exchange

How can I do this? Is it also available to set calculation in the editable grid?

Please help, many thanks!


Submitted by ttoine on Thu, 08/07/2014 - 10:25

do you want to do "live" calculation like in Excel ? or do you want to just display the results in a grid ?

Submitted by bakacowby on Thu, 08/07/2014 - 11:23

Hi ttoine,

I am going to design a grid table, which users fill in data in "Original Amount" & "Exchange Rate", than "Local Amount" will calculate and show the result. Finally, the grid table should also show the total of "Local Amount"

Please advise, many thanks!

Submitted by ttoine on Thu, 08/07/2014 - 11:34

You can not use table like in Excel. If you want to have "live" formulas on a html table, you will have to do that with Javascript on you forms.

No answers yet.