I have been getting to know bubble since couple of months and created a questionnaire in which the user answers 10 questions to get a quote. The answers when entered are saved along with the rest of the data. I have the data in excel along with the calculations and now the question is how in bubble to pull the unit price depending on what the customer chose. E.g. A customer has a choice of size S or L in standard or premium. The customer chooses size L in standard version. In the database called “Price Units”, each type has a description and its price depending on the size.
The assumption is that I send the user an offer by email.
So how now with bubble count the result of the offer? How to get (extract) the result from the data placed in the bubble? How to use the formula having all the answers assigned to the user? In other words: How to find the unit price depending on what the user has chosen?
When I get a results then I need to sum up unit prices and send an offer.