Hi there!
I need something like a customer satisfaction questionnaire but because this is for kids with cognitive and learning problems, I need to do it with words or images.
What I mean is instead of rating with stars (1 or 4 or etc) the kid will choose one of excellent, good, fair, or poor (or some emoticons equal to these values) for every question.
Excellent being 4 points, good 3, fair 2 and poor 1; at the end, we’ll have a total point.
So how can I replace the default rating with stars and use words or images?
I imagine that I have to link fields and use maybe some simple formulas, but my head just doesn’t want to function :expressionless: :upside_down_face:
Thanks for your attention :slightly_smiling_face:
Self rating questionnaire - Rating with words or images
This topic has been closed for replies.
+18Hi @Umut_UYDAS - maybe with a single select:
And another formula field to turn the selection into a score:
IF(Rating = 'Excellent', 4, IF(Rating = 'Good', 3, IF(Rating = 'Fair', 2, 1)))
The single select field could also contain words and emojis if you want.
JB
@JonathanBowen Thank you very much.
Is there a way to add custom images in single select (instead of emojis or words)?
+18@JonathanBowen Thank you very much.
Is there a way to add custom images in single select (instead of emojis or words)?
Hmmm…I don’t think so, probably the closest is going to be emojis.
+3Hi @Umut_UYDAS - maybe with a single select:
And another formula field to turn the selection into a score:
IF(Rating = 'Excellent', 4, IF(Rating = 'Good', 3, IF(Rating = 'Fair', 2, 1)))
The single select field could also contain words and emojis if you want.
JB
Hi @JonathanBowen & @Umut_UYDAS,
You should consider a Switch formula:
Switch(Rating,
'Excellent', 4,
'Good', 3,
'Fair', 2,
'Poor', 1
)
It’s easier to read. And works well when you have many options.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.