We are just taking a look at Form Assenbly for the first time, and have looked at it pretty extensively for the last couple of days. We are in the middle of migrating from our DOS based CRM system to a SalesForce system. Our SF implementor suggested that FormAssembly would be invaluable as a Front End to Sales Force.

So far we are very impressed wth Form Assembly's capabilities, however for the life of us we cannot figure out how to accomplish a number of tasks inside FormAssembly.
All our quotes are generated inside Excel, and we'd like to automate that as an Internet available form.

So, more or less we understand how to do simple data queries, with conditional questions. However how do we:

1. Perform complex data manipulation - for example how do I apply complicated @IF statements to data.
2. It seems as if my form data must be submitted some kind of formula engine to do the @IF statements - is this correct?
3. How do I retrieve the calculated data into my original form?

For example, I have a table that has a variety of materials, each with a cost.
Suppose:

Material Cost
A: $1/ft2
B: $2/ft2
C: $3/ft2

I'm building a pad, comprised of layers as follows.
ABBAAC

How do I pull the costs in from the Materials form?