# How would you approach storing rating data of multiple users to 1 or many (at the moment around 100) skills? **URL:** \ **Category:** Ask for Help\ **Created:** [November 22, 2022, 9:08pm UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725 "2022-11-22T21:08:06Z")\ **Posts on this page:** 14\ **Page:** 2
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 24, 2022, 3:26am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/21 "2022-11-24T03:26:04Z")
I’m thinking to have only a choice list of skills…that you can add or remove… then to the separate sheet, you add a new record for each rating with the name of the skill, row ID of that skill, rate, who rated, and who was rated… now you can do all magic with that kind of data ---
**Author:** ![dartiede](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dartiede/32/50216_2.png) [@dartiede](https://community.glideapps.com/u/dartiede)\ **Post date:** [November 24, 2022, 3:33am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/22 "2022-11-24T03:33:17Z")
that sounds like a good plan! thank you uzo =) i will give that a try. can you explain what you mean by having “only a choice list of skills”? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 24, 2022, 3:34am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/23 "2022-11-24T03:34:55Z")
don’t combine skills and users as X,Y dimensions it will never work without the script adding new columns and copying formulas… so… you need a separate sheet with just skills names and row IDs… and a separate sheet with users and row IDs… and a separate sheet with records of users ratings ---
**Author:** ![dartiede](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dartiede/32/50216_2.png) [@dartiede](https://community.glideapps.com/u/dartiede)\ **Post date:** [November 24, 2022, 3:37am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/24 "2022-11-24T03:37:37Z")
oh yes, you mean the part where i said i have a rating column for each user in the skills table (e.g. uzosRating, robsRating etc.) as i can’t automatically add new columns. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 24, 2022, 3:38am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/25 "2022-11-24T03:38:32Z")
yes! you will have data sheets of each rating made ---
**Author:** ![dartiede](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dartiede/32/50216_2.png) [@dartiede](https://community.glideapps.com/u/dartiede)\ **Post date:** [November 24, 2022, 3:38am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/26 "2022-11-24T03:38:48Z")
got it! wow, thank you so much. i think that will work! 🙂 so have everything seperate and relate through row ids. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 24, 2022, 3:40am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/27 "2022-11-24T03:40:12Z")
yes… then if you need a summary or average… just get the user row ID to filter out skills from the data sheet… to have a hard copy of all skills for all users… you need to have a script to add columns with formulas for each new user or skill ---
**Author:** ![dartiede](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dartiede/32/50216_2.png) [@dartiede](https://community.glideapps.com/u/dartiede)\ **Post date:** [November 24, 2022, 3:41am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/28 "2022-11-24T03:41:22Z")
that helped miles uzo! thank you. much love from germany. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 24, 2022, 3:43am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/29 "2022-11-24T03:43:12Z")
i will think about it more tomorrow, how to make it simpler ---
**Author:** ![dartiede](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dartiede/32/50216_2.png) [@dartiede](https://community.glideapps.com/u/dartiede)\ **Post date:** [November 24, 2022, 3:46am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/30 "2022-11-24T03:46:29Z")
Yeah i will have to snooze a night over it as well 🙂 Thank for all the time you’ve spent thinking about it. Appreciating so much. Will report if i made any progress tomorrow! Good night. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 24, 2022, 4:23am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/31 "2022-11-24T04:23:45Z")
Hey @dartiede … are you looking for something like this? ---
**Author:** ![dartiede](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dartiede/32/50216_2.png) [@dartiede](https://community.glideapps.com/u/dartiede)\ **Post date:** [November 24, 2022, 4:46am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/32 "2022-11-24T04:46:29Z")
Oh nice! Yeah it’s really close. I would love to see a video on json. Half asleep right now, so gonna watch again tomorrow with a fresh and rested brain. 🙂 ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 24, 2022, 4:48am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/33 "2022-11-24T04:48:16Z")
That’s what I’m thinking… to have dynamic filters is not a problem… but to have hard data, it has to be all records compressed into one cell ---
**Author:** ![dartiede](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dartiede/32/50216_2.png) [@dartiede](https://community.glideapps.com/u/dartiede)\ **Post date:** [November 25, 2022, 2:26am UTC](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725/34 "2022-11-25T02:26:31Z")
Hey Rob, watched again today. That is a nice solution for the problem. Veryinterested in how the JSON gets turned into a view in a tab. Very exciting! Thanks to you and uzo for diving into this \<3 Very much appreciated and can’t wait to watch your next video(s). [Previous page](https://community.glideapps.com/t/how-would-you-approach-storing-rating-data-of-multiple-users-to-1-or-many-at-the-moment-around-100-skills/54725.md?page=1)