I am not sure if this extension can do the following..

It would be fantastic if a software were written that could question a user in a variety of ways and store their answers in a database (any survey software can do this part) with branching (see question 3 below), and then based on their answers generate a custom output page. This page could be viewable and printable by only administrators or could be displayed immediately to the customer or emailed to admin or customer. Here is what I am looking for:


Questions:

1.What is your name? Jason
2.What is your wife's name? Ashley
3.What is your wife's favorite color to wear (red,pink,green)? pink
1.What type of pink (hot, pastel)? hot
4.What is her favorite type of jewelry (earrings, necklace, ring)? earrings

Output:

Client: Jason
Client's wife: Ashley
Color: pink
Color variation: hot
Jewelry: earrings

Jason, based on your selections we recommend that you buy your wife Ashley hot pink earrings. The selection of earrings is a safe bet for any occasion. Click here to view our selection of hot pink earrings.


Obviously such an application in joomla! would have a lot of applications and would be a hot item. The output tool would need the ability to perfom if/then statements. Pink is the color often associated with feminity and hot pink has not been popular since the 80s and 90s, but is making a comeback!

If Color=Pink then display: Pink is the color...

you get the idea.

Is this magic output something already in existence? Can pages in joomla use tags pulling info from the database in the interim?

Can the output email use features like this:

allows the use of conditional statements depending on tags values. This is particularly handy for example when you need to customize your messages depending on each recipient gender for exemple. To insert a conditional statement, use the button just on the right of the tag pull-down menu, choose the tag to be used in the condition from the tag pull-down menu, the operator, the value to compare the tag with and the result (the text you want to be used if the condition is verified).

Available operators are:

* contains
!* doesn't contain
= is equal to
<> is not equal to
#? starts with
?# ends with
> is greater than
< is less than
>= is greater or equal to
<= is less or equal to

You can write as many rules as needed using the AND and OR instructions and IF, ELSEIF and ELSE switches inside the same conditional statement. A rule is made of a tag, an operator, a value to compare with and a result.

An example of a conditional statement, to customize your messages depending on recipient's gender would be:

<IF Gender = \"M\" <AND> Surname <> \"\">Dear Mr. [Surname],
<ELSEIF Gender = \"F\" <AND> Surname <> \"\">Dear Mrs. [Surname],
<ELSE>Dear Friend,</IF>

This example contains 4 rules. We have renamed an optional field to 'Gender'. In the 'Gender' column we have placed a letter 'M' or 'F' for male and Female. At delivery time MaxBulk will choose from: 'Dear Mr. [Surname]', 'Dear Mrs. [Surname]' or 'Dear Friends' depending on which condition is verified first. Of course you can write and modify the conditional statements manually, just follow a few simple guidelines:

• A conditional statement always begin with <IF and end with </IF>.
• Tags are always surrounded with double brackets like Gender when inside a rule.
• Use as many <AND> and <OR> instructions as needed, however parenthesis are no allowed.
• Use as many <ELSEIF switches as needed using the same syntax as with the <IF tag.
• <ELSE> tag is optional and has to be placed at the end. Only one <ELSE> tag is allowed per statement.
• Available operators are *, !*, =, <>, #?, ?#, >, <, >= and <= according to the table above.
• Place the value of the rule between double quotes and end with \">\". No spaces are allowed before \">\".
• Write the result text to be used if the condition is verified.
• However we have used colors in the example above, styles are not allowed in the statement, only in the result.