Calculations Using Symbols: Category, Addition and Division - Using the ☆ Symbol

Follow

Randall D (KDM)

• January 02, 2022 09:47

Hello,

I created an app that allows our company to receive valuable customer feedback. 

Basically a rating/review form.

I decided to use a symbol in a category field: ☆

The category field is named: Q1 or @Q1 (for purposes of referencing in calculations)

The options for the fields are:

☆

☆ ☆ 

☆ ☆ ☆ 

☆ ☆ ☆ ☆ 

☆ ☆ ☆ ☆ ☆ 

I'm attempting to create a separate calculation field that will show a total of the stars so that the answer would be something like: 4.7 or 3.5

I think this can be done by converting each group of stars to represent the number.

Then a calculation based on said numbers.

Any help would be appreciated.

0

• 

  Rainer Grabowski

  • January 03, 2022 15:07
  • Edited

  Hi Randall,

  you can do something like this:

   

  

   

   

  

  Note: There must be a blank space between the stars (but no blank space at the end).
  If you don't want blank spaces between the stars use: 
  split("").length instead of split(" ").length

  Rainer

  1

  Comment actions Permalink
• 

  Randy (BHB)

  • January 04, 2022 19:54

  Wow! Let me give this a shot right now! Rainer Grabowski

  0

  Comment actions Permalink
• 

  Randy (BHB)

  • January 04, 2022 20:22

  Rainer Grabowski - So it seems that would have worked but Podio did not like the fact the answer turned from "text to number". The calculation worked though. I simply can not publish the result. Please advice. Your help is greatly appreciated.

  var q1 = @Q1: My Pro Completed The Job As Described: == null ? 0 : @Q1: My Pro Completed The Job As Described:.split(" ").length;
  var q2 = @Q2: My Pro Was Punctual/On Time: == null ? 0 : @Q2: My Pro Was Punctual/On Time:.split(" ").length;
  var q3 = @Q3: My Pro's Pricing Was Affordable == null ? 0 : @Q3: My Pro's Pricing Was Affordable .split(" ").length;
  var q4 = @Q4: My Pro's Communication Was Good: == null ? 0 : @Q4: My Pro's Communication Was Good:.split(" ").length;
  var q5 = @Q5: My Pro's Quality Of Work Met and/or Exceeded My Expectations: == null ? 0 : @Q5: My Pro's Quality Of Work Met and/or Exceeded My Expectations:.split(" ").length;

  (q1 + q2)/2

   

  *** THE TYPE OF RESULT TURNED FROM TEXT TO NUMBER ***

  

  0

  Comment actions Permalink
• 

  Randy (BHB)

  • January 04, 2022 20:25

  Rainer Grabowski Fixed! I simply deleted the previous "calc field" and created a new "calc field" pasted the code and viola! Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  0

  Comment actions Permalink

Please sign in to leave a comment.