Hi all, 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 nonnumeric characters like ,,= etc in numeric columns. Therefore I cannot implement this functionality. How can I implement this functionality in formspider? George. asked 24 Mar '13, 23:44 George 
Hi George, 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:
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:
Hope this helps, answered 25 Mar '13, 05:24 Ibrahim Sand... ♦♦ Hi Ibrahim, Thank you for the feedback. I will try this. George.
(25 Mar '13, 10:18)
George

I write =10+20 star 2 but question removed the star without my permission.
George