-
1. Re: Calculate directly in a field like you can in Excel
Jono Moore Oct 9, 2013 2:18 PM (in response to meem23)There's nothing built-in to do that but you might be able to write script to handle it.
-
2. Re: Calculate directly in a field like you can in Excel
dcidev Oct 9, 2013 2:39 PM (in response to meem23)In the exit event of the field, language=JavaScript put:
this.rawValue=eval(this.rawValue);
Kyle
-
3. Re: Calculate directly in a field like you can in Excel
Jono Moore Oct 9, 2013 2:45 PM (in response to dcidev)Oh sure Kyle make it look easy...
-
4. Re: Calculate directly in a field like you can in Excel
meem23 Oct 10, 2013 5:24 AM (in response to Jono Moore)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?
-
5. Re: Calculate directly in a field like you can in Excel
dcidev Oct 10, 2013 8:12 AM (in response to meem23)What's the pattern?
-
6. Re: Calculate directly in a field like you can in Excel
meem23 Oct 10, 2013 8:31 AM (in response to dcidev)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%}
-
7. Re: Calculate directly in a field like you can in Excel
dcidev Oct 10, 2013 8:49 AM (in response to meem23)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
-
8. Re: Calculate directly in a field like you can in Excel
meem23 Oct 10, 2013 9:01 AM (in response to dcidev)Thanks so much for your help!


