I have a form that will help a user build up a quote for fees to move house. The first page of the form will ask the user to select their nearest location from a drop down list, they will then enter the value of the house they wish to buy into a text field.
What I need to happen on the next page is to display the selected location from the drop down list and also the value they entered for the house, but also to display an estimated fee for purchasing the house.
The Fee is calculated by a series of ranges for each location, for example;
Location A House Price | Fee Up to 80000 | 100 80000 - 100000 | 200 Over 100000 | 300 Location B House Price | Fee Up to 80000 | 150 80000 - 100000 | 250 Over 100000 | 350
I have looked at various Form modules, but none of them do any kind of calculations. So I was wondering if anyone has done anything like this before with forms and calculations?