CASE
WHEN {custentity_jj_avg_feedback_rating} = 5 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’
WHEN {custentity_jj_avg_feedback_rating} = 4 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’
WHEN {custentity_jj_avg_feedback_rating} = 3 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’
WHEN {custentity_jj_avg_feedback_rating} = 2 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’
WHEN {custentity_jj_avg_feedback_rating} = 1 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’
ELSE ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#CCCCCC;-webkit-text-stroke:1px black;”>?????</div><br>’
END
Revised
View Reviews–>
‘<br><div style=”font-size:12px;color:#666666;”># OF RESPONDED REVIEWS</div><br>’||
‘<span style=”display: inline-block; padding: 8px 16px; font-size:15px; color: #000000; font-weight: bold; text-decoration: none; border-radius: 4px;”>’ || {custentity_jj_total_feedback_received} || ‘</span>’||
‘<a href=”https://td2976892.app.netsuite.com/app/common/search/searchresults.nl?searchtype=Custom&CUSTRECORD_JJ_CUSTOMER_NAME=’||{id}||’&CUSTRECORD_JJ_EMAIL_STATUS=3&style=NORMAL&report=&grid=&searchid=1537&”
target=”_blank”
style=”display: inline-block; padding: 8px 16px; background-color: #007bff; color: white; text-decoration: none; border-radius: 4px; transition: background-color 0.3s; font-style: italic;”>
View Reviews
</a>’
Star Rating–>
CASE
WHEN ROUND({custentity_jj_avg_feedback_rating}) = 5 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’
WHEN ROUND({custentity_jj_avg_feedback_rating}) = 4 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’
WHEN ROUND({custentity_jj_avg_feedback_rating}) = 3 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’
WHEN ROUND({custentity_jj_avg_feedback_rating}) = 2 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’
WHEN ROUND({custentity_jj_avg_feedback_rating}) = 1 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’
ELSE ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#CCCCCC;-webkit-text-stroke:1px black;”>?????</div><br>’
END