Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Lime_Tiger_Witc
Lime_Tiger_Witc
Offline

Badges

Badges
4

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts

Posts
10

Discussions

Discussions
0

Questions

Questions
10

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Lime_Tiger_Witc
Customize the badges you want to showcase on your profile
Re: LC Javascript Help - Adobe LiveCycle 07-02-2012
Hi Naill! Got it to work using the Number(bs.formattedValue) formula (I also went through and made sure all the field names were not script words (b_y). Thanks again for all your help on this!Kim

Views

224

Likes

0

Replies

0
Re: LC Javascript Help - Adobe LiveCycle 30-01-2012
Additional Info might make it clearer: Fields: bs & by need to be added together (there are 16 fields to add together in total but for explanation purposes I’ll use 2)The calculation is done in field ed which currently has the formula this.rawValue = bs.rawValue + by.rawValue applied to it and does the calculation of all 16 fields, except the calculation is based on the user entered number (100.006) but I want to base the calculation on the rounded number (100.01) so I applied the previous codin...

Views

227

Likes

0

Replies

0
Re: LC Javascript Help - Adobe LiveCycle 30-01-2012
Just when I thought I may have worked through all the issues another one pops up… At the bottom of this column all I want to do is a sum of the column but as is the theme of this form the addition/sum has to be of the formatted/rounded number and not the number entered by the user, so same issue as the original but it seems that (addition) + might need a different solution?. (each of these fields have a calculation script applied to them: this.rawValue = bq.formattedValue / br.formattedValue Cur...

Views

226

Likes

0

Replies

0
Re: LC Javascript Help - Adobe LiveCycle 30-01-2012
Worked like a charm, thanks again Niall!

Views

225

Likes

0

Replies

0
Re: LC Javascript Help - Adobe LiveCycle 27-01-2012
Addendum/Update:After further testing I have discovered the following: the calculation fails when more than 3 digits are entered (999.00 vs 1000.00) the field displays the number (1000.00 for example) but fails the script calculation. So it appears to be connected to the formattedValue command that somewhere needs the parameters set to accept over 999.00. Is there a way I can define this formattedValue field or is there another approach. I feel we’re close, thanks again Naill!

Views

227

Likes

0

Replies

0
Re: LC Javascript Help - Adobe LiveCycle 27-01-2012
Just to clarify: (for field bl) This works, until field bj has a number over 999.00 in it then it fails? this.rawValue = bj.formattedValue * bk.formattedValue Field bj when entered as anything under 999.00 does the calculation properly and the calculation appears in bl properly BUT as soon as I put in a number over 1000.00 it fails, now this is with the formattedValue coding BUT doesn’t fail if I replace it with rawValue and change nothing else, makes no sense to me so I’m still poking around to...

Views

225

Likes

0

Replies

0
Re: LC Javascript Help - Adobe LiveCycle 27-01-2012
You’re correct, neither of the fields are a formattedValue as they are both user entered, but if I put in rawValue in the code it goes back to the same calculation error of calculating on the user input data rather than the rounded/display number. Also, if you meant this, I checked the display pattern and all cells are set to: num{zzz,zzz,zz9.99} So, field bj is user entered at 100.006 it rounds/displays as 100.01, field bk is user entered at 10.006 it rounds/displays as 10.01 – therefore: field...

Views

227

Likes

0

Replies

0
Re: LC Javascript Help - Adobe LiveCycle 27-01-2012
Hi Niall, this works for the original script I posted but I am unable to get it to work for another similar field in the same formand am hoping that you can spot my error as I’m sure it’s straightforward but I seem to be missing it. Current Code: (same issue as previous, user enters a number with .006 and it rounds up to .01 but calculation is based on .006 and should be .001) this.rawValue = bm.rawValue * bn.rawValue Code I tried based on your code: if (bn.rawValue != null && bn.rawValue != 0) ...

Views

224

Likes

0

Replies

0
Re: LC Javascript Help - Adobe LiveCycle 27-01-2012
Thanks so much Niall! I will test it out today, really appreciate the help.

Views

229

Likes

0

Replies

0
LC Javascript Help - Adobe LiveCycle 26-01-2012
Script Help Please:(for form field bs) this.rawValue = bq.rawValue / br.rawValue(Issue is field bq is input as 1.005 by the user and gets automatically rounded up to 1.01 as the display field is only 2 decimal points as a requirement, but the input number above: 1.005(bq.rawValue) is what the script is using for the calculation but I want to use the rounded number (1.01)for the calculation (1.01)- how do I script this?

Views

1.6K

Likes

0

Replies

13