In my forms application I use column for simple arithmetic calculation as in EXCEL. This is specially used in numeric columns. Ex. =10+202 entered in a column will replace this expression with 50. However, formspider does not permit entry of non-numeric characters like ,-,= etc in numeric columns. Therefore I cannot implement this functionality. How can I implement this functionality in formspider?

As you mentioned, Formspider does not permit entry of calculation expressions into numeric columns. To implement this functionality, you should assign a varchar2 datatyped domain to your numeric datasource column where the calculation expression needs to be entered. To achieve this:

From the Formspider IDE, open the datasource definition edit dialog for the datasource definition containing this numeric column

Expand "Columns" node from the tree existing at the left side of the dialog, all columns are listed

Click on the numeric column where the calculation expression needs to be entered and select "DefaultVarchar2" option from the "Domain" combobox. This selection overrides the original datatype of the column.

Press "OK" to save your change.

As the next step you have to implement a calculation procedure which can be called from the valueChanged event of the calculation field. This procedure needs to perform the calculation and also restrict and ignore the characters that are entered in the field. A quick example can be as follows: