Sorry to be lengthy. I am also attaching the file I am working on. I am doing incremental saves so I can go back to what worked or not. I will not touch this one for a while as I am asking for help and this is where I stopped.
Note: I am also on Acrobat 9. Long story short, employer refusing to provide documentation that can allow me to purchase the educational priced latest version.
I’m getting the dreaded “The value entered does not match the format of field [ Balance 4 ]”
Some things generate the issue for Balance3. These things do not use the Balance4(they don’t go that far)
If I share the PDF, the issues are on Page 8, where I have also consolidated all my fields for testing in one convenient area so I don’t have to go back and forth. There are elements in the white space at the bottom of the page, all of which will be removed from the final document.
Balance 4 is a final calculation that pulls information from all over the place. I am adjusting an existing PDF form, but we didn’t do certain things before, and now we have to. I have adjusted calculation orders as that has resolved a good many problems. I also feel that the calculations are correct because at every step, I am seeing correct numbers, which is confirmed via an Excel spreadsheet that I am using as my safety check. I can manipulate the numbers in the Excel file and see how they line up in the PDF. Also, before I started manipulating this PDF, everything was working. Also, I have had to change the calculation order around because this was a problem for a bit. Anything that is important as far as calculations are concerned has been moved to the end of this area. Most of the “calculations” are really just “copy down from this area”, and it is text. I mostly did that because I didn’t want to COPY fields, I wanted them to be read only and/or also do some basic adjusting for formatting so it looks nice when printed.
Page 1 is just an informational collection page. When this was added to the original form, no issues came up. This is used to populate certain fields and generate the two final pages that are given to me for data entry.
As far as Page 2, the only notable things are the Program selection and Full/Part time, which are carried down to Page 3 and can be selected/adjusted from there as well. I am considering moving these items also to Page 1 for convenience. ON Page 3, we do have a few fields that need to be populated or adjusted, but the only one notable for this is the transfer hours/”Number of clock hours accepted as transfer/re-entry”. This field is important.
Skipping to the top of Page 8, we have two check boxes, which are important to this scenario. While the values next to these check boxes does not change, the check boxes adjust another set of boxes that are used for calculations..
I will focus on Page 8. Starting from the top area, the “starting balance” calculation is confirmed correct and when it comes to things being calculated on the page, this is the first item. It gets its numbers from the addition of 3 locations I think on Page 3. All page 3 calculations are correct.
Then there is a visible but non-printing “adjusted rate” calculation, with a green outline. Green outlines means “this is a value I am generating and will use in other calculations and will be marked as hidden when I am done”.
When I skip down just a tiny bit, I see 4 fields: Hours 1-4. These fields are being populated by the document javascript for populating those fields. This is correct, text only, no calculations.
The next line is “PlannedPayment1-4”, and all those values are correct and are calculated.
The next line is “Balance 1-4”, where Balance3 and Balance4 generate issues. 2 programs have an issue with Balance3 because they don’t use Balance 4. 2 programs have issue with Balance4 because they use Balance 4. For those that end on Balance3, the value for Balance 3 should be a zero and the calculation shows that. For those that end on Balance4, the value for Balance 4 should be a zero and the calculation shows that. I am convinced the calculations are correct so I am puzzled as to why there is this issue.
The white space at the bottom is being used as a temporary work space for troubleshooting. I can remove all these fields here and the problems still exist. There is a pull-down menu that allows the programs to be selected. This is a copy placed here for convenience. There are two check boxes, which are defaulted as unchecked, and make the box next to it either a value or zero. These are the same check boxes on the top of Page 7. I did things this way because it made the most sense to use the box values for calculations. Checking and unchecking these checkboxes generates the error as well. I’m open to a better way of doing it. There is also a field where the value can be changed. I won’t go into all the details but let’s just say for my testing purposes, the calculations are adjusted based on this number being changed and the calculations are coming out correct. The Javascript for the document set-up is pushing a a value of “0” into this field whenever a program is changed and I added a validation script to ensure a zero is populated if the field is blanked. This is intentional because if someone changes programs, I want to start “fresh” for that program. I also added my document reset button for convenience. I have an issue with people using the form and NOT clearing it out so the reset is necessary.
Setting the format Balance 3 and 4 to text makes the error go away but then I lose the formatting I would like to use.
The Java console is not generating any errors.
Thank you in advance for pointing out all the things I am doing wrong. This is a big learning curve for me.
29
Replies
AdChoices