Calculate directly in a field like you can in Excel

[meem23]

Is it possible to type a calculation into a field and once you exit the field it will display the result?  For example, type 30+40 and then exit the field and it will display 70.

[Jono_Moore]

There's nothing built-in to do that but you might be able to write script to handle it.

[dcidev]

In the exit event of the field, language=JavaScript put:

this.rawValue=eval(this.rawValue);

Kyle

[Jono_Moore]

Oh sure Kyle make it look easy...

[meem23]

Thanks for the response.  I got it to work in a Text Field, but not a Numeric Field. How can it to work in a Numeric Field that has a pattern or is this not possible?

[dcidev]

What's the pattern?

[meem23]

I have a few, but the main one is the first one listed below.

num{($zzz,zzz,zz9)}

num{zzzz9.zz}

num{zz9.9%}

num{zzzzz.9%}

[dcidev]

Technically, you CAN use those patterns for text fields although it's not officially supported. Make sure the parentheses on your first one are taken out and put single quotes (') around your percentage sign.

Kyle

[meem23]

Thanks so much for your help!