Hi guys,
I have the following problem. I should create a form with answers that must be rated from 1 to 5. Each entry is part of a category.
For example:
Category: category 1
Question 1: rate 1 to 5
Question 2: rate 1 to 5
Category: category 2
Question 1: rate 1 to 5
Question 2: rate 1 to 5
Values from 1 to 5 will be entered via a dropdwon that takes them from a separate sheet.
The final result completes a row inside a results sheet (could it be a JSON of the answers?).
What do you think is the best method to avoid creating too many columns of all the answers in one sheet?
Thanks 
What would you do with the answers afterwards? Do you display them or will you use those values in further calculations?
Would users always have to answer every question?
Hi @ThinhDinh !
I would like to have a json of answers possibly, so that I can then externally create a pdf.
Yes, users have to answer all the questions!
@ThinhDinh have you tried to think of a possible solution?
Maybe @Jeff_Hager could you help us with some workaround?
I just don’t know how to do it 
I think you can just store each answer as a column, then use a JSON column to convert it to a JSON object.
There might be alternatives, but if you want users to answer multiple questions then I think it’s straightforward to have to create columns to store them.
Check out the below from @grumo.
The generated forms are stored as a JSON object, as are the the collected responses.
If you want to learn how to do it using JSON, get yourself a copy of the below template and study it.
Thank you guys, so, at this point I think that I’ll create columns for every questions!
