# Form with many fields **URL:** \ **Category:** Ask for Help\ **Created:** [March 14, 2024, 5:26pm UTC](https://community.glideapps.com/t/form-with-many-fields/71689 "2024-03-14T17:26:49Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Luca\_Dipa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_dipa/32/67530_2.png) [@Luca\_Dipa](https://community.glideapps.com/u/Luca_Dipa)\ **Post date:** [March 14, 2024, 5:26pm UTC](https://community.glideapps.com/t/form-with-many-fields/71689/1 "2024-03-14T17:26:49Z")
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 🙏🏼 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 15, 2024, 12:13am UTC](https://community.glideapps.com/t/form-with-many-fields/71689/2 "2024-03-15T00:13:36Z")
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? ---
**Author:** ![Luca\_Dipa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_dipa/32/67530_2.png) [@Luca\_Dipa](https://community.glideapps.com/u/Luca_Dipa)\ **Post date:** [March 15, 2024, 7:27am UTC](https://community.glideapps.com/t/form-with-many-fields/71689/3 "2024-03-15T07:27:08Z")
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! ---
**Author:** ![Luca\_Dipa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_dipa/32/67530_2.png) [@Luca\_Dipa](https://community.glideapps.com/u/Luca_Dipa)\ **Post date:** [March 17, 2024, 5:20pm UTC](https://community.glideapps.com/t/form-with-many-fields/71689/4 "2024-03-17T17:20:55Z")
@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 🥲 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 18, 2024, 12:01am UTC](https://community.glideapps.com/t/form-with-many-fields/71689/5 "2024-03-18T00:01:39Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 18, 2024, 1:12am UTC](https://community.glideapps.com/t/form-with-many-fields/71689/6 "2024-03-18T01:12:44Z")
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. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/7453ffdd838ddba1672c27a8a7c7bddb675adfc8.jpeg "Generate Online Forms with AI + Glide") ](https://www.youtube.com/watch?v=33FuUaeuGwk) ---
**Author:** ![Luca\_Dipa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_dipa/32/67530_2.png) [@Luca\_Dipa](https://community.glideapps.com/u/Luca_Dipa)\ **Post date:** [March 18, 2024, 8:08am UTC](https://community.glideapps.com/t/form-with-many-fields/71689/7 "2024-03-18T08:08:02Z")
Thank you guys, so, at this point I think that I’ll create columns for every questions! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 25, 2024, 8:08am UTC](https://community.glideapps.com/t/form-with-many-fields/71689/8 "2024-03-25T08:08:14Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.