Calculation in widgets and editable grid

Q&A
1

Hello,

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!

2

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

3

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!

4

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.