Skip navigation
motiondude
motiondude
Currently Being Moderated

Simple calculation script

May 23, 2012 5:53 PM

Categories: Macintosh Tags: #fields #acrobat-form #calculations

Hi there, I never used Forms this deep so here's my simple question.

I have 5 tick boxes (option A to E), each representing a different money value.

You can only tick 1 of these 5 options.

Then I have a field for amount, i.e. how many times option A, B, C, D or E.

The last field is for the total sum.

 

Now how do I set this up? I've been messing around but couldn't get it to work.

 

TIA

566 Views   6 Replies   Latest reply: GKaiseril, May 27, 2012 9:17 AM
 
Replies
  • GKaiseril
    Currently Being Moderated
    1. GKaiseril,
    May 24, 2012 7:19 AM   in reply to motiondude
    Report

    If you have 5 check boxes and only 1 can be selected,  then the total times any one check box can be selected is 1 or 0 and the total selected can only be 1 or 0,

     

    Do you have multiple rows of 5 check boxes?

     
    |
    Mark as:
  • motiondude
    Currently Being Moderated
    2. motiondude,
    May 24, 2012 7:56 AM   in reply to motiondude
    Report

    Thanks for chiming in GKaiseril. Maybe my explanation was not that sound. It was pretty late when I wrote it.

    Here's what I want to do. The form has 5 options to choose from, you can tick only 1.

    Each option has a different (money) value.

    The next step is the amount of the choice, i.e. 3 times option A or 2 times option E, etc.

     

    So if option A (= 75) is ordered 3 times, that would total 225

    The formula would be something like sum=(option * amount) but then in javascript.

     

    In my layout I have a row of 5 tickboxes, 1 field for amount and 1 field for total.

     

    Does my explanation make any sense this time? Thanks!

     
    |
    Mark as:
  • motiondude
    Currently Being Moderated
    3. motiondude,
    May 27, 2012 4:30 AM   in reply to motiondude
    Report

    Anyone, please?

     
    |
    Mark as:
  • GKaiseril
    Currently Being Moderated
    4. GKaiseril,
    May 27, 2012 7:32 AM   in reply to motiondude
    Report

    How are you determining your quantities from a single row of check boxes?

     

    Can you link to a sample form?

     
    |
    Mark as:
  • motiondude
    Currently Being Moderated
    5. motiondude,
    May 27, 2012 7:48 AM   in reply to GKaiseril
    Report

    Thanks GKaiseril. I made a screendump for you to look at. Here it is:

     

    example.jpg

    5 tick boxes, each representing a different value.

    You can only choose 1 of the 5 boxes, then the amount

    of that choice (i.e. 1 or higher) in the field below

    which would present us with the total sum in the last field.

     

    On the internet you would use radio buttons but this is print

    hence the tick boxes.

     
    |
    Mark as:
  • GKaiseril
    Currently Being Moderated
    6. GKaiseril,
    May 27, 2012 9:17 AM   in reply to motiondude
    Report

    There is no tick box in Acrobat forms. You can use either a check box or radio button. There have a lot of similarities except radio buttons once selected always need one selected while one can remove the selection form a check box.

     

    You need to  create 5 check box or radio button fields all with the same name. Then for each individual check box or radio button change the selection value to the numeric amount of the selection.Do not use any currency symbols and use a ".' for the decimal point.

     

    You can then use the "Field is the ____ or the following fields:" to perform the calculation for the total sum by selecting the field name for the check box or radio button and the Attendees field names.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points