Skip to main content
Answered

Replace scores with a value

  • 13 June 2021
  • 3 replies
  • 83 views

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! 

@Brendan Racquets - welcome from another user

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


Thank you so much!! 

Works perfectly. Big help 


@Brendan Racquets - congrats! good luck with the quiz!

let us know how it works!

 

des


Reply