Adobe Community: Message List - Almost Finished: Plz Help With Calculation/Checkbox And Hidden Fields

Re: Almost Finished: Plz Help With Calculation/Checkbox And Hidden Fields

forums_noreply@adobe.com — Fri, 07 Nov 2014 10:26:51 GMT

That type of thing usually means the field calculation order is not correct, so just set it to what makes sense.

Re: Almost Finished: Plz Help With Calculation/Checkbox And Hidden Fields

forums_noreply@adobe.com — Fri, 07 Nov 2014 08:51:19 GMT

Hi George, good eye in catching my spelling error -- thanks very much!

The Total box works now, but in a bit of a strange way -- it seems to be one Checkbox behind. It shows $20 right off the bat which is what I expected to see because the first Checkbox line is read only and cannot be deselected. However, when I select the second Checkbox (BMMC for $20), the Total box does not update until the next Checkbox is selected, and so forth.

Can this be corrected?

Also, I wonder if I made things unnecessarily complicated by using hidden fields, etc. Maybe I should've just had the 4 Checkboxes (plus the donation amount box), and left the dollar amounts ($20, $20, and $45) as plain text...

Re: Almost Finished: Plz Help With Calculation/Checkbox And Hidden Fields

forums_noreply@adobe.com — Fri, 07 Nov 2014 08:34:25 GMT

The field name is "Donation Amount", not "Donatin Amount", and the resulting error does show up in the JavaScript console. I recommend that you enable the following preference: Edit > Preferences > JavaScript > Show console on errors and messages

so that you notice errors when they happen.

Re: Almost Finished: Plz Help With Calculation/Checkbox And Hidden Fields

forums_noreply@adobe.com — Fri, 07 Nov 2014 08:28:10 GMT

No errors.

Here's the updated file if you'd like to have a look.

Re: Almost Finished: Plz Help With Calculation/Checkbox And Hidden Fields

forums_noreply@adobe.com — Fri, 07 Nov 2014 08:17:54 GMT

Seems fine to me... Are there any errors in the JS console?

On Fri, Nov 7, 2014 at 8:38 AM, sgdfxfslkcmz <forums_noreply@adobe.com>

Re: Almost Finished: Plz Help With Calculation/Checkbox And Hidden Fields

forums_noreply@adobe.com — Fri, 07 Nov 2014 07:38:14 GMT

Hi Gilad,

Thank you very much for taking the time to help -- the Checkboxes now work the way I hoped they would!

However, I can't get the Total box to work. This is what I have in the Calculation script properties:

var total = 0;

if (this.getField("ROAE Fun Ride").display==display.visible) total+=Number(this.getField("ROAE Fun Ride").value);

if (this.getField("2015 BMMC Membership").display==display.visible) total+=Number(this.getField("2015 BMMC Membership").value);

if (this.getField("2015 BCORMA Membership").display==display.visible) total+=Number(this.getField("2015 BCORMA Membership").value);

if (this.getField("Donatin Amount").display==display.visible) total+=Number(this.getField("Donatin Amount").value);

event.value = total;

Have I made a mistake somewhere?

Re: Almost Finished: Plz Help With Calculation/Checkbox And Hidden Fields

forums_noreply@adobe.com — Thu, 06 Nov 2014 09:26:58 GMT

1. Yes, you can use something like this as the check-box's MouseUp event:

if (event.target.value=="Off") this.getField("Field1").display = display.hidden;
else this.getField("Field1").display = display.visible;

2. Yes, but only if the calculation is done with a script, not with the built-in simplified calculation options in Acrobat.

A simple example: conditionally adding the values of 3 fields, if they're visible.

var total = 0;
if (this.getField("Field1").display==display.visible) total+=Number(this.getField("Field1").value);
if (this.getField("Field2").display==display.visible) total+=Number(this.getField("Field2").value);
if (this.getField("Field3").display==display.visible) total+=Number(this.getField("Field3").value);
event.value = total;

Almost Finished: Plz Help With Calculation/Checkbox And Hidden Fields

forums_noreply@adobe.com — Thu, 06 Nov 2014 07:24:34 GMT

This Interactive simple document was made with InDesign, then brought into Acrobat XI Pro via the Form wizard.

Is there any way for a Checkbox to show/hide another field? I have tried using the Actions tab in the Checkbox properties but simply cannot get the field to show/hide when the Checkbox is selected/deselected.
Is there any way to have a field that uses simple calculation (addition) to ignore fields if they are hidden? I am trying to get the Total field to add the amounts from the 4 Checkboxes (the first line is required, hence the pre-selected Checkbox and read only field).

Basically, I need the Checkbox to show or hide another field (which is a dollar amount), and then the Total field to add those amounts but to ignore any field if it is hidden (Checkbox deselected).

Here's a link to the file for those that have the time for a closer look: Dropbox - BMMC ROAE Registration.pdf

I am stuck at this point and do not know how to fix this. Any help offered would be greatly appreciated.