I am using Adobe LiveCycle Designer 7.0.04. I have several checkboxes (which represent different dollar amounts for different membership levels) that the end user can select. At the bottom of the page, I have a total box (numeric field) which the end user can then enter the total amount of all the memberships selected. Is it possible for the total box to automatically calculate the total amount of the selected checkboxes as they are selected? If so, how? Thank you for your help.
Form creation
2007-07-03 07:18:24
My Product Information:
Acrobat Pro 7.0.0, Windows
Acrobat Pro 7.0.0, Windows
2007-07-10 12:00:55
#2
Yes, use FormCalc. See "Creating basic calculations" in Designer Help.
Check box values can be calculated just like values in text fields.
Check box values can be calculated just like values in text fields.
2007-07-10 08:37:52
#3
How to get multiple checked boxes to sum in a numeric field?
I was putting together a two page conference registration form and there were approximately 20 options that cost different amounts that registrants could select to register for the conference. I was looking for a way that the registrants could check the options (via a checkbox) and a total amount for the registration would show at the bottom of the page. Here is what I did to get my form to work. I have Adobe Acrobat LiveCycleDesigner 7.0.04
First, I renamed each CheckBox to unique name that I would remember for that option. I did this by first selecting the CheckBox and then to the right of my page there was a box that had the following tabs: Object, Layout, Accessibility…. Under the Object tab, I selected the Binding tab. The first option available was Name and that is where I typed in the unique name.
Next, still on the Binding tab, I changed the On Value: from 1 to the value that I wanted that option to represent. For example, one CheckBox was $495 with the box to the left of it. So for that On Value, I entered 495. Therefore, when it was selected, it would hold a value of 495.
After doing this for each of the CheckBoxes, I inserted a Numeric Field. Just under the main row of toolbars on Adobe, I saw a couple of buttons and options which allowed for formula to be entered. In the Show: box, I selected Calculate. To the right, I made sure that the Language: was FormCalc and the Run At: was Client. Between Show: and Language: there is a long white space which is available for the formula to be typed into it. I needed a basic Sum equation, so I typed: Sum(nameof1stcheckbox,nameof2ndcheckbox,nameof3rdcheckbox,……). I then pressed the green plus button which saved the equation.
Because I wanted it to be in dollars, I also formatted the numeric field so that the Display Pattern was in a dollar format.
In doing this I was able to get numerous CheckBoxes to sum at the bottom of a page when selected.
I was putting together a two page conference registration form and there were approximately 20 options that cost different amounts that registrants could select to register for the conference. I was looking for a way that the registrants could check the options (via a checkbox) and a total amount for the registration would show at the bottom of the page. Here is what I did to get my form to work. I have Adobe Acrobat LiveCycleDesigner 7.0.04
First, I renamed each CheckBox to unique name that I would remember for that option. I did this by first selecting the CheckBox and then to the right of my page there was a box that had the following tabs: Object, Layout, Accessibility…. Under the Object tab, I selected the Binding tab. The first option available was Name and that is where I typed in the unique name.
Next, still on the Binding tab, I changed the On Value: from 1 to the value that I wanted that option to represent. For example, one CheckBox was $495 with the box to the left of it. So for that On Value, I entered 495. Therefore, when it was selected, it would hold a value of 495.
After doing this for each of the CheckBoxes, I inserted a Numeric Field. Just under the main row of toolbars on Adobe, I saw a couple of buttons and options which allowed for formula to be entered. In the Show: box, I selected Calculate. To the right, I made sure that the Language: was FormCalc and the Run At: was Client. Between Show: and Language: there is a long white space which is available for the formula to be typed into it. I needed a basic Sum equation, so I typed: Sum(nameof1stcheckbox,nameof2ndcheckbox,nameof3rdcheckbox,……). I then pressed the green plus button which saved the equation.
Because I wanted it to be in dollars, I also formatted the numeric field so that the Display Pattern was in a dollar format.
In doing this I was able to get numerous CheckBoxes to sum at the bottom of a page when selected.
Creating Dynamic Forms with Adobe LiveCycle Designer (Paperback)
by J. P. Terry (Author)
List Price: $50.00
Language: English
ISBN-10: 0321509870
ISBN-13: 978-0321509871
My favorite quote - "Success is the ability to go from one failure to another with no loss of enthusiasm.