How should i structure this in my database?

Orbit · 2024-09-23T12:39:10.729Z

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.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?

Orbit · 2024-09-24T06:18:46.465Z

Bumping this

bonjour_17 · 2024-09-24T07:08:55.910Z

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 and yes is equivalent to the most extreme .

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

Orbit · 2024-09-24T07:19:37.442Z

Hey thanks for your comment 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.

tunacardak · 2024-09-24T07:32:30.193Z

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

Orbit · 2024-09-24T08:02:48.002Z

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

tunacardak · 2024-09-24T08:06:35.220Z

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.

Orbit · 2024-09-24T08:07:38.070Z

So you also recommend numbers?

tunacardak · 2024-09-24T08:09:56.788Z

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