Hi Guys,
Im trying to recommend a product based on 4 different scores which I created as custom variables. To get them to add a point based on questions answered is easy enough but I can't seem to get all the values to display on a final summary page.
E.g. The right racquet should be based on 4 variables (weight, stiffness, balance point and tension). After answering questions your tally might be weight 5, stiffness 5, balance point 2, tension 5. On the final summary page i show this to the customer by saying your recommended racquet has the following stats:
Weight: @weight
Stiffness: @stiffness
Balance Point: @bp
Tension: @tension
This displays the score. My problem is I don't want the scores to display as the tally amount. A weight tally score of 5 represents “4U-83grams”. Is there a way to change the code/logic on this page to set up a replace function??
i.e. =IF(@weight>4) then replace @weight with “4U-83grams”
This is easy enough in excel but not sure how to do it here.
Please help.
Thank you!
Answered
Replace scores with a value
Best answer by john.desborough
what i have done is to create a ‘parallel’ text variable ie @weight_words and then use your logic thoughts:
- if @weight gt 4, then replace weight_words with ‘text string’
that should work just fine for you
des
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.