1

Hello bubble,

in my app i have a long but quick sign up process, where they can click on a scale of buttons:

Screenshot 2024-09-23 at 14.24.09
Screenshot 2024-09-23 at 14.24.09704×96 8.13 KB

(disagree | disagree a little | dont know | agree a little | agree)

and some questions has more detailed answers and sometimes over 20 alternatives from option sets.

My question is how should i store this data? ChatGPT says it’s best to store the agree, disagree questions etc as a number from 1-5 and then display the data as a condition on the text later for the user. Reason according to chatGPT: Quicker to display data, easier to calculate averages etc.

How i have other questions with only 3 alternatives, No | Dont know | Yes and ChatGPT says to to that on these as well?

What i did in the beginnging was storing them as texts like disagree | disagree a little | dont know | agree a little | agree

And then keep a note that says on disagree | disagree a little | dont know | agree a little | agree = 1,2,3,4,5 and same for the other questions

Or maybe i should use option sets?

What would you recommend?

2

Bumping this

3

First of all, what do you want to do as an end result? Display, calculations, comparissons…?

Generally speaking, ChatGPT is correct, it is better to find a standardised way to store stuff. Furthermore, storing digits is way more evolutive than storing emojis or text in general.

If some answers can have 5 different answers, but others only 3. Maybe you can standardise this by attributing different weight to each answer. Basically you can say that “no” is equivalent to the most extreme :-1: and yes is equivalent to the most extreme :+1:.

Explanation :
:-1::-1::person_shrugging::+1::+1: = [1,2,3,4,5]
No | Dont know | Yes = [1,3,5]

4

Hey thanks for your comment :slight_smile: Yes that was my idea, so i would store them as a number and then display it later as 1 = Agree and so on.

Becouse the plan is to display this data as well for users.

5

Let me ask you a question. What would you do if you wanted to show the average?

1 Like
6

Not sure, i have not calculated that part yet, that is more for the admin dashboard later

7

If you want to do mathematical calculations like that, text-based solutions can be quite challenging. Setting up a database before you know what you want to do is like starting to shoot a movie before the final scene is written.

8

So you also recommend numbers?

9

Yes, you have to have numbers. If you need some other fields in a feedback, than you can create a feedback object in the database includes a number, a text etc

1 Like