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?
asked 24 Mar '13, 23:44
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... ♦♦