Inputting questions/answers into database, not using boolean

[Travis6876874]

im needing a detailed answer on how to make the quiz part of my app in apperys database. Each question has 3 answers. I will use Ans1, Ans2, and correctAns for this but dont even know where i'd put these either. Thanks

[Travis6876874]

where do i put Ans1, Ans2, or correctAns at, in front or behind the answer I type in? Can someone please tell explain from start to finish this process in detail? Thanks!

[Alena Prykhodko]

Hello Travis,

Please clearify, do you ask in what order to put the data in database?
For example, you can store question as a row, where one column - question, other columns - Ans1, Ans2 and correctAns.

[Travis6876874]

Hi, thank you. So I hit add new column, title it question and the type I choose? String? I intend to later use the questions in a quiz like setting, sets of 7 questions, each timed at 25 seconds. So with 4 categories with 10 or so subjects each category. I thought to make a database for each category, adding each different subject with the create new collection option?

[Travis6876874]

I understand the columns thing now except for which type to choose for the question and answers. Thank you!

[Travis6876874]

I was just letting you my full intention cause right now im dumber than a box of rocks, this computer foriegn language, lots to learn)!

[Travis6876874]

Is it okay that I start building by first inputting all my questions and answers? If so id like to do this first!

[Alena Prykhodko]

String. Correct, you can add new collection for each category. Please find more here http://docs.appery.io/documentation/b...

[Travis6876874]

Thanks!!!!!!!!!, u r the best)

[Alena Prykhodko]

Definitely