Sub-totalling / Totalling on an order form

Hi,

I want to create an order form for ordering gift cards from various stores with various price point options that then provides a sub-total and total for the order.

I have an existing form that allows for the various selections and provides me the data in a useful excel format, but I couldn't figure out how to get sub-totalling and totalling to work.  This would be extremely useful for the form users.

Any ideas on how to do this or a form template that already does something similar?

Thanks

Rachel

Here's how:

1. First, you will have to add a calculation widget for every input table you have. Use it to get the sub-total.

Example:

Then in the calculation formula, add all the quantity columns and multiply them according to their column group.

Example:

First 5 fields should be added and multiplied by 25

Next 5 fields should be added and multiplied by 50

and so on...

Here's a visual guide:

You can do the same steps for the next input tables.

To get the grand total, just add all the sub-total calculation fields in a new calculation field.

If you need further assistance, let us know.

Sorry, the calculation format should look like this. The multiplication should be separated by another parenthesis.

Example:

((FieldA+FieldB+FieldC)*25)+((FieldA+FieldB+FieldC)*50)

Thanks so much, got it working!