# Forms

Currently Being Moderated

## I need to calculate based on a value chosen in a drop down list!!

### Aug 2, 2012 12:58 AM

Tags:

Ok, here's the deal.

I'm writing an order form for custom guitars.

There will be a dropdown list for many things.

Example:

Body Shape : (Shape A, Shape B, Shape C)  <-(dropdown list)

Body Color : (Color A, Color B, Color C)  <-(dropdown list)

all three shapes and colors have different costs.

So for example, if the base cost is \$450

and chosing

Shape A = +\$0

Shape B = +\$50

Shape C = +\$65

Color A = +\$0

Color B = +\$15

Color C = +\$35

So after the customer chooses the shape and Color, I want the final price to display in the "Price" box.

So if I chose Shape B & Color C in my dropdown list, the price would read \$535.

Is this possible?

If so, do I need to write a seperate calcuation for it?? How do I do it?

Replies
• Currently Being Moderated
Aug 2, 2012 8:44 AM   in reply to dm7g

If all of your items in a given drop down box have a unique price you can set the export value for each option.

The custom calculation for the total price field could be, with the field names of "Body Shape" and "Body Color":

var nBase = 450;

var nShape = Number(this.getField("Body Shape").value);

var nColor = Number(this.getField("Body Color").value);

event.value = nBase + nShape + nColor;

If you created a hidden field for the base price you could use the "Field is the sum of the following fields:" and select the field names.

You could also use the Simplified Field Calculation:

450 + Body\ Shape + Body\ Color

|
Mark as:
Actions

#### More Like This

• Retrieving data ...

#### Answers + Points = Status

• 10 points awarded for Correct Answers